Icon

C26_​Calculating Sales Performance

Did it in 2 ways
1. Column expressions (with multi-row access selected) to run window functions
2. Lag nodes + Math to mimic window functions

Plotted on a Line Plot to get a sense of what's going on.

Lag + Math Nodes Used on individual columns Column Expression NodesUsed on multi columns Read sales datacalculate sales differencecalculate sales difference %Plot sales difference % against monthsMath sales difference % to look like PercentagesLag Product ALag Product BCalc % difference for Product ACalc % difference for Product BPlot sales difference % against months CSV Reader Column Expressions Column Expressions Line Plot Math Formula(Multi Column) Lag Column Lag Column Math Formula Math Formula Line Plot Lag + Math Nodes Used on individual columns Column Expression NodesUsed on multi columns Read sales datacalculate sales differencecalculate sales difference %Plot sales difference % against monthsMath sales difference % to look like PercentagesLag Product ALag Product BCalc % difference for Product ACalc % difference for Product BPlot sales difference % against months CSV Reader Column Expressions Column Expressions Line Plot Math Formula(Multi Column) Lag Column Lag Column Math Formula Math Formula Line Plot

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: Dreamcore
Created at: 2023-09-22
On NodePit since: 2023-09-22
Last update: 2024-11-23
Created with KNIME version: v4.7.6
Tags: JKISeason2-26KMIME IT

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

Try NodePit Runner!