I am currently using merged queries to calculate % change of media spend between two time periods. I use 2 dimensions, channel and platform, to see spend at a more granular level. The primary merged query shows data from the past 7 days, while the comparison period shows data from the last 14 days. Using this information I made % change calculated fields for spend. I want the spend and other metrics to be able to roll up into channel and platform like normal visuals do when the sub-totals option is checked. With my current merged query, the sub-totals option is no longer available. Is there a way to nest the rows based on the different dimensions for merged queries?
Nesting rows in merged query visuals
This topic has been closed for comments
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.