33 Replies Latest reply: Apr 28, 2014 12:35 AM by Mohamed Abubakker RSS

    Count with Mode function



      I am using the mode function to find out the item which was ordered many times with the same quantity during the project life cycle.


      The expression that I used to compute the mode is


      = mode  (aggr (sum(Quantity), Project, Item))


      I need the count of mode in the aggregate output.


      I am using this the above expression in the chart and I need to know how much percentage that the same quantity is used in the project.


      Please help.




      Mohamed Abubakker