How to calculate Avg of a duration in Timelion

I want to know the exact command for calculating the average of a duration. For now I used the following code to get the average. Wonder why is it showing me the count of the average but not the average itself

".es(index=crs-,q="wapqos.component=MATS,Average wapqos.ResponseTime.response_time_duration:"), .es(index=crs-,q="wapqos.component=TEAMS,Average wapqos.ResponseTime.response_time_duration:"),.es(index=crs-,q="wapqos.component=TPGW,Average wapqos.ResponseTime.response_time_duration:")"

you also need to add "metric=avg:name_of_field" to your queries.

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