How can I compute the sum of a month until yesterday? The first signal is a production volume in [t] per day, which automatically writes the same value from yesterday 06:00 further into now until its value is changed again at 06:00 of the next day (black dotted line). The second signal is an energy volume in [t] per day, which updates its value automatically to the actual now value (red bar).
What I want is, to compute the sum of each signal (a sum for signal 1 and a sum for signal 2) per month, but without the current value, i.e., only until yesterday 06:00. If I just compute the sum per month, also the now value is taken into account but thats incorrect.
Compute Sum of Month until yesterday
in General Seeq Discussions
Posted · Edited by mattoe
Hello together,
I have the following question:
How can I compute the sum of a month until yesterday? The first signal is a production volume in [t] per day, which automatically writes the same value from yesterday 06:00 further into now until its value is changed again at 06:00 of the next day (black dotted line). The second signal is an energy volume in [t] per day, which updates its value automatically to the actual now value (red bar).
What I want is, to compute the sum of each signal (a sum for signal 1 and a sum for signal 2) per month, but without the current value, i.e., only until yesterday 06:00. If I just compute the sum per month, also the now value is taken into account but thats incorrect.
Any ideas? Thank you very much.
Regards
Matthias