Query based on dates/building daily tracker?

Hello! I’m trying to track some stats via last month, 14 days, 7 days etc with charts and get averages for each period.

I have 3 big tables, they are:

Call Data
Work Orders

Then I have another big table with Dates as the first column from 2022-2025 that is called “Daily Data”.

Id like to build a graph that is capable of showing the total transactions from the last month, bi-week or week like the first image.

But when I do a relation to the Transaction table from Daily Data the 2 dates are “12/12/2023, 12:14:35 PM” and “12/12/2023”. Even though both are set to date only and short.

Then if I do a excel or date format to make them the same it wont let me lookup or query.

The call page is a similar problem.

And I cant make the charts off the Call Data or Transaction data tables because it doesn’t give me the total for the day and/or I get duplicates.

Is there a better way to do this? Thanks for the help.