Are there aggregate functions?

I would like to show sum of numeric values for the current week, month, etc? are the functions that help with that or how is this type of thing supposed to be done?

We’re working on this currently, should be live very soon

4 Likes

do you think there is a workout for that for now? May be there is some API(something like momentjs) where i can pass in the date and it can tel me start and end of the week. I can use that as constraint and display the sum of the field

You can use a workaround.

Assign 2 custom states - start date and end date. Then compare the current date (change this based on week, month etc) with this start and end date. You should be able to get data based on this filter and then find a sum or count based on that data.

Hope this is useful.

Regards,

Anil