Kibana retention rate metric and charts

[Richard_Bao]

My case is show user use an app retention rate in last 30 day.
value = app opened count / total installed app count
How to do this by using Kibana?

[Brandon_Kobel]

Hey @Richard_Bao, if you can provide additional information regarding how your data is structured in Kibana we can help further. You'll most likely want to use the Time Series Visual Builder Metric visualization: https://www.elastic.co/guide/en/kibana/current/TSVB.html

[Richard_Bao]

Hi Brandon,

Thanks for reply!
The user schema is as follow, means who installed the app. The "created_on" can be the date when install the app.
{
"created_on" : {
"type" : "date"
},
"dob" : {
"type" : "date"
},
"email" : {
"type" : "text",
"fields" : {
"keyword" : {
"type" : "keyword",
"ignore_above" : 256
}
}
},
"fullname" : {
"type" : "text",
"fields" : {
"keyword" : {
"type" : "keyword",
"ignore_above" : 256
}
}
},
"id" : {
"type" : "long"
},
...
}

app usage schema is as follow:
{
"appid" : {
"type" : "text",
"fields" : {
"keyword" : {
"type" : "keyword",
"ignore_above" : 256
}
}
},
"user_id" : {
"type" : "long"
},
"duration" : {
"type" : "long"
},
"end_time" : {
"type" : "date"
},
"id" : {
"type" : "long"
},
"start_time" : {
"type" : "date"
}
}

So last 30 day app retention rate should be unique count of user who open the app (based on "start_time") divide by the total user who installed the app. The chart will show 5 day retention rate, 10 days retention rate,..., 30 days retention rate. All the 5, 10,.. days period should be total user number who installed the app before the date.