2 Replies Latest reply on Sep 15, 2018 3:22 PM by Ken Flerlage

    Missing dates before earliest date in data source

    chris.calmeijermeijburg

      Hi all,

       

      I've created a viz to show the number of documents that are received per week for the current calendar year. The data source has a column with a date and a column with an ID of the document received:

      Capture3.PNG

       

      The viz then performs a distinct count on Work Record ID and aggregates this per week:

      Capture1.PNG

       

      The problem I'm encountering is dat the earliest date in my data source is half January, which causes the viz to not show any data for the first two weeks of January:

       

      Capture2.PNG

       

      I know I can use 'Show missing values', but this only works for missing values in between dates, not for the dates before the earliest date in my data source. Is there any best practice way to solve this? I've attached a sample of my workbook.