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.

1
 Navigate to  Data Sources
2
 Find the Data Source where the Metric you want to invert is located, using the Search bar if necessary. Click on the drop-down arrow next to the Details button and select  Edit metric keys
3
 Use the Search bar to find the Metric whose percentage change color you want to invert. Click on the Invert checkbox to invert the percentage change color for the Metric
The percentage change color will now display red if there is an increase in the Metric value and green if there is a decrease in the Metric value in all of your Databox reports. 
    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. 

1
 Navigate to  Databoards and open the Databoard that contains the Custom Metric in the Designer by clicking Edit
2
 Click on the Data Source where the Custom Metric you want to invert is located. This will open the Datablock Editor
3
 Click Edit to edit the Custom Metric
4
 Check the Invert metric checkbox
The percentage change color will now display red if there is an increase in the Metric value and green if there is a decrease in the Metric value in all of your Databox reports. 
Did this answer your question? Thanks for the feedback There was a problem submitting your feedback. Please try again later.

Still need help? Contact Us Contact Us

Related Articles