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

[Kartikeyan Mag2]

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?

[Slawek_Radziewi]

For daily average you need to create new indicator and in aggregate change from Count to Average.

[Kartikeyan Mag2]

Thanks. Should i use above indicator source (incidents opened today) and if i need to create new indicator source what condition should i use.

Also if i select average in aggregate then which field should i select.

[Slawek_Radziewi]

Sorry for my previous suggestion. I think average daily makes no sense. You can check what is i.e. average duration of ticket but average number daily is not what you want because daily it is just a number. When you calculate average weekly you will get average every day in last week for example etc. 

[Kartikeyan Mag2]

Thank you so much for the help!!

[Kartikeyan Mag2]

Hi Slawek,

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