Icon

02.2_​Bar_​Chart_​Solution

This workflow shows how to apply custom colors to a bar chart.

Session 2Exercise 2 - Apply custom colors to categories in a bar chartSummary:In this exercise, we are going to visualize the sum of sales per productcategory using a bar chart with customized colors.Instructions:1) Execute the CSV Reader node to load the sales data2) Create a duplicate category column using a String Manipulation node3) Create a pivot table that shows the sum of sales per different productcategories4) Extract the column names using the Extract Table Spec node5) Apply categorical color mapping on different product categories using aColor Manager node6) Use a Bar Chart node to visualize the results Data loading Duplicating the category column Pivoting and aggregating Extract the column names using aExtract Table Spec node Apply categorical color mappingon the column names. Visualize the results using a bar chart. Hint: Column names are the product category names. Sales DataTotal sales by categoryDuplicate category columnCustom colorsusing RGB codesSort the bars CSV Reader Pivoting Bar Chart String Manipulation Extract Table Spec Color Manager Sorter Session 2Exercise 2 - Apply custom colors to categories in a bar chartSummary:In this exercise, we are going to visualize the sum of sales per productcategory using a bar chart with customized colors.Instructions:1) Execute the CSV Reader node to load the sales data2) Create a duplicate category column using a String Manipulation node3) Create a pivot table that shows the sum of sales per different productcategories4) Extract the column names using the Extract Table Spec node5) Apply categorical color mapping on different product categories using aColor Manager node6) Use a Bar Chart node to visualize the results Data loading Duplicating the category column Pivoting and aggregating Extract the column names using aExtract Table Spec node Apply categorical color mappingon the column names. Visualize the results using a bar chart. Hint: Column names are the product category names. Sales DataTotal sales by categoryDuplicate category columnCustom colorsusing RGB codesSort the bars CSV Reader Pivoting Bar Chart String Manipulation Extract Table Spec Color Manager Sorter

Nodes

Extensions

Links

Download

To use this workflow in KNIME, download it from the below URL and open it in KNIME:

Download Workflow
Created by: ahmad.hajipour
Created at: 2022-07-04
On NodePit since: 2023-04-06
Last update: 2024-05-05
Created with KNIME version: v4.7.2
Tags: education

Deploy, schedule, execute, and monitor your KNIME workflows locally, in the cloud or on-premises – with our brand new NodePit Runner.

Try NodePit Runner!