topic Re: Identifying user activity by day and rolling that up to a month? in Getting Data In

Identifying user activity by day and rolling that up to a month?

sf-mike — Mon, 28 Sep 2020 12:17:00 GMT

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

Re: Identifying user activity by day and rolling that up to a month?

kristian_kolb — Fri, 17 Aug 2012 06:18:28 GMT

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

Re: Identifying user activity by day and rolling that up to a month?

sf-mike — Fri, 17 Aug 2012 06:40:03 GMT

perfect! you've saved me hours!!!

Re: Identifying user activity by day and rolling that up to a month?

kristian_kolb — Fri, 17 Aug 2012 06:43:14 GMT

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. 🙂