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] |  |
