• Replies 11 replies
  • Subscribers 962 subscribers
  • Views 270 views
  • Users 0 members are here
Related

Looking for second most recent performance year

Anh Le
$organization
Hi everyone,
 
I’m attempting to create a report to show when re-engaged (i.e. formerly lapsed) patrons in a current season last attended a performance (by year). I am familiar with the “Years in First Performance Date” and “Years in Most Recent Performance Date,” but does anyone have a handy formula to look at the second most recent performance date?
 
Thanks in advance for any ideas!
 
Best,
Anh
 
signature_1078652768
Anh Le (she/hers/hers)
Director of Marketing & PR
OPERA THEATRE OF SAINT LOUIS
email: ale@opera-stl.org
phone: 314.963.4294 | mobile: 760.834.5926
210 Hazel Ave St. Louis, MO 63119
facebook icon twitter icon youtube icon linkedin icon instagram icon 
 
Parents Reply
  • $organization in reply to Anh Le

    I think this is super, and I just created one for my own org. I just want to make sure I'm reading this right. If I look at the very last screenshot in which all the bars in the chart are orange, is it accurate to say:

    The current season includes 12 hh whose last visit was in 2019. The current season also includes 27 hh whose last visit was in 2020. 
    And the current season also includes 47 hh whose last visit was last year. 

    Is that how this is read?

Children