Hello,
I am making a dashboard to run post-show analytics on an event the day after it passes. One piece of information I am interested in seeing is what are the top future performances that audience is coming back to see. Does anyone have any good tricks on how to run what subsequent performances those constituents are coming back to see?
Hi Michael,
A Constituent ID filter using a Ranking type filter to return only ticket holders from yesterday's events should get you started.
I don't have any "yesterday" events in my sample database, but the dashboard filter on Constituent ID (disabled within other widgets perhaps):
Another filter on Seat Sold Flag = Y to exclude the "Unsold Seat" Constituent ID -999999.
Then a pivot widget with its own filter on Performance Date using a Time Frame of Next 30 Days or whatever future time frame you want. And then performance details on rows and constituent counts and other values in place to get the results.