Issue modelling date table with dates in other tables

[Anonymous]

Hi,

I am trying to build a dashboard which lets me have an overview of team performance. I am attempting to create a simple bar chart which shows the number of tasks created over time.

So i'm currently facing an issue where I have a table which has the start date of a task with the task name and ID.

I simply want to connect the start date from that table to the date table so I can slice the count of tasks using the data table. 

However when i try to slice the number of tasks by the data table it just comes up blank.

So you can see here, I have 58 tasks that slice when i use the start date of the same table

But, when i slice with the data table it says blank despite the start dates falling within that parameter

Same thing here when i use the date table date on a bar chart no data is showing

Can anyone help me understand why the date table isn't functioning as I intend it to? 

Thank you,

Yoshi

[Anonymous]

Hi Rim,

I can confirm all data columns across all tables are in the same format(dd/mm/yyyy)

Thanks,

Yoshi

[negi007 · Accepted solution]

@Anonymous I can see all your date column has calender icon against them. However, start date does not have the calender icon against it suggesting me that data in that column is not in the date format. Can you please check.

[Anonymous]

Hi negi007

Good spot, i've checked and it is in data format? not sure why thats happened?

[negi007]

@Anonymous i hope your issue has been resolved now. Thanks

[timg]

Hi Yoshi,

Could you check first whether the date columns you are trying to use in the relationship are in the same format. E.g. if the date in table one is in date format (01/01/2021) and the other is in datetime format (01/01/2021 00:00:00) the join won't work.

Regards,

Rim