I want to use data rather than ReloadTime() - possible?

[#1]

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  🙂

[Anonymous · Accepted solution]

loadDate is field in your data?

If yes, then use this?

=max(loadDate)

[thakkarrahul01]

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

[#4]

Brilliant - thanks.