9 Replies Latest reply: Apr 30, 2014 7:05 AM by Sudeep Mahapatra RSS

    Value on data points different than expression result



      I have a graph with one dimension and 2 expressions:

      Expression 1 = % of Open Invoice/Order

      count({<STATUS = {'Open'}>} ID) / count(ID)


      Expression 2 = % of Closed Invoice/Order

      count({<STATUS = {'Closed'}>} ID) / count(ID)


      I want to display in the bars, the count of Open Invoice/Order and Closed Invoice/Order.


      I know how to do it when I have one expression but it does not work with multiple expressions. I tried the "show value" attribute of expressions but it only allows to decide if the value should be displayed or not, I cannot put a different calculation.


      Anybody would know how I can achieve below result without changing the dimension/expression implementation?

      Percentage and Count.PNG.png