Hi - I've attached a simple dataset and example worksheet. I would like to display the # of unique user ids that purchased per day. So, if userId 'user101' purchased once today, then he counts. If he then purchases 3 times tomorrow, he counts again for that day...but still just once for that day.
Through reading the forums I was introduced to LOD. I am able to use that to figure out first-time-ever purchased, which is great. But I also need to show per day (and per month, but hopefully that's obvious after per-day).
Here is my LOD expression for fist-ever-purchas:
{FIXED [User Id]: MIN([Purchase Date])}Here is the sample data (also attached as CSV):
Hi Jobe,
Have you tried doing a count distinct of User ID by purchase date ? This will give you a unique user id view of your data.
HTH
Peter
