Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a chart which plots highest, lowest, and average percentages by grade on a line graph.
Each data point plotted in the highest and lowest lines is a specific school district (whichever happens to be the highest or lowest in that grade).
What I'm looking for is some way to identify, ideally within the hover-text, which school district it is that's holding the highest or lowest 'record' for that data point.
My expression for highest is
max(aggr(sum(Truant)/sum(StudentCount), Grade, District))
and lowest is
min(aggr(sum(Truant)/sum(StudentCount), Grade, District))
Attached is a sample using popups. The hover shows both high and low districts. I haven't figured out how to display just the relevant district -- high when hovering on the high line -- and still maintain your values on data points.
-Rob
Try to add text inside the graph and see the document attached...
Regards.
The expression to identify the District with the highest rate by Grade would be:
aggr(NODISTINCT
FirstSortedValue(District,
-aggr(sum(Truant)/sum(StudentCount), Grade, District)
)
,Grade)
and the lowest would be the same without the "-" on the second aggr.
aggr(NODISTINCT
FirstSortedValue(District,
aggr(sum(Truant)/sum(StudentCount), Grade, District)
)
,Grade)
I'll have to play with it a bit to get the hovers to display correctly on a line chart. Maybe you'll figure it out before I do,
-Rob
Attached is a sample using popups. The hover shows both high and low districts. I haven't figured out how to display just the relevant district -- high when hovering on the high line -- and still maintain your values on data points.
-Rob
Brilliant! That's perfect, thanks so much Rob!