Stacked Column

[charliehodgson]

I'm trying create a stacked column report in PA. When I add the breakdown to the widget, it does not show on the graph. However, if I take that breakdown out of the widget and put it in the indicator, then I can view them breakdowns just fine. I have a report that we work off of, but I'd really like to utilize the trending with original view.

Report View (This is what I'm trying to recreate)

Widget with Breakdown

Widget without Breakdown

Breakdown working in the breakdown tab

[Tracy Davis · Accepted solution]

I think you need to create 4 indicators for this. Have your primary indicator that shows one stack of the bar - then scroll to the bottom of the widget, there's an area to add additional indicators. You can set the order and color for each bar.

This enabled me to create the stacked bar chart.

Hope this helps.

[charliehodgson]

Thanks. It's not ideal but I'll build it that way.

Here are two other threads that I've found since posting this.

https://community.servicenow.com/community?id=community_question&sys_id=88f807a1db5cdbc01dcaf3231f9619ce

https://community.servicenow.com/community?id=community_question&sys_id=ce2097e5dbdcdbc01dcaf3231f96196e

[ashtiw]

Follow these steps and you will be able to create stacked column chart just the same way you want.

1. Create an indicator and add breakdown items as "Type" which has the values: "Planned", "Urgent Change", "Latent" etc.

2. Run the job linked with the above indicator.

3. Add Widget and select type: Breakdown, Visualization: Stacked Column. Now add indicator and then go to breakdown down which is visible on the left side, and add your breakdown which you had selected while you were creating an indicator and which is "Type".

4. Select the time series.

5. Select the period from the date settings.

Save and Exit and you will get your stacked column chart.