I’m fairly acquainted with Grafana i.c.w. Influx. I’ve also recently set up Loki and am trying to get a table view top 10 on found errors in the centralized logs.
In pseudo it reads: Top 10 from all hosts, counting regex(error) over selected time period, sorted on error hit count descending.
Do I use transformations? Solve it in the query? Use a calculated field?
I already have Loki data based log / warn / error graphs (captured via regex), just no clue how to get to a table with error count top 10 per host.
Any help or tips on how to achieve this is greatly appreciated. Thanks!