If I use a saved search to get a list of records f...
# general
k
If I use a saved search to get a list of records for the last two months, is there a formula I can use to get the total number of records by month. For example, I can do
COUNT({internalid})
to get the count of everything. Is there any way to do some type of COUNT_WHERE? I've tried to do something like this and it causes an error:
CASE WHEN to_char({custevent_create_time}, 'MM') = to_char({today}, 'MM') THEN 1 ELSE 0 END