In PA Widgets containing multiple Indicators, how to stack specific indicators with specific other indicators

[Hanleyp]

Hi Folks,

I have 6 indicators in a widget. 3 contain positive dollar values, and three contain negative dollar values. However, the end user wants the negative values displayed in the positive domain, so I used a formula indicator (value*-1) for them. Therefore, though they are positive, they are really negative, and this only impacts what I'm about to ask, because it would be easy if they didn't go this route. The negative designations are done via color coding, red for negative and blue for positive.

So, here's the problem. The end user wants these grouped in stacked columns, showing the reds in one stack, and the blues in another stack. Being that these end up all on the same side of the zero slope of the chart (top/positive) I am lost on how to simply stack three specific reports together, and the other three together to create the visual they are seeking.

Is there a specific widget for this? I'm just using the basic Time Series type. Any way to accomplish this view? Thanks so much for your help folks!

Paul

[sachin_namjoshi]

You can Create a stacked column visualization for a breakdown widget.

Check below

https://docs.servicenow.com/bundle/orlando-performance-analytics-and-reporting/page/use/performance-...

Regards,

Sachin

[Hanleyp]

Thanks Sachin. Unfortunately, the view shown in that link is the problem. I need to have the widget combine only specified indicators with other specified indicators. For the sake of simplicity, let's say I have 4 indicators, all containing positive values, but Named A, B, C, and D. 

I want indicator B stacked with indicator D. Then, I want indicator A stacked with indicator C. After reviewing the features of the breakdown widget, I am unable to locate a method of specifying which indicators get stacked with other indicators, yet all need to be included in the overall view.

The secondary part of this issue, is that 2 indicators trend on one particular date field, while the other 2 trend on another. However, I need one from each category to stack with the other. 

Can a breakdown widget accomplish something like this? Essentially, I need to be able to specify which indicators stack with others, and still include 4-6 of them all on one widget. It's almost as if I need to build a widget for each pair, and then add those widgets to a master widget.

[Hanleyp]

BTW, I also tried using a Breakdown Widget, and built two breakdowns to "group" the indicators in the widget, and filtered those by two elements, to no avail.  

[sachin_namjoshi]

Following article should be useful to you

https://hi.service-now.com/kb_view.do?sysparm_article=KB0724552

Regards,

Sachin