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?

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!