Icon

02.1_​Line_​Plot_​Solution

This workflow shows how to build a line plot that compares categories by separate lines

Session 2Exercise 1 - Plot multiple lines in a line plotSummary:Use a line plot to visualize total sales per product category and monthInstructions:1) Execute the CSV Reader node to load the sales data2) Use a Date&Time to String node to extract the month from the Order Datecolumn by reformatting them to yyyy-MM-01 3) Use a String to Date&Time and convert the reformatted dates 4) Pivot the data table and apply aggregation to find the sum of monthlysales per product category5) Use a Line Plot (Plotly) node to visualize your result Data loading Reformatting the order date columnand storing them into a separatecolumn Convert the Reformatted dates todate&time Pivoting and Aggregation Visualize your results using a line plot Total sales per category and monthSales Data Pivoting Line Plot (Plotly) Date&Time to String String to Date&Time CSV Reader Session 2Exercise 1 - Plot multiple lines in a line plotSummary:Use a line plot to visualize total sales per product category and monthInstructions:1) Execute the CSV Reader node to load the sales data2) Use a Date&Time to String node to extract the month from the Order Datecolumn by reformatting them to yyyy-MM-01 3) Use a String to Date&Time and convert the reformatted dates 4) Pivot the data table and apply aggregation to find the sum of monthlysales per product category5) Use a Line Plot (Plotly) node to visualize your result Data loading Reformatting the order date columnand storing them into a separatecolumn Convert the Reformatted dates todate&time Pivoting and Aggregation Visualize your results using a line plot Total sales per category and monthSales DataPivoting Line Plot (Plotly) Date&Time to String String to Date&Time CSV Reader

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!