How to add additional dimensions to a report in bulk using Ad Hoc

Avatar

Avatar

kateyt59506756

Avatar

kateyt59506756

kateyt59506756

21-08-2017

I have a report in ad-hoc that is pageviews by page name. I know I can drag another dimension (say Language) and drop it on the page name, so I can see the page name, broken down by language. What I can't seem to figure out is how to do a bulk drag and drop - that is, have the "Language" variable be applied to every page name. Right now I can only drag and drop one by one - there has to be an easier way.

Thanks everyone.

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar

Gigazelle

Employee

Total Posts

1.9K

Likes

458

Correct Answer

734

Avatar

Gigazelle

Employee

Total Posts

1.9K

Likes

458

Correct Answer

734
Gigazelle
Employee

24-08-2017

Using the Table Builder allows you to create a report that automatically breaks down every line item.

Answers (4)

Answers (4)

Avatar

Avatar

ursboller

MVP

Total Posts

1.0K

Likes

484

Correct Answer

250

Avatar

ursboller

MVP

Total Posts

1.0K

Likes

484

Correct Answer

250
ursboller
MVP

21-08-2017

and here is a video that might help you:

Dimensions in Analysis Workspace - YouTube

Avatar

Avatar

ursboller

MVP

Total Posts

1.0K

Likes

484

Correct Answer

250

Avatar

ursboller

MVP

Total Posts

1.0K

Likes

484

Correct Answer

250
ursboller
MVP

21-08-2017

have you selected more than one row (blue shadow on the selected rows) and did you drop the metric on one of them? or did you try with another browser? i have no problems with chrome ...

Avatar

Avatar

kateyt59506756

Avatar

kateyt59506756

kateyt59506756

21-08-2017

Thanks for your answer, however I tried doing this and the secondary dimension only gets attributed to the line item where it was dropped.

Avatar

Avatar

ursboller

MVP

Total Posts

1.0K

Likes

484

Correct Answer

250

Avatar

ursboller

MVP

Total Posts

1.0K

Likes

484

Correct Answer

250
ursboller
MVP

21-08-2017

select all items (shift or ctrl + click) which you want to break down (blue marked) and drop the desired metric on on of the marked items ...