Here’a my solution - table and line chart.
Here you go!
KNIME Solution using Column Expressions / Lag & Math Nodes
This is my solution.
Cells in the table are colored according to the percentage increase or decrease in sales.
This is my take to the challenge:
Welcome back, @gonhaddock! I am thrilled to see you here again.
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.
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.
Note: The use of the ‘Column Expressions’ node requires coding, but the advantage is that it can simplify the flowchart.
No problem! That node was a game changer for me.
Find herewith my submission for challenge 26
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:
Lots of loop-free solutions! I like it.