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. Right now my date slicer doesn't affect the value from that Sum Of Hours card.

 

 

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,

2 Replies

  • ajaybabuinturi's avatar
    ajaybabuinturi
    Icon for Super User rankSuper 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,