10 Replies Latest reply: Feb 13, 2014 6:57 AM by Alec Smith RSS

    Gauge Chart Min/Max Setting

    Alec Smith



      I created a gauge that computes the average number of orders(i.e. References) per month using the following calculation.

      =Avg(Aggr(Count (Reference),Year, Month)) 


      On the Presentation tab, I set the following Gauge settings:

      Min(Aggr(Count(Reference), Year, Month))

      Max(Aggr(Count(Reference), Year, Month))

      The issue is that when I select one month from my Month list box, I get an error of "Bad Min or Max Value in Gauge".  See attached screen shot.  When I select more than one month, the gauge computes the Min and Max without error.  See second screen shot.

      Any information to resolve this issue would be much appreciated.  Thank you,

      Screen Shot 2014-02-12 at 5.26.19 PM.png

      Screen Shot 2014-02-12 at 5.33.38 PM.png