Expand my Community achievements bar.

Webinar: Adobe Customer Journey Analytics Product Innovations: A Quarterly Overview. Come learn for the Adobe Analytics Product team who will be covering AJO reporting, Graph-based Stitching, guided analysis for CJA, and more!

Make "Change" column in comparison reports customizable

Avatar

Level 5

5/1/12

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

Community Advisor

3/27/18

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“