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-18-2019 02:11 AM
Hi Varun,
is it possible to Exclude weekends (and possibly Holidays).
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-16-2019 03:41 AM
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?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-18-2019 02:10 AM
Hi Adam,
is it possible to Exclude weekends (and possibly Holidays).
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-31-2020 02:45 AM
You got the formula, to calculate Monthly Average Incident Count ?