Formula to Calculate Average Incidents opened per day, week, month and quarter?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-13-2019 12:41 AM
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?
- Labels:
-
Dashboard
-
Performance Analytics
-
Reporting
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-13-2019 02:52 AM
Hey thanks..Values are showing now and changing when I am changing time series but I am not understanding how it is calculating average. What formula it is using. How should I explain it to client (the calculation)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-13-2019 03:23 AM
What do you mean?
It takes daily numbers and calculates average in that period (for week, month).
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-13-2019 03:41 AM
OK. Thanks for the information but what formula it is using to calculate average for per day, week, month, quarter.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-13-2019 04:03 AM
(x+y+z...../no. of days). where x,y,z are the values per day.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-14-2019 06:59 AM
Thanks. Now I am able to get Average incidents per week using time series "By week AVG+", Average incidents per month using time series "By month AVG+" and Average incidents per quarter using time series "By quarter AVG+". But how should i calculate Average incidents per day. What time series should i use for same.
