Lets’ say, this is how my table look like
| Week | 1 | 2 | 3 | 4 | WoW bps | |
|---|---|---|---|---|---|---|
| MP | ||||||
| US | 99.96% | 99.20% | 99.76% | 99.84% | 9 bps | |
| CA | 99.94% | 99.65% | 99.24% | 99.32% | 9 bps | |
| IN | 99.50% | 99.40% | 99.50% | 99.63% | 13 bps | |
| BR | 99.81% | 99.30% | 99.50% | 99.56% | 6 bps |
My current week keeps on changing and i want to show only the difference between current week vs previous week (where the values are in %) in bps. These % values are also from a calculated field. Could you please help me create a calculated field for this?
Hi @Samridhi and welcome to the Quick Sight community!
Would you be able to share the calculated fields that are being used for your percentage values as well?
Hi Brett,
Thank you!
The percentage values are calculated as : sum(column_name)/sum(column_name)
Hi @Samridhi,
Have you explored the percentDifference function, this could be helpful for your case.
Hi @Samridhi,
Following up here as it’s been awhile since we last heard from you; did you have any additional questions regarding your initial post?
If we do not hear back within the next 3 business days, I’ll close out this topic.
Thank you!
Hi @Samridhi,
Since we haven’t heard back, I’ll go ahead and close out this topic. However, if you have any additional questions, feel free to create a new post in the community and link this discussion for relevant information if needed.
Thank you!