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

Make Analysis Workspace auto-conditional formatting work better

Avatar

Avatar
Boost 100
Level 6
AdamGreco
Level 6

Likes

100 likes

Total Posts

64 posts

Correct reply

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

Avatar
Boost 100
Level 6
AdamGreco
Level 6

Likes

100 likes

Total Posts

64 posts

Correct reply

30 solutions
Top badges earned
Boost 100
Give Back 50
Ignite 3
Give Back 25
Give Back 10
View profile
AdamGreco
Level 6

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
Validate 1
Moderator
jen_lasser
Moderator

Likes

119 likes

Total Posts

317 posts

Correct reply

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

Avatar
Validate 1
Moderator
jen_lasser
Moderator

Likes

119 likes

Total Posts

317 posts

Correct reply

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

Likes

592 likes

Total Posts

328 posts

Correct reply

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

Avatar
Shape 100
Community Advisor
Andrew_Wathen_
Community Advisor

Likes

592 likes

Total Posts

328 posts

Correct reply

16 solutions
Top badges earned
Shape 100
Bedrock
Coach
Seeker
Contributor 2
View profile
Andrew_Wathen_
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

11 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

11 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
Level 10
jantzen_belliston-Adobe
Level 10

Likes

360 likes

Total Posts

2,372 posts

Correct reply

823 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
Level 10
jantzen_belliston-Adobe
Level 10

Likes

360 likes

Total Posts

2,372 posts

Correct reply

823 solutions
Top badges earned
Give Back 1000
Give back 900
Give Back 800
Give Back 700
Give back 600
View profile
jantzen_belliston-Adobe
Level 10

27-10-2020

 
Status changed to: Archived