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 ?

[vangurideepu]

Hi Adam,

Please provide the expression for that....

[mohan2391]

I want as like in 1st one but there i want 9 stacks in each bar, showing how much 1 particular status(stack) is contributing into the Approval/Creation . . .

[mohan2391]

For now, i didn't face any issue as the development of this dashboard is started recently but in future they are planning to include many things in this.

Okay, anyhow i will follow this approach for now.

If i face any issues in future, need to look for some other solution.

Thank You for your support..

[mohan2391]

Thank You Adam and Dinesh for your support..

[dineshm030]

Hi Mohan,

I think, you want like this.