How can I merge on shared dimensions in a report with with multiple queries?
Once you have more than one query, using Add Query in the Edit Query mode, you need to merge the shared dimensions (or make sure it’s merging on the ones you want).
To do that, click on the Merge Dimensions tool:
And tell it what dimensions to merge on:
Name your newly merged dimension and give it a description:
Click “OK”, and “OK” again to save it.
Use that new merged dimension in a new report:
You can bring in measures or details into the new report. But if you try to bring in other non-merged dimensions to this new report, you’ll have problems. Instead, make a variable – in this case we made a detail objects associated with the Pennid:
And you can use that new variable in your new report (in this case the variable is named “app status as a detail”, but you can call it whatever you want).