I'm trying to make a stacked barchart with 3 dimensions. Month, week country, and as expression the distinct count of orders.
I almost have it, but now I'm stuck with a little problem between the month and week dimension.
At the moment he shows per month all the weeks possible, but i want to show only the weeks of that month.
I've added a picture to clarify. In this picture i filtered down to 2 months. As you can see, in the first month i have 10 week, with only data for 5 weeks. The weeks from that month. In the other month the same. I dont want those empty weeks.
