I need some help for a query.
My documents are Apache access logs and they have a "jsessionid" field (string) and a JVM field (string).
I would like to get the average number of unique count of jsessionid per JVM for a given period; to display it on a line chart. So that I will have an indicator of the average number of sessions in my JVMs.
Could someone help me in building this query ? Maybe I need some scripted field ?
Thanks for your help