Alright friends. I have a few questions today. Hi friends! I am working on a Summer Camp Sales Dashboard.Below is a screenshot. I am running into a small issue and I am hoping a guru here can help me out!I highlighted 2 columns below. I want to know the Total Capacity of a given performance in the first highlighted column. Then in the second highlighted column, I would love to have the number of unsold seats. Any help would be grand!
Hi Antonio,
First, you'll have to move these fields from the "Rows" section to the "Values" section.
For total capacity, Seat Count should populate what you need once it's moved.
For unsold seats, you can use the "Seat Unsold Count" field, which populates based on the "Seat Sold Flag." (more info under the Seats and Tickets Values section here)
Editing to add: I noticed that you're using the "Ticket Paid Value" field. Forgive me if you already know this, but I always like to remind people that this shows the price of a purchased ticket, not necessarily the actual amount paid. To get the amount paid for a line item, use "Ticket Paid Amount" instead. More information on this in the same section mentioned above.
This is all quality feedback! And I didnt know about the Ticket Paid Value. I really appreciate it. Let me see what I can do here.