Graduate Count per Program per Year
Hello:
I have a Graduation Data table that includes the following fields:
Term - Text-Multiple Choice Field
Program Title -Text Field
Count - Numeric Field
Data
2...
Forum Discussion
One solution would be to create a new field for 'year' that parses out the year from your Term value, so you have a distinct value that says 2019, 2020, 2021 etc. Then you can do a Stacked Bar Chart where you group by the Year Chat as the X value and you can split the bar based on your Program Title so it shows the itemization by program and then a grand total.
You could play with other chart types if you prefer, but you'll want the year field no matter what.
------------------------------
Chayce Duncan
------------------------------