Icon

Challenge 01 - June

1) 5 Most popular and best rated genre

Loading the base data from the HUB

Prepare the genres to seperate rows

2) Creating bins for runtime

3) Average rating in every decade

4) Calculating HGS

Visualization

Read the letterboxddataset
CSV Reader
Split genres into list by ","
Cell Splitter
Split list itemsinto rows
Ungroup
Group by genremean popularitymean vote average
GroupBy
5 most populargenres
Top k Row Filter
5 best rated genres
Top k Row Filter
Visualization
Create % ofthe HGS score
Math Formula
New column: Type"Rating"
Constant Value Column Appender
New column: Type"Popularity"
Constant Value Column Appender
Connect toJKI space
Space Connector
Creating the decade
Math Formula
Authenticateto KNIME Hub
KNIME Hub Authenticator
Concatenate
Just where thevote count is biggerthan 500
Row Filter
Bin the moviesbased on their runtime
Numeric Binner
Calculating HGSscore for thehidden gems
Math Formula
Calculating voteaverage for everydecade
GroupBy
Put 's after thedecade number
String Manipulation

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: BBD
Created at: 2026-06-03
On NodePit since: 2026-06-12
Last update: 2026-06-12
Created with KNIME version: v5.11.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!