Static Date

[Anonymous]

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!!

[sunny_talwar · Accepted solution]

Use set analysis to ignore all selections

Max({1} date)

[rupamjyotidas]

Scirpt:

Let vMax= MAX(date);

Show the Variable in UI

[rupamjyotidas]

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

[Anonymous]

Thanks Sunny for help.

Can you please help me in the below query

Subfield Function

Thanks again