Skip to main content
nish_bandara
October 24, 2016
Solved

Percentages in rows instead of columns?

Hi everyone,

Is it possible to get a percentage breakdown of values by row, instead by column?

I know I could just swap columns and rows, but this makes the trended graphs go wonky, and reading the data difficult.

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
mohan_dorairaj
mohan_dorairajAccepted solution
November 9, 2016

I didn't see one created so far, So created one: http://ideas.omniture.com/t5/Idea-Exchange-for-Adobe/Percentages-in-rows-instead-of-columns-in-Workspace/idi-p/15711

Please upvote if you find it as a useful feature

View in thread

5 replies

TanmayMathur
Adobe Employee
TanmayMathurAdobe Employee
Adobe Employee
October 24, 2016

Hi Nish,

Welcome to the Analytics Community!

In my knowledge there is no option of breaking down by row. It makes sense in your case as you have a single metric in the column (visits). But if you have more than one metric in a table (like most of workspace projects) then row-wise percentages would become invalid. One thing you can do is download it as csv and calculate the percentages in excel. 

I hope this helps.

Tanmay

Translate
KristiB1
KristiB1
Level 4
October 24, 2016

Downloading in a csv defeats the purpose of analytics workspace.  Hopefully the Adobe guys can add this is as it's a pretty straight forward feature.  I really don't know why the default is by column, most people would be doing trended tables and the % of the column is useless.

Translate
    TanmayMathur
    Adobe Employee
    TanmayMathurAdobe Employee
    Adobe Employee
    October 25, 2016

    Thanks for the insight Kristi. The best way to get it implemented would be through the Ideas Exchange - http://ideas.omniture.com 

    Create a feature request and get it upvoted by as many people you can. It will be picked up by the product managers and will be implemented.

    Translate
    mohan_dorairaj
    mohan_dorairajAccepted solution
    November 9, 2016

    I didn't see one created so far, So created one: http://ideas.omniture.com/t5/Idea-Exchange-for-Adobe/Percentages-in-rows-instead-of-columns-in-Workspace/idi-p/15711

    Please upvote if you find it as a useful feature

    Translate
      markus_barmettl
      markus_barmettl
      March 7, 2018

      The above link is not working. However I found this Add Comparison Type: % of row (In Discover) in the ideas section which goes into the same direction and voted for it. This is a much required feature in our company. We almost daily face this restriction in our analysis

      Translate
      Terms & ConditionsAccessibility statement

      Loading footer...