Hi community,
ran into a little problem here.I am trying to calculate the % of events an attendee has attended ever since he 1st joined. Any events that happened before he first joined is obviously ignored.
how can i write a calculated measure to count the number of events that happened after an attendee has joined. that way i can calculate the % attended.
Attached is the workbook. I've only managed to get the number of events an attendee has attended but the number of events that happened after 1st engagement turns out to be the same value which is obviously wrong.
appreciate any comments or help if you know.
thank you so much.
You are right Gavin. I forgot to put the join back correctly when I played with it I could not open 2020 ver, so I ended up extract your CSV file.
Let me know if you have any question and stay safe!
