Need to create an Indicator for Number of incidents assigned within 24 hours

rfike
Tera Contributor

Trying to create a formula indicator to show the number of incidents assigned within 24 hours

5 REPLIES 5

Bert_c1
Kilo Patron

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.

rfike
Tera Contributor

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

Then create a formula indicator, see the documentation on doing that.

Bert_c1
Kilo Patron

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.