Question
How to show only 6 values up to a selected date by parameter.
Example:
Show 6 weeks of the selected parameter date.
Last Modified Date: 07 Jun 2023
Environment
- MS SQL Server
Answer
It is possible to follow along with the sample packaged workbook found in the Attachments section to the right of this article.1. Create a parameter for the selected date as shown below:
2. Create a calculated field of the selected date with the following values:
name: TS_selecteddate
value: IF [Order Date] <= [selected date] THEN TRUE END
3. Create a calculated field of the 6 values as described below:
name: TS_selected6
value: (LAST()+1) <= 6
4. Drag TS_selecteddate to the Filter card and choose True.
5. Drag TS_selected6 to the Filter card and choose True.
Thank you for providing your feedback on the effectiveness of the article.
Open new Case
Continue Searching
Knowledge Base
Community
Product Help
Training and Tutorials