Visualising number of performances constituents come to in a festival

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