I’m facing an issue specific to calculated fields when exporting visuals to CSV format in QuickSight compared to Excel. While other data seems consistent, the totals of calculated fields differ between the two platforms. I’ve meticulously checked the calculations and ensured identical inputs, yet the mismatch persists. Has anyone else encountered this discrepancy with calculated fields? Are there nuances in how QuickSight and Excel handle these calculations that could explain the inconsistency? Any guidance on resolving this discrepancy would be invaluable.
Hi @DruthyS,
Would you be able to provide an example of the inconsistency with some sample data and screenshots?
Hi @DruthyS,
I’m just checking in on this question, as we have not heard back from you. We would still like to help. If we do not hear back in the next 7 days, we will archive the question.
Many Thanks,
Andrew
When exporting the QuickSight widget to CSV format and creating a pivot table, I noticed that the average values for columns such as CPM, CPC, CTR, and CPA do not match the original values displayed in QuickSight.
Attached is the screenshots for reference.
The original CPM must be 17.21 but getting 167.32
Hi @DruthyS,
If the average is wrong, then the individual values must also be wrong. I would focus on figuring out why the individual values are wrong first. What visual type are you exporting? You created a pivot table in Excel but is your visual in QuickSight also a pivot table? How is CPM calculated? Is it an aggregated value?
Without seeing your raw data, my guess would be that the issue has to do with how you’re aggregating your values in QuickSight. Are you using Excel to create a pivot table based on your raw data or based on data that has already been aggregated in QuickSight?
For example, the average of the numbers below is 55.
However, if you aggregate by product first, and then take the average, you’ll get a different value - 73.3 instead of 55.
