• Replies 2 replies
  • Subscribers 962 subscribers
  • Views 79 views
  • Users 0 members are here
Related

Counting number of visitors by number of visits in a season

Marie-Lisa Burrough
$organization

I can work out how to count how many times a first timer visits thanks to previous discussions, but more simply want to know, how many shows in a season our buyers are buying

Is there a simple calculation for #cbooking for only 1 show in a season; # booking for 2 productions, etc etc

Thanks!

Parents
  • $organization

    I use this formula which I've most certainly gotten from elsewhere on the forums!

    SUM ( [Constituent ID] , IF ( [# of unique Performance] >=2 ,1 , 0 ) )

    And then just change out the highlighted section depending on how many performances I want to track. I have also changed out '# of unique Performance' for '# of unique Production/Production Season'

    Hope this might be what you're after! 

Reply
  • $organization

    I use this formula which I've most certainly gotten from elsewhere on the forums!

    SUM ( [Constituent ID] , IF ( [# of unique Performance] >=2 ,1 , 0 ) )

    And then just change out the highlighted section depending on how many performances I want to track. I have also changed out '# of unique Performance' for '# of unique Production/Production Season'

    Hope this might be what you're after! 

Children