python (12.9k questions)

javascript (9.2k questions)

reactjs (4.7k questions)

java (4.2k questions)

java (4.2k questions)

c# (3.5k questions)

c# (3.5k questions)

html (3.3k questions)

Questions - amazon-quicksight

How to get % of subtotal in Quicksight Pivot Table

I am creating a pivot table for leads a brokerage received in a county - I am trying to show the market share for each brokerage so I want to divide the leads a brokerage received by the total leads i...
test-img

tidy2021

amazon-web-services

pivot-table

amazon-quicksight

subtotal

Votes: 0

Answers: 1

Latest Answer

Add a calculated field called Overall Leads Percentage as follows: sum(leads) / min(sumOver(leads, [], PRE_AGG)) You can then add this calculated field to the values field well of the pivot table. Al...
test-img

darcoli

AWS QuickSight: maxOver() calculated field?

I am a stock trader who visualizes data in QuickSight. I identify the trades I want to submit to the market, sometimes for the same stock, at the same time, but in opposite directions depending on the...
test-img

Adam Weir

sql

amazon-quicksight

Votes: 0

Answers: 1

Latest Answer

Add a new calculated field called volume_direction_specifier {Volume} * 10 + ifelse({Direction}='BUY', 1, 2) This is a single number that will indicate the direction and volume. (this is needed in ...
test-img

darcoli

Filtering a column to use in a calculated field in Quicksight

I have a table like this: group value A 2 B 3 I want to create a calculated field that is the value of A divided by the value of B (2/3). In PowerBI I could create two measures storing t...
test-img

Guilherme Miranda

calculated-field

amazon-quicksight

Votes: 0

Answers: 1

Latest Answer

You could do create two sums, one for each group, and then do the final calculation Add a calculated field called Sum A sumOver(ifelse(group='A', value, null), [], PRE_AGG) Add a calculated field cal...
test-img

darcoli

Can a single visual contain fields from 2 separate datasets in Quicksight?

The example above is where I'd like to have X axis coming from dataset_1, and Value coming from dataset_2. In PowerBI and QlikSense, this is possible because 2 tables can be related via key fields wi...
test-img

Ee Ann Ng

dataset

amazon-quicksight

Votes: 0

Answers: 1

Latest Answer

In QuickSight, all visuals can only make use of a single dataset. However, if you have an author/admin account, you should be able to create a new dataset joining data coming from existing datasets se...
test-img

darcoli

Posts

Questions

Blogs

Jobs