Get sum of outage duration per day in performance analytics

[Felix20]

Hi everybody,

I'm currently working on getting a performance analystics view on our outage table (cmdb_ci_outage). In our dev environment we only have some 10 to 15 outage entries whose outage duration sums up to about 150 minutes.

I created an indicator that has indicator source on "cmdb_ci_outage" table and aggerate "sum" on field "duration". that sound good and i run the job to build the dashboard scores and information. finally i had a look at the timeline and saw, that on nearly each day in the last month, i see the sum of 150 minutes downtime. But that is not true.

I want to see the downtime sum that happens on each day. We havent created new outage entries the last 5 days, so I would like to see 0 minutes of downtime of the last 5 days in our timeline.

What am I missing to get that indicator working fine for my purpose?

Best regards,

[Derek Behunin · Accepted solution]

Hi there,

With your current set up PA is showing the sum of the duration field on all Outage records. To put this in everyday speak (Because thats how I like to think of things) Your report is showing the total outage time of the system.

To have this report display based on days you will need to create a breakdown on the Outage records that is based on a date field. That way it calculates the sum of all Outage fields per day.

Let me know if this helps!

Derek

[Felix20]

Hi Derek,

works perfect, thank you

Best regards,

[Derek Behunin]

I'm glad this solved your issue. Cheers!

[Russell Park]

@Felix  Felix do you mind sharing the indicator source after you made the changes that fixed your issues.  I am running into a similar issue.

Thank you,

Russell