Forum Discussion
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....
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,
That worked, thank you muchly!