I’m trying to display the result of a CloudWatch log query in Grafana as table and having some issues. The problem is, that Grafana only shows the first row of the result when the query contains a “stats” statement like in this query:
| filter service=‘name_of_service’
| filter data.response.status=404
| filter data.request.url like “content”
| stats count(*) as numberOfErrors by data.request.url
| limit 200
I can select single results from the drop-down menu at the bottom of the panel, but I can’t figure out how to show all.
Maybe I’m missing something obvious? The query works fine in the AWS console…
I hope you can help me!