How to actually USE the summary info from a report?

Carly Chaput

I have two reports both bringing in information from the same sheet. One is grouped first by country, then by month. The other is grouped just by month. For each of these groupings, I have it summarizing totals and maximums for each column. This is brilliant, this is exactly the information that I need. But now I need to be able to do things with this information and I'm not sure how?

The primary thing I'd like to do is create line graphs showing the trends over time, using the information that's in the summary lines of the report, but that data seems almost inaccessible. Is anyone able to take this information and use it, either on a dashboard as visuals or have all of this copied to another sheet to use it further, or is seeing the summary line data the end of the road?

Report 1:

Report 2:

kowal

hi @Carly Chaput,

Once you have report built on Sheet Summary you can create a Dashboard on Chart Widget based on it.

So the data will be visible as a chart, graph etc. it's very simple.

Hope it helps