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.
Hmmmm. My "Total Seat Count" seems to be duplicating the "Total Ticket Count"and the "Total Seat Unsold" seems to be giving me zeros all the way around. Any help would be wonderful. Thanks in advance.
I get our capacity with this formula: SUM([Total Ticket Count])+SUM([Total Seat Unsold Count])For the unsold seats, make sure you've got the sum selected:
Does your widget or dashboard have a "constituent ID not equal to -999999" filter? That will usually cause this.
Hmmm. My widget has the follow filters. And my dashboard has these filters ...
Ah, that'll do it too. An unsold ticket doesn't have a price type. Can you add (none) to your price type filter selections and see if it helps?
Hmmmm. I did that. I am still getting zeros in that column.
Wow. So (none) doesnt exist in our Price Types. I tried "other" and that did nothing.
Interesting! I didn't know not having it was an option.
Maybe try formulas in those columns and see if they populate that way? I would try:
(sum( [Seat Unsold Count] ) , ALL( [Price Type] ) )
(sum( [Seat Count] ) , ALL( [Price Type] ) )