Grafana Table Help

Grafana Dashboards
, ,
1

Alright, I am fairly new to Grafana and its Dashboards and I just cannot get the Table panel to look as expected.

I have a Loki datasource with application logs, in each line I have a ‘level’ label, which can either be INFO, WARN or ERROR. All I am trying to do in this table is count over a period of time how many of each I have.

image
image2654×1340 236 KB

However as you can see in the image my panel has the level as a header, but I am getting an entry for each unique timestamp, whereas what I was looking for was having three rows, where the columns are level and the count:
INFO. 240
WARN 37
ERROR 3
Something along these lines. What am I missing in my query and/or panel configuration? Thanks for the help.

2

Hi @hugoalmeida1,

Welcome to the :grafana: community support forums !!

Well, you can use the Transformation function in Grafana to get the data as per your needs.

Please check the documentation regarding it i.e.

I hope this helps.