Hello,
I'm rather novice in Kibana/Elasticsearch.
I have records of sessions containing two fields:
"mappings": {
....
"start_date": {
"type": "date",
"format": "dateOptionalTime"
},
"end_date": {
"type": "date",
"format": "dateOptionalTime"
},
....
}
My purpose is to plot the number of active sessions in function of the time, that is for a given time t, the number of documents with start_date <= t <= end_date.
How can I do this ? I did not find any simple way, either using date histograms or other aggregations to do this.
Alternatively, is there a way to plot in Kibana the difference of two curves (a kind of stacked date histograms with one serving as a reference, i;e. one being set to 0).
Thank you for any hint,
Fred