Adding a side-by-side bar chart to a stacked bar chart in Platform Analytics or UI Builder

[rupro]

Hi all,

I currently have a stacked bar chart data visualization which effectively shows Cost A and Cost B stacked onto a bar. I want to add an adjacent bar to each stacked bar in this visualization which will be a value represented by 'Budget'. I have the data for Cost A, Cost B and Budget coming in from a data resource properly & loaded as metrics. The only problem is that, I can not use a mixture of both stacked bar chart and side-by-side bar chart. 

Posting an example chart for what I'm trying to achieve

[Dr Atul G- LNG]

Hi @rupro 

You can try one thing: there's a concept called in the Legacy Reporting dataset. Create a dataset based on these three different values and try it. However, my gut feeling says it might not be possible because on one side, you want to show a bar, and on the same chart, you want to stack it.

https://www.servicenow.com/docs/bundle/yokohama-now-intelligence/page/use/reporting/concept/c_Multip...

[rupro]

I already have a stacked chart (check screenshot 1). It is built using a developer test instance and has 2 metrics stacked onto each other. What I want to do next is add a 3rd metric and have that appear as a column which shouldn’t stack but instead appear side by side to the stacked bars (i.e the orange bar from screenshot 2 should appear as the 3rd metric and the blue bar appears as a stacked bar). Is there any way to do this i.e making a chart using both stacked as well as side-by-side capabilities?

Screenshot 1 consists of me using ‘stacked’ variation under chart

Screenshot 2 consists of me using ‘side-by-side’ variation.

Table used for data resource: fm_expense_line

Metrics used: (using the same metric twice for the sake of this example) amount

[rupro]

I already have a stacked chart (check screenshot 1). It is built using a developer test instance and has 2 metrics stacked onto each other. What I want to do next is add a 3rd metric and have that appear as a column which shouldn’t stack but instead appear side by side to the stacked bars (i.e the orange bar from screenshot 2 should appear as the 3rd metric and the blue bar appears as a stacked bar). Is there any way to do this i.e making a chart using both stacked as well as side-by-side capabilities?

Screenshot 1 consists of me using ‘stacked’ variation under chart

Screenshot 2 consists of me using ‘side-by-side’ variation.

Table used for data resource: fm_expense_line

Metrics used: (using the same metric twice for the sake of this example) amount

[johnhebenstreit]

We have the very same question when trying import our legacy performance analytics dashboards into platform analytics.  We had successfully created pa widgets that mixed lines, bars and stack bars in a single  PA widget.  The migration tool for platform analytics did not handle this after importing.

We haven't able to replicate this in Platform Analytics:

After migrating, all the columns were stacked and we had to update each widget to get the line graphs to display fully:

Please help!