I am trying to create a report that will chart out the frequency of order pickups into time ranges. We've collected the time of pick up for all of our orders, and I want to create a graph that shows how many people come in each hour. I have next to zero experience with Filemaker (16), so I am having a lot of trouble trying to do something that I imagine should be pretty simple!
I was trying to do it with a script that would separate the data into hourly chunks, but I'm not sure how that would be done, or if that would be the correct way to access, "chunk", and report the data.
Thanks in advance for any pointers!