Dear community,
I would like to compare automatically sales of December 2018 with sales of November 2018 and put in mesure the evolution rate (+ or – and %).
The difficulty is that I have sales for December (1 to 5 december) and I would like to compate with sales from 1 to 5 november and not the full month,
Tomorrow when I will check my KPI it should be evolution between 1 to 6 november ans 1 to 6 december…
This is my mesure to have sale for December 2018 :
count(aggr(if(year(date_signup) = year(today()-1) and month(date_signup) = month(today()-1) and FID_ANA_NUM = 1 ,1),[FID_shop_id-Offre - Identifiant unique]))
and I would like to have :
count(aggr(if(year(date_signup) = year(today()-1) and month(date_signup) = month(today()-1) and FID_ANA_NUM = 1 ,1),[FID_shop_id-Offre - Identifiant unique])) / sales of month-1 from 1 to 5 etc …
regards,
Cyrille
