JKISeason2-10_​tark

0 ×

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

Challenge 10: Calculating YTD and MTD for Restaurant Yummy
Level : Easy

Description: 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.

Nodes

• Column Rename3 ×
• Column Rename (Regex)2 ×
• Joiner2 ×
• Moving Aggregation2 ×
• Pivoting2 ×
• Show all 11 nodes

Extensions

• FeatureKNIME Base nodes
• FeatureKNIME Excel Support
• FeatureKNIME Javasnippet
• FeatureKNIME Timeseries nodes

Links

• Just Knime it

  www.knime.com/just-knime-it