As a continuation from the How to Filter an Entire Dashboard, it is possible to select the Last Number of elements in the Filter panel. This feature is available if you are a Power User in Performance Analytics or are either a Power User or Dashboard & Alert User in Collaboration Analytics.
Last N Elements
Use the Last N Elements filter option on a Dashboard that has a Chapter that focuses on a Trend or Time Range.
From a Trend Dataset, drag a time attribute into the Filter panel (Ex: Week)
Select the Menu button for the attribute filter (Ex: Week)
Click Dynamic Selection
Click Last N Elements
Enter the Quantity (Ex: 6)
Click OK
All the Trend data will be filtered to your selections above (Ex: to all of the last six weeks)
Under the File drop-down menu, it is recommended to select Create Personal View to Save because any SPS updates to any pre-built dashboards will carry over. Alternatively, click Save As... and rename the Dashboard.
As the saved dashboard updates on a weekly basis, it will continue to show the data for the most recent six weeks.
⛑️ SPS Analytics Support
If you have any additional questions regarding Collaboration or Performance Analytics, please reach out to our Analytics Support team at the contact information below:
☎️ 888-739-3232, Option 2