02-02-2016 11:07 AM
Hi dear members!
My objective is to Filter a "Gauge" object in a way to show a measure only for the most recent date available in the data. The filter need to be dynamic as the data will get updated every few days.
Problem is that Max operator is not available for Filtering. Do you have any idea how I can do this?
Thank you in advance!
02-03-2016 02:53 AM
In present versions (to 7.3) we don't have any option to get Max date (or As on date Values).., This is the most basic requirement........
The best way is that you have to Calculate Max date in your backend data.
after loading the data in VA environment put a condition (Calculated).
If date = Max date
Return (Your measure)
You will get Max date or As on date value and it is dynamic.
Hope this helps..,
Thanks & Regards,
02-03-2016 09:19 AM