I currently have a chart where I show the count of student ID by their degree. The automatic name given for the calculation is: CNT(Student ID)
As a fix, I created a calculated field : COUNT(Student ID) and dragged it to my chart, which then gives me the automatic name: AGG(Student ID)
I would like to rename this to Student count. However, I'm unable to see a rename option for this.
I am aware that I can change the axis names and the chart titles, however I want to change this measure name because it is what shows up when I look at options to sort and I would want my table to be able to sort by "Student count" and not "CNT(Student ID)". I'm unable to take a screenshot as the sort option vanishes when I click away or hit print screen. Would appreciate a solution to this issue.
Thanks
Hi Michael,
Thanks for your reply. I created it as an ad-hoc calculation in the columns section. I also created a measure in my data source field list called Student Count where Student Count = COUNT(Student ID). When I drag this to my columns section it shows up as AGG(Student ID). Ctrl-drag the pill option didn't work which is why I created a calculated in the measures section.
