Calculating Avg of a variable from ES datasource

1

Hi,

I have the json data in Elastic Search as below.

{
    "responsetime": "100",
    "operation": "api1"
  },
  {
    "responsetime": "200",
    "operation": "api2"
  },
  {
    "responsetime": "110",
    "operation": "api1"
  }

I want to display this in a table with the below columns.

OperationName
AvgTime
MinTime
MaxTime

Can you please assist !

Here is my Grafana screen. I was trying to bring Avg column first !!

image.png
image.png1330×580 38.7 KB

2

@mefraimsson Could you please assist with this issue

3

You can’t do averages on a string field. That’s not a Grafana issue, it’s Elasticsearch limitation. Please re-index your data to use numeric response time instead.

4

Thanks. Your solution on the below solved this issue too

https://localhost:3000/t/filter-based-on-a-column/16569/5