Amount mismatch issue seen between Quicksight and Snowflake though similar logic used in both. The reason behind this problem might be the time zone . Please give the appropriate solution for this issue. Please find the attached snapshot for more detail

We don’t have access to your data.

I would suggest trying out the timezone difference. You can do this by addDatetime in a calculated field or changing your date in sql to take into the timezone affect.

Here is documentation if you want to add / subtract hours to your date field in quicksight.

1 Like

@rajesh - Can you also check the timezone where your Snowflake and QuickSight hosted, both the systems are SaaS( Software as a Service).

Regards - Sanjeeb