I am currently using Elasticsearch as the data source and trying to find the time difference between timestamps group by a session id.
I successfully group the session id and obtain the first instance and the last instance within a log file. However, I was not able to obtain these values using the MAX, MIN function.
Therefore, I was not able to calculate the time difference between the first instance and the last instance since these calculation functions did not work.
How can I calculate the timestamp difference in Grafana or do I need to do any configuration in Elasticsearch in order to reach the objective? Thanks