Date between 2 data sources

[#1]

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

[alexandros17]

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

[its_anandrjs]

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