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.
here is my solution:
I decided to show states in both absolute and relative numbers.
Have a nice day,
Here is my solution for Challenge 30
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)
Here is my solution. (Oops… Revised, as it was missing some states…)
Updated, forgot to add Filter Apply Node
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.
here is my solution
All the best
here my solution:. jKi-30 – KNIME Hub
My Take on Challenge 30 - Visualizing KPIs by States
The workflow need bit more work… though.
Here’s my solution. Not very elegant, but works.
I changed my workflow because the Brandenburg state is not recognized by the Choropleth map, it needs states as codes as input.
All the best