I need to create a report showing activity over over the entire month. I need a histogram showing distribution of unique users who used the product on 1 day within that period, 2 days, 3 days, etc. , up to 30 days. There's a field for each user called 'u' which I can/need to use.
Here's what I was given as an example of what I need to create:
Session_days unique_users
1 2300323
2 233555
3 1255
4 304
5 233
6
:
:
30 1
This depends a little bit on the format of your data. I'm assuming that you have some sort of log where you have multiple entries per user per day, but you only want to count that as a single visit or session.
... | stats dc(date_mday) as Session_days by u | top 30 Session_days | rename count as unique_users | fields - percent
That should get you what you want i believe.
Hope this helps,
Kristian
This depends a little bit on the format of your data. I'm assuming that you have some sort of log where you have multiple entries per user per day, but you only want to count that as a single visit or session.
... | stats dc(date_mday) as Session_days by u | top 30 Session_days | rename count as unique_users | fields - percent
That should get you what you want i believe.
Hope this helps,
Kristian
Glad to hear that - just make sure to verify that the answers are correct, I haven't had my morning coffee yet, so I'm not really responsible for my actions. 🙂
perfect! you've saved me hours!!!