Solutions to “Just KNIME It!” Challenge 28 - Season 3

:sun_with_face: Hi, folks! We’re back with a fresh Just KNIME It! challenge to hone your data skills this week! :brain:

:moneybag:The crypto market is very dynamic, and data scientists working in finance often have to analyze its data. :left_right_arrow: Let’s practice our API interaction and data visualization skills this week, generating a flexible and up-to-date tree map of the top current gainers and losers in the crypto market.

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 JKISeason3-28 .

:sos: Need help with tags? To add tag JKISeason3-28 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. :blush: Let us know if you have any problems!

1 Like

My solution:

I really wanted to convince K-AI, that a scrolling ticker (just like in the link) would be very great, but I couldn’t achieve it :frowning: Maybe I wasn’t persistent enough (sadly I do not have more time right now, but I post my solution as-is, maybe it’s inspiration for others :slight_smile: )

2 Likes

Here’s my solution. The Treemap looks a little strange, but based on market cap, Bitcoin absolutely dominates its competitors.

2 Likes

Hello, here is my solution.

I really like E-Chart and K-AI for chart generation!
I tried xpath and jsonpath, also some variations of the tree map.

2 Likes

I’m still learning K-AI. Here’s the original workflow treemap with boxes around the data.

2 Likes

Hi all,
Here is my solution. All I had to do was copy and paste the assignment statements as a K-AI prompt, and the Generic ECharts View was effortlessly completed. K-AI and Generic ECharts View truly make complex tasks incredibly simple and efficient!


5 Likes

Hi all,
Here is my solution.

K-AI assisted in the implementation of interactive filters on the tree map.

2 Likes

Hi all,
Here is my solution.


By using only four node, I can create the required tree map.
Same as @sryu mentioned, I only copied a prompt suggested from K-AI and I did not type any code line!!

2 Likes

Find my submission as step by step flow :


2 Likes

Hi all,
Here is my solution. Like @sryu did, I created the tree maps without any template codes.


2 Likes

Added a timestamp and separate views for the Gainers & Losers

1 Like

Link to my solution:

Note: Built this in 5.4 preview - some of the new features came in really handy :slight_smile:

1 Like

:sun_with_face: Good morning, folks! :sun_with_face:

As always on Tuesdays, here’s our solution to last week’s Just KNIME It! challenge.

Very similar to what many of you presented! I think it can be really nice to run this workflow often if you’re into crypto. :wink:

:mega: Now, an important announcement: we won’t have a new challenge tomorrow! One of the suggestions we got for this season was to give everyone a break over Thanksgiving, so this is what we’re doing. :turkey: See you all for a new challenge on 12/04!

2 Likes

Here is my solution. Sorry I am late. I was busy with job interviews. :confused:

2 Likes

One step in the solution needs correction. When identifying the top gainers or losers, the column is still in “string” format. It needs to be converted to “number” format first to enable sorting for the subsequent steps.

1 Like