Forum Discussion

hr_tetra's avatar
hr_tetra
Helper I
2 years ago

Weird date table issues 2024

Hi everyone,

 

I have noticed in to different datasets that if a date filter only include 2024 dates, the data dissappears. If I include some dates from 23 the data will be there. If I check the date table all the dates are there. I fixed it in one report by just replacing the date table with a new one, but now I see another report with the exact same issue.

 

Does anyone know what is causing this behaviour and how to fix?

 

Best regards,

 

hr tetra

Need Help

1 Reply

  • Idrissshatila's avatar
    Idrissshatila
    Super User
    2 years ago

    Hello hr_tetra ,

     

    make sure there are no filters on the report or the date table has dates for 2024.

     

    some date tables are made with calendar function with start and end date, make sure the end date is not 2023.

     

    you could use calendarauto function that would give you dates from the minimum date till the maximum in a current model.