question

In the attached example I get the value of a number label every hour, but the general setup can be used for any value you might want to track. In this example I keep the tracked value untouched. If you don't need the total value, you can also build a simpler collector by resetting the value every time you record it.

The Statistics Collector uses a Timer/On Reset event that repeats once every hour. Every time it fires, it writes the current value of the tracked label/variable/... to the label newValue on the data object. I used a row value of 1 in the example. The actual value doesn't matter. It is only important that the event does have a fixed row value (not leaving the field blank) and that the rows are still "finished" after the event.

In the Columns tab, the current time and value of the last hour is recorded. The value is calculated as the difference between the newValue label (current total) and the previousValue label (previous total). The ? operator first checks if the label actually exists and returns a 0 if it doesn't. It is needed because the previousValue label will not exist yet when the data is recorded for the first time.

The previousValue label is created/updated in the On Row Added trigger, where its value is set to the current newValue label.

Because we finish the rows (in order to create a new row for every event despite the fixed row value), you have to the check the option to keep row labels for finished rows, so the previousValue label is not lost between events.

value-per-hour-collector-fm.fsm