Last 'N' dates list Based on Date Filter
I want to get the list of last 90 days based on Date Parameter ( Date filter Selection). How can we achieve this ?
5 replies
-
Hi ,
To clarify, you want the user to select a date and then view that date plus the 89 days preceding it? Individually or as a total?
Ian
-
Hi Immanuel Gem ,
The simplest way to do this is as follows:
Create a Parameter to include all the dates from which you want your user to select. Make it single select.
Create a Dynamic List. Use the Range List Block:
Select the Parameter you created as the start member of the range. Click on the little fx icon, shown in the red box.
This allows functional selections. In this case we want a Lag of 89 as that will give us the 90th day from the selected parameter value.
Simply select the Parameter for the other Member of the range
Save the List and put Dates on the Rows, deselect all the Dates in the Elements panel, but select the List name you created. The parameter will be invoked and a list generated form the selected Date back 89 Days:
Hope that helps!
Ian