4 Replies Latest reply on Jul 22, 2019 1:08 AM by Simon Runc

    Despite null data, show all selected dates with date range filter in line chart

    Barry Jhang

      Hi,

      I am novice in Tableau. This question has been bothering me for a long time. I have a data like this below

       

      task_idperson_in_chargebig_taskstatusstart_atcomplete_at
      1191556FALSEstart2019-07-13NULL
      1193556TRUEstart2019-07-01NULL
      1194667TRUEstart2019-07-05NULL
      1195556TRUEcomplete2019-07-032019-07-20
      1198658TRUEcomplete2019-06-032019-07-05
      1196556TRUEcomplete2019-07-032019-07-03
      1197556TRUEstart2019-07-07NULL

       

      I try to print line chart by using date range filter. For example, if I select the date range which is from 2019-06-30 to 2019-07-06 and status is complete, I want the line chart axis that show all data between 2019-06-30 and 2019-07-06 even if there is no data in that date. I have tried to create start date and end date parameter,

      but I don't know how to do for the next step. Is there is anybody who could help me

       

      thankful and grateful

      Barry