DASHBOARD CHARTS

Paul Rosas · 11/01/21

I have a sheet that has a drop-down menu with 9 different options. This sheet is attached to a form that will have random inputs, however every one of the 9 options from the dropdown will be selected every time someone fills out the form and a row is populated in the sheet. I have a dashboard that is also attached to this form that shows a bar chart that represent the 9 different options. However, for every time that one of the 9 options was inputted, it shows a different bar---- I would like for it to be cumulative data that shows a bar for each of the 9 options, that represents all of the rows that are inputted perhaps as an average.

Any help would be appreciated. Thank you!

PR

Genevieve P. · 11/02/21

Hi @Paul Rosas

How did you create the Data for the Chart?

I would suggest using a Report to Group and Summarize your data for the chart. You can GROUP by the each Dropdown Option, then use the SUMMARIZE function in the Report to either SUM or AVG the values.

See:

Webinar - Redesigned Reports with Grouping and Summary Functions

Help Articles - Reports / Configure Grouping to Organize Results in Report Builder / Summarize Content to Extract Key Information with Report Builder

If you're having trouble after reviewing the webinar above, I'd be happy to explain how to do this based on your specific sheet/process, but it would be useful to see a screen capture of your sheet (please block out sensitive data).

Cheers,

Genevieve

Genevieve P. · 11/02/21