Icon

Example_​TC_​ActivityScore Dynamic columns

Fibinacci Score Activity Columns Create Sample Data Notes:The concept is create a score for activity. Each day with no activity results in a 0 value day.For each consecutive day of inactivity, the penalty increases in a Fibinacci sequence.The cycle (lag) is variable depending on the requirement. The penalty for inatcivity is validfor the number of days in the "lag" cycle. Node 1Node 2Node 4Node 6Node 7Node 8Fibinaci ConstantF7F5Node 16Node 20F2F3F4F5MAve 90Node 29MAve30Node 81Node 82Node 83Node 85Node 86Node 87Lag ValueNode 99F1numbered colsdynamicnumber of colsrule engineappend colsonly numbered colsdate rangemerge Create Date&TimeRange Sorter Random BooleanAssigner Rule Engine Lag Column Math Formula(Multi Column) DoubleConfiguration Rule Engine Rule Engine Insert ColumnHeader Update ColumnHeader Rule Engine Rule Engine Rule Engine Rule Engine Moving Average Date&Time to String Moving Average Column Rename GroupBy Date&Time Shift Table Rowto Variable Rule-basedRow Filter Line Chart(JFreeChart) IntegerConfiguration Column Aggregator Rule Engine Column ListLoop Start Column Filter Extract TableDimension Column Expressions Loop End (ColumnAppend) Column Filter Column Splitter Column Appender Fibinacci Score Activity Columns Create Sample Data Notes:The concept is create a score for activity. Each day with no activity results in a 0 value day.For each consecutive day of inactivity, the penalty increases in a Fibinacci sequence.The cycle (lag) is variable depending on the requirement. The penalty for inatcivity is validfor the number of days in the "lag" cycle. Node 1Node 2Node 4Node 6Node 7Node 8Fibinaci ConstantF7F5Node 16Node 20F2F3F4F5MAve 90Node 29MAve30Node 81Node 82Node 83Node 85Node 86Node 87Lag ValueNode 99F1numbered colsdynamicnumber of colsrule engineappend colsonly numbered colsdate rangemerge Create Date&TimeRange Sorter Random BooleanAssigner Rule Engine Lag Column Math Formula(Multi Column) DoubleConfiguration Rule Engine Rule Engine Insert ColumnHeader Update ColumnHeader Rule Engine Rule Engine Rule Engine Rule Engine Moving Average Date&Time to String Moving Average Column Rename GroupBy Date&Time Shift Table Rowto Variable Rule-basedRow Filter Line Chart(JFreeChart) IntegerConfiguration Column Aggregator Rule Engine Column ListLoop Start Column Filter Extract TableDimension Column Expressions Loop End (ColumnAppend) Column Filter Column Splitter Column Appender

Nodes

Extensions

Links

Download

To use this workflow in KNIME, download it from the below URL and open it in KNIME:

Download Workflow
Created by: Russell
Created at: 2022-11-01
On NodePit since: 2022-11-02
Last update: 2024-04-25
Created with KNIME version: v4.6.3

Deploy, schedule, execute, and monitor your KNIME workflows locally, in the cloud or on-premises – with our brand new NodePit Runner.

Try NodePit Runner!