# Solutions to "Just KNIME It!" Challenge 19 **URL:** \ **Category:** Just KNIME It!\ **Tags:** justknimeit\ **Created:** [June 1, 2022, 1:37pm UTC](https://forum.knime.com/t/solutions-to-just-knime-it-challenge-19/43680 "2022-06-01T13:37:43Z")\ **Posts on this page:** 19\ **Page:** 2
**Author:** ![gonhaddock](https://forum-cdn.knime.com/user_avatar/forum.knime.com/gonhaddock/32/35425_2.png) [@gonhaddock](https://forum.knime.com/u/gonhaddock)\ **Post date:** [June 2, 2022, 8:00pm UTC](https://forum.knime.com/t/solutions-to-just-knime-it-challenge-19/43680/21 "2022-06-02T20:00:00Z")
> [@gonhaddock](#): > > Here is my solution to #justknimeit-19 : > > KNIME Hub \> gonhaddock \> Spaces \> Just\_KNIME\_It \> [Just KNIME It \_ Challenge 019](https://kni.me/w/ZcM4v9S9SbkBZNf2) Adding a Bar Chart component: ![image](https://forum-cdn.knime.com/uploads/default/original/3X/b/d/bd686c8d642a01653c79ba875b05933bde5f6d9a.png) BR ---
**Author:** ![eamendola](https://forum-cdn.knime.com/user_avatar/forum.knime.com/eamendola/32/36540_2.png) [@eamendola](https://forum.knime.com/u/eamendola)\ **Post date:** [June 2, 2022, 8:03pm UTC](https://forum.knime.com/t/solutions-to-just-knime-it-challenge-19/43680/22 "2022-06-02T20:03:58Z")
@Ilkka You need to first select your workflow (before upload it to the Hub) ![image](https://forum-cdn.knime.com/uploads/default/original/3X/2/7/278cadb8abdc73a58aac70e77cd6796c7bf13680.png) Then on the toolbar select **View \> Description** ![image](https://forum-cdn.knime.com/uploads/default/original/3X/1/a/1ab8914515886efc906530aa5e5c0c7aed0d3e93.png) Finally at your right, a new tab will open. Click on the edit button (top right) and then fill the form. Click on the save button (top right again) and then you can upload it to the Hub. ![image](https://forum-cdn.knime.com/uploads/default/original/3X/9/4/943450dde8521e14ab48d09467d82376e1cedf35.png) ---
**Author:** ![walkergv77](https://forum-cdn.knime.com/user_avatar/forum.knime.com/walkergv77/32/39486_2.png) [@walkergv77](https://forum.knime.com/u/walkergv77)\ **Post date:** [June 2, 2022, 11:06pm UTC](https://forum.knime.com/t/solutions-to-just-knime-it-challenge-19/43680/23 "2022-06-02T23:06:18Z")
I got pretty much the same for my attempt - pretty straightforward 👍 ---
**Author:** ![walkergv77](https://forum-cdn.knime.com/user_avatar/forum.knime.com/walkergv77/32/39486_2.png) [@walkergv77](https://forum.knime.com/u/walkergv77)\ **Post date:** [June 2, 2022, 11:10pm UTC](https://forum.knime.com/t/solutions-to-just-knime-it-challenge-19/43680/24 "2022-06-02T23:10:05Z")
Knime is a super powerful tool. I remember starting out spending hours and hours trying to get my head around it. When it clicks in your head, it’s gold. This tool saves me countless hours a week doing analysis and reporting. 👍 ---
**Author:** ![eamendola](https://forum-cdn.knime.com/user_avatar/forum.knime.com/eamendola/32/36540_2.png) [@eamendola](https://forum.knime.com/u/eamendola)\ **Post date:** [June 3, 2022, 3:16am UTC](https://forum.knime.com/t/solutions-to-just-knime-it-challenge-19/43680/25 "2022-06-03T03:16:55Z")
Good night everyone ! My take on this challenge. The solution was pretty straightforward but I wanted to play around some more with a top-down style dashboard; high level KPIs to a detailed level. ![image](https://forum-cdn.knime.com/uploads/default/original/3X/a/f/affb7bd1d84d14f4986650c5ea7e282096500fe5.png) ![1](https://forum-cdn.knime.com/uploads/default/original/3X/6/f/6f1f911baf2d6f81e95fcfac1bc426b3aad495da.png) > **[Challenge 19 - Employee Skills – eamendola](https://hub.knime.com/eamendola/spaces/Just%20KNIME%20it%20!/latest/Challenge%2019%20-%20Employee%20Skills~ltVbHTYnaJwi5sJq)** > > CategorIze employees based on a tech skills survey ---
**Author:** ![badger101](https://forum-cdn.knime.com/user_avatar/forum.knime.com/badger101/32/45755_2.png) [@badger101](https://forum.knime.com/u/badger101)\ **Post date:** [June 3, 2022, 3:20am UTC](https://forum.knime.com/t/solutions-to-just-knime-it-challenge-19/43680/26 "2022-06-03T03:20:02Z")
Looks so beautiful & clean! @eamendola ---
**Author:** ![walkergv77](https://forum-cdn.knime.com/user_avatar/forum.knime.com/walkergv77/32/39486_2.png) [@walkergv77](https://forum.knime.com/u/walkergv77)\ **Post date:** [June 3, 2022, 3:50am UTC](https://forum.knime.com/t/solutions-to-just-knime-it-challenge-19/43680/27 "2022-06-03T03:50:39Z")
Here is my submission. I tried to do it in as few nodes as possible. The Numeric Binner is a nice tool to use as it categorizes plus provides the column names to use in a pivot. ![image](https://forum-cdn.knime.com/uploads/default/original/3X/0/b/0b46bf140e225b8b8ac69af5d43f3d4295f0ade2.png) ![image](https://forum-cdn.knime.com/uploads/default/original/3X/6/a/6a206ae5a1ef0c34f746009cc7c617ea42e73da6.png) > **[Just Knime It #19 Solution – walkergv77](https://hub.knime.com/walkergv77/spaces/Public/latest/Knime-It%2019~iiLZNfLbt9EelCR7)** > > Solutions for data science: find workflows, nodes and components, and collaborate in spaces. ---
**Author:** ![Ilkka](https://forum-cdn.knime.com/letter_avatar_proxy/v4/letter/i/5f8ce5/32.png) [@Ilkka](https://forum.knime.com/u/Ilkka)\ **Post date:** [June 3, 2022, 5:38am UTC](https://forum.knime.com/t/solutions-to-just-knime-it-challenge-19/43680/28 "2022-06-03T05:38:09Z")
This is why I like these challenges, looks great! Didn’t even know you could build a dashboard view, will definitely use that on my own workflows! ---
**Author:** ![ismailakgun](https://forum-cdn.knime.com/letter_avatar_proxy/v4/letter/i/eb8c5e/32.png) [@ismailakgun](https://forum.knime.com/u/ismailakgun)\ **Post date:** [June 3, 2022, 7:21am UTC](https://forum.knime.com/t/solutions-to-just-knime-it-challenge-19/43680/29 "2022-06-03T07:21:11Z")
Thank you. I have learned so much. I was not using Pivot/Unpivot and GroupBy nodes in my workflows. But in this challange I’ve seen perfect use cases 🙂 ---
**Author:** ![victor\_palacios](https://forum-cdn.knime.com/user_avatar/forum.knime.com/victor_palacios/32/37922_2.png) [@victor\_palacios](https://forum.knime.com/u/victor_palacios)\ **Post date:** [June 3, 2022, 8:57pm UTC](https://forum.knime.com/t/solutions-to-just-knime-it-challenge-19/43680/30 "2022-06-03T20:57:36Z")
I love these dashboards you’ve made for some of the challenges. Really beautiful and useful at once! ---
**Author:** ![dawud](https://forum-cdn.knime.com/user_avatar/forum.knime.com/dawud/32/41006_2.png) [@dawud](https://forum.knime.com/u/dawud)\ **Post date:** [June 4, 2022, 6:57am UTC](https://forum.knime.com/t/solutions-to-just-knime-it-challenge-19/43680/31 "2022-06-04T06:57:25Z")
Don’t worry and don’t be shy put you throught it, a warm welcome ---
**Author:** ![eamendola](https://forum-cdn.knime.com/user_avatar/forum.knime.com/eamendola/32/36540_2.png) [@eamendola](https://forum.knime.com/u/eamendola)\ **Post date:** [June 4, 2022, 7:56pm UTC](https://forum.knime.com/t/solutions-to-just-knime-it-challenge-19/43680/32 "2022-06-04T19:56:21Z")
Thank you very much @victor_palacios !! It means a lot ! 👏👏👏 ---
**Author:** ![eamendola](https://forum-cdn.knime.com/user_avatar/forum.knime.com/eamendola/32/36540_2.png) [@eamendola](https://forum.knime.com/u/eamendola)\ **Post date:** [June 4, 2022, 7:58pm UTC](https://forum.knime.com/t/solutions-to-just-knime-it-challenge-19/43680/33 "2022-06-04T19:58:00Z")
Yes! They are indeed useful to visually explore your data. Take a look at this blog in case you want to dig deeper into dashboard making: [Build a Data App: Create an Interactive Dashboard in Three Steps with KNIME Analytics Platform | KNIME](https://www.knime.com/blog/how-to-create-an-interactive-dashboard-in-three-steps-with-knime) ---
**Author:** ![Andrew\_Steel](https://forum-cdn.knime.com/user_avatar/forum.knime.com/andrew_steel/32/4472_2.png) [@Andrew\_Steel](https://forum.knime.com/u/Andrew_Steel)\ **Post date:** [June 5, 2022, 8:11pm UTC](https://forum.knime.com/t/solutions-to-just-knime-it-challenge-19/43680/34 "2022-06-05T20:11:18Z")
Hi knimers, This > **[Employee Skills – andrew\_steel](https://hub.knime.com/andrew_steel/spaces/Public/latest/EmployeeSkills~tdGhLlAq_-M2o00G)** > > A survey was done to ask employees to rate themselves on a scale of 1-5 on different technologies and skills. We would like you to analyze this data and presen… is a slightly different solution. If the task is taken as described in [Challenge 19: Employee Skills](https://www.knime.com/just-knime-it), solutions with Unpivoting, Rule Engine or Column Expression and GroupBy and Pivoting notes are certainly the right solution. However, if you follow the link in the description, two methods have to be combined: 1. Primary skill can be defined as skills rated 5, Secondary skills rated 3 and 4 and tertiary skills are rated 2. The final list should appear like below. 2. Top three skills as “Primary Skills”, Next five skills as “secondary Skills” and next 7 skills as “Tertiary skills”. There could be cases where an employee has not rated themselves more than 3 on any of the skill. Therefore my solution is a bit more complex: ![Bildschirmfoto von 2022-06-05 22-07-03](https://forum-cdn.knime.com/uploads/default/original/3X/3/9/39c73755f69ae3a30284f87c8b6f321a605f2920.png) ![Bildschirmfoto von 2022-06-05 22-08-31](https://forum-cdn.knime.com/uploads/default/original/3X/d/0/d025ebdd9b9744da87fc3a7d611d1f694b089511.png) Best regards Andrew ---
**Author:** ![amineKac](https://forum-cdn.knime.com/user_avatar/forum.knime.com/aminekac/32/40825_2.png) [@amineKac](https://forum.knime.com/u/amineKac)\ **Post date:** [June 6, 2022, 9:04am UTC](https://forum.knime.com/t/solutions-to-just-knime-it-challenge-19/43680/35 "2022-06-06T09:04:25Z")
great to hear that , i am looking forward to learn as muc as i can on kinme and from the community ---
**Author:** ![sriram5608](https://forum-cdn.knime.com/letter_avatar_proxy/v4/letter/s/df705f/32.png) [@sriram5608](https://forum.knime.com/u/sriram5608)\ **Post date:** [June 6, 2022, 10:44am UTC](https://forum.knime.com/t/solutions-to-just-knime-it-challenge-19/43680/36 "2022-06-06T10:44:11Z")
hello Here is my solution [justknimeit-19.knwf](https://forum.knime.com/uploads/short-url/qXndOP34NhmRm20DRmjrTCia7yt.knwf) (28.1 KB) ---
**Author:** ![alinebessa](https://forum-cdn.knime.com/user_avatar/forum.knime.com/alinebessa/32/33306_2.png) [@alinebessa](https://forum.knime.com/u/alinebessa)\ **Post date:** [June 7, 2022, 1:07pm UTC](https://forum.knime.com/t/solutions-to-just-knime-it-challenge-19/43680/37 "2022-06-07T13:07:38Z")
As always on Tuesdays, here’s our solution to last week’s challenge. ❣ > **[Challenge 19 - Employee Skills - Solution – alinebessa](https://hub.knime.com/knime/spaces/Just%20KNIME%20It!/latest/Challenge%2019%20-%20Employee%20Skills%20-%20Solution~QEDXntpXYMzjMrEl)** > > A survey was done to ask employees to rate themselves on a scale of 1-5 on different technologies and skills. We would like you to analyze this data and presen… We’re forever in love with the Unpivoting node (in case you haven’t noticed it yet haha). 😍 Thanks @Jyotendra for submitting this super cool challenge to our community. 🙂 🙂 ---
**Author:** ![MEPivnenko](https://forum-cdn.knime.com/user_avatar/forum.knime.com/mepivnenko/32/36596_2.png) [@MEPivnenko](https://forum.knime.com/u/MEPivnenko)\ **Post date:** [June 21, 2022, 6:44am UTC](https://forum.knime.com/t/solutions-to-just-knime-it-challenge-19/43680/38 "2022-06-21T06:44:06Z")
1 challenge 5 nodes > **[KnimeIT\_19 – mepivnenko](https://hub.knime.com/mepivnenko/spaces/Public/latest/KnimeIT_19~j3KeFQqW4zliz3_k)** > > Solutions for data science: find workflows, nodes and components, and collaborate in spaces. ---
**Author:** ![system](https://forum-cdn.knime.com/uploads/default/original/1X/ab3ccf34482a0329361734a18199390177204f15.png) [@system](https://forum.knime.com/u/system)\ **Post date:** [September 19, 2022, 6:44am UTC](https://forum.knime.com/t/solutions-to-just-knime-it-challenge-19/43680/39 "2022-09-19T06:44:27Z")
This topic was automatically closed 90 days after the last reply. New replies are no longer allowed. [Previous page](https://forum.knime.com/t/solutions-to-just-knime-it-challenge-19/43680.md?page=1)