1 Reply Latest reply on Oct 4, 2018 6:36 AM by Andrew Brew

    Week average over the quarter data - KPI

    Andrew Brew

      Hey,

       

      I'd like to create KPI (single value) that shows me the average sales per week over the quarter.

       

      Let's say I have the following data:

      where weekly average is simply sum(sales value) over 7 days divided by 7.

      Quarterly average is given by the formula in spreadsheet (attached).

       

      In result on worksheet I'd like to have only the single final value for the current day. In the example above it's '498'.

       

      Is there anybody to help?

       

      Thanks a lot in advance!