Calculating energy consumption for off-peak hour, peak hour, today, yesterday, current month and previous month

[ramhuzaini]

Hi there,

I have data point that read energy consumption (kwH) from a power meter. I would like to know how can I divide the data into off-peak hour consumption and peak-hour consumption. In addition, I would also like to calculate the total consumption for today, yesterday, current month and previous month. I am still quite new with mango. Can somebody assist me on this matter or share any link that can be helpful for solving my problem.

best regards
Ramhuzaini

[Gordoe]

Is your kWh energy consumption accumulating or is it interval data. You'll want to take a look at the Metadata Datasource.

[MattFox]

Expanding on what Gordoe set, look at mango javascript under the help. You will want to pull by certain time frames. To make things easier, use the momentJS library stored in a global variable to help configure your times.
You will want to look at the pointValuesBetween method. You can also perform rollup queries if desired.

Fox

[ramhuzaini]

Hi Gordoe,
The energy consumption in accumulating form

[ramhuzaini]

Thanks @mattfox for the information. I will try to explore the things you said.

[cooldjmc]

@mattfox
Hi, i'm new to Mango can you please give an example using pointValuesBetween(from, to) function for this case. I have intented to understand but without success.
Thank you.

[MattFox]

var pointValues = myContextPoint.getPointValuesBetween(fromTimestampInMilliseconds,toTimestampInMilliseconds);
print(pointValues);

Fox