Let's plot in KNIME
1. Let's plot in KNIME
KNIME Analytics Platform offers a variety of nodes to perform data visualization. You can find them in the Nodes menu, under the category “Views”. Let’s use one of them to visualize the data. In this example, you have a table containing the hours worked by each department for each month and the relative expenses. To understand the expenses across different departments, you can create a pie chart. Let’s add the node and have a look at its configuration window. A pie chart shows the proportions of components that make up a whole. In this case, you want to know how much did every department spend. Thus, the category dimension is Department and the Frequency dimension is Expenses. However, this configuration will show one slice of the pie for each row of the data table. To aggregate rows of the same department into the same slice, you need to select a different aggregation operation. Select Sum. Now you can see that the Engineering department has the highest share of expenses. In the same way, you can calculate the average hours or just show the occurrence count of each category element. Have a look at the other options available in the configuration window of the Pie Chart node. You can give the chart a title and resize it. By clicking the checkbox, you can even put a hole in it and make it a donut chart. Below are also the options to sort the categories and set the labels. If you want to select the color of the slices, you can use the Color Manager node. Add it before the Pie Chart node. In its configuration, select the category that you want to color, and assign a color to each value. The colors are appended to each row in the table and will be automatically picked up by the Pie Chart when creating the visualization. That was easy, right? Continue the course to discover the other plots that you can create in KNIME.2. Let's practice!
Create Your Free Account
or
By continuing, you accept our Terms of Use, our Privacy Policy and that your data is stored in the USA.