I'm trying to visualize the user retention using Timelion.
In order to do calculate the retention, I have to get today's register user count and next day's " registered only 1 day" user count.
So far, I managed to get this 2 sheet separately.
But I can't figure out how to hold the number of next day's data and use it into this day's expression.
Is there any way I can do this? To cross 2 day data?
This is the expression i came out so far.
.es(q=' event : "login" AND param1 : 1 ', metric=cardinality:Id.keyword).label(register 1 day) , .es(q=' event:"register" ').label(register)