2 Replies Latest reply on Oct 27, 2016 10:32 AM by paolo.raia

    Unique dates on column shelf

    paolo.raia

      Hi,

       

      Take, for example, the following simplistic data set:

      1-Jan

      1-Jan

      2-Jan

      3-Jan

      3-Jan

      5-Jan

       

      I would like to add these dates onto the column shelf but as unique values:

      1-Jan, 2-Jan, 3-Jan, 5-Jan

       

      What would be beneficial is to also include any missing dates in-between, I.e. 4-Jan.

       

      Is there a way to achieve this without having to create a mapped file with all the required dates?

       

      Many thanks and regards.