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

    Count with Mode function

      Hi

       

      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.

       

      Regards

       

      Mohamed Abubakker