Reporting on attendance for all Saturdays in a year

Hi all, does anyone have guidance on how to get a report on attendance from all Saturdays from last year?

Tagged:

Comments

  • @Laura McCabe There may be a different way, but this works. Run a Daily Admission report from the Sales page. Choose Last Year. You can then export it to .csv and it gives you all the data. You would have to add the days of the week to the dates to filter out Saturdays, but that would be pretty quick. Then, you could sort by day of the week.

  • @Tami Goertzen

    The export process does work pretty well; it's what we used when asked to find all paid weekend admissions. Using Excel, I had to add a helper column that converted date into day of the week, and then I used a pivot table to limit results to the weekend and break down by price type.