Nesting rows in merged query visuals

  • 26 July 2021
  • 0 replies

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?

This topic has been closed for comments