Expand my Community achievements bar.

Join us for our next community Coffee Break on February 28th! Four of our Analytics Champions will be joining us to discuss Summit tips, best practices, and any of your Analytics questions!

Percentages in rows instead of columns in Workspace

Avatar

Level 2

11/9/16

Workspace percentages are always calculated top down. It would be very helpful to have row level percentage of total.

Please refer http://help-forums.adobe.com/content/adobeforums/en/analytics-forum/analysis-workspace.top ic.html/forum__uf7y-hi_everyoneisi.html for details

6 Comments

Avatar

Level 5

11/10/16

This would be useful. I'm trying to figure out how the user of the report would know which way to read the %s though (would probably need some kind of visual clue).

Avatar

Employee

11/10/16

We believe we have a good way to solve this, using an option (so you can do row or column).  We will hopefully get to this soon, as we want to do it.

Avatar

Level 2

5/25/17

I really, really, really need this.

 

We use stacked bar charts a lot and the %s used in them make absolutely no sense, because they're the %s of the entire table, not just the row.

 

Example: If I have my rows as a time granularity (day), revenue as my column metric, then apply 5 dimension values on top of revenue to have 5 columns, I get my basic stacked bar chart:

 

Bar.PNG

 

If I change the % chart setting to use %, I get this weird this:

 

Bar2.PNG

 

These %s clearly do not represent the size of the revenue amount each day. My expectation is that a % is calculated for the row, for the day, and used in the charts.

 

I guess what we're asking for here is pivot table style options:

 

Screenshot 2017-05-26 10.51.05.png