Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 ?
can you share your application?
I feel like this is possible but can't quite picture it
Hi,
Can you attach your QVW file?
Here is QVW file.
Is this correct?
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 ?
Hi Mohan,
Your Bar Chart has already Stacked Bar.
Below is the image for your reference.
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.
Hi Mohan,
Do you want like this??
OR
I personally wouldn't worry too much about the calculated dimension if it works.. are you seeing a huge performance issue with it?