Solutions to “Just KNIME It!” Challenge 30

[elisrich]

This thread is for posting solutions to “Just KNIME It!” Challenge 30. This week we will compare the number of foreign students in different German states over the years

Here is the challenge: Just KNIME It!

Feel free to link your solution from KNIME Hub as well!

And as always, if you have an idea for a challenge we’d love to hear it! Tell us all about it here.

[lelloba]

Hello everyone,

here is my solution:

justknimeit - 30 - Raffaello Barri – lelloba

I decided to show states in both absolute and relative numbers.

Have a nice day,
RB

[si_daniel_a]

Here is my solution for Challenge 30

justknimeit-30 – si_daniel_a

I’ve used the range filter so it can select the year range of the data not just individually, added the column selection so the result is not limited to values coming from foreigner column, added an integer input for the top k selector node so it’s not limited to top 3 states, and made the Titles dynamic based on the year/range of the year and which data column is selected

Top 3 States with most Foreign Students (Year 2000)

Top 3 States with most Foreign Students (Year 2020)

Top 5 States with most Foreign Students (Year 1998-2020)

[kwatari]

Here is my solution. (Oops… Revised, as it was missing some states…)

Challenge 30 Visualizing KPIs by States – kwatari

[si_daniel_a]

Updated, forgot to add Filter Apply Node

2000

2020

All

[ndwulst]

Dear all,

Here is my attempt for this week’s challenge: justknimeit30 - Visualizing KPIs by States – KNIME Hub

In general, a visualizer was created to view the number of foreign students in German states over the years, using an interactive map, a bar chart, and a table of the top 3:

There is also a bonus visualizer with a similar format which allows all combinations of gender and nationality, including totals as well:

Hopefully, the workflows function as intended.

[esperanca]

Hi,
here is my solution
justknimeit-30

All the best

[cf_123]

Hi,
here my solution:. jKi-30 – KNIME Hub

[AnilKS]

My Take on Challenge 30 - Visualizing KPIs by States

Just Knime it-030 – anilks

The workflow need bit more work… though.

[rfeigel]

Here’s my solution. Not very elegant, but works.

REF Challenge 30 – rfeigel

[esperanca]

Hi,
I changed my workflow because the Brandenburg state is not recognized by the Choropleth map, it needs states as codes as input.

JustKnimeIt Challenge-30 Visualizing KPIs by States - Number of Foreign...

All the best

[elisrich]

As always on Tuesdays, here is our solution to the challenge 30!

Challenge 30 - Visualizing KPIs by States - Solution – elisrich

As you can see, we kept it quite simple in our solution
It’s amazing to see all your different approaches though
Don’t forget to come back tomorrow for a new challenge!

[HypnosProject]

This is my solution to the challenge
Challenge 30 - Visualizing KPIs by States