CODEWITHSUNDEEP
amazon-web-servicesamazon-quicksight
Valip
Valip

Reputation: 4650

AWS QuickSight how to combine fields from multiple datasets

Is it possible to use columns from different datasets when defining a calculated field?
Something like this: sum({sales.refund_amount})+sum({refunds.refund_amount})

For example, I have two datasets, each with an amount and date columns:

  1. sales: sale_amount, sale_date
  2. refunds: refund_amount, refund_date

My goal is to create a visual which sums the sales and refunds amount for the selected date range. Is there any way to do this without creating a new dataset and join the tables?

Upvotes: 1

Views: 3064

Answers (1)

ashutoshP
ashutoshP

Reputation: 36

Sadly you can't. A visual in QuickSight can use fields from only one dataset.

Upvotes: 2

Related Questions