Where Clause in Formula Indicators

LenaLindel_f · ‎06-29-2015

Hej,

A few times when I have created formula indicators I have wanted to use a where clause in the formula… for example get a %-age
only for Priority 1 Incidents where I have indicators with Break-downs on Priority already… the only way to do this today as I understand it is to create a new indicator adding a filter of priority 1 and then divide that with indicator capturing the total (resolved incidents for example).

Have I missed the functionality or is this something in the pipeline for coming versions of PA?

If I have missed the functionality...is the same possible in Widgets as well...? for example just show total volume for priority 1, 2 and 3 incidents but not Priority 4... where I have an existing Automated Indicator collecting a breakdown on Priority.

We are using Fuji.

Regards,

Lena

Vincent Loffel1 · ‎06-30-2015

Hi Lena,

If i understand it correctly, what you want to achieve is an formula indicator/widget that shows you a selection of for instance incidents not updated in 5 days. Where the selection should is you only want prio 1 - 3 and not prio 4.

What you could do is create an indicator that is a duplicate of incidents not updated in 5 days and change some parts of the formula. The numerator is the part where you want to create the selection. Click "browse for an indicator" and click on the + sign left of "number of incident not updated in 5 days", now click the + sign before breakdowns. Then it shows the breakdowns that are connected. Click on the + sign before priority and it shows the values the breakdown holds. Now you can select the specific breakdowns you want to have. It is not possible to select multiple indicators at once, but you can select them one-by-one and add them up to a total of only priority 1 - 3.

The formula then would look like:

(( [[Number of open incidents not updated in last 5 days / Priority / 1 - Critical]] + [[Number of open incidents not updated in last 5 days / Priority / 2 - High]] + [[Number of open incidents not updated in last 5 days / Priority / 3 - Moderate]]) / [[Number of open incidents]] ) * 100

The formula no does divide prio 1 - 3 by all open incidents. If you want you could do the same exercise with the demoninator.

I hope this helps.

Regards,

Vincent

View solution in original post

Vincent Loffel1 · ‎06-30-2015

Hi Lena,

If i understand it correctly, what you want to achieve is an formula indicator/widget that shows you a selection of for instance incidents not updated in 5 days. Where the selection should is you only want prio 1 - 3 and not prio 4.

What you could do is create an indicator that is a duplicate of incidents not updated in 5 days and change some parts of the formula. The numerator is the part where you want to create the selection. Click "browse for an indicator" and click on the + sign left of "number of incident not updated in 5 days", now click the + sign before breakdowns. Then it shows the breakdowns that are connected. Click on the + sign before priority and it shows the values the breakdown holds. Now you can select the specific breakdowns you want to have. It is not possible to select multiple indicators at once, but you can select them one-by-one and add them up to a total of only priority 1 - 3.

The formula then would look like:

(( [[Number of open incidents not updated in last 5 days / Priority / 1 - Critical]] + [[Number of open incidents not updated in last 5 days / Priority / 2 - High]] + [[Number of open incidents not updated in last 5 days / Priority / 3 - Moderate]]) / [[Number of open incidents]] ) * 100

The formula no does divide prio 1 - 3 by all open incidents. If you want you could do the same exercise with the demoninator.

I hope this helps.

Regards,

Vincent

LenaLindel_f · ‎06-30-2015

Thank you Vincent!

Exactly what I wanted to do!

Regards,

Lena