I'm looking for help creating a simple bar chart that will show me the number of unique performances per season in which the sum of total paid/reserved tickets and total comps exceeds a certain number...but can't figure out quite how to build the necessary formula. (I currently have a workaround with a pivot table that is filtered from largest value to smallest, but would like something a little more elegant to show my executive leadership.) Does anyone have any ideas or suggestions on how this might be accomplished within Analytics?
Thank you!Anh
Hi Anh,
Sound like you would have Season on the Categories of the bar chart, and the a Multi-Pass Aggregation over each unique performance to determine if it should count toward the total. You won't be able to copy/paste this into your Analytics, but when you're creating it, replace the ##### with your lower bound for inclusion.
SUM ( [Performance ID] , IF ( [Total Ticket Paid/Reserved Amount] >= ##### , 1 , NULL ))
Best,Chris