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
Transactions
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.