New! Create a chart from reports with grouping and summary

Brendan Reed

Hi Community,

We just released an update to the chart widget in dashboards to enable charting from reports that have grouping and summary added. To create a chart from a report, create a chart widget or edit an existing widget, select “Add Data”, and choose the report you’d like to use as the source for your chart.

Note:You will only be able to create a chart from the summary data that is in the first level of grouping on your report, the top group in your “Groups” dropdown. This update does not support charting from the second level or third level groups in your report and does not support charting from the “Total” group.

If you'd like to learn more, check out our help content onchartingin dashboards andgroupingandsummaryin reports.

As always, let us know what you think through theProduct Feedbackform (availablefrom the menu here in Community), and thank you to everyone who submits feedback and requests for dashboards — we appreciate everything you send us!

-Brendan

Kate Folwell

Thanks for this!

Bryan Moss

Excellent feature add. I will check it out.

Bassam Khalil

@Brendan Reed

Great Update, but is there any idea when we can print the report with grouping and summary ?

Pamela Wagner

My view is still not letting me grab only the summarized data:

How can I get this functionality,@Brendan Reed?

Pam

Conchata Hosley

I will definitely have to check this out.

Paul Newcome

@Pamela Wagner原文说的注意we still can't grab from the "Total" row. Hopefully that is coming soon.

Pamela Wagner

@Paul NewcomeI was able to make it work per@Genevieve P.guidance! Here is the string:https://community.smartsheet.com/discussion/82173/how-to-summarize-a-report#latest

Mike Wilday

I would also like to pull individual metrics from a grouped report, is that possible yet? If not, is it on the roadmap???

Andrée Starå

Thanks,@Brendan Reed& the Smartsheet team.

This is a fantastic addition to Smartsheet.

I can't wait for what's next.

heyjay

The labels for my date are weird. How do I fix?

Jeff D

Where can I find information on the status of adding charting from the second level or third level groups? Is this planned? It would be helpful to create stacked charts.