I have a widget that shows performance total ticket paid count, total ticket paid amount, budget amount, budget to go, total seat unsold count and avg ticket price. I would like to add two more columns, yesterday's ticket paid count and yesterday's ticket paid amount. In other words yesterdays sales numbers. Is there a way to do this using a formula in the value for Ticket Paid Count and Ticket Paid Amount?
Hi Terry. Try this ...
5. RT Click and filter that [Year in Date]
6. Choose DAYS and TIME FRAME then choose YESTERDAY
Remember the whole function should be in brackets like (sum ( [Ticket Paid Amount]) , [Days in Date] )
That should do it. It looks OK here but our Analytics is playing up so I can't check it 100%
Hope that helps
Heath
Heath you are amazing! I also was pretty sure you would be the one to help because I was working so late, thank you! I have a couple more questions. What do I need to add to the formula to show zeros for those that have had no sales? I am so close to getting this report looking perfect thanks to you. The only thing I'm still missing is to show our ticket count budget numbers for each production. Is there a custom area in Production or Performance where I can add ticket count budget numbers and then pull that into the dashboard?
Hey Terry.
No problem. It was a fun discovery for me too. I just finished my Friday night D&D game but when i get to work in the morning I'll have a play around. I think there is an IF NULL function in there than I've been meaning to look at. That might do it.
Cheers
H
Hi Terry,
Me again ... Try this little conditional formula. It's my first ever but it seems to work.
IF ( ISNULL ( sum ([Ticket Value]) ) , 0 , sum ([Ticket Value]) )