Graphing Data
Hello All, I am trying to build a graph of data and I was hoping someone had some ideas for me.
Scenario: Multiple locations use a form to input data on incidents that occur at their location. The form has them input incident type (from a dropdown list), time of day (from a dropdown list), their location (from a dropdown list), and the date (from a date picker). Each one of these elements are separate columns in a worksheet, in one row.
Solution Needed: Provide a graph for each location on a dashboard displaying number of incident types reported by time of day, day of the month, month of the year.
This is very similar to a scatter or plot chart and I know these are not available Smartsheet but I was hoping somebody would have some ideas.
Please let me know if more info is needed, Thank you in advance!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- 10.7K Get Help
- 63 Global Discussions
- 69 Industry Talk
- 385 Announcements
- 3.5K Ideas & Feature Requests
- 55 Brandfolder
- 125 Just for fun
- 50 Community Job Board
- 464 Show & Tell
- 40 Member Spotlight
- 44 Power Your Process
- 28 Sponsor X
- 234 Events
- 7.3K Forum Archives
Check out the Formula Handbook template!