跳到主要内容

🥷 [S2] Challenge 10

· 阅读需 1 分钟

Just KNIME It, Season 2 / Challenge 10 reference

Challenge 10: Calculating YTD and MTD for Restaurant Yummy​

挑战 10:计算 Restaurant Yummy 的 YTD 和 MTD 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.

描述:Restaurant Yummy 每天记录其销售额。数据包含两列:日期和销售额。年初至今 (YTD) 销售额和月初至今 (MTD) 销售额是跟踪业务收入的重要指标。但 YTD 和 MTD 值到底是多少? YTD 值允许您计算当年的指标(例如,销售额总和),而 MTD 值表示当月的指标值。您需要构建一个 KNIME 工作流,将此数据作为输入并在每条记录中添加 YTD 和 MTD 值。

Author: Mahantesh Pattadkal 添加一名作者

Dataset: Sales Data in the KNIME Hub

any thoughts?​

No, it is a simple challenge.