'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:
- sales: sale_amount, sale_date
- 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?
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|
