Generate Fixed Time Intervalls

Here the node will generate a Date/Time cell with constant time intervalls. The user can select a start date, the end date is always be execution time.

If you have repeating functionalities, you don't want to copy the nodes on and on. Instead you can generate your own custom nodes. With the Quickform nodes you can make them configurable.

Customers Trx Money vs Loyalty

In this workflow we convert raw customer transactions, that is contract registrations, into money measures on one side and loyalty features on the other side. The idea is to move from a list of transactions to one or a few numbers describing an aspect of the customer activity. Here we have chosen money and loyalty. Money as total amount of money paid by customer or as amount paid per year. Loyalty as # of days under contract or as loyalty ratio (= # effective days / total number of days till now).

Filter TimeSeries Data Using FlowVariables

This workflow demonstrates the usage of flow variables in the date and time nodes. Here the use case is to filter the last full week of data. Hence if you execute the workflow on wednesday you still only want to get the data until the last saturday.

We achieve this by first finding the last Sunday. This will be the enddate in our filter node.
Afterwards we use the information as a flow variable in the Date&Time-based Row Filter node. In addition we set the end of the filter to one week before the start date.

Subscribe to Date and Time Manipulation