As a continuation from the How to Filter an Entire Dashboard, it is possible to select the First or 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.
First N Elements
From a Trend Dataset, drag an attribute into the Filter panel (Customer)
Click the Menu button of the already selected attribute filter (Customer)
Click Dynamic Selection
Click First N Elements
Enter the desired displayed quantity
Click OK
The quantity entered will now display across all Chapters.
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