A new Wednesday starts, and here we come with a new Just KNIME It! challenge.
CO2 emissions are rising and compromising our environment. This week, let’s build a low-code report that tells us which regions of the globe and what sources are producing the most emissions.
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 JKISeason3-2.
Need help with tags? To add tag JKISeason3-2 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!
Just to add a bit of clarity to the data set. The columns cement, coal, flaring, gas, oil and other represent the individual contributions to the CO2 column. I reordered the columns and added a SUM for visibility as data, just by how it’s organized, also has context.
Thank you for your contribution. Additionally, please consider the following important points:
The unit for CO₂ emissions is million metric tons.
The column labeled “CO₂ per capita” actually represents CO₂ emissions per million people. This was determined by dividing the total CO₂ emissions by the values in the “CO₂ per capita” column and comparing the results with population data available online.
Here’s my solution. In interest of full disclosure I used some parts of a workflow which was uploaded several years ago. I created a dynamic Single Selection widget so if the user changes the size of the input set it automatically is reflected in the widget list.
In this solution, I decided to split the report into two parts:
View Report Year-wise:
This section provides an overview of the performance of all countries based on the year selected by the user.
View Report Country-wise:
This section details the CO2 emissions based on the user’s country selection. Additionally, it allows the user to select and compare the performance of two countries.
However I could not insert world map section to the report field. The section was generated by Generic Javascript view node using Google GeoChart… I could not find any solutions to generate a SVG image from the chart.
Rookie KNIMER on the road.
Would like to share with you all my solution for challenge 2. Open to discussion and suggestion for improvements! JustKNIMEit challenge 2 solution-Kel
I have created two types of dashboards.
The first one is designed to provide an overview of all the data.
You can drill down into specific information by using the year and region tags.
The second one is a summary of CO2 emission data for individual countries.
It includes a pie chart, CO2 emissions by fuel type, CO2 emissions per capita, and the rate of change over a year.
Amasing solutions here
My one won’t be able to compete with these I guess
Unfortunately I still haven’t figured out what kind of report I should use so I used BIRT
Here’s my solution. I wanted to illustrate how the different countries rank in CO2 emissions by source, how the different sources have grown YoY over time and how each sources share of the total CO2 has developed over time.
I have identified a bug in the previous workflow; therefore a new version of the workflow has been uploaded (v1.1.0).
Now, the pie chart created by the Python View Node can be exported to PDF.
A new Wednesday starts, and here we come with a new Just KNIME It! challenge. 
CO2 emissions are rising and compromising our environment. 
This week, let’s build a low-code report that tells us which regions of the globe and what sources are producing the most emissions.
Need help with tags? To add tag JKISeason3-2 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!
:
