Sum Values - calculation field problem

Hi all, I’m facing some calculation problems in Quicksight.

Here is an example:
in my original data, the sum of Misscans on week 13 is 63, and if I use the sum of Misscans in my dashboard in Quicksight, I will get different and larger data:

How can I just calculate the sum of misscans of specific week? Is there any solution to solve this problem?

Thanks in advance!


Add week column in group value.

Naveed Ali

Hi @Naveed , thanks for your answer! if i understand correctly, I have already added Week column and doesn’t work.