I want to sum a data set where inside the dataset, an average value of every 5 min. (I have a dataset that produces every second and I need to get the addition of the average value in every 5min interval) How can I do this? Note that: Dataset is timestamped and I am using perspective

Is the dataset ordered by timestamp?

You need to group by the "truncated" timestamp. I would use my groupBy() expression function (from my free Integration Toolkit), getting the truncated timestamps by converting to millis, taking the modulus of 300000, and subtracting those millis from the original timestamp. Wrap the grouping with …

How can I find these functions? The usage of 'grounBy()' is not familiar to me. I am trying to solve this through the script and writing two 'for' loops.

[image] ignitionSL: find these functions? [image] Automation Professionals' Integration Toolkit Module 3rd Party Modules Automation Professionals is pleased to announce the immediately availability of a major upgrade to its free Simulation Aids Integration Toolkit m…

This is the formula [image] I need to calculate the summation of every 15min averaged P_t. This is the dataset and it has 50k entries. [image]

Please paste the dataset as text (use the copy to clipboard icon in the dataset property editor). I'm not going to type all those in. (And tell us the right answer, computed by hand if necessary, so we can check our code. That formula is not particularly clear.)

Here attached the dataset data.txt (40.3 KB) It is a huge formula. I do it part by part. So simply, I need to get the summation of 15min averaged P(power) value.

Do you want the averages to start on the 5-minute boundaries or the 15-minute boundaries? (Also, please follow directions on creating CSVs--I can't just paste this into Ignition because it wasn't copied out of Ignition's dataset property editor.)

Sum of average value in the dataset

Ignition

pturmel November 28, 2023, 11:59pm 6