9 Replies Latest reply: Nov 20, 2015 3:13 PM by CIRO ORIC RSS

    KPI: Formula For Count Highers than Average

    CIRO ORIC

      Hi there!

      I need your help to create a KPI formula that returns the number of years with Sum(Amout) above the average.

       

      Higher than Average.png

      My data serie is:

      AggregationScope:

        LOAD * inline [

        Year Quarter Amount

        2012 Q1 1000

        2012 Q1 1000

        2012 Q2 1700

        2012 Q3 1400

        2012 Q4 1800

        2013 Q1 1000

        2013 Q2 1300

        2013 Q3 1100

        2013 Q4 1400

      ] (delimiter is ' ');

       

      Best regards,

       

      Ciro