Displaying unaggregated numeric values in QuickSight tables from Athena parquet data

Question & Answer
,
1

Hello, I’m working with Athena Parquet data in QuickSight and facing challenges in displaying numeric values (like order_price , order_quantity ) directly in table visualizations without applying any aggregation (e.g., SUM, COUNT).

I’ve already transformed my data into SPICE using custom SQL, but QuickSight seems to only offer aggregated views for numeric fields. My goal is to create a dashboard that allows users to view e-commerce order details in a table format, with the ability to filter by date, among other identifiers, and download this information as a CSV file.

Is there a way to display these numeric values as they are in the original dataset without aggregation?

2

Hi @9haeng
the reason is as soon as you left one dimension field out of the visual QS is aggregating.

You could bring all dimensions into the table and hide all columns you dont want to see.

grafik
grafik1163×352 55.2 KB

BR

1 Like
3

Hi @ErikG!

Thanks for the best response. Your reply was so much helpful and directly addressed the challenge I was facing in QuickSight.
I’m now able to create a more effective and user-friendly dashboard that meets our project’s needs.

Best regards.

2 Likes
4

Thanks @9haeng for letting us know! :slight_smile: @ErikG – thank you for sharing your incredible expertise!