Is there a chance to create a calculation witout joining queries?

I have 2 SQL pulls both calculating 2 different cost numbers, for the 3rd visual I need to add both of those calculations together. When I try to join the datasets they become too big and don’t load into SQL. is there a way to have the calculation without joining the datasets?

No you would need to join them together.

Can you do any of this in sql?

In SQL it will join and produce the results without a problem, but in QS it doesnt work

Hello, any chance there is an alternate solution?

This needs to be done at the SQL level. It can’t be done in QuickSight.