Solutions to “Just KNIME It!” Challenge 26 - Season 2

[alinebessa]

New Wednesday, new Just KNIME It! challenge!

This week we have our last easy challenge of the season! Join us and solve a sales management task to hone your data preprocessing skills. How much can you simplify your solution?

This season we will have 30 challenges, so it’s fair to say we can already see the end of it coming! Time to tackle old challenges and score your way into our leaderboard!

Here is the challenge. Let’s use this thread to post our solutions to it, which should be uploaded to your public KNIME Hub spaces with tag JKISeason2-26.

Need help with tags? To add tag JKISeason2-26 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!

[rfeigel]

Here’a my solution - table and line chart.

JKISeason2-26 – rfeigel

[skybe077]

Here you go!

KNIME Solution using Column Expressions / Lag & Math Nodes

Workflow

Output Table

Line Plot

[sryu]

Hi all,
This is my solution.
Cells in the table are colored according to the percentage increase or decrease in sales.

JKISeason2-26_sryu – sryu

[gonhaddock]

Hello knimers,
This is my take to the challenge:

Just KNIME It S02 _ CH26 _ Calculating Sales Performance – gonhaddock

Happy Knim(e)ing

[MoLa_Data]

Welcome back, @gonhaddock! I am thrilled to see you here again.

[MoLa_Data]

Happy KNIMing

JKISeason2-26 Ángel Molina – mola_data

[gonhaddock]

Hello @MoLa_Data
I’ve been very busy these days with work + logistics… then I couldn’t follow up the JKI Challenges as I would like, by delivering out of the box solutions. This CH26 was an easy one, so it didn’t require too much from my side.

I have a couple of unfinished past challenges in my desktop. I would like to complete them before season ends; now that northern hemisphere’s summer already passed away.

salu2

[tomljh]

The ‘Column Expressions’ node is a magical node that can replace the’ Math ‘node, the’ String Manipulation ‘node, and even the’ Lag Column 'node. We can also program multiple lines and only return the last line, which can also be annotated.

Thank you to @skybe077 for sharing, and also to @sryu for sharing the processing skills of the “Lag Column” node.

JKISeasor2-26_tomljh_ver1 – tomljh

Note: The use of the ‘Column Expressions’ node requires coding, but the advantage is that it can simplify the flowchart.

[skybe077]

No problem! That node was a game changer for me.

[AnilKS]

Find herewith my submission for challenge 26

Justknimeit-S2C26 – anilks

[HeatherPikairos]

Hi Everyone

I have done much the same as everyone else this week:

I was inspired by @MoLa_Data to use a stacked bar chart so that the total percentage change for each month can be viewed:

Thanks also to those of you who shared solutions with the -Column Expressions- node, that was interesting to see!

My solution is here:

20230921 Pikairos JustKNIMEIt Season 2 Challenge 26 Calculating Sales...

Best wishes
Heather

[alinebessa]

As always on Tuesdays, but a little later today due to technical issues, here’s our solution to last week’s Just KNIME It! challenge

Challenge 26 - Calculating Sales Performance – knime

As you can see, our solution relies mostly on a basic loop and lagging operations. Easy peasy! We hope this last easy challenge felt inclusive and honed you a bit for our final stretch. We only have 4 more challenges to go!

[alinebessa]

Lots of loop-free solutions! I like it.