Hi I am currently collecting SNMP information from a power monitor which is giving me current power usage in KW for our datacenter - what i am looking for is a way to combine this information in to a usage per day.
My current query in Grafana is
SELECT last(“INPUT KW”) FROM “snmp” WHERE (“agent_host” = ‘xx.x.x.xx’) AND $timeFilter GROUP BY time(15s)
my question is how do i combine the collected information in to a bar graph that would show the past x number of days total usage - i have tried (although briefly to edit the query by using “sum” and group by 1day etc but the query provides no data - this leads me to believe i may need to do something on the DB side to be able to visualise the information.
Any help greatly appreciated.