I have revenue figures recorded at random intervals of days throughout months. It has not been updated since June, so I cannot use the automatic date filters in Domo without manually going in every month it gets updated and changing things around. I was able to get the most recently updated month and the prior month totals using the following BM filter:
The only drawback I can see doing this is that I cannot see in a single value card the % difference between the most recent month and the prior month.
I also tried to use the following source to create it, to no avail:
I also tried summing a new aggregated total column using a Group By function, which obviously didn't work as I was trying to take an aggregate of an aggregate. I finally tried using the same syntax as the filter for the date, which didn't work either.
Does anyone have any ideas?