Tracking Membership Conversion

Hi there,

We track membership conversion for an exhibition by counting the number of new members who using their new membership first visited that specific exhibition. For example if there was an exhibition on Aug 2023, we only count back then the new members that it was their first time using their membership by visiting that exhibition. So, there are two conditions:

1- The membership needs to be new at the time frame we are looking at it in the past (or present if we are tracking a live exhibition) and;

2- It needs to be that members' first time using their membership benefits.

I have tried many ways to set this up in a dashboard but have not been successful. Could anybody please point me in the right direction?

Best wishes,

Sina