How to build a card which show the latest-date data only?
I have lots of datasets, which are updated by daily/weekly/bi-weekly. They dont have a specified update date.
I'd like to build cards based on them which show the "latest-date" data only, and should be updated automaticly when datasets updated.
I notice "date_range" in domo cards build don't have a non-specified latest_date field.
And if using a beastmode to be added as a filter, it will report error.
WHEN `aggregation_date` = max(`aggregation_date`) then 'Yes'
END as latest_date
Do you have a workaround solution?