I'm trying to add a 'Number of seats sold yesterday' column to my daily report dashboard.
I've tried this but it returns zero:
PASTDAY([TOTAL TICKET PAID COUNT])
What am I missing?
I think you'll want to filter it based on order or transaction date? I can't test it because we don't have any sales yesterday, but try this formula:
(sum([Ticket Paid Count]), [Days in Date])
Where the date field is Order Date filtered to Time Frame > Days > Yesterday
Thanks Anna, that did the trick :)