1 Reply Latest reply on Jun 27, 2018 6:57 PM by ArseneXie

    Display all values in a dimension - LOD calculation help

    Dylan Brandon



      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.