Stacked bar chart always shows a 0 line on top of every stack for the last series
I'm creating stacked bar charts in Fusion business intelligence.
I'm using a custom DM, which is working fine. I'm creating the bar graph based on employee count.
The chart is using column Region2 (which is the basically larger geographic region) as the grouping.
The actual stack(series) is by column Region (which is basically country). So for each Region2, we are stacking Region on top of it.
Everything works fine, except the last Region is always stacking on every Region2, even though it belongs to only 1. The others get a thin line showing 0.
I'm attaching screenshots. You can see in the example, the last series is 'United Kingdom'. In the data table, you can see that UK only has data in region2=EMEA.