New business owner and attempting to build a database with it. I’ve exhausted YouTube/online docs before registering here so I apologize if this is a simple question for the veterans.
I’ve got 300+ records and I’m trying to generate charts from the data. I can create charts of the total database, but can’t work out how to limit to a particular date range (one day or one week).
For example I can chart the number of reports different publishers have made overall, but I’m interested in narrowing it down to numbers of reports those publishers make per day.
One of my record fields is ‘Date Published’ which opens a drop down menu to select the date, so the criteria exists within the dataset.
So far I have not attempted any scripts or relationships, but would be willing to learn if this will help move forwards.
Any help would be genuinely appreciated, I’ve spent hours trying to do this.