# Query based on dates/building daily tracker? **URL:** \ **Category:** Ask for Help\ **Created:** [June 18, 2024, 11:48pm UTC](https://community.glideapps.com/t/query-based-on-dates-building-daily-tracker/74214 "2024-06-18T23:48:56Z")\ **Posts on this page:** 1\ **Page:** 1
**Author:** ![Travis\_Anderson](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/travis_anderson/32/61251_2.png) [@Travis\_Anderson](https://community.glideapps.com/u/Travis_Anderson)\ **Post date:** [June 18, 2024, 11:48pm UTC](https://community.glideapps.com/t/query-based-on-dates-building-daily-tracker/74214/1 "2024-06-18T23:48:56Z")
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. ![1](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/f/4/f4255bc753b241a0a1e59283f8e0fae70e2c94f8.jpeg) ![2](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/0/f/0f008e93211d8a9c06d6529e55ed69e7d70c9a1e.jpeg) ![3](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/1/6/16e03e2199d22c5b45d2c787c5538ffef2439f26.jpeg)