跳到主要内容

🥷 [S2] Challenge 26

· 阅读需 1 分钟

Just KNIME It, Season 2 / Challenge 26 reference

Challenge question​

Challenge 26: Calculating Sales Performance

Level: Easy

Description: You work for a company that sells two products: Product A and Product B. As a data analyst, you want to calculate how sales increased or decreased for both products over a period of 12 months, on a monthly basis. In the end, you want to have a table with columns indicating the increase/decrease percentages of sales per month, as in the example below.

MonthPercentage_Sales_Product APercentage_Sales_Product B
February45 %100%
March78%-87%

Author: Sanket Joshi

Dataset: Sales Data in the KNIME Hub

Any thoughts?​

  • I'm trying to use the KNIME AI Assistant. With the prompt "using the CSV node, I want to have a table with columns indicating the increase/decrease percentages of sales per month," it suggests a new CSV reader node and a "moving xxx" node. I realize that this AI lacks the ability to understand context. If I select certain nodes in the workflow, it starts building from those nodes onwards. The selected nodes will be its context, which I believe would be more helpful.
  • I will think about how to express this idea and then post a suggestion in the forum.