Here is the calc for 7/30 usage with cost. The kwhcost1 is the KWH cost field in the dashboard.
SELECT monitordata_hourly.deviceaddress,(datetime(monitordata_hourly.date)),
Round(Sum(monitordata_hourly.ch1kwh),3) AS SumOfch1kwh,
Round(Sum(monitordata_hourly.ch1kwh),3)*(select kwhcost1 from applications) AS SumOfch1kwh_cost,
Round(Sum(monitordata_hourly.ch2kwh),3) AS SumOfch2kwh,
Round(Sum(monitordata_hourly.ch2kwh),3)*(select kwhcost1 from applications) AS SumOfch2kwh_cost,
Sum(monitordata_hourly.aux1kwh) AS SumOfAux1kwh,
Sum(monitordata_hourly.aux1kwh)*(select kwhcost1 from applications) AS SumOfAux1kwh_cost,
Sum(monitordata_hourly.aux2kwh) AS SumOfAux2kwh,
Sum(monitordata_hourly.aux2kwh)*(select kwhcost1 from applications) AS SumOfAux2kwh_cost,
Sum(monitordata_hourly.aux3kwh) AS SumOfAux3kwh,
Sum(monitordata_hourly.aux3kwh)*(select kwhcost1 from applications) AS SumOfAux3kwh_cost,
Sum(monitordata_hourly.aux4kwh) AS SumOfAux4kwh,
Sum(monitordata_hourly.aux4kwh)*(select kwhcost1 from applications) AS SumOfAux4kwh_cost,
Sum(monitordata_hourly.aux5kwh) AS SumOfAux5kwh,
Sum(monitordata_hourly.aux5kwh)*(select kwhcost1 from applications) AS SumOfAux5kwh_cost
FROM monitordata_hourly
Where monitordata_hourly.deviceaddress=142265 and (datetime(monitordata_hourly.date))>=(datetime('now','localtime','-30 days'))
Group by monitordata_hourly.deviceaddress
@presonalt
Thanks, that's exactly what I was looking for.