Forum Discussion
count one item for another?
hello, i'm a new user and i have what i hope is a simple question. i need to count teaching assistants assigned to particular classes over a period of many years. i have duplicate back-end rows for...
Hi jamesja ,
You could create clustered bar chart or clustered column chart.
For example, place course in Axis field, year in Legend field and count of teaching assistants in value field.
Result would be shown as below.
Best Regards,
Jay
hi Jay, thanks so much. i think this is going to get me close. there's a twist in that i've now been asked to display a ratio of teaching assistants to students for each course/year, so i've been reserching that separately, but if you've got some pointers on how that may work in conjunction with the above, it would definitely be helpful. thanks either way!
Hi jamesja ,
You could create a measure using count of teaching assistants/count of students then put this measure to Value field.
Best Regards,
Jay
