Rolling average for past 3 month indicator

sberri
Tera Contributor

Hello community, 

Hope everyone is doing well 🙂 

 

I have a question related to something requested by a manager in my company. 
We currently have incidents with different fields configured, and one of these fields is the ERP name (client name). 
This manager wants to see the total number of incidents opened for a specific client: Until here nothing special. 
He wants to compare the data, based on an average per month, nothing special again here. 


But, he doesn't want to compare the current month to the last month only, he wants to compare the current month to a rolling average on the previous 3 months (current one not included). 


Do you know if displaying what he wants on the same graph is possible? 
I was maybe thinking about a formula indicator that can allow for calculating the sum of the last 3 months (relative) and then applying a time series or something else.

 

Sorry if my question seems stupid, I'm pretty new on this 🙂 

 

Thanks a lot for you help and time ! 

0 REPLIES 0