View 1 - Spend Variation YTD 2021 vs 2020 RSB in M€
Spend variation in absolute value between Year Y and Year Y-1 RSB (converted with same exchange rate) available by Macro Package and Package in line, and by GBU in column
It should be looking at with ZBB filter = "Yes"
Possibilty to look at the values YTD (year-to-date), QTD (quarter-to-date) or for the month (the current one)
View 2 - Spend Variation YTD 2021 vs 2020 RSB in %
Spend variation in % between Year Y and Year Y-1 RSB (converted with same exchange rate) available by Macro Package and Package in line, and by GBU in column
It should be looking at with ZBB filter = "Yes"
Possibilty to look at the values YTD (year-to-date), QTD (quarter-to-date) or for the month (the current one)
View 3 - Speed of Spend Reduction by Macro Package of Q1 2021
Delta in MEUR = the savings of the current quarter by Macro Package
Q1 2021 vs Q1 2020 RSB = comparison with the savings done in the same quarter of the previous year RSB
Q4 2020 vs Q4 2019 RSB = comparison of the previous quarter with the savings done in the same previous quarter of the previous year RSB
Acceleration vs Q4 :
- If %(Current Quarter vs Same Quarter Y-1 RSB) > %(Previous Quarter vs Same Quarter Y-1 RSB) = Δ
- If %(Current Quarter vs Same Quarter Y-1 RSB) < %(Previous Quarter vs Same Quarter Y-1 RSB) = Δ
- If %(Current Quarter vs Same Quarter Y-1 RSB) = %(Previous Quarter vs Same Quarter Y-1 RSB) = Δ- Tolerance (-2%; 2%)
View 4 - Speed of Spend Reduction by Package of Q1 2021
Delta in MEUR = the savings of the current quarter by Package
Q1 2021 vs Q1 2020 RSB = comparison with the savings done in the same quarter of the previous year RSB
Q4 2020 vs Q4 2019 RSB = comparison of the previous quarter with the savings done in the same previous quarter of the previous year RSB
Acceleration vs Q4 :
- If %(Current Quarter vs Same Quarter Y-1 RSB) > %(Previous Quarter vs Same Quarter Y-1 RSB) = Δ
- If %(Current Quarter vs Same Quarter Y-1 RSB) < %(Previous Quarter vs Same Quarter Y-1 RSB) = Δ
- If %(Current Quarter vs Same Quarter Y-1 RSB) = %(Previous Quarter vs Same Quarter Y-1 RSB) = Δ- Tolerance (-2%; 2%)
A. Need Help?
If you click on the “Need Help” button, you will be directed to freshdesk platform to open a ticket. Don't hesitate to use it, should you require assistance or should you wish to report an issue such as some inaccuracies in the data.
B. Documentation
From Qlik Sense dashboard, you can access directly to this wiki
