Icon

JKISeason2-26_​sryu

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.

Month | Percentage_Sales_Product A | Percentage_Sales_Product B

February | 45 % | 100%

March | 78% | -87%

dataLag ALag Bskip initial incomplete rowsCalculate % for ACalculate % for BTable viewCSV Reader Lag Column Lag Column Math Formula Math Formula Component dataLag ALag Bskip initial incomplete rowsCalculate % for ACalculate % for BTable viewCSV Reader Lag Column Lag Column Math Formula Math Formula Component

Nodes

Extensions

Links