# What approach should I take to visualize next-day user retention?

**URL:** <https://discuss.elastic.co/t/what-approach-should-i-take-to-visualize-next-day-user-retention/371263>\
**Category:** Kibana\
**Created:** [November 30, 2024, 3:05pm UTC](https://discuss.elastic.co/t/what-approach-should-i-take-to-visualize-next-day-user-retention/371263 "2024-11-30T15:05:51Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![NealJ](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/nealj/32/139610_2.png) [@NealJ](https://discuss.elastic.co/u/NealJ)\
**Post date:** [November 30, 2024, 3:05pm UTC](https://discuss.elastic.co/t/what-approach-should-i-take-to-visualize-next-day-user-retention/371263/1 "2024-11-30T15:05:51Z")

</div>

Hello everyone,  
I’m new to Elastic, and I’d like to ask a question.

In Analytics -\> Dashboard, when creating a visualization panel, how can I view the next-day user retention rate?Assume I have the following data:

```auto
`userid 100, date 2024-11-27, event register `
`userid 101, date 2024-11-28, event register `
`userid 102, date 2024-11-28, event register `
`userid 103, date 2024-11-28, event register `
`userid 104, date 2024-11-28, event register `
`userid 100, date 2024-11-29, event active `
`userid 101, date 2024-11-29, event active `

```

The user retention rate for the 28th is 25% because the same userid must register on the first day and be active on the next day to count as retained.

Should I use Elasticsearch Aggregations?  
Based on my current understanding, It seems impossible to ensure that the userid in the 11-29 active events matches the userid in the 11-28 register events when performing calculations in Elasticsearch Aggregations. it may also be possible that I missed something.

What approach should I take to visualize next-day user retention?