Hi,
Has anyone got a good way of finding out how many people visit once, twice etc a year?I've got an approach but it's not great (filtering by exhibition, Rows: CID, Values = number of unique perf codes, Columns = fiscal year). Requires me to export and do a COUNTIF in excel.
Would be great to have a stacked bar chart by fiscal year showing proportion who visit x number of years. Or even a table with # of visits = # of constituents
Any ideas?
Hi Ronan,
That's absolutely doable. The Pre-Built Single Ticket Jump To Dashboard has a widget called Number of Performances by Customer that sounds like what you're looking for. Also this thread for a deeper dive: (+) Comparing ticket buyers and tickets for two or more events - Reporting & Analytics - Forums - Tessitura Network
Best,Chris