Percentages in rows instead of columns? | Community
Skip to main content
N
nish_bandara
October 24, 2016
Solved

Percentages in rows instead of columns?

  • October 24, 2016
  • 5 replies
  • 5038 views

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.
Best answer by mohan_dorairaj

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

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

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.

    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.

    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

      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

      Terms & ConditionsAccessibility statement

      Loading footer...