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

**URL:** <https://forum.knime.com/t/solutions-to-just-knime-it-challenge-6-season-3/80511>\
**Category:** Just KNIME It!\
**Tags:** justknimeit\
**Created:** [June 19, 2024, 1:38pm UTC](https://forum.knime.com/t/solutions-to-just-knime-it-challenge-6-season-3/80511 "2024-06-19T13:38:36Z")\
**Posts on this page:** 20\
**Page:** 1

<div class="post-metadata">

**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 19, 2024, 1:38pm UTC](https://forum.knime.com/t/solutions-to-just-knime-it-challenge-6-season-3/80511/1 "2024-06-19T13:38:37Z")

</div>

💥 It’s Wednesday once again! 🌞 And here we are with a fresh _Just KNIME It!_ challenge.

⚽ As the UEFA European Football Championship unfolds, let’s create a data app to visualize, for any timeframe in football history, what teams held the most victories 🏆. We can’t wait to see if you find any surprising rankings!

[Here](https://www.knime.com/just-knime-it) is the challenge. Let’s use this thread to post our solutions to it, which should be uploaded to your public [KNIME Hub](https://hub.knime.com/)spaces with tag **JKISeason3-6**.

🆘 **Need help with tags?** To add tag JKISeason3-6 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. 🙂 Let us know if you have any problems!

---

<div class="post-metadata">

**Author:** ![rfeigel](https://forum-cdn.knime.com/letter_avatar_proxy/v4/letter/r/7ea924/32.png) [@rfeigel](https://forum.knime.com/u/rfeigel)\
**Post date:** [June 19, 2024, 6:04pm UTC](https://forum.knime.com/t/solutions-to-just-knime-it-challenge-6-season-3/80511/2 "2024-06-19T18:04:04Z")

</div>

Here’s my solution. This challenge was a little more complicated than I first thought.

> **[JKISeason3-6 – rfeigel](https://hub.knime.com/rfeigel/spaces/Public/JKISeason3-6~nl1MNcbsxUFP5ki5/current-state)**
>
> Solutions for data science: find workflows, nodes and components, and collaborate in spaces.

 ![View](https://forum-cdn.knime.com/uploads/default/original/3X/a/f/af6b94f33033be48ceb5a4b95e2a97a183b7932c.jpeg)

---

<div class="post-metadata">

**Author:** ![mr\_icaro](https://forum-cdn.knime.com/letter_avatar_proxy/v4/letter/m/a5b964/32.png) [@mr\_icaro](https://forum.knime.com/u/mr_icaro)\
**Post date:** [June 20, 2024, 2:20am UTC](https://forum.knime.com/t/solutions-to-just-knime-it-challenge-6-season-3/80511/3 "2024-06-20T02:20:30Z")

</div>

Hello! This is my solution!!

> **[just\_knimeit\_s03C06 – mr\_icaro](https://hub.knime.com/mr_icaro/spaces/Public/JKISeason6-3_Visualizing_Top_Football_Teams_in_History/just_knimeit_s03C06~FJpRBjDPIVrgt9bA/current-state)**
>
> Description: As the 2024 European Football Championship (UEFA) unfolds, let's dive into football history with a data challenge. Today you are asked to create a…

 ![image](https://forum-cdn.knime.com/uploads/default/original/3X/4/c/4cb7bb5edcf0f839987717765a00bf2406fdb8b5.png)

 ![image](https://forum-cdn.knime.com/uploads/default/original/3X/a/a/aaa59bcbb8d189ac8f36395571a5944a5d8e7c14.png)

 ![image](https://forum-cdn.knime.com/uploads/default/original/3X/4/9/4947a585c2d32eb35918e178cb4774eea4d4e9d6.png)

---

<div class="post-metadata">

**Author:** ![rfeigel](https://forum-cdn.knime.com/letter_avatar_proxy/v4/letter/r/7ea924/32.png) [@rfeigel](https://forum.knime.com/u/rfeigel)\
**Post date:** [June 20, 2024, 3:04am UTC](https://forum.knime.com/t/solutions-to-just-knime-it-challenge-6-season-3/80511/4 "2024-06-20T03:04:59Z")

</div>

I would suggest that you don’t use a nightly build KAP to build workflows for JKI. Very few other Knimers use nightly builds for production work. Its always tempting because of new features but it means most Knimers won’t be able to use your workflow.

---

<div class="post-metadata">

**Author:** ![mr\_icaro](https://forum-cdn.knime.com/letter_avatar_proxy/v4/letter/m/a5b964/32.png) [@mr\_icaro](https://forum.knime.com/u/mr_icaro)\
**Post date:** [June 20, 2024, 12:37pm UTC](https://forum.knime.com/t/solutions-to-just-knime-it-challenge-6-season-3/80511/5 "2024-06-20T12:37:31Z")

</div>

Thank you for your reply. I noticed I did a wrong aggregation.  
I fixed it and I uploaded again using KNIME 5.2.5  
I added 1980s information too.

 ![image](https://forum-cdn.knime.com/uploads/default/original/3X/f/d/fdfac2b7bd49dc0206d7073457b761e4051a2995.png)

 ![image](https://forum-cdn.knime.com/uploads/default/original/3X/9/1/91c48a4845b47ddd54d43aa9680911c9cbf417a0.png)

---

<div class="post-metadata">

**Author:** ![arief\_rama](https://forum-cdn.knime.com/user_avatar/forum.knime.com/arief_rama/32/82032_2.png) [@arief\_rama](https://forum.knime.com/u/arief_rama)\
**Post date:** [June 20, 2024, 2:31pm UTC](https://forum.knime.com/t/solutions-to-just-knime-it-challenge-6-season-3/80511/6 "2024-06-20T14:31:04Z")

</div>

Hi @alinebessa 👋 🙂

Tonight, I managed to come up with a solution for the JKISeason3-6 challenge, even though I don’t really understand much about the game of soccerc 😄

> **[JKISeason3-6 arief\_rama – arief\_rama](https://hub.knime.com/arief_rama/spaces/Public/JKISeason3/JKISeason3-6%20arief_rama~Q8x_S9G72vMhy5Pv/current-state)**
>
> Visualizing Top Football Teams in History Challenge 6 Level: Medium Description: As the 2024 European Football Championship (UEFA) unfolds, let's dive into foo…

 ![Screenshot 2024-06-20 at 21.27.36](https://forum-cdn.knime.com/uploads/default/original/3X/d/5/d51aa8d9224f8fcff91b63aec010cdf03adcf126.jpeg)

---

<div class="post-metadata">

**Author:** ![jm1950sjr](https://forum-cdn.knime.com/user_avatar/forum.knime.com/jm1950sjr/32/67705_2.png) [@jm1950sjr](https://forum.knime.com/u/jm1950sjr)\
**Post date:** [June 20, 2024, 4:23pm UTC](https://forum.knime.com/t/solutions-to-just-knime-it-challenge-6-season-3/80511/7 "2024-06-20T16:23:53Z")

</div>

Hi all,  
Here is my solution.

> **[JKI-S3\_challenge06 – jm1950sjr](https://hub.knime.com/jm1950sjr/spaces/Public/Just%20KNIME%20It!%20Season3/JKI-S3_challenge06~K7FyJs91SxPCNbsm/current-state)**
>
> Level: Medium Description: As the 2024 European Football Championship (UEFA) unfolds, let's dive into football history with a data challenge. Today you are ask…

I have developed two types of tournaments. It includes features such as a range filter (by year) and a top N filter. One of my favorite components, the Choropleth Map, makes it easy to visualize trends.

 ![スクリーンショット 2024-06-21 1.17.43](https://forum-cdn.knime.com/uploads/default/original/3X/0/8/086bbaf50523e62aec2d276b1b94e23acd30cb91.png)

The second application is specifically designed for examing the details of each tournament.

 ![スクリーンショット 2024-06-21 1.23.05](https://forum-cdn.knime.com/uploads/default/original/3X/d/0/d08143801bdbb60b539eb2504f997e9688394255.png)

---

<div class="post-metadata">

**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 20, 2024, 5:10pm UTC](https://forum.knime.com/t/solutions-to-just-knime-it-challenge-6-season-3/80511/8 "2024-06-20T17:10:59Z")

</div>

Welcome to our community, @mr_icaro!

---

<div class="post-metadata">

**Author:** ![RBre](https://forum-cdn.knime.com/user_avatar/forum.knime.com/rbre/32/76285_2.png) [@RBre](https://forum.knime.com/u/RBre)\
**Post date:** [June 20, 2024, 8:30pm UTC](https://forum.knime.com/t/solutions-to-just-knime-it-challenge-6-season-3/80511/9 "2024-06-20T20:30:12Z")

</div>

Hello, this is my solution.

I used a range slider to select the year range and an integer widget to select the number of top teams to display.  
The bar chart shows total win, draw and lose.

 ![Component View](https://forum-cdn.knime.com/uploads/default/original/3X/b/3/b3e05d18db20b68d2be45e3649e4c70762294276.jpeg)

> **[JKISeason3-6\_RBre – rbre](https://hub.knime.com/rbre/spaces/Public/JKISeason3-6_RBre~8aGUtS1UKpa07f00/current-state)**
>
> Visualizing Top Football Teams in History Challenge 6 Level: Medium Description: As the 2024 European Football Championship (UEFA) unfolds, let's dive into foo…

---

<div class="post-metadata">

**Author:** ![veniapputrii](https://forum-cdn.knime.com/user_avatar/forum.knime.com/veniapputrii/32/53106_2.png) [@veniapputrii](https://forum.knime.com/u/veniapputrii)\
**Post date:** [June 21, 2024, 9:33am UTC](https://forum.knime.com/t/solutions-to-just-knime-it-challenge-6-season-3/80511/10 "2024-06-21T09:33:04Z")

</div>

Hi!!  
I’m delighted I can go with this event (again)  
here are my solutions :

 ![image](https://forum-cdn.knime.com/uploads/default/original/3X/3/3/3315a47733a24c940d8aef95c984384449f76746.png)  
 ![image](https://forum-cdn.knime.com/uploads/default/original/3X/a/b/ab150f3cbf27de0df028701729a0831f01e06b06.jpeg)

> **[JKISeason3-6-Veni – veniapputrii](https://hub.knime.com/veniapputrii/spaces/Project/Just%20KNIME%20it!/Season%203/JKISeason3-6-Veni~R3rQaQMdseiSS5Kl/current-state)**
>
> Solutions for data science: find workflows, nodes and components, and collaborate in spaces.

cheers,  
Veni

---

<div class="post-metadata">

**Author:** ![tomljh](https://forum-cdn.knime.com/user_avatar/forum.knime.com/tomljh/32/67732_2.png) [@tomljh](https://forum.knime.com/u/tomljh)\
**Post date:** [June 21, 2024, 1:24pm UTC](https://forum.knime.com/t/solutions-to-just-knime-it-challenge-6-season-3/80511/11 "2024-06-21T13:24:43Z")

</div>

Hi,  
I only focus on the UEFA Euro, which uses win rate data to evaluate the results of each team.

 ![001](https://forum-cdn.knime.com/uploads/default/original/3X/1/8/1831cc3b70d7c3df5d25cb4a522994d1a86976fd.jpeg)

> **[JKISeason3-6\_tomljh – tomljh](https://hub.knime.com/tomljh/spaces/Public/JKISeason3/JKISeason3-6_tomljh~uXFigCTh87KlSFb0/current-state)**
>
> Visualizing Top Football Teams in History Challenge 6 Level: Medium Description: As the 2024 European Football Championship (UEFA) unfolds, let's dive into foo…

BR

---

<div class="post-metadata">

**Author:** ![MartinDDDD](https://forum-cdn.knime.com/user_avatar/forum.knime.com/martindddd/32/69988_2.png) [@MartinDDDD](https://forum.knime.com/u/MartinDDDD)\
**Post date:** [June 21, 2024, 1:44pm UTC](https://forum.knime.com/t/solutions-to-just-knime-it-challenge-6-season-3/80511/12 "2024-06-21T13:44:48Z")

</div>

TL:DR:

- implemented ELO system - all-time ELO turned out useless, however after 3h of execution I at least saved the .table file to local wf data area
- made it interactive - user pics cut of date and number of years to go backwards in time as well as the competitions to include
- ELO is calculated for the selected timeframe / competitions - in the first match every team starts with ELO = 1000
- Top 10 by average ranking for each year shown in rank bump chart
- absolute ranking over full timeframe shown in Table View
- full Match history and ELO development shown in different Table View

I think this one derailed a little bit for me :D. This tends to happen when sports data is involved…

I was trying to work out how to best determine “the best team” whilst also somehow considering the quality of opponents… then it occurred to me… there is something called ELO that is used in matchmaking for multiplayer games (warcraft 3, startcraft 2… and of course… CHESS just to name those that I have touched in the distant past).

It actually was not too difficult to find a source for ELO algorithms and to implement it - I though started to get concerned a little when I realised that every row needed to be processed individually inside a recursive loop as the new ELO after a match needed to be considered in the next matches ELO calculation… **46k rows… can’t take too long right? 😂** It looked ok to start with however after a few hours of running when hitting the high 30ks the end seemed near however processing slowed down more and more…

I then realised that KNIME was running on 2k of RAM max so I cancelled, set it to 16gb and started again… **three hours later it was done** … and the outcome was gibberish as ELO doesn’t work very well over this long timeframe once ELO differences between teams are large.

Given the computational effort my poor computer put into it I saved the data regardless and moved on to building something that makes sense on top of the algo so:  
To limit the rows to be processed, there are widgets to pick a cut of date (no matches after this date to be considered) and a full number of years to go backwards from that date (no games earlier than the calculated date are considered). Also the competitions to be included can now be selected via widget.

So despite the all-time calculation definitely not working out I wanted to share the results here:

**Top 3 teams based on total ELO after processing all 46k games:**

 ![image](https://forum-cdn.knime.com/uploads/default/original/3X/7/a/7a260f52ee593afabfecfcbd55a411e62493d2d3.png)

South Korea? Really did not see that one coming!

**Top 3 Teams in the 1980s:**  
Based on Average ELO (Rank Chart example)

 ![image](https://forum-cdn.knime.com/uploads/default/original/3X/5/0/507e415102ba199dd3dfb0ffb4c0e5414d5c1f8b.png)

Based on Absolute ELO (Table View Example)

 ![image](https://forum-cdn.knime.com/uploads/default/original/3X/0/b/0b9144f895c9f4d6a5533c3a1a2996db22f59824.png)

You can find the workflow here:

> **[JKI-S3-C6-MartinDDDD – martindddd](https://hub.knime.com/martindddd/spaces/Public/Just%20Knime%20It/S3/C6/JKI-S3-C6-MartinDDDD~1TO3zL-H5B17BoZ6/current-state)**
>
> Solutions for data science: find workflows, nodes and components, and collaborate in spaces.

---

<div class="post-metadata">

**Author:** ![kwatari](https://forum-cdn.knime.com/user_avatar/forum.knime.com/kwatari/32/41003_2.png) [@kwatari](https://forum.knime.com/u/kwatari)\
**Post date:** [June 21, 2024, 2:13pm UTC](https://forum.knime.com/t/solutions-to-just-knime-it-challenge-6-season-3/80511/13 "2024-06-21T14:13:51Z")

</div>

Hi all, here is my solution to Just KNIME It! Challenge 6 - Season 3.

> **[JKI\_S3\_C6 – kwatari](https://hub.knime.com/kwatari/spaces/Public/JKI/S3/JKI_S3_C6~j4NclNA_G3Sc45V-/current-state)**
>
> Visualizing Top Football Teams in History Challenge 6 Level: Medium Description: As the 2024 European Football Championship (UEFA) unfolds, let's dive into foo…

 ![image](https://forum-cdn.knime.com/uploads/default/original/3X/e/b/eb5b403900e5e606b18e4c0e363cb2c887d3506a.jpeg)

---

<div class="post-metadata">

**Author:** ![pablofernandez](https://forum-cdn.knime.com/letter_avatar_proxy/v4/letter/p/aca169/32.png) [@pablofernandez](https://forum.knime.com/u/pablofernandez)\
**Post date:** [June 21, 2024, 6:24pm UTC](https://forum.knime.com/t/solutions-to-just-knime-it-challenge-6-season-3/80511/14 "2024-06-21T18:24:53Z")

</div>

Here it´s my solution!

[https://hub.knime.com/pablofernandez/spaces/Public/latest/JKISeason3-6~2U4odL9nSnp2VROf/](https://hub.knime.com/pablofernandez/spaces/Public/latest/JKISeason3-6~2U4odL9nSnp2VROf/)

Including also possibility to choose Tournaments, and average of Winning matches over Total matches.

---

<div class="post-metadata">

**Author:** ![Tofusa](https://forum-cdn.knime.com/letter_avatar_proxy/v4/letter/t/ecd19e/32.png) [@Tofusa](https://forum.knime.com/u/Tofusa)\
**Post date:** [June 22, 2024, 1:45am UTC](https://forum.knime.com/t/solutions-to-just-knime-it-challenge-6-season-3/80511/15 "2024-06-22T01:45:08Z")

</div>

Hi all, here is my solution.

> **[JKISeason3-6\_tofusa – tofusa](https://hub.knime.com/tofusa/spaces/Public/Just_KNIME_It/JKISeason3-6_tofusa~61uNIMGwa2uMe3Ac/current-state)**
>
> Level: Medium Description: As the 2024 European Football Championship (UEFA) unfolds, let's dive into football history with a data challenge. Today you are ask…

I feel like there are a lot of complicated solutions from everyone these days, so I went back to the beginner’s mood and created an application with a simple table view.

 ![image](https://forum-cdn.knime.com/uploads/default/original/3X/f/f/ff87d6d47fbdcc42223bfe52dacaf3975068b896.png)  
 ![image](https://forum-cdn.knime.com/uploads/default/original/3X/3/e/3e0a7dd0fdf5f14aaeb5f1fe630f693267a21782.png)

The challenge asked us to show the top 3, but I’ve expanded it and set it up to display the top 10. The upper table lists the teams by number of wins and winning percentage from the 1980s, the bottom one allows the user to set the time period for the tally using the Date&Time widget which can show calendar.

---

<div class="post-metadata">

**Author:** ![PKRISH](https://forum-cdn.knime.com/letter_avatar_proxy/v4/letter/p/dc4da7/32.png) [@PKRISH](https://forum.knime.com/u/PKRISH)\
**Post date:** [June 23, 2024, 2:55am UTC](https://forum.knime.com/t/solutions-to-just-knime-it-challenge-6-season-3/80511/16 "2024-06-23T02:55:23Z")

</div>

![image](https://forum-cdn.knime.com/uploads/default/original/3X/e/a/ea8bfa1da34279b56c66face6aa7f0237d9eb013.png)  
 ![image](https://forum-cdn.knime.com/uploads/default/original/3X/5/8/58a1136603d001b67150a8551b7b8bbecb28e179.jpeg)

Friendly matches have been ignored.

 ![image](https://forum-cdn.knime.com/uploads/default/original/3X/e/8/e810dda8a49e245a1662e6fe090d3b0fb3e8ed33.png)

To improve my productivity as a KNIMEer, I used Components available in the Community Hub. It definitely helps.

---

<div class="post-metadata">

**Author:** ![tark](https://forum-cdn.knime.com/user_avatar/forum.knime.com/tark/32/79770_2.png) [@tark](https://forum.knime.com/u/tark)\
**Post date:** [June 23, 2024, 4:01pm UTC](https://forum.knime.com/t/solutions-to-just-knime-it-challenge-6-season-3/80511/17 "2024-06-23T16:01:05Z")

</div>

Hi everyone,  
Years were converted to decades using string manipulation to facilitate selection from a drop-down list. I’m not very familiar with soccer, so… the median of annual number of matches and participating countries in each tournament over the entire period were calculated to estimate their importance and scale. Total victories were calculated (1 point per win, 0.5 per draw) and displayed in a bar chart with the top three highlighted in red.

 ![image](https://forum-cdn.knime.com/uploads/default/original/3X/f/8/f8e7bd486f0b969591bd116b474b183fc0e5e305.png)

> **[JKISeason3-6\_tark – tark](https://hub.knime.com/tark/spaces/Just%20KNIME%20It/JKISeason3/JKISeason3-6_tark~zM-_dH081J6EDbaO/current-state)**
>
> Visualizing Top Football Teams in History Challenge 6 Level: Medium Description: As the 2024 European Football Championship (UEFA) unfolds, let's dive into foo…

---

<div class="post-metadata">

**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 23, 2024, 5:22pm UTC](https://forum.knime.com/t/solutions-to-just-knime-it-challenge-6-season-3/80511/18 "2024-06-23T17:22:16Z")

</div>

Hello knimers  
This is my take to the challenge. All challenge requests are addressed in the visualization dashboard.

 ![image](https://forum-cdn.knime.com/uploads/default/original/3X/d/8/d8ebc95ceb52ccfde84727ba9a35b571d5af1522.jpeg)

> **[Just KNIME It S03 \_ CH06 \_ Visualizing Top Football Teams in History –...](https://hub.knime.com/gonhaddock/spaces/Just_KNIME_It/Just%20KNIME%20It%20S03%20_%20CH06%20_%20Visualizing%20Top%20Football%20Teams%20in%20History~crv-YDQgAq3EboK0/current-state)**
>
> As the 2024 European Football Championship (UEFA) unfolds, let's dive into football history with a data challenge. Today you are asked to create a data app tha…

Keep it coding 🖖🏽

---

<div class="post-metadata">

**Author:** ![tomljh](https://forum-cdn.knime.com/user_avatar/forum.knime.com/tomljh/32/67732_2.png) [@tomljh](https://forum.knime.com/u/tomljh)\
**Post date:** [June 24, 2024, 5:25am UTC](https://forum.knime.com/t/solutions-to-just-knime-it-challenge-6-season-3/80511/19 "2024-06-24T05:25:16Z")

</div>

I have implemented another version using the Elo algorithm.

This algorithm is a simplified version of FIFA’s “SUM” algorithm, equivalent to an Elo like algorithm.Mainly simplified the setting of K value (I value), without taking different K values according to the competition category, but unifying them into one K value.

FIFA “SUM” algorithm:

> **[edbm045h0udbwkqew35a-pdf.pdf](https://digitalhub.fifa.com/m/f99da4f73212220/original/edbm045h0udbwkqew35a-pdf.pdf)**

The workflow implementation referred to @ Dennis Ganzaroli’s article:

> **[K-AI powered Python Code Generation in KNIME and the evaluation of Sports...](https://medium.com/low-code-for-advanced-data-science/k-ai-powered-python-code-generation-in-knime-and-the-evaluation-of-sports-scoring-systems-76de7399409f)**
>
> Evaluate different Sports Rating Systems like Elo Rating and TrueSkill with the help of K-AI, KNIME’s Python code generation engine

 ![001](https://forum-cdn.knime.com/uploads/default/original/3X/6/f/6ffd23935d0acf8a77fcc15347c3d0c3f81fe280.png)

> **[JKISeason3-6\_tomljh-v2-Elo algorithm – tomljh](https://hub.knime.com/tomljh/spaces/Public/JKISeason3/JKISeason3-6_tomljh-v2-Elo%20algorithm~hxj6ApdT0KXsbcSW/current-state)**
>
> Visualizing Top Football Teams in History Challenge 6 Level: Medium Description: As the 2024 European Football Championship (UEFA) unfolds, let's dive into foo…

There may be differences in ranking compared to FIFA, so different K values may need to be taken based on the category of the competition. But this involves certain professional knowledge, so it has not been further refined.

---

<div class="post-metadata">

**Author:** ![skybe077](https://forum-cdn.knime.com/user_avatar/forum.knime.com/skybe077/32/12094_2.png) [@skybe077](https://forum.knime.com/u/skybe077)\
**Post date:** [June 24, 2024, 9:33am UTC](https://forum.knime.com/t/solutions-to-just-knime-it-challenge-6-season-3/80511/20 "2024-06-24T09:33:36Z")

</div>

**Approach**  
To answer the question, I needed to know what & where does a win mean? E.g. is it absolute wins or winning percentages? Do friendlies or Confederation Cups count? How about teams that win all of their very few matches?

Why not use it all? Start with dates, filter by wins and tournaments, then let the user decide if they want to get the top 3 teams by absolute wins or winning percentage.

Apart from just returning the top 3 teams, we should provide more context for each team.

1. How many wins, losses, and draws?
2. How many tournaments did they take part in?
3. What’s their best win and worst loss?
4. What’s the breakdown of their WLD?

And, how did the other teams do?

**How**

1. Build 2 datasets:  
A) Aggregated dataset of wins, losses, draws for each team and tournament for specified duration  
B) Add on features to original dataset: home, away outcomes; goal difference

2. Use dataset A to get the top 3 winners, and rest of the pack info

3. Use dataset B to get best & worst match details for each of the 3 winners

4. Display results in dashboard

**Link to Workflow**

> **[S3C6 - Visualizing Top Football Teams in History – skybe077](https://hub.knime.com/skybe077/spaces/Public/S3C6%20-%20Visualizing%20Top%20Football%20Teams%20in%20History~N6VGSY3OYNqIjYvn/current-state)**
>
> Visualizing Top Football Teams in History Level: Medium As the 2024 European Football Championship (UEFA) unfolds, let's dive into football history with a data…

**tada???**  
**Dashboard of top 3 teams & miscellanea**

 ![data_app](https://forum-cdn.knime.com/uploads/default/original/3X/8/3/83bba69b464fcf6b729d3f87d3a846a0369d7c54.jpeg)

**Main workflow**

 ![Slide2](https://forum-cdn.knime.com/uploads/default/original/3X/8/e/8e387ccba13f8423274a5ee6bad6309ab4f71e07.jpeg)  
**The actual Data App**  
 ![Slide3](https://forum-cdn.knime.com/uploads/default/original/3X/0/8/08e811ee0ae8f4f0309bfc589011c8bb793d14eb.jpeg)

[Next page](https://forum.knime.com/t/solutions-to-just-knime-it-challenge-6-season-3/80511.md?page=2)
