Challenge 26: Calculating Sales Performance
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.
|Month||Percentage_Sales_Product A||Percentage_Sales_Product B|
Author: Sanket Joshi
Dataset: Sales Data in the KNIME Hub
- 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.