Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn More

View all

Sign in to view all badges

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

Avatar

Avatar
Validate 1
Level 1
kateyt59506756
Level 1

Likes

0 likes

Total Posts

2 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
View profile

Avatar
Validate 1
Level 1
kateyt59506756
Level 1

Likes

0 likes

Total Posts

2 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
View profile
kateyt59506756
Level 1

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
Coach
Employee
Gigazelle
Employee

Likes

468 likes

Total Posts

1,947 posts

Correct Reply

739 solutions
Top badges earned
Coach
Contributor 2
Validate 1
Ignite 80
Ignite 70
View profile

Avatar
Coach
Employee
Gigazelle
Employee

Likes

468 likes

Total Posts

1,947 posts

Correct Reply

739 solutions
Top badges earned
Coach
Contributor 2
Validate 1
Ignite 80
Ignite 70
View profile
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
Coach
MVP
ursboller
MVP

Likes

517 likes

Total Posts

1,016 posts

Correct Reply

255 solutions
Top badges earned
Coach
Contributor
Bedrock
View profile

Avatar
Coach
MVP
ursboller
MVP

Likes

517 likes

Total Posts

1,016 posts

Correct Reply

255 solutions
Top badges earned
Coach
Contributor
Bedrock
View profile
ursboller
MVP

21-08-2017

and here is a video that might help you:

Dimensions in Analysis Workspace - YouTube

Avatar

Avatar
Coach
MVP
ursboller
MVP

Likes

517 likes

Total Posts

1,016 posts

Correct Reply

255 solutions
Top badges earned
Coach
Contributor
Bedrock
View profile

Avatar
Coach
MVP
ursboller
MVP

Likes

517 likes

Total Posts

1,016 posts

Correct Reply

255 solutions
Top badges earned
Coach
Contributor
Bedrock
View profile
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
Validate 1
Level 1
kateyt59506756
Level 1

Likes

0 likes

Total Posts

2 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
View profile

Avatar
Validate 1
Level 1
kateyt59506756
Level 1

Likes

0 likes

Total Posts

2 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
View profile
kateyt59506756
Level 1

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
Coach
MVP
ursboller
MVP

Likes

517 likes

Total Posts

1,016 posts

Correct Reply

255 solutions
Top badges earned
Coach
Contributor
Bedrock
View profile

Avatar
Coach
MVP
ursboller
MVP

Likes

517 likes

Total Posts

1,016 posts

Correct Reply

255 solutions
Top badges earned
Coach
Contributor
Bedrock
View profile
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 ...