Forum Discussion
Count and distinct count pulling in the same value
Hi everyone, I'm trying to visualize total and distinct users by day and week. By week seems to be pulling in ok, but the by day counts are the same for some reason, and I can't figure out how to fi...
Anonymous , seem like in this case for each date userID record is there only one time in the table. that is why it is same at day level, as subtotal will recalculated for distinct count , you are getting a different number in subtotal
Anonymous , seem like in this case for each date userID record is there only one time in the table. that is why it is same at day level, as subtotal will recalculated for distinct count , you are getting a different number in subtotal
Thank you, Amit! This makes sense and I verified with the data. Appreciate your help!