Creating a chart in a dashboard using summarized data from 10 differents reports
Hi ! I have summarized data (group and recap) in 10 reports. I want to use the data (here a percentage) in 10 different reports to create a chart in a dashboard. Is it possible to do and if so, HOW ?
Thanks a lot !! 🙏🙂
Answers
-
@LyndaRousseau From what you describe it sounds like you'll need to get the data from those reports into a sheet to do the % calculations.
Simplest options are:
- If you have Smartsheet DataMesh you could map those reports, or combine all 10 into 1 report and map the report to a sheet then you can perform the calculations
- If you don't have Smartsheet DataMesh, we have a Report to Sheet add-on that can move your report data to a sheet :)
- A more advanced option would be if you have access to Smartsheet Bridge you could take the data from the reports into a sheet as well.
Here's the report to sheet add-on if you're interested:
Darren Mullen, join the Smartsheet Guru Elite
Get my 7 Smartsheet tips here
Author of: Smartsheet Architecture Solutions
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.1K Get Help
- 430 Global Discussions
- 149 Industry Talk
- 490 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 154 Just for fun
- 74 Community Job Board
- 499 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives