Hi everyone,
I have this very simple query right now to figure out which months a user has logged in and I'm trying to figure out the next step.
| stats dc(date_month) as DCmonth values(date_month) by user_company
It returns a table with the user, and which months they've logged in (e.g. Feb, Mar, Apr, May). What I want to check is whether a user has logged in every month until now since their first appearance: i.e, we are in June right now, so if a user had their first appearance in March, I want to only count them if they've logged in March, April, May, and June . If a user's first appearance is March, but they didn't log in during April and they only have Mar, May, June, they won't count.
Thanks!
... View more