I have set 7 datasets which pull from an asset table and each dataset refreshes on a set day of the week, this gives me running weekly data from a table which updates daily. I need this weekly data in one graph, I have tried joining the tables together, however each table ends up with its own column instead of the assets listed as duplicates with the dataset date as the variant. Do I have any other option here?
Hi @smithaa ,
welcome to the community 
What you need is a union-option in QuickSight to union all 7 tables into one, but QuickSight does not offer it at the moment.
As you mentioned you get the 7 datasets from an asset table, could you use a custom sql to union the 7 tables into one table?
Here you can find a step-for-step instruction:
As alternative you can use Glue to union the data an write it into a single table.
In case both option do not work, maybe this blog post can be helpful:
If this helped you, please mark my answer as solution. That helpes the community to find solutions faster.
Best regards,
Nico
1 Like