I just figured out that Quicksight applies, by default, aggregated data (distinct) to a simple table chart. How could I simply list data as it is, in a table chart, without any aggregation? In this case, I don’t want to present any metrics, so I just want to list data from a specific table without having to add it’s PK, but if I don’t add it’s PK, quicksight automatically applies aggregation for the chosen dimensions. I understand that Table chart’s dimensions are set in a “group by” section, but actually I don’t want to group by anything since I don’t have any metrics in this simple table chart, similar to an excel sheet.
Helo Gabriel,
First of all Welcome to the QuickSight Community.
If you’re currently seeing aggregated data in your table, it’s because QuickSight automatically applies aggregation functions (like count, sum, etc.) when fields are placed in the “Group by” field well.
To create a simple table that just lists your data as is, without requiring you to add a primary key, follow these steps:
- Open Amazon QuickSight and navigate to your analysis
- Choose “Insert” from the file menu and then “Add Visual”
- Select the table icon from Visual types
- Add the fields you want to display to the “Value” field well only
This method allows you to view your raw data without any grouping or aggregation, even if you don’t include the primary key field.
Hope this helps.
Cheers,
Deep