Hello Everyone,
One of the Stacked bar chart is showing gray areas, we have 2 dimension and the year is starting from 2013 and another dimension which is category - distinct count in 1880 and not all the months in the chart has all the categories.
Measure I am using is:
COUNT(distinct ID)
/
count(Total<MonthYear> distinct ID)
Please let me know how to bring 100% stacked bar for all the months.
Appreciate your feedback on this