This is a little baffling.
I've created a small dashboard for a registration (comp) event that we are running. I've got a lovely Scatter Map telling me where around the world people are booking from, and a widget that counts number of unique Constituent Id. But total ticket count is 0. I can use rows to show the price type and even the constituent Ids of all the people who have allegedly not bought a "ticket". bi.VT_ORDER_DETAIL has all of the sales and I have a seat map full of orders.
I can't figure why I might have a Ticket Count as 0?
2526.DanceLocale.dash
If that doesn't solve it, you may also want to try a formula. I have DUPCOUNT(Ticket Paid Value) on a few dashboards to count items that did not have their own count element.
DUPCOUNT is a row count... So should return 2 for a single ticket that has 2 price layers. Can I recommend an alternative workaround of COUNT( [SLI ID] ) or [# unique SLI ID]? And then filter out unsold seats.
Thanks Both. They are excellent solutions and I now have a working gauge in rainbow colours as the registrations go up