Format component settings

Format lets you determine how a given metric is displayed when used in reports.

Configure format settings for a metric

You can determine how a given metric is displayed by adjusting its format settings.

1. In Customer Journey Analytics, select the Data views tab.

2. Select the data view that contains the component whose format setting you want to configure.

3. Select the Components tab.

   

4. Select the component that you want to configure, then expand the Format section on the right side of the page.

   

5. Specify the following information:

   Setting	Description
   Format	Lets you specify the formatting of a metric as Decimal, Time, Percent, or Currency.
   Decimal	Not visible on Integer schema data types. Lets you specify the number of decimal places a metric displays.
   Date	Lets you determine how you want the date-time field displayed when used as a dimension in reporting. Learn more
   Date-Time	Lets you determine how you want the date-time field displayed when used as a dimension in reporting. Learn more
   Currency	Lets you determine which currency you want the metric to display in. If you analyze global data where transactions occur in different currencies, see Use currency conversion.
   Show upward trend as	Lets you specify if an upward trend on this metric is good (green) or bad (red).
   True value and False value	Only visible on Boolean schema data types. Lets you customize the dimension item label for true and false values.

Use currency conversion

Currency conversion in Customer Journey Analytics can be extremely valuable for businesses that operate internationally. By removing the complexities of manual currency conversion, currency conversion in Customer Journey Analytics brings uniformity and clarity to financial data. Currency conversion keeps track of daily historical exchange rates and maintains those daily rates for a period of 4 years.

For example, if an e-commerce business operates in the US, UK, and EU, sales data can be automatically converted to USD, ensuring easy comparison and holistic understanding of performance.

To determine how currencies are displayed and converted for a given metric:

1. Begin configuring the metric for which you want to use currency as the format, as described above, in Configure format settings for a metric.

2. With the metric selected, make the following selections in the Format section on the right side of the page:

   • In the Format field, select Currency.

   • In the Decimal places field, choose the number of decimal places the metric displays.

     This option is available only if the metric has a numeric type of ‘Double’.

   • Select the Convert Currency option.

   • In the Select currency code dimension field, select the dimension that represents the currency you are converting from (the currency that your data is based on). For example, select a dimension called Currency code.

     If you don’t have a dimension in your current data schema that contains a currency code field, you can create a new currency code field using Data Prep, Data Distiller, or Derived Fields. Data Prep is suitable only for new implementations because it is only on a go-forward basis. Depending on an organization’s setup, Data Distiller and Derived Fields can be used to access the currency code values historically.

   • In the Convert and display currency in field, choose the currency in which you want data to be converted.

3. Repeat these steps if you want to apply currency conversion to additional metrics.

Frequently Asked Questions