1 Reply Latest reply on Oct 15, 2017 2:50 AM by Robin Ruehlicke

    Average and Baseline

    magdalena.bielaski.0

      Hi,

       

      I have 12 months and I need to calculate  6 months rolling  average then see if the current and next months forecast increased by 10% (above the 6 month rolling average). If it did then I need to color code a cell  (red).

       

      The data look like:

       

       

                          January   February  March ..............................................current.......next month1......next month 2 etc

      Customer 1  20          30             40                                                                         10                           15

      Customer 2 10         15             50                                                                           60                          80

      Customer 3

      customer 4

       

       

      I would greatly appreciate any help!

       

      Thank you.

        • 1. Re: Average and Baseline
          Robin Ruehlicke

          Hi Magdalena,

          first, I would try to rearrange the data so that it has columns "Customer", "Date", "Sales" (or whatever the forecast is)

          Then calculate the average sales over 6 months:

          Now, calculated an indicator for the alert:

          Convert the "Alert" calculated field to discrete and put together your Viz:

          Is this what you are looking for?