Percentages in rows instead of columns?

Avatar

Avatar

nish_bandara

Avatar

nish_bandara

nish_bandara

23-10-2016

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.

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar

mohan_dorairaj

Avatar

mohan_dorairaj

mohan_dorairaj

09-11-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-Works...

Please upvote if you find it as a useful feature

Answers (4)

Answers (4)

Avatar

Avatar

markus_barmettl

Avatar

markus_barmettl

markus_barmettl

06-03-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

Avatar

Avatar

TanmayMathur

Employee

Total Posts

1.2K

Likes

241

Correct Answer

421

Avatar

TanmayMathur

Employee

Total Posts

1.2K

Likes

241

Correct Answer

421
TanmayMathur
Employee

24-10-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.

Avatar

Avatar

KristiB1

Avatar

KristiB1

KristiB1

24-10-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.

Avatar

Avatar

TanmayMathur

Employee

Total Posts

1.2K

Likes

241

Correct Answer

421

Avatar

TanmayMathur

Employee

Total Posts

1.2K

Likes

241

Correct Answer

421
TanmayMathur
Employee

24-10-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