Table Value Inflating when Sum Aggregate is selected

Question & Answer
, , , ,
1

I’ve manually uploaded a table via csv into Quicksight from a survey engine export and am running into issues when trying to use the Sum Aggregate selection for my value field in my tables. For some reason it’s returning my numbers inconsistently altered. In one instance it magnified the correct value from 4 to 84 and another 5 to 50. Either way when I select sum from the value aggregate options, my table data changes. Any ideas on how to avoid this? Is there a different Aggregate I should be using? Should I avoid the value field designation all together? Note that I do want to get subtotals of the inputs by the organization’s leaders, but the subtotal is inflated since the field values are exponentially greater than what they should be.

2

Hello @hssoulie !

When you are adding this value field to your table visual, are you including any other fields or just this field?

I would recommend adding some kind of key field, such as UUID or other unique identifier for the rows. That should at least help narrow the issue.

1 Like
3

The other fields I have included are a unique employee identifier and the org level leader. I’m not familiar with UUIDs, do you have any resources on these?

1 Like
4

Following your guidance, I’ve also tried adding in response ID (a unique identifier that consists of 16 alphanumeric characters) and that doesn’t seem to help. Any other suggestions?

1 Like
5

Hello @hssoulie ,I’m sorry for the late reply I was OOO recently and am still catching up on old messages! Are you still running into this issue? UUID’s are unique identifiers like the id’s that you added in your table.

Is there any way that you could share an anonymized view of the issue that you are having like a screenshot of your table where the sum is incorrect?

For the issue of the field well aggregate, you could try using LAC-W functions

6

Hello @hssoulie, since no follow-up information was provided, I am going to archive this topic. If you still need assistance with this or another issue you are facing in QuickSight, feel free to post a new topic to the community. That way you will be at the top of the priority listing for a response from one of our QuickSight experts. Thank you!