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!


  • Scott Orsey
    Scott Orsey ✭✭✭✭✭
    edited 04/01/24

    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!