Sum Values - calculation field problem

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

Here is an example:
image
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:
image
image

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

Thanks in advance!

Hi,

Add week column in group value.

regards,
Naveed Ali

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

Hi @fengjing, can you test if using the sumOver function results in the correct sum being returned?

For example, you can create the below calculated field and add it to the values field well in your visual.

sumOver
(
sum(misscans),
[Week]
)

I am marking this reply as, “Solution,” but let us know if this is not resolved. Thanks for posting your questions on the QuickSight Community Q&A Forum!