Cloudera Docs

Changing currency field display format

In CDP Data Visualization, you can set currency display options for numerical fields across all visuals of a dataset.

Follow these steps to continue configuring a field at the dataset level for currency format. See Changing the Field Display Format for the initial navigation steps.

  1. In the Edit Field Parameters window modal, under the Display Format tab, select Currency from the Category menu.
    selecting currency format
  2. In the Currency Symbols menu, select $ (Dollar). Note that we support other currencies, namely £ (Pound), ¥ (Yen/Yuan), ₹ (Rupee), and € (Euro).
    selecting dollar currency symbol format
  3. Click Apply.
    formalizing field display
  4. Save the changes to the dataset.

    In this case, under Dataset: World Life Expectancy, click Save.

  5. [Optional] Repeat the display formatting steps for the original field, gdp_per_capita.
  6. To verify that the format applies to all new visuals that use the field, create a new visual by repeating the steps in Testing the Calculated Field.
The new visual displays the vertical axis numbers in currency format.
Comparing field display