Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello All
Please help me in the below query.
I have the data from 2013 to 2016... In the visualization I need to show the max date.
I am using the formula as MAX(date)..
The issue is that if I select any month on the sheet it will change and shows that particular month max date.
I want that it will always show the max date of the data.. No matter what the filter we apply.
Please suggest.
Thanks!!
Use set analysis to ignore all selections
Max({1} date)
Scirpt:
Let vMax= MAX(date);
Show the Variable in UI
Or Rather
Temp:
Load
Min(DateField) as minDate,
Max(DateField) as maxDate
Resident FWRSData;
Let varMinDate = Num(Peek('minDate', 0, 'Temp'));
Let varMaxDate = Num(Peek('maxDate', 0, 'Temp'));
Show the Variable in UI