Need to create an Indicator for Number of incidents assigned within 24 hours
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-26-2023 11:41 AM
Trying to create a formula indicator to show the number of incidents assigned within 24 hours
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-27-2023 06:56 AM
Find the "Number of new incidents" indicator, and copy it using "Insert and stay". change the name to something like "Number of new incidents assigned". Add a condition 'Assigned to' 'is not empty'. Add the "[PA Incident] Daily Data collection" data collection job to that new indicator. then review the indicator's score card after data collection runs.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-27-2023 07:42 AM - edited 01-27-2023 07:43 AM
Thank you for the response however I really need the logic in the formula for determining the time assigned to the created time < less that 24hrs. I plan on using this in a calculation for the % of incidents owned in less than 24 hrs. Thanks
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-27-2023 09:33 AM
Then create a formula indicator, see the documentation on doing that.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-27-2023 01:28 PM
Seems a business rule on the incident table, with condition "Assigned to" changes to capture that. You could then calculate the time between "var current_time = new GlideDateTime(); var diff = current_time - current.sys_created_on; Store 'diff' (a new custom field on the incident table, the BR would then need to run "Before") And then report on the new field.