3 Replies Latest reply: Jul 12, 2011 7:04 PM by adavies1 RSS

    Show value in gauge chart when using if type statement in dimension

      Hi,

      I have a gauge chart where the dimension is an if type statement (=FieldName>Variable) and the expression is a count (Count(FieldName2)).

       

      The gauge works fine, but I can't figure out how to build the 'Text in Chart' expression to show the calculated value as a number (%) on the gauge.

       

      I tried  IF(CUR_LOS>MyLOS,count(stay_number))/count(stay_number)*100  but I just get a dash.

       

      I would appreciate any assistance.

       

      Thanks,

      Anne