daily number of historically new users

[jperezes]

Hi,
I am struggling to get a what I think should be a quite straight job.
I need to create a dashboard showing new users accessing per day, that is if for example if on a Friday a user that has never accessed before then count should be one, if the user acceded to the system some time last month for example than the count should be zero as is not strictly new.

|timechart span=1d dc(user_id) as "New Users", that resets the distinct count every day, so I would be repeating users...

Thanks in advance,

Juan

[asimagu]

hola Juan

In order to be more efficient, I would store a list of known users in a lookup table or a kvstore. Then you would only need to run your search through the last 24 hours and do a lookup against your existing users.

You could schedule that search to run every day and then backfill a summary index if you want to report on wider ranges.

Let me know if you need further help 😉

[jperezes]

Gracias!

I already have the lookup tables created, the schedule coming when I have the permission.
Will let you know if I find any problem.

Rgds,
Juan