Let me copy dimension values only in Analysis Workspace tables | Community
Skip to main content
D
daniellereisch
Level 4
March 19, 2019
Delivered

Let me copy dimension values only in Analysis Workspace tables

  • March 19, 2019
  • 3 replies
  • 3704 views

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.

    3 replies

    Brian_Kent_Watson
    Adobe Employee
    Brian_Kent_WatsonAdobe Employee
    Adobe Employee
    March 20, 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:

    Is that what you're looking for?

    D
    daniellereischAuthor
    Level 4
    March 20, 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.    

    G
    GinoR1
    April 3, 2024

    Old topic, but I would love this as well. I don't think there's been any use case so far where I needed the entire row (unless it's every row, but that's a different topic).

    Terms & ConditionsAccessibility statement

    Loading footer...