• Replies 1 reply
  • Subscribers 962 subscribers
  • Views 53 views
  • Users 0 members are here
Related

Counting Number of Performances that Met Goal?

Gabe Rivera
$organization

I'm trying to figure out if there's a way to create a chart in Analytics like the one I made in Excel after some data grouping; within a series for multiple seasons, counting the number of performances that made goal. As you can see in the chart I created custom ranges to group how much the performances made goal by:

Parents
  • $organization

    Hi Gabe,

    Something like this should get you started... a count by performance of performances having a %revenue of budget between 50% and 60%.

    SUM ( [Performance ID] ,
      IF ( [Total Ticket Paid/Reserved Amount] / [Max Budget Amount] >= 0.5
        AND [Total Ticket Paid/Reserved Amount] / [Max Budget Amount] < 0.6
      , 1 , NULL )
    )
Reply
  • $organization

    Hi Gabe,

    Something like this should get you started... a count by performance of performances having a %revenue of budget between 50% and 60%.

    SUM ( [Performance ID] ,
      IF ( [Total Ticket Paid/Reserved Amount] / [Max Budget Amount] >= 0.5
        AND [Total Ticket Paid/Reserved Amount] / [Max Budget Amount] < 0.6
      , 1 , NULL )
    )
Children
No Data