I'm trying to create an EnergyWise report which supplies a node's key EnergyWise stats--in the manner that the existing 'Total Energy Consumption and Savings per EnergyWise Device - Last 7 Days' report does--but with an additional 'Domain Name' field, so that nodes can be grouped by their EnergyWise domains.
The domain name field is found in this location:
NPM_NV_EW_DEVICE_V.DomainName AS Domain_Name
The problem is integrating the NPM_NV_EW_DEVICE_V table (via a join, I assume) with the existing report code for 'Total Energy Consumption and Savings per EnergyWise Device - Last 7 Days'. Does anyone have any idea how to modify this report to incorporate the 'domain name' field from the NPM_NV_EW_DEVICE_V table?