• Replies 2 replies
  • Subscribers 961 subscribers
  • Views 52 views
  • Users 0 members are here
Related

Counting Sold Out Performances Per Season

Anh Le
$organization

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

Parents
  • $organization

    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

Reply
  • $organization

    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

Children
No Data