Advanced Analytics - Net values?

[DougA]

I've been asked to provide a dashboard that shows the difference between incidents logged in a period and the number of incidents resolved. Is this possible?

Thanks

Doug

[Guest]

Hi @DougA

This depends what you are specifically looking at displaying. If you are looking for a graphical comparison, the easiest way to do this is to create two measures with the same sample frequency, but one looking at the Incident Logged Date and one looking at the Incident Resolved date. 

Once these samples have run, you can then display them on as a "Measured Samples" Chart Widget together for a nice comparison. My example below shows the example of Incidents Logged vs Resolved Per Month

 

Is this the kind of thing you were thinking of?

Kind Regards

Bob

[DougA]

Hi @Bob Dickinson Not quite. I need 3 lines, Incident logged, Incidents Resolved and logged minus resolved.

Thanks

Doug

[Guest]

Hi @DougA

I have had a look and I don't think this is possible with the current functionality, certainly not on a graph. I'll ask about internally to see if there is any way this could be achieved. 

Kind Regards

Bob

[DougA]

Thanks @Bob Dickinson

Much appreciated

[Steve Giller]

Personally I'd tell the person asking that the third line is redundant - it's clearly visible as the "gap" between the two lines ...