Quicksight shows incorrect week over week % based on table calculation

Question & Answer
, , ,
1

Hi, I have a dashboard where I display period over period % (For example Week over Week %) I use quicksight’s table calculation for this purpose, I have observed that where we have 2 negative numbers the week over week % is calculated incorrectly

3

Hey!

This is a standard issue that could be addressed if you use a calculated field. The reason for the issue might be because of the negative numbers not working with percent change formulas.

Here is formatting of a calculated field that might help:

ifelse(
    {Old Value} < 0 and {New Value} < 0,
    (({New Value} - {Old Value}) / abs({Old Value})) * 100,
    (({New Value} - {Old Value}) / {Old Value}) * 100
)

The above formula uses the absolute value to account for negative numbers. Let me know if this helps if you are still running into the issue!

1 Like
4

Hi, thanks for your response, I am aware of the workaround but since I have multiple metrics for which I want to calculate period over period difference, adding a calculated field significantly slows down my dashboard.

5

Hi @Pajink,
It’s been awhile since last communication on this thread. I can mark this as a feature request to promote visibility to the support team. However, I also wanted to check if you had any additional questions?

If we do not hear back within the next 3 business days, I’ll go ahead and close out this topic.

Thank you!

6

Hi @Pajink,
Since we haven’t heard back, I’ll 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!