Stacked charts in Performance Analytics

[ncp]

We have been tasked in creating a stacked bar chart in Performance Analytics and the way we have been doing that is by creating multiple indicators and adding that to the widget indicator as a stacked column visualization. The problem is it works if the number of "stack by" is small or manageable. The requirement is to stack by CI which has 100's of records and creating individual indicators for those are an impossibility. Is there a way to get stacked column visualization without having to build individual indicators?

Thanks

[Adam Stout]

Is you indicator collecting the breakdown matrix?  You have to have that if you want to combine two breakdowns (one at the dashboard level and one on the widget).

[paolomerlo]

Hi ncp,

it should work. 

You must have "Follow element" checked in the widget and you must have breakdown matrix between the breakdown used at dashboard level and the breakdown you defined in the widget.

Moreover if you have the same breakdown in dashboard and in widget you have a strange behavior, i.e. the dashboard filter is not applied and you continue to see all elements instead of the only one selected at dashboard level.

I hope this help.

Best Regards,

Paolo.

[ncp]

Thanks Paolomerlo, follow element was selected, just did not highlight that in my screenshot. It seems to work fine on the pie visualization, just does not work for stacked column. And its not the same breakdown at the dashboard level vs widget level. It might be a  bug in ServiceNow would be my guess

[ncp · Accepted solution]

For those who are interested, finally got it to work

1) On the widget level select visualization as stacked column under breakdown

2) Select the indicator and breakdown

3) On the indicator itself you have to make sure the "collect breakdown matrix" is selected

4) Run your jobs one more time and now you can follow the dashboard level breakdown as well as stack by indicator level breakdown