Forum Discussion

PatrickMcLeanGL's avatar
PatrickMcLeanGL
Frequent Visitor
1 year ago
Solved

How to Tie Two Tables Together?

I have a dashboard that takes values from "Current Data" table, but I also want to include a card value from my "ADP Hours" table that sums up the total hours in that table for the date range chosen....
Need Help
  • ajaybabuinturi's avatar
    ajaybabuinturi
    1 year ago

    Hi PatrickMcLeanGL,

    I belive your question is, are we restric the data with same date slicer/filter for both column and card charts.
    Yes, we can achive the results by creating relationship between "Current Data" and "ADP Hours" tables by using "Date" column.

    If the dates are not unique, create separate "Date/Calander" table and then create a relationship between "Current Data", "ADP Hours" and "Date/Calander" table by using "Date" column


    Thanks,

ajaybabuinturi's avatar
ajaybabuinturi
Super User
1 year ago

Hi PatrickMcLeanGL,

I belive your question is, are we restric the data with same date slicer/filter for both column and card charts.
Yes, we can achive the results by creating relationship between "Current Data" and "ADP Hours" tables by using "Date" column.

If the dates are not unique, create separate "Date/Calander" table and then create a relationship between "Current Data", "ADP Hours" and "Date/Calander" table by using "Date" column


Thanks,