Each percentile is actually a calculated field because I need to know the score of the student at 80th percentile, instead of using the distribution band.
Is there another way we can go about this?
Thanks for this. This is exactly what I need! I have the percentiles calculated. But not sure how to put it as reference line.
I used a bar graph to show the current value. When I added in the 50th percentile, the value 21.7 appears as a label at the top. How do I make it into a reference line? Thank you!
image001.png 67.4 KB
Hi Sarah Chan ,
I am so sorry I missed your reply and that's the reason why i am replying so late .
So once you have created these measure and your bar chart ,Drag the calculated field to label marks then right click on the axis so that you can add a reference line .
Here in value select the name of calculated field , please keep in mind if you have not added or dragged it to label marks you will not get this as a option there .
now change the label to custom and then click on > next to that ,select value this will gives you the value on your reference line .