BRADFORD_DASH_MONTH
DeviceID | monthname(one_year_computed.`Date`) | round(sum(one_year_computed.`Load_Watts1`) / 1000,1) | round(sum(one_year_computed.`Grid_Watts`) / 1000,1) | round(((sum(one_year_computed.`Grid_Watts`) / 1000) * 0.12),2) | round(((sum(one_year_computed.`Load_Watts1`)) * 0.527) / 1000,1) | month(one_year_computed.`Date`) |
---|---|---|---|---|---|---|
DeviceID | monthname(one_year_computed.`Date`) | round(sum(one_year_computed.`Load_Watts1`) / 1000,1) | round(sum(one_year_computed.`Grid_Watts`) / 1000,1) | round(((sum(one_year_computed.`Grid_Watts`) / 1000) * 0.12),2) | round(((sum(one_year_computed.`Load_Watts1`)) * 0.527) / 1000,1) | month(one_year_computed.`Date`) |
![]() ![]() | [current_date] | ![]() ![]() |