Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

X-Axis on Horizontal Bar visualization in Workspace

Avatar

Avatar
Boost 5
Level 3
tim_wilson11
Level 3

Likes

40 likes

Total Posts

15 posts

Correct reply

0 solutions
Top badges earned
Boost 5
Boost 3
Boost 25
Boost 10
Boost 1
View profile

Avatar
Boost 5
Level 3
tim_wilson11
Level 3

Likes

40 likes

Total Posts

15 posts

Correct reply

0 solutions
Top badges earned
Boost 5
Boost 3
Boost 25
Boost 10
Boost 1
View profile
tim_wilson11
Level 3

02-11-2016

The "horizontal bar" visualizations seem to have a fixed "100%" x-axis basis. That's okay (sort of) if they're showing volume values like visits or orders or revenue. But, they make for some unhelpful displays when looking at other metrics.

 

In the example below, it's difficult to see the relative difference in conversion rates, because the bars are all very short.

 

Conversely, the AOV appears to have an x-axis of "$100," so any AOV over that just maxes out the bar, which makes little sense.

 

Ideally, the user would have some control over what the "Max" basis is when using an in-cell bar chart, and the automatic option would put the max value at ~90% of the width of the column. Excel, I believe, defaults to a max that is 100% of the max value of the column, which would work, too (but isn't ideal).

 

 

in-cell-bars.png

1 Comment

Avatar

Avatar
Boost 50
Employee
benjamingaines2
Employee

Likes

271 likes

Total Posts

874 posts

Correct reply

0 solutions
Top badges earned
Boost 50
Boost 5
Boost 3
Boost 250
Boost 25
View profile

Avatar
Boost 50
Employee
benjamingaines2
Employee

Likes

271 likes

Total Posts

874 posts

Correct reply

0 solutions
Top badges earned
Boost 50
Boost 5
Boost 3
Boost 250
Boost 25
View profile
benjamingaines2
Employee

04-11-2016

Good suggestion, @GilliganOnData2. I have observed this myself as well.