Hello All,
As you can see on the attached, I have two sets up stacked bars. I would like to present these stacked bars side-by-side to each other; however, when I select "dual axis", the bars all stack on top of each other and are no longer separated.
I tried using the SPLIT([Measure]," ",1) function but I noticed this doesn't work on Date fields. Let me know if you have any suggestions.
Any and all help is much appreciated!
Mikey
I renamed 'Measure Name 1' to 'Effort Type' so I could distinguish it from Measure Name. Likewise, I renamed 'Measure Value 1' to 'Effort' to distinguish it from Measure Value.
The problem is that all the values you want to graph are all on the same week line, so they will all stack or they will all unstack. The values need to be arranged so that the values you want stacked are on one line and the value you do not want stacked is on the other line.
Because one of your bars is the sum of [Effort], a FIXED LOD can be used to place that sum on both date lines.
{ FIXED [Week Number]:SUM([Effort])}A dimension is needed to distinguish between the two lines. [Effort Type] could be used directly, but that could get confusing, so instead I used it to create a TRUE/FALSE calculation
IF [Effort Type]='Effort Done (D5+)' THEN TRUE
ELSE FALSE
END
Because the SUM[EFFORT] value is on both lines, one line needs to be set to not graph. The line that should NOT graph is the line that contains the 'Effort Remaining' calculations, i.e., the FALSE line
//_Graph Sum Effort
IF [_TrueFalse]=FALSE THEN NULL
ELSE { FIXED [Week Number]:SUM([Effort])}
END
Now you can create a dual axis chart. Place the [_TrueFalse] field on the columns shelf to separate the stacks. Place the [Effort Type] field on the color mark of the [_Graph Sum Effort] chart.
