Hi team,
I'm trying to recreate a google spreadsheet we've used in the past to track our daily ticket sales for each show. I need help getting the values to show what I want them to.
My Column needs to be Day of the Year, my Row needs to be the Performance Code. The Values need to be the Ticket Total Paid Count, and the number needs to be cumulative to show the grand total number of tickets sold for each show to date. This way, we can look down the row of a certain performance and see how it's numbers have grown or fallen so we know if we need to push its marketing or not. Right now, I have the performance codes showing correctly, but the Day of the Year and the values aren't showing up right. If possible, I'd like to format the Day of the Year as May 1, May 2, May 3..., rather than just numbers because that's hard to see where each months begins.
I've included pictures of the Google Sheet and my widget so far. I believe what I'm essentially doing is recreating a Ticket Sales By Period report, just shown as a Pivot table.
Google Sheet to be recreated:
My Widget as it stands now:
Thanks as always for your help.
Sara Funk (she/her)
Tessitura System Administrator
OGUNQUIT PLAYHOUSE
Theater that Enlightens, Entertains and Inspires
Would it work if you changed "Calendar Day of Year" to "Performance Date", then click the calendar button to change how the dates are displayed?