Chart/Graph - # of inspections by month and segmented by board district
This visualization should categorize the number of inspections conducted, broken down by month and further segmented by board district.
Specifics in the chart/graph?
- Time frame: Starting [start month and year] to [end month and year].
- Data points: Total number of inspections conducted each month, categorized by each board district.
Answers
-
Charts display what's been set up in the source data, meaning you'll need either a Sheet or Report with the numbers you're looking to display in order to format it as a chart.
For example, you could set up a sheet with a Date column listing each Month/Year down the rows. Then have one column per Board District. Then you can use a formula to SUM or COUNT or create a sort of calculation based on each value (month & district).
Once you have the numbers set up in a sheet, you can create a chart!
The reason I'd do it this way is because you could potentially create a Report off of the sheet using the Date column if you only wanted to show rows from the last 2 months (60 days) and have it automatically update. Or you could filter by if the cells are blank, so you don't show all months (but only months with data).
If you need help with the formulas, it would be useful to see an example of your source sheet (either with test data or blocking out sensitive data on your real sheet) with an explanation of what you want counted/charted.
Cheers,
Genevieve
Join us at Smartsheet ENGAGE 2024 🎉
October 8 - 10, Seattle, WA | Register now
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 284 Events
- 33 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!