Dashboard using loki as data source -> Bar chart of country from access.log

Grafana Dashboards
1

In my setup I have,

  • nginx access.log got country field.
  • nginx access.log is being scraped by promtail and pushed to loki with country field correctly extracted.

I would like to create a Bar chart that display number of hits from each country with x axis being country names and y axis being number of hits from that country.

I am not able to figure out a query for this. Any assistance is greatly appreciated.

Thanks.