Issue with line plotting for bar chart with line across two dimensions
I have chart with a stacked bar chart and a line chart plotted on different axes. I'm using both a month and year dimension. When I have the dimensions leveled as Month above Year then there are no problems with how the chart computes. However, when I switch the dimension order to Year above Month (which is my desired order) then the stacked bar chart plots correctly but the line chart does not plot correctly. For some reason the line chart takes all of the monthly values over a year and plots them vertically in the middle of the year. It does this for each year. I have no idea what is causing this...
Re: Issue with line plotting for bar chart with line across two dimensions
...but who cares I suppose.
A sort of.
In this situation (combo chart with bar and line), all monthly results are shown in the Year point. Don't ask me why, but if you disable bar expression and keep only one line expression, the months appear in the legend - the whole picture makes some sense. Not the one you want though.