Add values form whole week

hello all,
I keep my data in Influx DB - some program ad data to it every hour. So graph looks like this

I would like to create graph in grafana which will add values from whole week and show weekly bar graph. it is possible ?

Have you explored the documentation for the InfluxDB query editor, or using transformations?