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
BedrockMission!

Learn more

View all

Sign in to view all badges

Make Analysis Workspace auto-conditional formatting work better

Avatar

Avatar
Give Back 50
Community Advisor
AdamGreco
Community Advisor

Likes

97 likes

Total Posts

64 posts

Correct reply

30 solutions
Top badges earned
Give Back 50
Ignite 3
Give Back 25
Give Back 10
Give Back 5
View profile

Avatar
Give Back 50
Community Advisor
AdamGreco
Community Advisor

Likes

97 likes

Total Posts

64 posts

Correct reply

30 solutions
Top badges earned
Give Back 50
Ignite 3
Give Back 25
Give Back 10
Give Back 5
View profile
AdamGreco
Community Advisor

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
Give Back 25
Moderator
jen_lasser
Moderator

Likes

117 likes

Total Posts

316 posts

Correct reply

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

Avatar
Give Back 25
Moderator
jen_lasser
Moderator

Likes

117 likes

Total Posts

316 posts

Correct reply

8 solutions
Top badges earned
Give Back 25
Ignite 3
Ignite 1
Give Back 5
Give Back 3
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
Community Advisor
AndrewWathen
Community Advisor

Likes

582 likes

Total Posts

326 posts

Correct reply

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

Avatar
Shape 100
Community Advisor
AndrewWathen
Community Advisor

Likes

582 likes

Total Posts

326 posts

Correct reply

16 solutions
Top badges earned
Shape 100
Bedrock
Coach
Seeker
Springboard
View profile
AndrewWathen
Community Advisor

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
Boost 10
Level 2
kelseypedersen
Level 2

Likes

10 likes

Total Posts

9 posts

Correct reply

0 solutions
Top badges earned
Boost 10
Establish
Contributor
Applaud 5
Give Back
View profile

Avatar
Boost 10
Level 2
kelseypedersen
Level 2

Likes

10 likes

Total Posts

9 posts

Correct reply

0 solutions
Top badges earned
Boost 10
Establish
Contributor
Applaud 5
Give Back
View profile
kelseypedersen
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
Give Back 1000
Community Manager
jantzen_belliston-Adobe
Community Manager

Likes

351 likes

Total Posts

2,366 posts

Correct reply

822 solutions
Top badges earned
Give Back 1000
Give back 900
Give Back 800
Give Back 700
Give back 600
View profile

Avatar
Give Back 1000
Community Manager
jantzen_belliston-Adobe
Community Manager

Likes

351 likes

Total Posts

2,366 posts

Correct reply

822 solutions
Top badges earned
Give Back 1000
Give back 900
Give Back 800
Give Back 700
Give back 600
View profile
jantzen_belliston-Adobe
Community Manager

27-10-2020

 
Status changed to: Archived