New! Create a chart from reports with grouping and summary

Brendan Reed · 08/09/21

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 on图表in 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 · 08/11/21

Thanks for this!

Bryan Moss · 08/11/21

Excellent feature add. I will check it out.

Bassam Khalil · 08/12/21

@Brendan Reed

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

Pamela Wagner · 08/16/21

我的观点是还不让我抓住the summarized data:

How can I get this functionality,@Brendan Reed?

Pam

Conchata Hosley · 08/16/21

I will definitely have to check this out.

Paul Newcome · 08/18/21

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

Pamela Wagner · 08/18/21

@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 · 08/25/21

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å · 08/27/21

Thanks,@Brendan Reed& the Smartsheet team.

This is a fantastic addition to Smartsheet.

I can't wait for what's next.

heyjay · 09/14/21

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

Jeff D · 04/08/22

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.

Jen H · 02/23/23

Any updates on when or if we can chart data from the second or beyond levels of grouping?

Paul Newcome · 02/24/23

@Jen HNot yet. Have you browsed through the Product Ideas topic at the top of the screen? If the idea has been submitted then you can add your vote. If it hasn't then you can submit it and allow others to add theirs. Either way there should be a "Status" there that will let you know where on the roadmap it is.

Jen H · 03/21/23

Thank you!

Hari Jaiswal · 07/29/23

Would it be possible to display more than one level of groups in the chart dashboard?

New! Create a chart from reports with grouping and summary

Comments

Categories