Display daily consumption grafana using prometheus datasource

I’m using grafana v9.5.1 and my datasource is prometheus.
I have a metric called container_network_transmit_bytes_total.
I want to create a graph which the X-axis represents the date of the day and the Y-axis represents the total consumption for that specific day.

I want to manage it using some kind of PromQL or MetricsQL.
Here’s a picture of what I’m trying to achieve.

How can I manage that?


a Bar Chart should do the work.