stacked bars

[mohan2391]

Hi,

Please find the attached word document.

I have a bar chart with 2 expressions

1.avg(tat_approval)

2.avg(tat_creation)

and i want to show this data by a cyclic group of Month,Quarter,Year,Week and client also asked to show the segregation of data for different statuses(STATUS field) as well so i included that as 2nd dimension.

By default i'm getting a stacked bar with 2 bars(expressions) (Approval+Creation) with different bars for diff statuses. (Totally 10 stacked bars for 10 statuses under each month/week/year/quarter)

Now, what i want is can i show it as 2 stacked bars only under each month/week/quarter/year with stacked bars as statuses.

If possible, how can i achieve it ?

[adamdavi3s]

can you share your application?

I feel like this is possible but can't quite picture it

[dineshm030]

Hi,

Can you attach your QVW file?

[mohan2391]

Here is QVW file.

[adamdavi3s · Accepted solution]

Is this correct?

[mohan2391]

Yeah,

This is super Adam.

But i hope using Calculated Dimension is not good when we look from Dashboard Performance.

So, is there any other approach if possible ?

[dineshm030]

Hi Mohan,

Your Bar Chart has already Stacked Bar.

Below is the image for your reference.

[mohan2391]

That is what I said Dinesh..

If you see October data, there are 9 stacked bars(1 stack for Approval, 1 stack for Creation) for 9 diff statuses.

But i want 2 stacked bars only under October, each contains 9 stacks (for 9 statuses). 1 for Approval, 1 for Creation.

[dineshm030]

Hi Mohan,

Do you want like this??

OR

[adamdavi3s]

I personally wouldn't worry too much about the calculated dimension if it works.. are you seeing a huge performance issue with it?