I am trying to analyze if an event is triggered by an user during his entire life time inside our app, dividing that number by the total amount of users who performed a specific event at least once.
For example, users who liked a photo at least once since they have installed the app, divided by the total amount of users who performed an event to open a photo - In short, check how many users who are truly interacting with the feature (opening a photo) are giving a like on it.
I heard I can use ROLLWIN for that, my current formula is "UNIQUES(A)/UNIQUES(B)", where A = users who liked a photo at least once, and B = users who opened a photo. I want to measure that, but using events analyzed from the entire lifetime of the user.
How do I do that?
Best answer by MikkoKarvonenView original