Average of a string text variable

Elastic Stack Elasticsearch
1

Hi All,

I am new to elastic search SQL , and canvas side of world.
I have a variable 'message' in which data comes in 't' text format and it has time duration coming in.
I need to take the average of that variable and need the output to come in "mm:ss" format.

Below is the sample of data that I have in my variable

message t
00:01:42.3510750
00:00:58.9317560
00:03:10.4225445
00:00:45.8493632

2

hi all,
request if someone can help with the above query

3

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.