# How to find Retention Rate of users in kibana **URL:** \ **Category:** Kibana\ **Created:** [December 15, 2020, 11:26am UTC](https://discuss.elastic.co/t/how-to-find-retention-rate-of-users-in-kibana/258705 "2020-12-15T11:26:07Z")\ **Posts on this page:** 6\ **Page:** 1
**Author:** ![dharanesh](https://avatars.discourse-cdn.com/v4/letter/d/b5e925/32.png) [@dharanesh](https://discuss.elastic.co/u/dharanesh)\ **Post date:** [December 15, 2020, 11:26am UTC](https://discuss.elastic.co/t/how-to-find-retention-rate-of-users-in-kibana/258705/1 "2020-12-15T11:26:07Z")
How to create a chart in kibana to represent Retention Rate. ---
**Author:** ![AClerk](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/aclerk/32/55297_2.png) [@AClerk](https://discuss.elastic.co/u/AClerk)\ **Post date:** [December 16, 2020, 4:10am UTC](https://discuss.elastic.co/t/how-to-find-retention-rate-of-users-in-kibana/258705/2 "2020-12-16T04:10:37Z")
Can you elaborate? ---
**Author:** ![AClerk](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/aclerk/32/55297_2.png) [@AClerk](https://discuss.elastic.co/u/AClerk)\ **Post date:** [December 16, 2020, 4:38am UTC](https://discuss.elastic.co/t/how-to-find-retention-rate-of-users-in-kibana/258705/4 "2020-12-16T04:38:09Z")
And what is your data model? It is a bit hard to guess what you need and want without details. ---
**Author:** ![dharanesh](https://avatars.discourse-cdn.com/v4/letter/d/b5e925/32.png) [@dharanesh](https://discuss.elastic.co/u/dharanesh)\ **Post date:** [December 16, 2020, 4:54am UTC](https://discuss.elastic.co/t/how-to-find-retention-rate-of-users-in-kibana/258705/5 "2020-12-16T04:54:26Z")
I have a application log in elasticsearch as below user\_id | timestamp | Event 1 |2020-11-01T01:00:00.629Z|login 1 |2020-11-01T01:30:00.629Z|logout 2 |2020-11-01T01:30:00.629Z|login 1 |2020-11-02T01:40:00.629Z|login ---
**Author:** ![dharanesh](https://avatars.discourse-cdn.com/v4/letter/d/b5e925/32.png) [@dharanesh](https://discuss.elastic.co/u/dharanesh)\ **Post date:** [December 17, 2020, 4:23am UTC](https://discuss.elastic.co/t/how-to-find-retention-rate-of-users-in-kibana/258705/6 "2020-12-17T04:23:01Z")
If company had 1,000 customers at the beginning of Q1 and ended the quarter with 1,200 customers, after having won 300 new ones over the span of Q1, your CRR would be 90%. (1200-300)/1000 ---
**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\ **Post date:** [January 14, 2021, 4:23am UTC](https://discuss.elastic.co/t/how-to-find-retention-rate-of-users-in-kibana/258705/7 "2021-01-14T04:23:12Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.