Trying to get a bar chart that would show daily sums / counts for events with values as labels

I am starting with Grafana / Prometheus / Push_Gateway, and got my first dashboard [mostly] working. Few things need to have more polish, but one I just don’t know how to bite.

My data for that event comes with the following labels:

event {a_value="0.5", env="test", exported_job="test_job_01", instance="localhost:9091", job="pushgateway", pushgateway_instance="test_pg", token="test_token_01"}

Only the a_value changes from time to time (say once per hour or so). I have created for that event both a gauge and a counter that take those parameters above (say event_gauge and event_counter). I am always setting the gauge to 1 and increasing the counter by 1.

I would like to create a bar chart that would either show count of such events per day or sum of a_value labels per day (daily on x-axis, and sum/count on y-axis). It really looks like a no-brainer chart, yet I am stuck.

Unfortunately, I am getting nowhere with it at all, don’t even know how to start. Whatever I was trying to do, nothing worked for me. At this point, it looks to me that I cannot do it using Prometheus as a source.

EDIT:
Actually, a good example would be to be able to create a such bar chart for geoip data. I have on my dashboard both geomap and a table with those IPs. Each entry is basically an event, where the only things that changes are coordinates. So, such bar chart would show how many IP events happened each day.

Any help would be really appreciated.

Hi @jacekgrafana,

Thanks for opening this post.

Can you please try to reproduce this same issue on https://play.grafana.org/ and then share the dashboard link so that we can view it?

Tip: Currently you cannot save a newly created Dashboard so use an existing Dashboard and apply the new settings after modifying it with your use-case and then share it.

Thanks