How to get the Sum of the last(current) data in SingleStat (Influxdb / Grafana)

grafana
influxdb
#1

I have multiple buckets in AWS S3, I would like a SingleStat in grafana (Or just an influxdb query, doesn’t have to be grafana) that shows the total of all buckets currently. For some reason I believe this is adding all buckets and ALL data points from time series (30 days) instead of just the last (current) one. How do I accomplish this? Total should be closer to 125TB not 3.33PB (!!) See image below for example of query: