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:

screen shot

And tell it what dimensions to merge on:

screen shot

Name your newly merged dimension and give it a description:

screen shot

 

Click “OK”, and “OK” again to save it.

Use that new merged dimension in a new report:

screen shot

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:

screen shot

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).