How do I create a 'drilled-down' chart in dashboard
Hi,
I have created a graph on a dashboard but I would like the ability to click on a value on the chart and drills or access the source data in a sheet to provide the user further information.
How do I do this?
Best Answer
-
Hi Rory,
Drill down capability into specific chart data doesn't exist yet. You can set the interaction to open the source report when you click the chart.
To do this:
Edit the interaction of the widget (interaction is what happens when you click the widget)
Follow these steps:
Edit the Chart Widget and click on Advanced Options. Under When this widget is clicked on, choose one of the following interaction options:
- Do nothing (no action)
- Open the source sheet
- Go to a URL
- Open a Smartsheet item
Help?
Mark
I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.
Answers
-
Hi Rory,
Drill down capability into specific chart data doesn't exist yet. You can set the interaction to open the source report when you click the chart.
To do this:
Edit the interaction of the widget (interaction is what happens when you click the widget)
Follow these steps:
Edit the Chart Widget and click on Advanced Options. Under When this widget is clicked on, choose one of the following interaction options:
- Do nothing (no action)
- Open the source sheet
- Go to a URL
- Open a Smartsheet item
Help?
Mark
I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.
-
Is this type of Chart Drill-Down functionality available yet?
Are there any plans to add it as a feature?
-
This is the #1 most requested feature from out stakeholders at my company.
Jeffrey McMillan CAPM, PMP
Project Manager, Financial Applications ERP
-
Is this feature available now?
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives