New Wednesday, new Just KNIME It! challenge!
To celebrate Pride Month, we came up with a data analytics challenge that will allow us to see which countries cover the most LGBTQIA+ laws.
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-14.
Need help with tags? To add tag JKISeason2-14 to your workflow, go to the description panel on the right 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!
This is my solution.
Hello everyone, this is my solution.
The calculation rules I set are: NO -0, YES -1, other -0.5. Because I don’t fully understand the data, I don’t know if this rule is completely correct.
Here’s my solution. I’m sure the data transformation could be done more elegantly, but my brute force method works. A few countries in the data don’t match the country names in Choropleth. It could be fixed manually, but I didn’t bother.
This is my solution.
I noticed it’s quite similar @sryu, even if he did some data manipulation more “elegant”…that’s good in order to learn how to improve workflows… thanks!
Very nice. Much more sophisticated than my brute force approach. We got the same result, but your workflow is much more professional.
Here’s my solution.
Countries with higher scores than the world average are colored green.
The average score is calculated according to the columns you select.
My submission on challenge 14 - Tried to explore different visuals
This was a really fun challenge. Here is my first solution, which steals my plotly js chloropleth used in JKISeason2-5_LF to do the dataviz.
I tinkered round a bit to get to this version, which i think answered the challenge better. But my earlier version (which i call the IKEA version, because i rushed ahead without reading the instructions and the final product wasnt quite right) binned the different laws into catagories to focus on and had a range slider to filter out the hate so you could focus on the best places to live. This one was a lot of fun too:
Edit: forgot to add the link:
@AnilKS really nice solutions!!! i always learn something new from you.
Here is my solution.
I used Twinlist and table view node.
I enjoyed the interactive challenge this week and was nice to see everyone’s solutions
In this challenge I used the -Multiple Selection Widget- node to create the dropdown list of rights. I then used the -Rule Engine- to calculate the scoring and the -GroupBy- node to sum the total scores. I’ve presented the results with the -Choropleth Map- component from the hub and also the -Table View- node with the countries listed in descending score order.
I also decided to present the number of countries per score as a -Pie Chart-, to see how many countries have implemented few or lots of the LGBTQIA+ rights:
Additionally, I created a -Pie Chart- of the Score per Right, to see how common the implementation of each right is:
My workflow is available on the hub here:
It was interesting to work with Rule Engine Dictionary to apply several rules at a time. As it was required I have built a component that represents the chart and allows user to select both countries and the laws.
As always on Tuesdays, here’s our solution to last week’s challenge!
We’re happy to see so many creative dashboards! We tried to keep it simple and used the Choropleth Map component
@elisrich i learned some new tricks from this solution! thank you so much for the challenge.
@HeatherPikairos very nice. i like very much your combo of unpivoting and then use of a single rule engine. This is a great way to convert the whole table from text to a score. Love it!
Thank you @l6fader but I must say I was inspired by @sryu for this part! So they should take the credit
totally right, @HeatherPikairos …thank you for spotting my mistake… @sryu so sorry that i missed that!
i always do something like this:
but for sure this very quickly becomes an inelegant approach. i think i was just at the limit this time.
sorry to anyone else i missed!
Sleek flow and aesthetically pleasing visuals.