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

    Display all values in a dimension - LOD calculation help

    Dylan Brandon

      Hi,

       

      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.

       

      Capture.JPG