Challenge 10 - Calculate YTD and MTD values

0 ×

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. You are asked to build a KNIME Workflow that takes this data as input and adds YTD and MTD values across each record.

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.

Nodes

• Column Renamer2 ×
• Column Filter1 ×
• Excel Reader1 ×
• Extract Date&Time Fields1 ×
• GroupBy1 ×
• Show all 12 nodes

Extensions

• FeatureKNIME Base nodes
• FeatureKNIME Excel Support
• FeatureKNIME JavaScript Views
• FeatureKNIME Math Expression (JEP)
• FeatureKNIME Timeseries nodes

Links

• No links available