Average responsetime based on services

Elastic Stack Kibana
1

Please see attachment to see how data on kibana discoverer. I am trying to generate table form report based on average response time.

ResponseTime.JPG960×352 30.4 KB

From above information, I want to generate average response time by grouping Test_AdminTypes and Test_Services in a table form. Please advise.

2

Hi Chaitanya,

I don't have your data of course, but I tried to create something similar. I created a new Data Table visualization and for the Metric, I changed it from Count to Average and selected a numeric type field event_id but you would select response-time.
Then I Split Rows by selecting a Terms aggregation and for Field I picked source_name but you would pick Test_AdminTypes or Test_Services

image.png1525×1394 63.1 KB

You can Split Rows again and select Terms, and you other fields.

Regards,
Lee

3

Thank you LeeDr.

Unfortunately "response-time" is not shown under Average aggrigarion's filed. But I can see it in Dashboard. Please advise.

Thanks,
Chaitanya.

4

Hi ,

The field response-time data type is in string and it is not showing under aggregation. How to convert it into number and make it available for aggregation. Please advise.

Thanks,
Chaitanya.