Icon

02.1_​Line_​Plot_​Exercise

02.1_Line_Plot_Exercise
Data loading 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 Reformatting the order datecolumn and storing them intoa separate column Convert the Reformatteddates to date&time Pivoting and Aggregation Visualize your results using aline plot Sales Data CSV Reader Data loading 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 Reformatting the order datecolumn and storing them intoa separate column Convert the Reformatteddates to date&time Pivoting and Aggregation Visualize your results using aline plot Sales Data 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: 2022-11-12
Last update: 2024-05-05
Created with KNIME version: v4.6.1
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!