Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I'm working on a dashboard with 2 data set and both containing multiple months of data. I want to create a slider that allows user to select up to six months data.
Data 1: contains the most recent six months data (Field Name: LONG_DATE)
Data 2: contains 24 months data. (Field Name: End_Date)
How to map them two together so when I select the date on the slider and both data will be apply?
Thank you!
Jasmine
You must call with the same name both fields data:
Load
...
LONG_DATE as mydate
...
load
...
End_Date as mydate
...
Use mydate as field in the slider
If there is common field between two tables or if this dates in the same table then use variables like
Let vMin1 = Peek('Date',0,'Temp');
Let vMax1 = Peek('Date',-1,'Temp');
Let vMin2 = Peek('Date2',0,'Temp');
Let vMax2 = Peek('Date2',-1,'Temp');
and use this variables in the slider objects.
Let me know
Hope this helps