Unique count of users and if the user appear in the following months do not count it at all

Elastic Stack Kibana
1

Hi everyone,

I want to create a chart using timelion to show me the unique users since the begining for a month.
I want to count the user only in the first month of usage and if it appears in the following months to not count it at all.
For the moment I managed to get the uniques in a month using: .es(metric='cardinality:username.keyword').

2

Did anyone had this issue before?

3

Looks like you're needing to consolidate information around a user and/or session entity in order to do this type of analysis. Entity-centric indexing is a common pattern that may help you achieve this.