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. 

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. All of these are performing better when the metric value decreases. 

How to invert the Percentage Change color for a Metric

How to invert the Percentage Change color for Basic Metrics

For all Basic Metrics (i.e., those that are available by default from a native 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 by following the steps below.

How to invert the Percentage Change color for Calculated Metrics

You can invert the percentage change color of Calculated Metrics (i.e., those created using Data Calculations) by following the steps below.

Pro Tip: You can also access Edit Metric Definiton by navigating to Metrics > Data Calculations and find the Metric you'd like to update the percentage change color for, using the Search bar if necessary. Next, click on the arrow by the Edit button to open the drop-down list and select Edit Metric Definition.

How to invert the Percentage Change color for Custom Metrics

Invert the Percentage Change color for Custom Metrics

You can invert the percentage change color of Custom Metrics from native integrations (i.e., those created using Query Builder for Google Analytics, HubSpot Marketing, Facebook Ads, etc.) by following the steps below.

Pro Tip: You can also access Edit Metric Definiton by navigating to Metrics > Query Builder and find the Metric you'd like to update the percentage change color for, using the Search bar if necessary. Next, click on the arrow by the Edit button to open the drop-down list and select Edit Metric Definition.

Pro Tip: The percentage change color can be set directly within Query Builder. This can be done by selecting the Invert metric checkbox when creating or editing the metric from the Query Builder or from directly within the Designer. 

Invert the Percentage Change color for Google Sheets, Excel and SQL Metrics

You can invert the percentage change color for Google Sheets, Excel and SQL Custom Metrics by following the steps below.

Pro Tip: The percentage change color can be set directly within Query Builder. This can be done by selecting the Invert metric checkbox when creating or editing the metric from the Query Builder or from directly within the Designer.