I am building displays of sales achievement, I have the account manager as a filter, with the week in quarter it was booked (1-12)
Currently, if the account manager only achieved sales in week 1,4,12 only three bars will show. I need the x axis to constantly display weeks 1-12.
I am thinking this is a LOD calculation, but I'm unsure what to put.
Achievement week is a string dimension, not a date.
Below is an example of what it currently looks like.
Any advice is appreciated. Thank you.
You can try "Analysis > Table Layout > Show Empty Columns"
to enable "Domain Completion".
And the issue is about data densifiation.
You can get more info from Joe's vedio: