SIGNAL widget - stacked bar chart

[vp_nbn]

Hi braintrust,

I'd appreciate help with a widget in SAP Signavio Process Intelligence. I have a dataset relating to IT incidents covering 6 months. These IT incidents have, among others two case attributes:

1. "incident category", and
2. "incident resolved".

Incident resolved is a timestamp.

I also have a event called "Incident is resolved", which uses "incident resolved" as c_time.

I'd like to visualise in a stacked columns (stacked bar chart) incidents resolved in the respective month broken down by incident category. See the screenshot for what I'm looking for.

What would be the SIGNAL script to achieve this? I look forward to your suggestions. Thanks.

Kind regards,

Vladimir

[JD_WongLoera · Accepted solution]

hi @vp_nbn 

Reading the information you provide, I recommend that you do something along these lines in the Signal code option of a brand new Breakdown Widget.

using DATE TRUNC, will set the months in the X axis, and then the attribute that have you named "Incident Category" will be stacked

Hope this helps you with your issue, and if it does, remember to mark the Answer as solution. 

Best!

/JD