I have written a calculation to place the Accrual Balance into bins based on the number of weeks Annual Leave. The calculation has placed the leave into the correct bins as it is displaying each in the table (see below) however when I add the calculation to a visual it only displays the last item in the bin (>12 weeks). Any suggestions on how to resolve this issue?
Hi Scott,
I don't see the Headcount in your tabular workbook so it is a little hard to compare the two.
I create a Visualization similar to yours with a Case statement.
This matches what I see in the Tabular Workbook if I include the 2 columns.
