Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
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.
How can I change this?
Thx in advance!
Check 'Suppress When Value is Null' in Dimension tab. Check- 'Suppress Zero Values', 'Suppress Missing' in presentation tab.
hope that helps
Hi Tres Qv,
thx for the quick reply. I tried it, but it doesnt seem to change anything.
I've added the qvw, maybe i did something wrong.
Thx!