I am trying to do some analysis on the time stamped field. My goal is to find out the duration browsed for each device type.
To achieve this, I need to do maximum of request date - minimum of request date and do some division. Essentially it is this.
(max(request_date)-min(request_date))/(1000.0*60.0). This will give me the duration. I need to plot this on the Y-axis and use X-axis for different devices such as iOS, Anroid etc.
How should I go about in achieving this in Kibana?