Forum Discussion

CPL's avatar
CPL
Frequent Visitor
8 years ago

Time axis: Complete timeline instead of existing data points

Hi All,

 

When working with time & date data (e.g., date as x axis in a column chart), dates which do not exist in the data set are skipped. 

 

Let's say I look at retail revenues (store is closed on Sunday and every second Saturday), I will just not see these days in the chart, rather than seeing a day with no revenue. Instead I would like to see a complete timeline, with zero revenue on days which are not in there. 

 

I guess this is quite a standard question - is there an easy solution to it? 

 

Thanks,

Chris

7 Replies

  • CPL's avatar
    CPL
    Frequent Visitor
    8 years ago

    My question has changed a bit - I found that I can select "Show items with no data" which gives me the effect I was looking for. 

     

    Problem now is, that filters and slicers can not limit the timeline in the visual e.g. if I do a relative filter only for the next 30 days (future), I still see the past in the visual. 

     

    Also, when trying to zoom into the timeline with a slicer, the timeline doesn't move although I select only a specific date range in the slicer. 

     

    Anyone knows a solution?

     

    Many thanks,

    Christian 

    • CPL's avatar
      CPL
      Frequent Visitor
      8 years ago

      And one follow-up... has any one managed to get the show items with no data function running on a hourly basis? Seems only to work in the given date hierarchy formats down to days. Thanks!

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      CPL,

      Firstly, I am unable to reproduce your issue that relative filter doesn't filter visuals. Could you please share dummy data of your table so that I can test?

      Secondly, do you use Timeline slicer and built-in slicer? Do you select data range in built-in date slicer, then use the slicer to filter values in Timeline? If so, I am unable to reproduce this issue, please post screenshots.

      Thirdly, you would need to create a hour column in your table, then drag the hour and date columns into X-Axis of chart.

      Regards,
      Lydia

      • CPL's avatar
        CPL
        Frequent Visitor
        8 years ago

        Hi Lydia,

         

        Thank you very much for your reply - highly appreciated. I attached an example file which shows the problem. https://ufile.io/d1qo5

         

        When show itmes with no data is selected, the slicer does only remove bars from the chart but does not cut the chart / zoom in. When it's not selected, the chart illustrates only the timespan selected in the filter. The problem for me is that, when I zoom down to days or even hours, you have to scroll hours just to get to the relevant data.  

         

        Thanks, 

        Christian