Graphing Only Total Row From Summary Report

Colin Abernathy
edited 09/29/21 in Smartsheet Basics

I want to graph my summary row of my report; however, when I select the report it does not give me the option to modify what is selected to be included in the graph which is the entire report. This report is built of summary data from about 50 different sheets so doing this using a metric sheet is not really an option that I think will work. Any suggestions on how to get the summarized data only?

Is it possible to use the Pivot App with Sheet Summary data?

Answers

  • Genevieve P.
    Genevieve P. Employee Admin

    Hi @Colin Abernathy

    As you've found, the very top summary row in a Report cannot be used as the source for a Chart Widget; there need to be a second-level summary in order for the chart to read the data. (See the announcement post about this feature here:  New! Create a chart from reports with grouping and summary)

    Can you set up a Grouping that will include every single row/field, such as grouping by who created the summary fields (if you created each of them)? This will create a second line that can be charted.

    Let me know if this works for you!

    Cheers,

    Genevieve