Have an ticketing app where I need to create a report to show daily numbers in a list sorted by date. Here are the totals I need to report for each day.
Number of tickets sold
Number of tickets redeemed
Total revenue
I have a collection called “orders” that stores date paid and date redeemed. I also have a collection called “order items” that contain each ticket with its price that has a relationship with the order collection.
Each date could have 100 orders. I need these to all roll up into one number. My goal is to have a list sorted by date newest to oldest and only show dates that have either tickets sold or tickets redeemed.
Any ideas? I would appreciate any help I can get because I’ve been racking my brain for 2 days now.
Hi, I have a ticket sales app with these functions
Publish my events, create event ticket prices, share my event link, add event staff, ticket control, create PRs to sell the event with a sales link, see the report of tickets sold, sale of PRs and more.
If you need a report that happens every day you must add a date report to the database that says day purchased, day redeemed… when you buy you put the day purchased start of today when you redeem you put start of today.
To filter: tickets,>count that sold which day is equal to start of today, redeemed>count which day is equal to start of today…
Then you can also play with the calendar… when you select the calendar, show me all the tickets that date is equal to input calendar