How to apply pivot in merge query dimensions
I don’t think pivots work in merge queries. When I first tried, Looker said that the pivoted query must not be the primary query in the merge. But even when I made the pivoted query the 2nd query, the measure that’s supposed to be pivoted ends up showing up as a single column with null values.