I have loaded the data from redshift to Quick Sight using Redshift connector
There is no data discrepancy when compared to redshift and dashboard for any columns
But when we export a csv file one of the fields in pivot table called clicks is facing data discrepancy as it is displaying 5 additional values when compared to dashboard
I have disabled the filters and checked as well and
here is the image of data displaying in dashboard
in dashboard its not displaying as 55
55 is for date sept 29th
when date is filtered from 7th sept to 30th september clicks display 50
but when date is filtered from 8th sept to 30th september clicks display 55
Are you still running into this problem or have you found a solution? If you found a solution could you post it to help the community?
To be sure, do you have any other controls or filters active on this sheet or elsewhere in the analysis that any fields on this visual is affected by? For example, it looks like most of the fields in this visual are calculated fields on the analysis level. Do any of them contain parameters that are not present on this sheet? If so, I would make sure that they are not causing changes in the data on the visual.
