3 Replies Latest reply: May 9, 2012 1:05 PM by Steve Kang RSS

    How to set gauge limits based on row?

      Here's a sample table:

       

      GamePlayerPoints
      1Michael Jordan27
      1Larry Bird31
      2Michael Jordan42
      2Larry Bird21
      3Michael Jordan35
      3Larry Bird25

       

      I have Michael Jordan and Larry Bird in a straight table that has a column for their name, and a column for a gauge on the average amount of points. 

       

      I want a gauge for each player.

       

      I want the gaugages for each player to be segmented with the limits of 0, min(Points), max(Points).

       

      However, the problem is, it's choosing the min and max values for BOTH players so the min and max for BOTh is 21 and 42.  I want it to be 27 and 42 for Michael Jordan, 21 and 31 for Larry Bird.

       

      Any ideas on how I can write this expression so it finds the minimum based on Player and not the entire data set?