Chart hover-text

[#1]

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))

[jolivares]

Try to add text inside the graph and see the document attached...

Regards.

[rwunderlich]

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

http://masterssummit.com

http://robwunderlich.com

[rwunderlich · Accepted solution]

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

[#5]

Brilliant! That's perfect, thanks so much Rob!