How can I chart this data with smartsheet?
I'm looking to create 3 different charts from the data in this report.
One chart displaying # of 6S audits per auditor department
One chart displaying # of Safety audits per auditor department
One chart displaying # of Quality audits per auditor department
I'm looking for the least complicated and most efficient way to do this. Any recommendations are appreciated! Thank you!
Answers
-
HI @ccousineau , The way I would do this is to create three reports. All three reports would be essentially the same. You will bring in the Audit Type and Audit Department. "Group" by Audit Department and filter by Audit Type. Each report will have a different value in the filter. Finally, use summarize to "count" the number of values in one of the columns. Then, in a Dashboard, you can make the three charts you are looking for from the summarized data on the reports.
BTW... doing it this way would also allow you to use "widget behavior" on the chart to open the source report and see all of the records for each department.
I hope this helps. Be well!
If my response was helpful or answered your question please be sure to upvote it, mark it asawesome, or mark it as the accepted answer!
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.9K Get Help
- 378 Global Discussions
- 208 Industry Talk
- 441 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 291 Events
- 33 Webinars
- 7.3K Forum Archives