Calculation from two unconnected tables

Hello,

I have two tables that I can’t join (i.e. I shouldn’t join them). One table contains info about parts and another one about usage. I need to calculate some KPIs based on values from both tables. Please take a look at the pictures. Is that possible?

Hi @Slavica and welcome back to the community!
Currently, it is not possible within QuickSight to build a visual off two separate datasets, to incorporate information from both of them, you would need to do some type of table join.

This is a common request in the community so I’ll mark this as a feature request to promote visibility to the support team.

Thank you

Thank you @Brett. Then, I need to think of another approach.
Regards,
Slavica