I like to show the max date [i.e. Max(someDate)] in my dashboards as an easy way to see how recent the data is. For example, if the dashboard is showing orders or concessions, I want to see a single value field that shows the max date in the dataset.
I found that the single value control does not support the max aggregation for date fields. My workaround for this is to use a Pivot table and then try to strip down the column and row headers to get close to a single date.
See ‘As of Date’ in the image below. I’d like to be able to spit this data out using the same controls that you see of the left of the As of Date control.
Is there a better way? I’m sure I tried creating a calculated field (though it’s been a while and I’m not sure).
Thanks,
Mark