Subscribing is a smart move!
You can subscribe to this board after you log in or create your free account.
Monthly aggregation formula bug
EcoStruxure Energy Hub
This forum is dedicated to supporting EcoStruxure Energy Hub service providers and partners with system implementation, reporting skills growth, and in demonstrating profitable improvements in monitored sites. Ask questions, get expert answers and the latest offer news, provide feedback and share community experience and knowledge!
Invite a Co-worker
Send a co-worker an invite to the portal.Just enter their email address and we'll connect them to register. After joining, they will belong to the same company.
Send Invite Cancel
Link copied. Please paste this link to share this article on your social media post.
It appears that the Monthly aggregation formula in Energy Hub is actually grabbing (Last 30 Days) not the full month:
Here is a comparison for the month of July aggregated monthly (top) and daily (bottom).
There is a 243kWh difference in the values for the month.
If we switch it to a custom date range and choose 2nd of July to 31st of July the monthly (top) and daily (bottom) numbers match:
If we change our date range to 1st July - 1st July the monthly and daily match and it is exactly the missing amount from the monthly amount:
I am not sure how this would function on a month with 28 days (we don't have the data for that yet) but is anyone else seeing similar things?
Is there a fix for this?
Link copied. Please paste this link to share this article on your social media post.
Create your free account or log in to subscribe to the board - and gain access to more than 10,000+ support articles along with insights from experts and peers.