I'm trying to make a report that will show how many people picked up at each hour throughout the day for each day of the week. I thought it would be best to do 5 different reports, one for each day of the week, with a chart of the number of people picking up for each hour of the day.
I would think you could do this with a script that starts when the layout is opened, that says something like "if DayOfWeek(Date Picked Up) = 2, go to Monday's layout" but I'm not sure how/where to implement this logic to make filemaker do what I want it to do. I also wanted the report to only take data from the last year, so I have a find request for the last year in a script on enter already.
Thanks for any help you can offer!