DASHBOARD CHARTS
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
Best Answer
-
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
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
Answers
-
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
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.6K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 63 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives