Get count of each log contents

Grafana Loki
, ,
1

Hi, i have log file in grafana using loki data source the problem is i want to make table in grafana for specific messages in the log . multiple methods of msg in the logs. so i need two coloumn one is msg type or method another coulmn is count of each methods. in the screenshot i need to get count of that msg type how many time it occurs within the hour or minute.

lokilog
lokilog1654×900 168 KB

2

This documentation could help.
Furthermore, rate gives you the occurs in a second, so you have to divide the result.

Maybe this query your solve you problem:

sum by(msg) (rate({} 
   | json msg="log.msg" 
   | msg != `` 
[$__range]))

And you must select queryType instant.