Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
So here is my case.
Today I use ReloadTime for some charts to filter out things for "today" only - works fine as long as there I any data available for the same date as the day of data-reload, however under some conditions - the data for "today" might not be available yet....and
all those charts get's "nulled" basically.
Is there a way to rather use something like; - "the last date that was available in column "loadDate"" ?
not sure my question is understandable - lets see what you think 🙂
loadDate is field in your data?
If yes, then use this?
=max(loadDate)
If you are sure date field you are using won't have future dates then you can go ahead with max(dateField) in set analysis.
I hope this helps. Please elaborate with data in case I have misunderstood your scenario.
Kind Regards,
Rahul Thakkar
Brilliant - thanks.