Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I want to calculate the Average growth rate of all my sales amount and the budget amount from the day the product launched.
Here is the sample data. I was able to achieve the Year of Year growth rate of each product. But I need Average growth for each product. So that I can see which product is performing better from the below plot.
Product | Launch Date | Sales Date | Sales Amount | Sales GrowthRate Year Over Year | Budge Amount | Budget GrowthRate Year Over year |
Apple | 2015 | 2015 | $ 100.00 | $ 1,000.00 | ||
Apple | 2015 | 2016 | $ 200.00 | 100% | $ 1,500.00 | 50% |
Apple | 2015 | 2017 | $ 150.00 | -25% | $ 2,500.00 | 67% |
Apple | 2015 | 2018 | $ 170.00 | 13% | $ 2,600.00 | 4% |
Apple | 2015 | 2019 | $ 210.00 | 24% | $ 7,000.00 | 169% |
Samsung | 2014 | 2014 | $ 80.00 | $ 150.00 | ||
Samsung | 2014 | 2015 | $ 110.00 | 38% | $ 300.00 | 100% |
Samsung | 2014 | 2016 | $ 150.00 | 36% | $ 350.00 | 17% |
Samsung | 2014 | 2017 | $ 130.00 | -13% | $ 380.00 | 9% |
Samsung | 2014 | 2018 | $ 120.00 | -8% | $ 400.00 | 5% |
Samsung | 2014 | 2019 | $ 200.00 | 67% | $ 450.00 | 13% |
Expected ResultSet:
Product | Average SALES GrowthRate of Each Product Since it Launched | Average Budget GrowthRate of Each Product Since it Launched |
Apple | 28% | 72% |
Samsung | 24% | 29% |
Scatter Plot :
Thanks in advance!!!
-Vidya
attached a qvf version
Thanks for your response. But I really can't use the attached file. Our firm only allows us to develop Apps in the Qliksense web version. If you don't mind can you please share the script and expression.
Thanks,
-Vidya
just add a table with
product as dimension
and mesure1==avg([Budget GrowthRate Year Over year])
and mesure2=avg([Sales GrowthRate Year Over Year])
and for the chart the same dimension and mesures
on complement add reference line and personalise axis
Thank you for your response. Your solution works only when I have Growth Rate Year over Year on Load Script level. How Can you achieve avg([Budget GrowthRate Year Over year]) and avg([Sales GrowthRate Year Over Year]) without having Growth Rate Year over Year on the script level? I can able to create a growth rate only on a measure expression.
Thanks,
-Vidya