CODEWITHSUNDEEP
amazon-web-servicesamazon-quicksight
Greg
Greg

Reputation: 324

Using aggregation within a calculated field in Amazon QuickSight

I'm using Amazon QuickSight and want to create a calculated field which in Tableau would be sum([Field1])/sum([Field2]). In QuickSight, I attempted sum({Field1})/sum({Field2}) but this did not work ("We encountered an error trying to save your calculated field. Please try creating it again."). Simply doing {Field1}/{Field2} and then applying the sum aggregation in the visualization stage gives me the incorrect value.

How do I apply a SUM within a calculated field?

Upvotes: 5

Views: 15619

Answers (3)

Andrey
Andrey

Reputation: 60065

It is now possible in Amazon QuickSight. To achieve this you need to add Calculated Field to an Analysis (as described here). There are two types of calculated fields: on a data set level and on on analysis level. You can use aggregations in the analysis level calculated field.

Upvotes: 1

vilaboa
vilaboa

Reputation: 21

In the link Greg posted, Quicksight team answer last year: "Hi All, Calculated fields in analysis are available for data sets that use direct query. SPICE data set support is coming soon.".

I tested it today using spice and it work for me.

I used this formula: distinct_count(field1) / min(field2) and then i used it on a pivot table using other field to group data.

Upvotes: 1

Greg
Greg

Reputation: 324

Seems that this is currently not possible with QuickSight: https://answers.quicksight.aws.amazon.com/sn/questions/153/data-field-percent-type-how-to-summarize-it-correc.html

Upvotes: 0

Related Questions