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 "Change" column in comparison reports customizable

Avatar

Avatar
Boost 50
Level 5
pouls29avnet
Level 5

Likes

102 likes

Total Posts

16 posts

Correct reply

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

Avatar
Boost 50
Level 5
pouls29avnet
Level 5

Likes

102 likes

Total Posts

16 posts

Correct reply

0 solutions
Top badges earned
Boost 50
Boost 5
Boost 3
Boost 25
Boost 100
View profile
pouls29avnet
Level 5

01-05-2012

It's great to compare date ranges and see the changes between the values.  However, it would be better if we could customize the "Change" column to make it easier to detect the significance of the change. Just having a positive change be green compared to a negative change in red would be a great start.

1 Comment

Avatar

Avatar
Coach
Community Advisor
Urs_Boller
Community Advisor

Likes

530 likes

Total Posts

1,024 posts

Correct reply

257 solutions
Top badges earned
Coach
Bedrock
Contributor 2
Originator
View profile

Avatar
Coach
Community Advisor
Urs_Boller
Community Advisor

Likes

530 likes

Total Posts

1,024 posts

Correct reply

257 solutions
Top badges earned
Coach
Bedrock
Contributor 2
Originator
View profile
Urs_Boller
Community Advisor

27-03-2018

quick tipp: change col settings (gear icon in header) => turn off numbers/percent and add custom color conditions.

or you can influence the output of the metric to better match a special „formatting“:

1) create the desired „change“ metric

2) edit the metric and move the formula within a „if ... then ... else“ formula, eg. „if X greater than 0 then 1 else 0“.

3) edit col settings (gear icon), switch off numbers and percent and add custom coloring (top 1, low 0)

with both ways you get a col just in red and green

you can even modify the formula in step 2) with another „if then else“ to add a more granular setting and output 0/1/2 for different cases in case you want to add „yellow“ for „almost not changed“