Formula to Calculate Average Incidents opened per day, week, month and quarter?

Kartikeyan Mag2
Tera Contributor

Need help with below Performance Analytics issue - 

What formula should i use in formula indicator to calculate Average incidents opened per day, week, month and quarter?

33 REPLIES 33

Hi Varun,

is it possible to Exclude weekends (and possibly Holidays).

Hi Adam,

Now I am able to get Average incidents opened per week using time series "By week AVG+", Average incidents opened per month using time series "By month AVG+" and Average incidents opened per quarter using time series "By quarter AVG+".

But for Average incidents opened per day what time series should i use?

Hi Adam,

is it possible to Exclude weekends (and possibly Holidays).

Lohith
Giga Expert

You got the formula, to calculate Monthly Average Incident Count ?