Group by Max Count?

Hi, I have a question about how to group by max count of a field. I am currently using the field path while obtaining current error codes per user request.

My goal is to display the top 5 users with request. I would like to group these users using their count totals to get the ideal top 5 users.

I am wondering what is the best approach to achieve this goal. I am using a basic Grafana table to display the results.

Which data source are you using?

I figured it out already. I am using telegraf.

1 Like

Hey can you tell me is how you structured the query, I am using InfluxDB