AWS QuickSight how to combine fields from multiple datasets

Question

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?

Answer 1

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