# Solutions to “Just KNIME It!” Challenge 22 - Season 4 **URL:** \ **Category:** JKI Season 4\ **Created:** [October 8, 2025, 1:45pm UTC](https://forum.knime.com/t/solutions-to-just-knime-it-challenge-22-season-4/90158 "2025-10-08T13:45:42Z")\ **Posts on this page:** 13\ **Page:** 1
**Author:** ![forum](https://forum-cdn.knime.com/user_avatar/forum.knime.com/forum/32/77398_2.png) [@forum](https://forum.knime.com/u/forum)\ **Post date:** [October 8, 2025, 1:45pm UTC](https://forum.knime.com/t/solutions-to-just-knime-it-challenge-22-season-4/90158/1 "2025-10-08T13:45:42Z")
🌞 Happy Wednesday, everybody! This week we’re back with a medium-level _Just KNIME It!_ challenge. 🧠 And remember: **even if you can’t solve an entire challenge, there are always easier objectives for you to play with. We are all here to learn!** 👩‍🎓 🎶 This week you’ll explore what drives global listening trends. Using a dataset of most streamed songs up to 2024, your goal is to uncover which artists dominated the charts. 🏆 Which artists released the most music? And who ranked highest in average track score? Discover which artists make the cut on both popularity and consistency. [Here](https://www.knime.com/just-knime-it) is the challenge. Let’s use this thread to post our solutions to it, which should be uploaded to your public [KNIME Hub](https://hub.knime.com/) spaces with tag **JKISeason4-22**. 🆘 **Need help with tags?** To add tag JKISeason4-22 to your workflow, go to the description panel in KNIME Analytics Platform, click the pencil to edit it, and you will see the option for adding tags right there. 😊 Let us know if you have any problems! ---
**Author:** ![jproudfoot111](https://forum-cdn.knime.com/letter_avatar_proxy/v4/letter/j/7bcc69/32.png) [@jproudfoot111](https://forum.knime.com/u/jproudfoot111)\ **Post date:** [October 8, 2025, 6:37pm UTC](https://forum.knime.com/t/solutions-to-just-knime-it-challenge-22-season-4/90158/2 "2025-10-08T18:37:42Z")
> **[JKISeason4-22 – jproudfoot111](https://hub.knime.com/jproudfoot111/spaces/Public/JKISeason4-22~KadOVoMHoeOt4K3U/current-state)** > > Solutions for data science: find workflows, nodes and components, and collaborate in spaces. ![tracks_year](https://forum-cdn.knime.com/uploads/default/original/3X/b/f/bfc11bfde86f7b23625f5ffd625302c9db4bbb9a.png) ![Top Artists](https://forum-cdn.knime.com/uploads/default/original/3X/c/3/c395fae2cdf0a7c06b691d79f1c8be78b426dd6e.png) ---
**Author:** ![rfeigel](https://forum-cdn.knime.com/letter_avatar_proxy/v4/letter/r/7ea924/32.png) [@rfeigel](https://forum.knime.com/u/rfeigel)\ **Post date:** [October 9, 2025, 3:01am UTC](https://forum.knime.com/t/solutions-to-just-knime-it-challenge-22-season-4/90158/3 "2025-10-09T03:01:10Z")
Here’s my solution. Thank god no JSON. > **[rfeigel/Public](https://hub.knime.com/rfeigel/spaces/Public/~Dl3wsnbxPcx7jg3P/)** > > – contains 304 items ![Workflow](https://forum-cdn.knime.com/uploads/default/original/3X/1/8/18f185a4daaf52a336da6c2e9200942cd225ba63.jpeg) ![Output](https://forum-cdn.knime.com/uploads/default/original/3X/e/a/eaab3b32425dcc99768b53efabaa2ebf556c8259.jpeg) ---
**Author:** ![rfeigel](https://forum-cdn.knime.com/letter_avatar_proxy/v4/letter/r/7ea924/32.png) [@rfeigel](https://forum.knime.com/u/rfeigel)\ **Post date:** [October 9, 2025, 3:07am UTC](https://forum.knime.com/t/solutions-to-just-knime-it-challenge-22-season-4/90158/4 "2025-10-09T03:07:49Z")
Here’s my solution. Thank god no JSON. Sorry couldn’t figure out how to save single link in the revised Hub. ![Workflow](https://forum-cdn.knime.com/uploads/default/original/3X/1/8/18f185a4daaf52a336da6c2e9200942cd225ba63.jpeg) ![Output](https://forum-cdn.knime.com/uploads/default/original/3X/e/a/eaab3b32425dcc99768b53efabaa2ebf556c8259.jpeg) ---
**Author:** ![trj](https://forum-cdn.knime.com/user_avatar/forum.knime.com/trj/32/17643_2.png) [@trj](https://forum.knime.com/u/trj)\ **Post date:** [October 9, 2025, 3:57am UTC](https://forum.knime.com/t/solutions-to-just-knime-it-challenge-22-season-4/90158/5 "2025-10-09T03:57:19Z")
Hi all, My solution here: [JKISeason 4-22 - Analyzing Top Streaming Artists – KNIME Community Hub](https://hub.knime.com/s/JOakRie3gPFQuYVI) I noticed some strange track name formatting, most likely to a change in the encoding. This is not handled here, but should be done for a prod workflow. Same with duplicates, nothing is checked in this current workflow, but should be done - also some inconsistency checking (dates, etc.) ![image](https://forum-cdn.knime.com/uploads/default/original/3X/1/b/1b403f7889b69898f356f47123374c67a125c744.png) Enjoy all Cheers Jerome ---
**Author:** ![AnilKS](https://forum-cdn.knime.com/user_avatar/forum.knime.com/anilks/32/52258_2.png) [@AnilKS](https://forum.knime.com/u/AnilKS)\ **Post date:** [October 9, 2025, 4:10pm UTC](https://forum.knime.com/t/solutions-to-just-knime-it-challenge-22-season-4/90158/6 "2025-10-09T16:10:08Z")
Find my Submission : [JKISeason4-22 – KNIME Community Hub](https://hub.knime.com/s/eiLIWM0S5tTAhzzY) ![flow](https://forum-cdn.knime.com/uploads/default/original/3X/9/b/9bd836bccc070ffe6d034d82dc8b5cae287122ff.png) ![artist](https://forum-cdn.knime.com/uploads/default/original/3X/9/a/9a9cc33dddf33fbf3261f1328403678bd37dec51.png) ![app](https://forum-cdn.knime.com/uploads/default/original/3X/6/c/6c85437e9d18fa5b97b30eec608728f7c4f33b4b.png) ---
**Author:** ![dataloca](https://forum-cdn.knime.com/user_avatar/forum.knime.com/dataloca/32/78464_2.png) [@dataloca](https://forum.knime.com/u/dataloca)\ **Post date:** [October 10, 2025, 5:31pm UTC](https://forum.knime.com/t/solutions-to-just-knime-it-challenge-22-season-4/90158/7 "2025-10-10T17:31:30Z")
After many weeks where time was limited, I’m very happy to be back with a fun challenge. Here is my [solution](https://hub.knime.com/topsbog/spaces/Public/JKISeason4-22%2520Top%2520Streaming%2520Artists~pf90lhQAnGrS7_L9/current-state). ![Capture d’écran 2025-10-10 132340](https://forum-cdn.knime.com/uploads/default/original/3X/7/4/7456fd00e42a758a0e92d3a8ae6d8721250d2be9.png) ---
**Author:** ![berti093](https://forum-cdn.knime.com/user_avatar/forum.knime.com/berti093/32/61891_2.png) [@berti093](https://forum.knime.com/u/berti093)\ **Post date:** [October 10, 2025, 7:39pm UTC](https://forum.knime.com/t/solutions-to-just-knime-it-challenge-22-season-4/90158/8 "2025-10-10T19:39:52Z")
My solution to the challenge: > **[JKISeason4-22\_berti093 – berti093](https://hub.knime.com/berti093/spaces/Public/Just%20KNIME%20it%20S04/JKISeason4-22_berti093~KnPkNXFFWXbivUMk/current-state)** > > Solutions for data science: find workflows, nodes and components, and collaborate in spaces. My thinking: 1. Getting the data 2. just filter for the needed columns and convert them to the needed data types (filtered out all the missing values) 3. Aggregate the data to year and visualize it in a bar chart 4. Get the TOP10 track score and TOP10 total streams and check if there is some overlap between the two lists 1. I started with the assumption with the minimum 10 tracks just refer to the track score (I understood from the task description like that) –\> In that way, there was no overlap between the two lists 2. From that I thought that is not the right approach, so I applied the minimum ten tracks for both track score and total streams, and in that way, there was four overlaps (MUSIC LAB JPN, Lil Nas X, Ed Sheeran, Harry Styles) 3. As I’m not sure which is the correct approach I kept both in the workflow My workflow: ![image](https://forum-cdn.knime.com/uploads/default/original/3X/8/b/8bd75f5d8f0f953ffce511d92ab92d559ad249eb.png) ![image](https://forum-cdn.knime.com/uploads/default/original/3X/8/0/807fb29f10671206959423a3f826f698a6298e9a.png) I tried to keep the documentation of the workflow to the maximum 🙂 I’m really interested which approach is the correct one. If there is no overlap, or there is four. I think there will be answer in the solution on Tuesday 🙂 ---
**Author:** ![garcbcpa](https://forum-cdn.knime.com/user_avatar/forum.knime.com/garcbcpa/32/74679_2.png) [@garcbcpa](https://forum.knime.com/u/garcbcpa)\ **Post date:** [October 11, 2025, 1:04am UTC](https://forum.knime.com/t/solutions-to-just-knime-it-challenge-22-season-4/90158/9 "2025-10-11T01:04:25Z")
Greetings Knimers Here is my solution to this week’s Just KNIME It challenge: [JKISeason4-22](https://hub.knime.com/s/GOTgOsoLvBG-HSjr) I had a difficult time getting a dataset where both artists had highest mean track score and number of total streams and looked at @trj workflow to understand how to get artists in both data sets and sometimes the problems lies in understanding the question and order of operations. I misunderstood that the count of tracks needs to be considered when determining highest mean track score and streams for the first 10 tracks. When using the count function I was then able to get a combined dataset for specific artists with both highest mean track score and highest total streams. ![Screenshot 2025-10-10 at 7.52.03 PM](https://forum-cdn.knime.com/uploads/default/original/3X/f/1/f1333aa338d6cf8e59ea5d11f8afd439f404f51e.png) I also considered Spotify Streams, Pandora Streams, and Soundcloud Streams as my total streams. Cheers ---
**Author:** ![Kamil\_Jan](https://forum-cdn.knime.com/letter_avatar_proxy/v4/letter/k/ce73a5/32.png) [@Kamil\_Jan](https://forum.knime.com/u/Kamil_Jan)\ **Post date:** [October 11, 2025, 4:58pm UTC](https://forum.knime.com/t/solutions-to-just-knime-it-challenge-22-season-4/90158/10 "2025-10-11T16:58:21Z")
Hi! My solution here: [JKI\_4\_Challenge22](https://hub.knime.com/s/jTMfXAoCC3684_q4) Let me know if you have any suggestions to improve my workflow 🙂 ![image](https://forum-cdn.knime.com/uploads/default/original/3X/f/8/f86131c2417409ef353507970813e9bced603ea9.png) ---
**Author:** ![wari](https://forum-cdn.knime.com/user_avatar/forum.knime.com/wari/32/73215_2.png) [@wari](https://forum.knime.com/u/wari)\ **Post date:** [October 11, 2025, 6:02pm UTC](https://forum.knime.com/t/solutions-to-just-knime-it-challenge-22-season-4/90158/11 "2025-10-11T18:02:43Z")
> **[JKISeason4-22 Wari – wari](https://hub.knime.com/wari/spaces/Public/JKISeason4-22/JKISeason4-22%20Wari~SAFAhyHnTZATEjf3/current-state)** > > Challenge 22 - Analyzing Top Streaming Artists Level: Medium Description: You are part of a music analytics team exploring what drives global listening trends.… ---
**Author:** ![trj](https://forum-cdn.knime.com/user_avatar/forum.knime.com/trj/32/17643_2.png) [@trj](https://forum.knime.com/u/trj)\ **Post date:** [October 13, 2025, 1:20am UTC](https://forum.knime.com/t/solutions-to-just-knime-it-challenge-22-season-4/90158/12 "2025-10-13T01:20:20Z")
Well done @garcbcpa - Happy to read that the workflow helped you. ---
**Author:** ![forum](https://forum-cdn.knime.com/user_avatar/forum.knime.com/forum/32/77398_2.png) [@forum](https://forum.knime.com/u/forum)\ **Post date:** [October 14, 2025, 10:09am UTC](https://forum.knime.com/t/solutions-to-just-knime-it-challenge-22-season-4/90158/13 "2025-10-14T10:09:42Z")
🌞 Our solution to last week’s Just KNIME It! challenge is out! 💥 📈 The last part of this challenge’s solution involved trend visualizations in streaming. We saw some incredible dashboards, and even creative custom visualizations! ✈ Tomorrow we will focus on an important topic that we rarely explore: big data! Can you help the regional airport authority mine lots of data to predict flight delays with an accuracy above 80%? > **[Challenge 22 - Analyzing Top Streaming Artists – Just KNIME It](https://hub.knime.com/just%20knime%20it/spaces/Solutions/Season%204/Challenge%2022/Challenge%2022%20-%20Analyzing%20Top%20Streaming%20Artists~9OOvrgT7S3SeXBOf/current-state)** > > Challenge 22: Analyzing Top Streaming Artists Level: Medium Description: You’re part of a music analytics team exploring what drives global listening trends. U…