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

Question & Answer
, , ,
1

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?

2

No you would need to join them together.

Can you do any of this in sql?

3

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

4

Hello, any chance there is an alternate solution?

5

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