Icon

04_​Explore_​Sunburst_​and_​Stacked_​Area_​Chart

Explore Sunburst and Stacked Area Chart

This Workflow demonstrates the usage of the Sunburst Chart, which is used to visualize data when the data has some level of hierarchy. In this Workflow, the Sunburst Chart displays the Sales of the Company across Products and Markets.

Additionally, a Stacked Area Chart is used to display the Composition of Sales across Products during various dates.

If you want to give your acquired knowledge a test run, take a look at the Just KNIME It challenges. (Just KNIME It Link provided in External resources section of this workflow)

Visualize Sales across Products and MarketsStep 1: Connect the Input Data(which has some level ofhierarchy) to Data Input port of "Sunburst Chart".Step 2: Double click on the node to open dialog box. Selectthe category columns that denote hierarchy. In this case it is "Product" and "Market". In the "Value Column", select"Sales_(in Thousands)" Step 3: Select “OK” and close the dialog box, now right-clickon the node and select on "Execute and Open View" Visualize Overall Sales as Composition ofProduct SalesStep 1: Connect the Input Data to Data Input Port of the"Stacked Area Chart". Step 2: Double click on the node to open dialog box. Selectthe "Date" column for the option "Choose column for x-axis".In the Column selection panel, select the columns "ProductA" and "Product B".Step3: Select “OK” and close the dialog box, now right clickon the node and select on "Execute and Open View" Visualize the distributionof salesVisualize Sales as compositionof Product Sales across DatesSales Tableacross Product and MarketsGroup ByProduct and Marketto summarize salesSummarize Sales acrossMonths and ProductsConvert Salesvalue to ThousandsCovert to date Format Sunburst Chart Stacked Area Chart Table Creator GroupBy Pivoting Math Formula String to Date&Time Visualize Sales across Products and MarketsStep 1: Connect the Input Data(which has some level ofhierarchy) to Data Input port of "Sunburst Chart".Step 2: Double click on the node to open dialog box. Selectthe category columns that denote hierarchy. In this case it is "Product" and "Market". In the "Value Column", select"Sales_(in Thousands)" Step 3: Select “OK” and close the dialog box, now right-clickon the node and select on "Execute and Open View" Visualize Overall Sales as Composition ofProduct SalesStep 1: Connect the Input Data to Data Input Port of the"Stacked Area Chart". Step 2: Double click on the node to open dialog box. Selectthe "Date" column for the option "Choose column for x-axis".In the Column selection panel, select the columns "ProductA" and "Product B".Step3: Select “OK” and close the dialog box, now right clickon the node and select on "Execute and Open View" Visualize the distributionof salesVisualize Sales as compositionof Product Sales across DatesSales Tableacross Product and MarketsGroup ByProduct and Marketto summarize salesSummarize Sales acrossMonths and ProductsConvert Salesvalue to ThousandsCovert to date Format Sunburst Chart Stacked Area Chart Table Creator GroupBy Pivoting Math Formula String to Date&Time

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: mpatt
Created at: 2022-03-25
On NodePit since: 2024-01-04
Last update: 2024-05-03
Created with KNIME version: v4.5.2
Tags: Sunburst ChartStacked Area ChartMath FormulaGroupByPivotingBeginnerBeginner Cheat SheetBeginners Space

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

Try NodePit Runner!