Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
So I have 1 dimension and 6 expressions...i need a stacked chart so that expr1,exp 2,exp 3 show up in 1 stacked bar and exp 4,exp 5 ,exp6 come in the adjacent stacked bar chart.. is this possible
|
| |exp1| |exp4|
| -------- --------
| |exp2| |exp5|
| -------- --------
| |exp3| |exp6|
----------------------------------------------------------
Yes, most simple are to have another variable "Group· with 2 values possibles A y B
In the graphic you write the expressions:
exp1 = if(Group='A', exp1, Null())
exp2 = if(Group='A', exp2, Null())
exp3 = if(Group='A', exp3, Null())
exp4 = if(Group='B', exp4, Null())
exp5 = if(Group='B', exp5, Null())
exp6 = if(Group='B', exp6, Null())
and put Group in a dimension.
The bar are appiled
Yes, most simple are to have another variable "Group· with 2 values possibles A y B
In the graphic you write the expressions:
exp1 = if(Group='A', exp1, Null())
exp2 = if(Group='A', exp2, Null())
exp3 = if(Group='A', exp3, Null())
exp4 = if(Group='B', exp4, Null())
exp5 = if(Group='B', exp5, Null())
exp6 = if(Group='B', exp6, Null())
and put Group in a dimension.
The bar are appiled
Thanks got it working