Calendar table does not work

[anna93]

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. 

[amitchandak]

@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]

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]

@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.