Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Folks,
I'm having to variables as mentioned below:
vDateStart =timestamp($(vDtStart) + $(vTsStart)/24)
vDateEnd =timestamp($(vDtEnd) + $(vTsEnd)/24)
Requirement: Please help me how to create a button by using these two variables or without them to see yesterday 6:00 AM to Today's 6:00 AM data.
Note: I'm using vDateStart and vDateEnd variables in all my expressions inside Pivot table and by pressing this button data should change automatically .
Thanks,
AS
Also please use the values againstvSatartDate & vEndDate
vStartDate =timestamp($(vDtStart) + $(vTsStart)/24)
vEndDate =timestamp($(vDtEnd) + $(vTsEnd)/24)
Thanks,
AS
Hi amit,
I am not sure if i really understood what you want. But in this example i added the date and time is changed to Yesterday's and Today's 6 to 6 AM. It changes the values in your calendar and slider. And if i understood you then the table below should limit its values.
I just used the actions --> External --> Set variable.
Is that what you looking for?
Best regard
Theresa