I have one query that creates some results with two pivots (count of sessions) and then I create simple table calculation based on both of those values.
I have another query, which is similar just in a different vertical.
While using Merge pre-existing looks by using unique URL of look this I created the URL but I’m getting this error:
I’m actually not using the data from the pivots (I have them as Hide from visualisation) but just the table calculations. If I still add the join I’m getting something like this:
I understand that there is a Calculations button in the Merged Query window but was wondering whether support for having those table calculations in the existing looks will be added.
Moreover the biggest problem is that I need the pivots. Is there any way to be able to merge queries/looks with pivots?