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

    Value on data points different than expression result

    Jean-Christophe PINOT

      Hello,

       

      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

      Thanks,

      jc