I'm having trouble with a Bar chart where the month is not totaling up as a single month. Instead, I'm getting a Bar each entry of the month. See the attached screenshot which may help this make more sense. I should only have one stacked bar for 201901, one for 201902, one for 201903, etc, with the stacks representing each CIO / LOB that has charges for that month. 201901, 02 03, etc, should only show once across the bottom.
CIO / LOB is simply loaded in the load script with no manipulation. ESTIMATED BILLING START2 is loaded from the load script and created as follows:
AddMonths(Date([COMPLETION_DATE], 'MM/DD/YYYY'), 1) as [COMPLETED ESTIMATED BILLING START2] <-- This is part of the initial load, then a couple more tables are loaded - A NoConcatenate Resident load, then a left join to Excel data and then another NoConcatenate Resident Load is performed where ESTIMATE BILLING START2 is created as follows
Date([COMPLETED ESTIMATED BILLING START2], 'YYYYMM') as [ESTIMATED BILLING START2]
Finally, here is the expression I'm trying to use: