How to change the Percentage Change color for a Metric
By default, the percentage change value displayed on Datablocks is green when the Metric value has increased, and red when the Metric value has decreased.
IN THIS ARTICLE
Why to invert the Percentage Change color for a Metric
There are some cases where an increase in the Metric value does not signify an improvement in performance, and vice versa. In those cases, an increase in the Metric value should be displayed in red while a decrease in the Metric value should be displayed in green. Examples of these Metrics are CPC, Bounce Rate and Email Unsubscribers.
How to invert the Percentage Change color for a Metric
HOW TO INVERT THE PERCENTAGE CHANGE COLOR FOR
How to change the percentage change color for Basic and Calculated Metrics
For all Basic Metrics (i.e., those that are available by default from an integration), the percentage change color is set by Databox developers and these inverted cases should be accounted for. However, there may be cases where your company's interpretation of a Metric is different than others.
For example, some companies view an increase in the Facebook Ads Metric "Amount Spent" as a positive change, since it signifies additional exposure, while other companies view an increase in "Amount Spent" as a negative change, since more money is being spent.
You can invert the percentage change color of Basic Metrics and Calculated Metrics (i.e., those created using Data Calculations) by following the steps below.
-
Pro Tip: For Agencies, inverting the percentage change color for a Metric is retained when sending a Databoard to a Client Account.
How to change the percentage change color for Custom Metrics
For Custom Metrics (i.e., those that are created using Query Builder), the percentage change color can be set from directly within Query Builder. This can be done by navigating to the Query Builder in-app ( Metrics > Query Builder) and editing the Custom Metric, or directly from within the Designer.
Pro Tip: This option is not currently available for SQL and Google Sheets Custom Metrics. Please follow these steps to invert the percentage change color for Custom SQL and Google Sheets Metrics.