Hello mattmca ,
Check whether this formula gives you expected result:
sum([UserID],
case
when max([UserInvited]) = 1 and max([UserFirstLogin]) = 1
then 1
else 0
end)-Hari
Hi Hari,
Unfortunately, this gives me the same result as the initial approach I took, where it only seems to be counting individual days that have both MAX([UserInvited] = 1 and MAX([UserFirstLogin]) = 1, rather than looking at all records for a given user in the filtered time period.
Hi mattmca ,
I'm just checking to see whether I'm understanding the problem correctly -
Is your dataset in below format?
When I apply the formula in this dataset I'm getting 3.
-Hari
Hi Hari,
Thank you for your help. You were correct in how my dataset is set up. I set up a new dataset to exactly match your sample data and I also got the correct answer of 3 (for January). This led me to dig into why my other dataset was not giving me the correct number. As it turns out, there was something weird happening with the data type of my alphanumeric UserID, and so it wasn't grouping the UserIDs together correctly, which is why my answer was off. I got the UserID fixed, and now I'm getting the results I should be. Thank you!
