Icon

seasonal data

2025-11-12 --> latest item

Monthly analysis

Monthly Sales Frequency Distribution

13 366 (44.59%) of items from item data were NOT sold in last 2 years

From all items that were sold at least once in past 2 years 8 961 (53,94%) were sold in every month and 2 313 (13,92%) were sold in 11 months / year at least once

Items with launch period >= 2025-02 and sales distribution 12

Run this first - enables date range selection
Missing Value
easter
Holiday_Dashboard
items that were NOT sold every month
Row Filter
how many months are missing for item to be sold
GroupBy
GroupBy
Constant Value Column Appender
Column Renamer
items that were sold every month
Row Filter
1+ items sold
Pie Chart
Concatenate
Holiday_Feature_Extractor
Missing Value
Joiner
String to Date&Time
Row Filter
0+ items sold
Pie Chart
String Manipulation
Column Filter
GroupBy
sales data
Excel Reader
item data
Excel Reader
Row Filter
Date&Time Part Extractor
Single Selection Configuration
Date ranges
Table Creator
Row Filter
Table Transposer
GroupBy
GroupBy
Table Column to Variable
Row Filter
Joiner
>= 50 frequency
Row Filter
Table Column to Variable
Bar Chart
Variable to Table Row
Table Row to Variable
specified range filter
Row Filter
RowID
String to Date&Time
Date Shifter
Cross Joiner
Joiner
all items sold in specified range
GroupBy
Date Shifter
all months
GroupBy
christmas
Holiday_Dashboard
Joiner
item quantityminmax normalisation
Math Formula
midsommer
Holiday_Dashboard
GroupBy
item quantityminmax values
GroupBy

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: andy
Created at: 2025-11-26
On NodePit since: 2025-11-27
Last update: 2025-12-21
Created with KNIME version: v5.9.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!