topic Re: combine two bars into single stacked graph in App Development

combine two bars into single stacked graph

LP27 — Sat, 16 Nov 2024 04:05:42 GMT

Hi Everyone,

Please find my issue below-

I have got the Bar chart as shown below in the picture-

It shows two bars for the same Dimension. Ex- Bar 1 = 206699-1001 (363) and Bar 2 = 206699-1001 (32).

Now i want to Show only one Bar as below pic-

Is there a possible way to do this ?

Note: There is only one Dimension and one Measure for the Bar chart.

Thanks in Advance!

Re: combine two bars into single stacked graph

sunny_talwar — Mon, 18 Nov 2019 15:33:23 GMT

If both of the dimension values are the same why is it not getting merged into a single bar by default?

Re: combine two bars into single stacked graph

LP27 — Mon, 18 Nov 2019 15:38:43 GMT

I have used dual function, hence its showing in two different bars.
Now I need to stack one above the other like stacked bar.

Re: combine two bars into single stacked graph

sunny_talwar — Mon, 18 Nov 2019 15:55:02 GMT

Then why not use 2 dimensions and one measure... 1st dimension: Text part of the dual function and 2nd dimension: Numeric part of the dual function and then create a stacked view?

Re: combine two bars into single stacked graph

LP27 — Mon, 18 Nov 2019 16:05:02 GMT

How is that ?

In my scenario,

dual function that i have used in Script editor = dual(compart_no, Row no()) as Compart_no

My Dimensions - compat_no

My Measure - sum(time)

Could you tell me how can i do it for the above scenario?

Re: combine two bars into single stacked graph

sunny_talwar — Mon, 18 Nov 2019 16:21:25 GMT

May be instead of creating a dual field... created a new field using RowNo() as RowNum which can be your second dimension. Script

Table: LOAD compat_no, time, RowNo() as RowNum; LOAD * INLINE [ compat_no, time 206699-1001, 363 206699-1001, 32 ];

And you can always turn off the legend under Appearance -> Colors and legend - > Show legend OFF

Re: combine two bars into single stacked graph

LP27 — Mon, 18 Nov 2019 17:59:33 GMT

Thanks Sunny!

It worked 🙂

Appreciate it!