Creating a formula for a Report

[jendugan]

Hello all,

Background:

I have formula indicators set up that show the following:

(([[SOM - Number of new incidents > Priority = 1 - Critical]]) * 125) + (([[SOM - Number of new incidents > Priority = 2 - High]]) * 25) + (([[SOM - Number of new incidents > Priority = 3 - Moderate]]) * 3) + (([[SOM - Number of new incidents > Priority = 4 - Low]]) * 2)

Which works perfectly:

However, I have now been asked to create a report that shows the LIVE severity score to put on a dashboard.

I see (by searching the forum) there is a possibility to create a script include but I am not sure how to accomplish this.

Any help would be greatly appreciated.

[Slawek_Radziewi]

What do you mean by live? 

I suggest you create normal report with single score and put in on dashboard.

[jendugan]

The request to be able to go to the Dashboard and have the report run showing the currently Severity score.

I could do that except my question still stands. I need to know how many P1 incidents * 125 (the score each P1 gets), P2 * 25, P3 * 3, and P4 * 2.

I can do a score but how do I multiple all the priorities by their Severity scores.

[Sushil Chaudhar]

You can create metric definition to calculate score according to priority and define report on 'incident_metric' to get real time score value.

Metric definition.. you should create one custom integer field on metric_instance to store the score value, that is referred in below metric definition as 'u_numeric_value'

 Report on 'incident_metric' will look like something below:

You can apply filter conditions and visualization on the report as per your requirement.

Check if it works for you.

[jendugan]

Sushil,

This would work great; however, using the Metric definitions is not an option at this time. Management has decided it is a drain on the system and will not allow me to create them. I will keep this information on hand for future reference, I may be able to convince them if I can't get other options to work. 

Jen