Loading

Reset Filter To The Latest Available Date Using A Reset Button

게시 일자: Apr 28, 2025
과업

Reset Filter to the latest available date using a reset button. Example: Clicking on reset filters will choose reset the Year filter to latest year

 

단계
1. On a new sheet (Reset button ), Create a calculated field called Reset label with "reset filters " formula and put it on Text in Marks card.
2. Drag Year(Order Date) on filters and select the latest year
3. Drag Year(Order Date)  onto Detail in Marks Card
4. On the dashboard, drag the Main view sheet, Reset button sheet 
5. Go to Dashboard -> Actions -> Filter action

In the Add Filter Action dialog, do the following:
  1. For Source Sheets, check only Reset Button
  2. For Run action on, choose Select
  3. For Target Sheets, check all worksheets that have filters that should be resettable
  4. For Clearing the selection will, select Show all values
  5. For Target Filters, choose Selected Fields
  6. Click Add Filter…
  7. In the Add Filter dialog, pick a dimension whose filter should be resettable and click OK
  8. Repeat the above two steps for all filters that should reset when the button is pressed.
  9. Note: there will be a "Missing fields on Reset Button" warning. This warning will not affect the solution and can be ignored.
  10. Click OK twice to close all dialogs
6) Click on the drop down for the Main view sheet, choose filters -> Action(Year(Oder Date))
User-added image
Knowledge 기사 번호

001456718

첨부 파일

sample_v10.5.twbx

1288 KB

Solution.mp4

1951 KB

 
로드 중
Salesforce Help | Article