Icon

20230531 Pikairos JustKNIMEIt Season 2 Challenge 10 Calculating YTD and MTD for Restaurant Yummy

Restaurant Yummy records its sales values on a daily basis. The data contains two columns: Date and Sales. Year-to-Date (YTD) Sales and Month-to-Date (MTD) Sales are important metrics to track the revenue of the business. But what exactly are YTD and MTD values? The YTD value allows you to calculate the metric (e.g., sum of sales) for the current year, while the MTD value denotes a metric value for the current month. You are asked to build a KNIME Workflow that takes this data as input and adds YTD and MTD values across each record.

Challenge 10: Calculating YTD and MTD for Restaurant YummyDescription: Restaurant Yummy records its sales values on a daily basis. The data contains two columns: Date and Sales.Year-to-Date (YTD) Sales and Month-to-Date (MTD) Sales are important metrics to track the revenue of the business. Butwhat exactly are YTD and MTD values? The YTD value allows you to calculate the metric (e.g., sum of sales) for the currentyear, while the MTD value denotes a metric value for the current month. You are asked to build a KNIME Workflow that takesthis data as input and adds YTD and MTD values across each record. Sales DataCalculate YTD Sales:CumulativeComputationSum of SalesLoop ThroughEach MonthConvert DateFrom Stringto DateFormatExtract MonthFrom DateCalculate MTD Sales:CumulativeComputationSum of SalesConcatenateData for All MonthsRename ColumnYTD SalesRename ColumnMTD SalesJoin MTD SalesData to TableView Data Excel Reader Moving Aggregation Group Loop Start String to Date&Time Extract Date&TimeFields Moving Aggregation Loop End Column Rename Column Rename Joiner InteractiveTable (local) Challenge 10: Calculating YTD and MTD for Restaurant YummyDescription: Restaurant Yummy records its sales values on a daily basis. The data contains two columns: Date and Sales.Year-to-Date (YTD) Sales and Month-to-Date (MTD) Sales are important metrics to track the revenue of the business. Butwhat exactly are YTD and MTD values? The YTD value allows you to calculate the metric (e.g., sum of sales) for the currentyear, while the MTD value denotes a metric value for the current month. You are asked to build a KNIME Workflow that takesthis data as input and adds YTD and MTD values across each record. Sales DataCalculate YTD Sales:CumulativeComputationSum of SalesLoop ThroughEach MonthConvert DateFrom Stringto DateFormatExtract MonthFrom DateCalculate MTD Sales:CumulativeComputationSum of SalesConcatenateData for All MonthsRename ColumnYTD SalesRename ColumnMTD SalesJoin MTD SalesData to TableView Data Excel Reader Moving Aggregation Group Loop Start String to Date&Time Extract Date&TimeFields Moving Aggregation Loop End Column Rename Column Rename Joiner InteractiveTable (local)

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: LAMBERT
Created at: 2023-05-31
On NodePit since: 2023-06-01
Last update: 2024-11-18
Created with KNIME version: v4.7.2
Tags: JKISeason2-10Moving AggregationGroup Loop

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

Try NodePit Runner!