Loading

How To Hide The Rows For A Date Dimension On Pages Shelf

Дата публикации: Feb 24, 2025
Задача
How to hide the rows for a date dimension on Pages shelf.
Example: Hide all the months except the ones already navigated i.e hide ALL except the first two dates in the below picture
User-added image
Действия
1. Create a date parameter with dates from the Data source
User-added image
2. On the dashboard, Create a change parameter action 
User-added image
3. Create a calculated field like below:

[Date] <= [Date param]

4. Drag to Filter Shelf on the Table sheet and select True

Now when you hover over the state, the date values are passed to parameter and the table adds up only those value less than or equal to the the date value on Page

User-added image

 
Дополнительные ресурсы
Please check the video for demonstration of steps in action
Номер статьи базы знаний

001453840

Вложения

Sample.twbx

38 KB

2020-09-13_11-07-59.mp4

1123 KB

 
Загрузка
Salesforce Help | Article