Data modelling

[Jochen Maurer]

Hi everyone,

I do have events wihch logs all logins to an app, i want to find out, how many users logon every business day. Multiple logins from the same user at the same day should not change the result.

Data:
Userid1 <timestamp>

Result should look like this:
In the last 20 days
X users have logged in daily
Y users have logged in at more than 15 days
Z users have logged in at more than 10 days
...

Can anybody help me to create a analysis for that? I can't see a easy solution...

[Taylor Barnett]

Hey Jochen! 

I have an idea for you to try out! It will take a tiny bit of client side processing, but it is possible!

Do an analysis query with a select unique on your logins collection, with the target property set to user id (or whatever similar property). 

Then, after you get the result on the client side, count the number of times you see the user id and you can have results for each of the things you are looking for. So then you can see: 

if(n > 15)

if(n > 10)

if(n === 20)

where n is the number of times they appear in the select unique

Sound good? 

-Taylor