Icon

JKISeason2-10

Challenge 10: Calculating YTD and MTD for Restaurant Yummy

Challenge 10: Calculating YTD and MTD for Restaurant YummyLevel : EasyDescription: Restaurant Yummy records its sales values on a daily basis. The data contains two columns: Date andSales. Year-to-Date (YTD) Sales and Month-to-Date (MTD) Sales are important metrics to track the revenue of thebusiness. But what exactly are YTD and MTD values? The YTD value allows you to calculate the metric (e.g., sum ofsales) for the current year, while the MTD value denotes a metric value for the current month. You are asked to build aKNIME Workflow that takes this data as input and adds YTD and MTD values across each record. Sales Data.xlsxmonth yearyearmonth Excel Reader String to Date&Time Extract Date&TimeFields GroupBy GroupBy Visuals Challenge 10: Calculating YTD and MTD for Restaurant YummyLevel : EasyDescription: Restaurant Yummy records its sales values on a daily basis. The data contains two columns: Date andSales. Year-to-Date (YTD) Sales and Month-to-Date (MTD) Sales are important metrics to track the revenue of thebusiness. But what exactly are YTD and MTD values? The YTD value allows you to calculate the metric (e.g., sum ofsales) for the current year, while the MTD value denotes a metric value for the current month. You are asked to build aKNIME Workflow that takes this data as input and adds YTD and MTD values across each record. Sales Data.xlsxmonth yearyearmonth Excel Reader String to Date&Time Extract Date&TimeFields GroupBy GroupBy Visuals

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: yilmaer
Created at: 2023-06-01
On NodePit since: 2023-06-01
Last update: 2024-05-01
Created with KNIME version: v4.7.2
Tags: JKISeason2-10

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

Try NodePit Runner!