Forum Discussion

anna93's avatar
anna93
Regular Visitor
6 years ago

Calendar table does not work

Hello all!

 

I have created a Calendar table using AUTOCALENDAR() and CALENDAR() and created a relationship with my existing tables using the Date column. However when I try to create any form of visualitzasion, or use the date filter from the Calendar table, it doesn't recognise the data from my other tables. I have watched many Youtube tutorials and followed each step of the process with no success. Both calendar and the column 'table' are formatted as date and I marked the Calendar table as a 'date table'. 

Hope someone could help me to understand what the issue is.

Thanks in advance. 

 

 

 

 

Need Help

3 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    6 years ago

    anna93 , Can you share the relationship diagram.

    Also, check if have a timestamp in your date. That might not be visible just because of format.

     

    In such case have date column and join with that

    Date = [datetime].date

    • anna93's avatar
      anna93
      Regular Visitor
      6 years ago

      Thanks for your reply.

       

      I remove the timestamp from the date column (WFFinancial) by formatting as dd/mm/yyyy.

       

      Here is the relationship by the Date columns.

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        anna93 
        Which column did you used between the other table and financial table?

        Try  link the other tables with calendar table rather than financial table, see if there is some error message pops up. 


        Paul Zheng _ Community Support Team
        If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.