Icon

JKISeason2-3_​tark

JKISeason2-3
https://www.knime.com/just-knime-it

Challenge 03: Comparing Monthly Sales
Level: Medium

Description: The sales manager at ABC Grocery Stores is looking for a way to compare the number of sales of a selected month with those of a prior month. You are tasked to create a component in KNIME which carries out this task, with a visualization tackling the comparisons. If there are no prior months then only data for the selected month should be shown. If a prior month can be picked for comparison, it should not be more than 12 months before the selected month.

Author: Ali Marvi

Dataset: Monthly Sales Data on KNIME Community Hub

Create a variable for a month of your choice. Create a range for selecting a previous month. #Create a variable for a previous monthof your choice.#Create a reference for row filter. Component Expand the component Node 16Add ascending-order numberto a new columnNode 19create possible value listand default valuefor single selection widgetNode 21Node 23Node 24Node 26Node 29Node 30create possible value listand default valuefor single selection widgetNode 32Node 34Node 35Node 36Node 37Node 39Node 42Excel Reader String Manipulation Single SelectionWidget GroupBy Table Rowto Variable Row Filter Math Formula Table Rowto Variable Numeric RowSplitter Single SelectionWidget GroupBy Table Rowto Variable Variable toTable Row Transpose ReferenceRow Filter Bar Chart Date&Time to String Component Excel Reader Create a variable for a month of your choice. Create a range for selecting a previous month. #Create a variable for a previous monthof your choice.#Create a reference for row filter. Component Expand the component Node 16Add ascending-order numberto a new columnNode 19create possible value listand default valuefor single selection widgetNode 21Node 23Node 24Node 26Node 29Node 30create possible value listand default valuefor single selection widgetNode 32Node 34Node 35Node 36Node 37Node 39Node 42Excel Reader String Manipulation Single SelectionWidget GroupBy Table Rowto Variable Row Filter Math Formula Table Rowto Variable Numeric RowSplitter Single SelectionWidget GroupBy Table Rowto Variable Variable toTable Row Transpose ReferenceRow Filter Bar Chart Date&Time to String Component Excel 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: seavi
Created at: 2023-05-27
On NodePit since: 2023-06-03
Last update: 2024-05-01
Created with KNIME version: v4.6.0
Tags: Just Knime itJKISeason2-3

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

Try NodePit Runner!