Filtering on dashboards?
@Paul Newcome - Hi Paul, I went through this thread:
but unable to follow it for my use case. Could you please help? I am new to Smartsheet and have an urgent use case for my team where I need to build a KPI scorecard dashboard. The details are as below:
- We have 3 teams who will maintain similar metrics for 5 KPIs (Data Availability, Pipelines#, Trainings# etc.) in 3 separate data sheets on Smartsheet
- Each team will update these data sheets with their metrics periodically in their data sheet
- In the dashboard, firstly, I want to show default data aggregated for All 3 teams against 5 KPIs when a user accesses it
- Next the user should be able select a particular team from a dropdown - All (Default), Team A, B, C
- If the user selects Team A, KPI/Metrics data for that particular team should be displayed on the dashboard from Team A data sheet
Kindly let me know how can I go about building such a dashboard. Thanks in advance!
~RK
Answers
-
We're all waiting desperately for dynamic filter dropdowns on dashboards. It's simply not possible today without awkward workarounds.
You can check out the Engage 2023 session recording and slides where they describe how to use a form to setup filters on a dashboard, but it's a workaround until we have real filtering.
On the link below, go to Power User Skills, then "Design dynamically updating dashboards"
Otherwise, I might suggest that you setup three dashboards, one for each of your subgroups. Then either have links from a central dashboard, or use Workapps (if available to you) to host all four dashboards as pages to navigate through.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 472 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!