I want to do a running totalize of a tag during a month then have to reset to 0 at the start of the next month.
Great question! There is actually a KB article (2834OSI8 - How do you create a Totalizer tag with a one month period?) specifically about this.
Essentially, you'll have the Totalizer write it's final result based on a trigger event that involves the function month('*') since that will increment each month. The KB shows including something like multiplying a Heartbeat tag by 0 and adding it to the function month('*') so the expression evaluates frequently, thus triggering the end of the totalizer for the previous month as soon as the month changes. But I'm sure there many variations on this you can do instead.
As seen below, the expression month('*') evaluates to 5 now since it is May. As soon as it becomes June, the expression would change to 6, thus triggering the Totalizer to write it's final result.
Let me know if this helps!
Yes this solved my problem.
Glad to hear it!
Retrieving data ...