Hello everyone,
I'm hoping you can help with a conundrum. We have a festival set up as a Production in Tessitura. I'd like to create a visualisation which shows how many constituents came to a how many performances in that festival i.e. a column chart with a column showing how many constituents came to 1 performance, how many to 2 and so on.
I can create a formula to show how many performances each constituent came to, but can't work out how to aggregate that to show how many constituents fall into each category.
Has anyone achieved anything similar?
Thanks so much
Grae
Hi Grae,
Have a look at the pre-built dashboard for _Single_Ticket dashboard (you can load that dashboard directly from \Seats and Tickets\Jump To Dashboards), and in the bottom right of the dashboard, there's a Number of Performances by Customer widget. This Shipping Filter on this dashboard might still try to load a lot of data for your organization, so if you find the widgets spinning at you, click through all the "Cancels" and then set the dashboard filters for a smaller data set. Expand the widget, or Duplicate the dashboard and Edit the widget if that's better for you, but you'll find bucketing formulas in there that will get you started...
Thanks Chris (and Sara) for your help and suggestions.
Chris' suggestion is exactly what I was looking for.
Thanks again