3 Replies Latest reply on Jan 23, 2019 3:14 PM by Zhouyi Zhang

    How to Include all days in month even when null

    William Mitchell

      Question regarding dates and nulls. 

       

       

      The top of this picture are days in a certain month, the bottom are the number of records. I want to include all the days in the month for example this picture starts January 7 and I want it to include (jan1,2,3,4,5,6). I have tried "show missing values" which included the 0 values, But I cannot seem to find a way to get the first days of the month.

       

      If anyone has a simple solution please let me know.