Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Issue modelling date table with dates in other tables

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

 

 

 

  • negi007's avatar
    negi007
    5 years ago

    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.

5 Replies

  • timg's avatar
    timg
    Icon for Solution Sage rankSolution Sage

    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

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi Rim,

     

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

     

    Thanks,

    Yoshi

    • negi007's avatar
      negi007
      Icon for Community Champion rankCommunity Champion

      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's avatar
        Anonymous
        Not applicable

        Hi negi007

         

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