Using ADF DVT Bubble Chart to display the number of goals per match per city at the World Cup Football 2014

0
Share this on .. Tweet about this on TwitterShare on LinkedIn0Share on Facebook0Share on Google+0Email this to someoneShare on Tumblr0Buffer this page

The final result – which is obtained in an incredibly easy manner – is shown in the next figure:

image

The bubble chart shows bubbles per match. The X and Y coordinate of the match-bubble are taken as longitude and lattitude. That means, the bubbles are roughly laid out in the chart in the same way as the cities are laid out on a map (and indeed in the real world). The size of each bubble corresponds with the total number of goals scored in the match. The smallest bubble corresponds to a 0-0, the largest represents 6 goals in the Spain vs Netherlands match in Salvador. The color indicates the group – with red (and circles) for Group A and lighter blue (or is that lavender?) and diamonds for group B. Dark blue squares is group C.

I was looking for a correlation between the lattitude (south to north position) and the number of goals scored – but so far that correlation is not found.

In this example, I am using the queries and data from some of my previous World Cup related articles – such as https://technology.amis.nl/2014/06/24/sql-challenge-drilling-down-into-world-cup-football-tag-cloud/.

Using the query that lists all matches – with some small changes to return the longitude and lattitude as negative values which creates a more recognizable representations – I have created a read only View Object

image

and added it to a default Application Module. This results in a Data Control with Collection.

image

To create the page with bubble chart, I created a new Page and drag the MatchResultsVw collection to the page. Drop as Chart, select BubbleChart and configure like this:

image

Then close the wizard and run the page. It is literally all it takes.

 

 

Resources:

Frank Houweling’s fine explanation of Bubble Charts: https://technology.amis.nl/2013/03/13/adf-dvt-speed-date-interactive-bubble-graph/

Share this on .. Tweet about this on TwitterShare on LinkedIn0Share on Facebook0Share on Google+0Email this to someoneShare on Tumblr0Buffer this page

About Author

Lucas Jellema, active in IT (and with Oracle) since 1994. Oracle ACE Director and Oracle Developer Champion. Solution architect and developer on diverse areas including SQL, JavaScript, Docker, Machine Learning, Java, SOA and microservices, events in various shapes and forms and many other things. Author of the Oracle Press books: Oracle SOA Suite 11g Handbook and Oracle SOA Suite 12c Handbook. Frequent presenter on community events and conferences such as JavaOne, Oracle Code and Oracle OpenWorld.

Leave a Reply