Icon

kn_​forum_​44856_​calculate_​weeks

knime forum (44856) - Calculating data for distinct weeks based on conditions

knime forum (44856) - Calculating data for distinct weeks based on conditions

knime forum (44856) - Calculating data for distinct weeks based on conditions Weeks daysWeeks valuesdetermine max weekExclude maximum of weeksvalues from previous weeksNode 8Node 9Node 10sum up days from weeks otherthan last weekSumWeek*IDIDSum_daysNode 18get last weekIDdays of last weekNode 25($Sum$ / $Sum_days$) * $Max$Node 27save_row_idsave_row_idrestored Table Creator Table Creator Extract Table Spec GroupBy ReferenceRow Filter ReferenceColumn Filter Column Filter Transpose ReferenceColumn Filter Column Aggregator Column Aggregator ConstantValue Column ConstantValue Column Column Rename Joiner ReferenceColumn Filter ConstantValue Column Column Aggregator Joiner Math Formula Column Filter RowID RowID knime forum (44856) - Calculating data for distinct weeks based on conditions Weeks daysWeeks valuesdetermine max weekExclude maximum of weeksvalues from previous weeksNode 8Node 9Node 10sum up days from weeks otherthan last weekSumWeek*IDIDSum_daysNode 18get last weekIDdays of last weekNode 25($Sum$ / $Sum_days$) * $Max$Node 27save_row_idsave_row_idrestored Table Creator Table Creator Extract Table Spec GroupBy ReferenceRow Filter ReferenceColumn Filter Column Filter Transpose ReferenceColumn Filter Column Aggregator Column Aggregator ConstantValue Column ConstantValue Column Column Rename Joiner ReferenceColumn Filter ConstantValue Column Column Aggregator Joiner Math Formula Column Filter RowID RowID

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: m_lauber
Created at: 2022-07-10
On NodePit since: 2022-07-11
Last update: 2024-04-27
Created with KNIME version: v4.6.0

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

Try NodePit Runner!