# Customizing a field format
Field format

Use the following procedure to customize the appearance of fields in an analysis. 

**To customize the appearance of fields in an analysis**

1. In an analysis, choose a field to format, either by choosing it in the field well or in the **Fields list** of the **Visualize **pane.

1. Choose **Show as** to change how the field shows in the analysis, and choose from the options on the context menu. The list of available options varies based on the field's data type. If you choose a non-numeric field from the fields list, you can change the *count format*, which is the formatting used when the field is counted.

1. Choose **Format** to change the format of the field, and choose from the options on the context menu. If you don't see an option that you want to use, choose **More formatting options** from the context menu.

   The **Format Data** pane opens, presenting options for the type of numeric or date field you chose.

   The options for **Show as** from the context menu now appear in the drop-down list at the top of the **Format Data** pane. The rest of the options are specific to the data type and how you choose to show the field. 

For date and time data, the default format pattern is YYYY-MM-DD**`T`**HH:mm:ssZZ, for example 2016-09-22T17:00:00-07:00.

For numbers, you can choose from the following units to display after the number:
+ No unit suffix. This is the default.
+ Thousands (K)
+ Millions (M)
+ Billions (B)
+ Trillions (T)
+ A custom unit prefix or suffix

For currency, you can choose from the following symbols:
+ Dollars (\$1)
+ Euros (€)
+ Pounds (£)
+ Yen (¥)

# Changing a field format


You can change the format of a field within the context of an analysis. The formatting options available for fields vary based on the field's data type.

Use menu options in the **Field list** pane or the visual field wells to make simple format changes, or use the **Format data** pane to make more extensive formatting changes.

**Topics**
+ [

# Format a currency field
](format-a-currency-field.md)
+ [

# Format a date field
](format-a-date-field.md)
+ [

# Format a number field
](format-a-number-field.md)
+ [

# Format a percent field
](format-a-percent-field.md)
+ [

# Format a text field
](format-a-text-field.md)
+ [

# Return a field's format to default settings
](set-field-format-to-default.md)

# Format a currency field


When you format a currency field, you can either choose the currency symbol from a list of common options, or open the **Format data** pane and manually format the field. Manually formatting the field allows you to choose which symbol to use, which separators to use, the number of decimal places to show, which units to use, and how to display negative numbers.

Changing a field format changes it for all visuals in the analysis, but does not change it in the underlying dataset. 

If you want to choose the symbol for a currency field from a list of common options, you can access such a list in several ways. You can access it from the **Field list** pane, an on-visual editor, or a visual field well.

**To select a currency field's symbol by choosing a list option**

1. Choose one of the following options:
   + In the **Field list** pane, choose the selector icon to the right of the number field that you want to format. 
   + On any visual that contains an on-visual editor associated with the currency field that you want to format, choose that on-visual editor. Expand the **Field wells** pane, and then choose the field well associated with the number field that you want to change. 

1. Choose **Format**, and then choose the currency field that you want:
   + Display in dollars (\$1).
   + Display in pounds (£).
   + Display in euros (€).
   + Display in yen or yuan (¥).

**To manually change a currency field's format**

1. Choose one of the following options:
   + In the **Field list** pane, choose the selector icon to the right of the number field that you want to format. 
   + On any visual that contains an on-visual editor associated with the number field that you want to format, choose that on-visual editor. Expand the **Field wells** pane, and then choose the field well associated with the number field that you want to change.

1. Choose **Format**, and then choose **More Formatting Options**. 

   The **Format data** pane opens. 

1. Expand the **Symbol** section and choose from the following options:
   + Display in dollars (\$1). This is the default.
   + Display in pounds (£).
   + Display in euros (€).
   + Display in yen or yuan (¥).

1. Expand the **Separators** section and choose from the following options:
   + Under **Decimal**, choose a dot or a comma for the decimal separator. A dot is the default. If you choose a comma instead, use a dot or a space as the thousands separator. 
   + Under **Thousands**, select or clear **Enabled** to indicate whether you want to use a thousands separator. **Enabled** is selected by default.
   + If you are using a thousands separator, choose whether to use a comma, dot, or space for the separator. A comma is the default. If you choose a dot instead, use a comma as the decimal separator.

1. Expand the **Decimal Places** section and choose the number of decimal places to use. The default is 2. Field values are rounded to the decimal places specified. For example, if you specify two decimal places, the value 6.728 is rounded to 6.73.

1. Expand the **Units** section and choose from the following options:
   + Choose the unit to use. Choosing a unit adds the appropriate suffix to the number value. For example, if you choose **Thousands**, a field value of 1234 displays as 1.234K.

     The unit options are as follows:
     + No unit suffix. This is the default.
     + Thousands (K)
     + Millions (M)
     + Billions (B)
     + Trillions (T)
   + If you want to use a custom prefix or suffix, specify it in the **Prefix** or **Suffix** box. Using a custom suffix is a good way to specify a currency suffix outside of those already offered by Amazon Quick. You can specify both. You can also specify a custom prefix in addition to the suffix added by selecting a unit.

1. Expand the **Negatives** section and choose whether to display a negative value by using a minus sign or by enclosing it in parentheses. Using a minus sign is the default.

1. Expand the **Null values** section and choose whether to display null values as `null` or as a custom value. Using `null` is the default.
**Note**  
When using a table or pivot table, null values only display for fields that are placed in the **Rows**, **Columns**, or **Group by** field wells. Null values for fields in the **Values** field well appear empty in the table or pivot table.

# Format a date field


When you format a date field, you can choose a list of common formatting options. Or you can open the **Format data** pane to choose from a list of common formats, or specify custom formatting for the date and time values.

Changing a field format changes it for all visuals in the analysis that use that dataset, but does not change it in the dataset itself.

If you want to format a date field by choosing from a list of common options, you can access such a list in several ways. You can access it from the **Field list** pane, a visual on-visual editor, or a visual field well.

**To change a date field's format by choosing a list option**

1. Choose one of the following options:
   + In the **Field list** pane, choose the selector icon to the right of the number field that you want to format. 
   + On any visual that contains an on-visual editor associated with the number field that you want to format, choose that on-visual editor. Expand the **Field wells** pane, and then choose the field well associated with the number field that you want to change.

1. Choose **Format**, and then choose the format that you want. The following quick formatting options are offered for date fields:
   + Show the month, day, year, and time.
   + Show the month, day, and year.
   + Show the month and year.
   + Show the year.

**To manually change a date field's format**

1. Choose one of the following options:
   + In the **Field list** pane, choose the selector icon to the right of the number field that you want to format. 
   + On any visual that contains an on-visual editor associated with the number field that you want to format, choose that on-visual editor. Expand the **Field wells** pane, and then choose the field well associated with the number field that you want to change.

1. Choose **Format**, and then choose **More Formatting Options**. 

   The **Format data** pane opens. 

1. Expand the **Date** section. Choose an existing date format, or choose **Custom** and specify a format pattern in the **Custom** section lower down in the **Format data** pane. If you choose **Custom** for the **Date** section, you must also choose **Custom** for the following **Time** section. The pattern that you specify in the **Custom** section must include any date and time formatting that you want.

   The default selection is **Custom**, with a default format pattern of MMM D, YYYY h:mma, for example Sep 20, 2022 5:30pm.

1. Expand the **Time** section. Choose an existing time format, or choose **Custom** and specify a format pattern in the **Custom** section lower down in the **Format data** pane. If you choose **Custom** for the **Time** section, you must also choose **Custom** for the preceding **Date** section. The pattern that you specify in the **Custom** section must include any date and time formatting that you want.

   The default selection is **Custom**, with a default format pattern of MMM D, YYYY h:mma, for example Sep 20, 2022 5:30pm.

1. If you chose **Custom** in the **Date** and **Time** sections, expand the **Custom** section and specify the format pattern that you want, using the format pattern syntax specified in [Moment.js Display Format](https://momentjs.com/docs/#/displaying/) in the Moment.js JavaScript documentation.
**Note**  
The time zone related display token `Z` from the Moment.js library is supported in Quick, but the `z` token is not.

   If you chose something other than **Custom** in the **Date** and **Time** sections, **Custom** is populated with the format pattern that reflects your selections. For example, if you chose Jun 21, 2016 in the **Date** section and 17:00:00pm in the **Time** section, the **Custom** section shows the format pattern MMM D, YYYY H:mm:ssa.

1. (Optional) Expand the **Custom** section and use **Preview** to verify your specified format.

1. Expand the **Null values** section and choose whether to display null values as `null` or as a custom value. Using `null` is the default.

# Customizing date formats in Quick
Customizing date formats

In Quick, you can customize how dates are formatted in your filter and parameter controls. For example, you can specify to format the date in a control as 20-09-2021, or, if you'd rather, as 09-20-2021. You can also specify to shorten the month in your dates (such as September) to three letters (Sep), among other customizations.

Following is a list of tokens you can use to create custom date formats. You can use them in combination with one another to control how dates appear in your controls.

## List of supported tokens for formatting dates


Use the following tokens to customize the format of dates in Quick.


| Example | Description | Token | 
| --- | --- | --- | 
|  0–6  |  Numeric representation of a particular day of the week. 0 is Sunday and 6 is Saturday.  |  `d`  | 
|  Mo–Su  |  A 2-character textual representation of a particular day of the week.  |  `dd`  | 
|  Mon–Sun  |  A 3-character textual representation of a particular day of the week.  |  `ddd`  | 
|  Monday–Sunday  |  A textual representation of a particular day of the week.  |  `dddd`  | 
|  99 or 21  |  A 2-digit representation of a year.  |  `YY`  | 
|  1999 or 2021  |  A full, 4-digit numeric representation of a year.  |  `YYYY`  | 
|  1–12  |  Number of a month, without leading zeros.  |  `M`  | 
|  1st, 2nd, to 12th  |  Number of a month without leading zeros and with an ordinal suffix.  |  `Mo`  | 
|  01–12  |  Number of a month with leading zeros.  |  `MM`  | 
|  Jan–Dec  |  A 3-digit textual representation of a month.  |  `MMM`  | 
|  January–December  |  A full textual representation of a month.  |  `MMMM`  | 
|  1–4  |  A numeric representation of a quarter.  |  `Q`  | 
|  1st–4th  |  A numeric representation of a quarter with an ordinal suffix.  |  `Qo`  | 
|  1–31  |  Day of the month without leading zeros.  |  `D`  | 
|  1st, 2nd, to 31st  |  Day of the month without leading zeros and an ordinal suffix.  |  `Do`  | 
|  01–31  |  A 2-digit day of the month with leading zeros.  |  `DD`  | 
|  1–365  |  Day of the year without leading zeros.  |  `DDD`  | 
|  001–365  |  Day of the year with leading zeros.  |  `DDDD`  | 
|  1–53  |  Week of the year without leading zeros.  |  `w`  | 
|  1st–53rd  |  The week of the year without leading zeros and with an ordinal suffix.  |  `wo`  | 
|  01–53rd  |  Week of the year with leading zeros.  |  `ww`  | 
|  1–23  |  Hours, in 24-hour format, without leading zeros.  |  `H`  | 
|  01–23  |  Hours, in 24-hour format, with leading zeros.  |  `HH`  | 
|  1–12  |  Hours, in 12-hour format, without leading zeros.  |  `h`  | 
|  01–12  |  Hours, in 12-hour format, with leading zeros.  |  `hh`  | 
|  0–59  |  Minutes without leading zeros.  |  `m`  | 
|  00–59  |  Minutes with leading zeros.  |  `mm`  | 
|  0–59  |  Seconds without leading zeros.  |  `s`  | 
|  00–59  |  Seconds with leading zeros.  |  `ss`  | 
|  am or pm  |  am/pm  |  `a`  | 
|  AM or PM  |  AM/PM  |  `A`  | 
|  1632184215  |  Unix timestamp.  |  `X`  | 
|  1632184215000  |  Millisecond Unix timestamp.  |  `x`  | 
|  Z  |  Zero UTC offset.  |  `Z`  | 

The following date types are not supported.
+ Time zones offset with a colon. For example, \$107:00.
+ Time zones offset without a colon. For example, \$10730.

### Preset date formats


To quickly customize dates and times to appear as one of the following example formats, you can use the following Quick preset tokens.


| Example | Token | 
| --- | --- | 
|  8:30 PM  |  `LT`  | 
|  8:30:25 PM  |  `LTS`  | 
|  August 2 1985  |  `LL`  | 
|  Aug 2 1985  |  `ll`  | 
|  August 2 1985 08:30 PM  |  `LLL`  | 
|  Aug 2 1985 08:30 PM  |  `lll`  | 
|  Thursday, August 2 1985 08:30 PM  |  `LLLL`  | 
|  Thu, Aug 2 1985 08:30 PM  |  `llll`  | 

## Common date formats


Following are three common date examples and their associated token formats for your quick reference.


| Example | Token Format | 
| --- | --- | 
|  Sep 20, 2021  |  `MMM DD, YYYY`  | 
|  20-09-21 5pm  |  `DD-MM-YY ha`  | 
|  Monday, September 20, 2021 17:30:15  |  `dddd, MMMM DD, YYYY HH:mm:ss`  | 

## Adding words to dates


To include words in your date formats, such as the word "of" in *20th of Sep, 2021*, enter backslashes (\$1) before each character in the word. For example, for the 20th of Sep, 2021 date example, use the following token format: `Do \o\f MMM, YYYY`.

## Example: Customizing the date format in a filter control
Customizing the date format in a filter control

Use the following procedure to learn how to use date token formats to customize dates for a filter control.

**To learn to customize dates for a filter control with data tokens**

1. In a Quick analysis, choose the filter control that you want to customize.

1. On the filter control, choose the **Edit control** icon.

1. On the **Edit control** page that opens, for **Date format**, enter the custom date format that you want. Use the tokens listed previously in this topic.

   For example, let's say that you want to customize your dates using the following format: *Sep 3rd, 2020 at 5pm*. To do so, you can enter the following token format:

   `MMM Do, YYYY \a\t ha`

   A preview of the date format appears below the input field as you enter each token.

1. Choose **Apply**.

   The dates in the control update to the format you specified.

# Format a number field


When you format a number field, you can choose the decimal place and thousand separator format from a list of common options. Or you can open the **Format Data** pane and manually format the field. Manually formatting the field enables you to choose which separators to use and the number of decimal places to show. It also enables you to choose which units to use, and how to display negative numbers.

Changing a field format changes it for all visuals in the analysis, but does not change it in the underlying dataset.

If you want to format a number field by choosing from a list of common options, you can access such a list from the **Field list** pane, an on-visual editor, or a visual field well.

**To change a number field's format by choosing a list option:**
+ Choose one of the following options:
  + In the **Field list** pane, choose the selector icon to the right of the number field that you want to format. 
  + On any visual that contains an on-visual editor associated with the number field that you want to format, choose that on-visual editor. Expand the **Field wells** pane, and then choose the field well associated with the number field that you want to change.
+ Choose **Format**, and then choose the format that you want. The following quick formatting options are offered for number fields:
  + Use commas to separate groups of thousands and use a decimal point to show the fractional part of the number, for example 1,234.56.
  + Use a decimal point to show the fractional part of the number, for example 1234.56.
  + Show the number as an integer and use commas to separate groups of thousands, for example 1,234.
  + Show the number as an integer, for example 1234.

**To manually change a number field's format:**

1. Choose one of the following options:
   + In the **Field list** pane, choose the selector icon to the right of the number field that you want to format. 
   + On any visual that contains an on-visual editor associated with the number field that you want to format, choose that on-visual editor. Expand the **Field wells** pane, and then choose the field well associated with the number field that you want to change.

1. Choose **Format**, and then choose **More Formatting Options**. 

   The **Format data** pane opens. 

1. Expand the **Separators** section and choose from the following options:
   + Under **Decimal**, choose a dot or a comma for the decimal separator. A dot is the default. If you choose a comma instead, use a dot or a space as the thousands separator. 
   + Under **Thousands**, select or clear **Enabled** to indicate whether you want to use a thousands separator. **Enabled** is selected by default.
   + If you are using a thousands separator, choose whether to use a comma, dot, or space for the separator. A comma is the default. If you choose a dot instead, use a comma as the decimal separator.

1. Expand the **Decimal Places** section and choose from the following options:
   + Choose **Auto** to have Amazon Quick automatically determine the appropriate number of decimal places, or choose **Custom** to specify a number of decimal places. **Auto** is the default. 
   + If you chose **Custom**, enter the number of decimal places to use. Field values are rounded to the decimal places specified. For example, if you specify two decimal places, the value 6.728 is rounded to 6.73.

1. Expand the **Units** section and choose from the following options:
   + Choose the unit to use. Choosing a unit adds the appropriate suffix to the number value. For example, if you choose **Thousands**, a field value of 1234 displays as 1.234K.

     The unit options are as follows:
     + No unit suffix. This is the default.
     + Thousands (K)
     + Millions (M)
     + Billions (B)
     + Trillions (T)
   + If you want to use a custom prefix or suffix, specify it in the **Prefix** or **Suffix** box. You can specify both. You can also specify a custom prefix in addition to the suffix added by selecting a unit.

1. Expand the **Negatives** section and choose whether to display a negative value by using a minus sign or by enclosing it in parentheses. Using a minus sign is the default.

1. Expand the **Null values** section and choose whether to display null values as `null` or as a custom value. Using `null` is the default.
**Note**  
When using a table or pivot table, null values only display for fields that are placed in the **Rows**, **Columns**, or **Group by** field wells. Null values for fields in the **Values** field well appear empty in the table or pivot table.

# Format a percent field


When you format a percent field, you can choose the number of decimal places from a list of common options. Or you can open the **Format data** pane and manually format the field. Manually formatting the field enables you to choose which separators to use. It also enables you to choose the number of decimal places to show and how to display negative numbers.

Changing a field format changes it for all visuals in the analysis, but does not change it in the underlying dataset. 

If you want to choose the number of decimal places for a percent field from a list of common options, you can access such a list in several ways. You can access it from the **Field list** pane, an on-visual editor, or a visual field well.

**To change a percent field's number of decimal places by choosing a list option**

1. Choose one of the following options:
   + In the **Field list** pane, choose the selector icon to the right of the number field that you want to format. 
   + On any visual that contains an on-visual editor associated with the percent field that you want to format, choose that on-visual editor. Expand the **Field wells** pane, and then choose the field well associated with the number field that you want to change.

1. Choose **Format**, and then choose the number of decimal places that you want. The following quick formats are offered for percent fields:
   + Display the value with two decimal places.
   + Display the value with one decimal place.
   + Display the value with no decimal places.

**To manually change a percent field's format**

1. Choose one of the following options:
   + In the **Field list** pane, choose the selector icon to the right of the number field that you want to format. 
   + On any visual that contains an on-visual editor associated with the number field that you want to format, choose that on-visual editor. Expand the **Field wells** pane, and then choose the field well associated with the number field that you want to change.

1. Choose **Format**, and then choose **More Formatting Options**. 

   The **Format data** pane opens. 

1. Expand the **Separators** section and choose from the following options:
   + Under **Decimal**, choose a dot or a comma for the decimal separator. A dot is the default. If you choose a comma instead, use a dot or a space as the thousands separator.
   + Under **Thousands**, select or clear **Enabled** to indicate whether you want to use a thousands separator. **Enabled** is selected by default.
   + If you are using a thousands separator, choose whether to use a comma, dot, or space for the separator. A comma is the default. If you choose a dot instead, use a comma as the decimal separator.

1. Expand the **Decimal Places** section and choose from the following options: 
   + Choose **Auto** to have Amazon Quick automatically determine the appropriate number of decimal places, or choose **Custom** to specify a number of decimal places. **Auto** is the default. 
   + If you chose **Custom**, enter the number of decimal places to use. Field values are rounded to the decimal places specified. For example, if you specify two decimal places, the value 6.728 is rounded to 6.73.

1. Expand the **Negatives** section and choose whether to display a negative value by using a minus sign or by enclosing it in parentheses. Using a minus sign is the default.

1. Expand the **Null values** section and choose whether to display null values as `null` or as a custom value. Using `null` is the default.
**Note**  
When using a table or pivot table, null values only display for fields that are placed in the **Rows**, **Columns**, or **Group by** field wells. Null values for fields in the **Values** field well appear empty in the table or pivot table.

# Format a text field


When you format a text field, you can choose how to display null values using the **Field list** pane, an on-visual editor, or a visual field well.

**To choose how to display a text field's null values**

1. Choose one of the following options:
   + In the **Field list** pane, choose the selector icon to the right of the number field that you want to format. 
   + On any visual that contains an on-visual editor associated with the percent field that you want to format, choose that on-visual editor. Expand the **Field wells** pane, and then choose the field well associated with the number field that you want to change.

1. Choose **Format**, and then choose **More Formatting Options**. 

   The **Format data** pane opens. 

1. Expand the **Null values** section and choose whether to display null values as `null` or as a custom value. Using `null` is the default.

# Return a field's format to default settings


Use the following procedure to return a field's format to the default settings.

**To return a field's format to the default settings**

1. In the **Field list** pane, choose the selector icon to the right of the field that you want to reset.

1. Choose **Format**, and then choose **More Formatting options**. 

   The **Format data** pane opens. 

1. Choose **Reset to defaults**.