In Zoho Analytics, there is a way to directly link a column in a table to a column in another table. I.e. the classic Product/Customer/Order would have the
id keys in each table linked with the matching column in the corresponding tables.
In visualizations, one could mix up the columns from the different tables and the JOINs would be made automatically. It’s very cool.
Is there a similar way to do this in QuickSight? Or do we have to edit or set up a new dataset for each field that needs to be joined?