Good afternoon,
I calculate the standard deviation using the following formula: Stdev( ALL aggr( COUNT(NumOco) , DataOco))
and the media with the following formula: Avg( ALL aggr( COUNT(NumOco) , DataOco)) ,
now my boss wants me to accumulate 365 days (or 12 months) before and I have no idea how would the formula.
To calculate 365 days earlier I use the following formula: Count(if(DataOco>(Today() - 365),NumOco))
Simply join the formulas??
Does anyone have any tips?
Hugs,