4 Replies Latest reply: Jul 19, 2013 12:44 PM by Shawn Haning RSS

    Chart hover-text

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