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
Bedrock Mission!

Learn more

View all

Sign in to view all badges

Let me copy dimension values only in Analysis Workspace tables

Avatar

Avatar
Give Back
Level 5
dreisch-wiley
Level 5

Likes

101 likes

Total Posts

61 posts

Correct reply

1 solution
Top badges earned
Give Back
Boost 50
Boost 5
Boost 3
Boost 25
View profile

Avatar
Give Back
Level 5
dreisch-wiley
Level 5

Likes

101 likes

Total Posts

61 posts

Correct reply

1 solution
Top badges earned
Give Back
Boost 50
Boost 5
Boost 3
Boost 25
View profile
dreisch-wiley
Level 5

19-03-2019

When I'm running a report in Analysis Workspace (dimensions as rows and metrics as columns), is it possible to copy ONLY the dimension of a table, and not the entire row? It seems I can select individual metric values, but not individual dimension values.

I'm constantly having to delete the tab and metric values when pasting into other contexts. For example:

  • Copying URLs into the browser's address bar - I always end up pulling the trigger before "cleaning up" my paste and generating 404s this way
  • Copying campaign IDs and pasting into a third party tool
  • Copying individual values and pasting into a dimension filter to narrow in on some data

..and so on. I don't JUST copy to paste into Excel, since I do a lot of integration work, investigation into outlier data, and bespoke analysis.

2 Comments

Avatar

Avatar
Give Back 10
Employee
Brian_Kent_Watson
Employee

Likes

19 likes

Total Posts

44 posts

Correct reply

13 solutions
Top badges earned
Give Back 10
Give Back 5
Give Back 3
Give Back
Boost 5
View profile

Avatar
Give Back 10
Employee
Brian_Kent_Watson
Employee

Likes

19 likes

Total Posts

44 posts

Correct reply

13 solutions
Top badges earned
Give Back 10
Give Back 5
Give Back 3
Give Back
Boost 5
View profile
Brian_Kent_Watson
Employee

20-03-2019

I was able to select just dimension values by clicking the dimension column header then shift-clicking in the dimension list. It selected only the column of dimension values and I could copy it to clipboard.  For example:

DimensionColumn.png

Is that what you're looking for?

Avatar

Avatar
Give Back
Level 5
dreisch-wiley
Level 5

Likes

101 likes

Total Posts

61 posts

Correct reply

1 solution
Top badges earned
Give Back
Boost 50
Boost 5
Boost 3
Boost 25
View profile

Avatar
Give Back
Level 5
dreisch-wiley
Level 5

Likes

101 likes

Total Posts

61 posts

Correct reply

1 solution
Top badges earned
Give Back
Boost 50
Boost 5
Boost 3
Boost 25
View profile
dreisch-wiley
Level 5

20-03-2019

Thanks - I tried that and see now, and that definitely wasn't obvious. But it's not exactly what I'm looking for. For one, it doesn't support ctrl-select to narrow in on a single row. But more importantly, it keeps the dimension heading selected, which means there's still "junk" to delete when I'm just trying to select a single value.

I realize this conflicts somewhat with overlapping functionality: selecting rows for focusing visualizations, and quickly selecting rows by their dimensional label. But if there were some keyboard shortcut (maybe ctrl-click for initial selection) to narrow in on a single cell, that would be killer.