Query for yesterdays traffic consumption on network interface


I’m using Telegraf, InfluxDB and Grafana. Telegraf collects data using SNMP including IF-MIB and its counter ifHCInOctets.

I’m searching of a query that allows me to visualize the traffic of a network interface for a day. That means if I’m on my dashboard, no matter which time interval I’m currently seeing, I would like to see the summed up traffic e.g. yesterday or the day before yesterday.

Is this possible at all? If so how looks the appropriate query?