Tips wanted: Loki log, sorted table on 'error' hit count over time

Hi All,

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!

Kind regards,

Gerard.