2 Replies Latest reply on Nov 9, 2017 12:26 AM by arnaud j

    Calculate an average of quaterly KPI adjusted by a score without split per Month

    arnaud j

      Hello,

       

      I work on several KPI published quaterly.

      I calculated a score per Month related to the level of the KPI (See worksheer Score/Month in my file)

      Then I added the average of the score on these 3 months (In my exemple Grand Total Avg Score).

       

      When I split per month, it woirks I have the result on Grand Total (Analysis) but not without split.

      So I would like to have this result directly by using a calcutated field.

      Also is it possible to use the Grand Total result in another calculated field?

       

      In addition, is it possible to use the result of mesures values of a Dashboard in order to use in another Dashboard (for example to add a difference)?

       

      Thanks in advance