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?
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