Show Data as it is without Group By

Question & Answer
, , , , , ,
1

Hi Community,
thank you in advance for any suggestion.

As my requirement is to show the data as it is without any group by even if the rows are are duplicated then show the rows as it is please refer the below screenshot mentioned.

image
image593×301 23.2 KB

Row Number 1 comes two times but still it is showing only once same with where credit is 200 as this comes 3 times but table is showing only single row,could you please help on this?

2

Hello @Arpit6075 Hope this message finds you well!

To ensure that all rows, including duplicates, are displayed, you need to check that no automatic aggregations are applied. By default, QS may aggregate data depending on the type of visualisation selected. So, my suggestions are:

  1. Choose the correct visualisation type: Use a Simple Table to display the data without aggregation.

  2. Disable automatic aggregations:

    • When creating or editing the visualisation, go to the field wells.
    • Ensure that the fields are not set to aggregate (e.g., SUM, COUNT, AVG). Instead, select “None” as the aggregation.

  3. Dataset configuration:

    • Ensure that the dataset imported into QuickSight is not configured to aggregate the data. You can check this during the dataset preparation step.

Please, let me know if one of this solutions helps you!