Make Analysis Workspace auto-conditional formatting work better

Avatar

Avatar
Contributor
MVP
AdamGreco
MVP

Likes

95 likes

Total Posts

64 posts

Correct reply

30 solutions
Top badges earned
Contributor
Shape 1
Publish 1
Ignite 1
Give Back 3
View profile

Avatar
Contributor
MVP
AdamGreco
MVP

Likes

95 likes

Total Posts

64 posts

Correct reply

30 solutions
Top badges earned
Contributor
Shape 1
Publish 1
Ignite 1
Give Back 3
View profile
AdamGreco
MVP

15-04-2018

Currently, the Analysis Workspace auto-generated conditional formatting feature doesn't work very well.  If you have a large date range with various metrics, it doesn't dynamically change or adjust to changes.  Often times you have to use the manual feature to sett upper and lower bounds.

I'd like to see this feature work better so you can make changes and have the color schemes change dynamically.  If that isn't possible, I'd like to have the ability to set the upper and lower bounds by using a formula that uses the same functions already available in Analysis Workspace.

4 Comments

Avatar

Avatar
Ignite 3
Moderator
jen_lasser
Moderator

Likes

116 likes

Total Posts

315 posts

Correct reply

8 solutions
Top badges earned
Ignite 3
Ignite 1
Give Back 5
Give Back 3
Give Back 10
View profile

Avatar
Ignite 3
Moderator
jen_lasser
Moderator

Likes

116 likes

Total Posts

315 posts

Correct reply

8 solutions
Top badges earned
Ignite 3
Ignite 1
Give Back 5
Give Back 3
Give Back 10
View profile
jen_lasser
Moderator

26-07-2019

Adam - can you provide a few examples of what improvements you'd like to see us make to the conditional formatting calculation?

Avatar

Avatar
Shape 100
MVP
AndrewWathen
MVP

Likes

575 likes

Total Posts

320 posts

Correct reply

16 solutions
Top badges earned
Shape 100
Bedrock
Springboard
Seeker
Contributor
View profile

Avatar
Shape 100
MVP
AndrewWathen
MVP

Likes

575 likes

Total Posts

320 posts

Correct reply

16 solutions
Top badges earned
Shape 100
Bedrock
Springboard
Seeker
Contributor
View profile
AndrewWathen
MVP

14-10-2019

One of the problems we've ran into in the past is where a particular data set has some outliers (e.g. one really high value).  The auto formatting then seems to use this to set the limits for the formatting.  It then doesn't show the nuances for the majority of values which are in a much narrower range.

Avatar

Avatar
Shape 1
Level 2
kelseyjoy31
Level 2

Likes

8 likes

Total Posts

7 posts

Correct reply

0 solutions
Top badges earned
Shape 1
Boost 5
Boost 3
Boost 1
View profile

Avatar
Shape 1
Level 2
kelseyjoy31
Level 2

Likes

8 likes

Total Posts

7 posts

Correct reply

0 solutions
Top badges earned
Shape 1
Boost 5
Boost 3
Boost 1
View profile
kelseyjoy31
Level 2

05-05-2020

Agreed! It would be incredibly helpful if there was an "absolute" option available to always differentiate increases as green and decreases as red. This is what our senior leadership team is used to seeing, so manual updates always need to be made to our reports. That isn't an issue, but with the Analysis Workspace options for conditional formatting, it unfortunately then only applies to top-level metrics and not the breakdowns.

 

Avatar

Avatar
Validate 1000
Community Manager
jantzen_belliston-Adobe
Community Manager

Likes

339 likes

Total Posts

2,340 posts

Correct reply

819 solutions
Top badges earned
Validate 1000
Springboard
Validate 500
Validate 250
Validate 100
View profile

Avatar
Validate 1000
Community Manager
jantzen_belliston-Adobe
Community Manager

Likes

339 likes

Total Posts

2,340 posts

Correct reply

819 solutions
Top badges earned
Validate 1000
Springboard
Validate 500
Validate 250
Validate 100
View profile
jantzen_belliston-Adobe
Community Manager

27-10-2020

 
Status changed to: Archived