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


      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.