# Changing fields used by a visual in Amazon Quick Changing fields used by a visual You can add or modify fields for a visual by using the **Fields list** pane, the field wells, or the on-visual editors or drop targets on the visual. The field wells, on-visual editors, and drop targets available for a specific visual depends on the visual type selected. For details, see the appropriate visual type topic in the [Visual types in Amazon Quick Sight](working-with-visual-types.md) section. **Important** You can also change the data type and format of numeric fields by using field wells and on-visual editors. If you change a field in this way, it changes for the selected visual only. For more information about changing numeric field data types and formats, see [Changing fields used by a visual in Amazon Quick](#changing-visual-fields). Use the following topics to learn more about adding, removing, and modifying fields on a visual. **Topics** + [ # Using visual field controls ](using-visual-field-controls.md) + [ # Adding or removing a field ](adding-or-removing-a-field.md) + [ # Changing the field associated with a visual element ](changing-a-field-association.md) + [ # Changing field aggregation ](changing-field-aggregation.md) + [ # Changing date field granularity ](changing-date-field-granularity.md) + [ # Customizing a field format ](customizing-field-format.md) # Using visual field controls You can edit the fields used by a visual with user interface (UI) controls. You can use these controls as follows: + Create a visual and assign fields to different elements on it by selecting fields in the **Fields list** pane, or dragging fields to field wells or drop targets. + Change the field associated with a visual element by dragging a field to a drop target or field well, or selecting a different field in a field well or on-visual editor. + Change field aggregation or date granularity by using the field wells or the on-visual editors. The field wells, on-visual editors, and drop targets available on a specific visual depends on the visual type selected. ## Dragging fields to drop targets or field wells When you drag a field to either a drop target or field well, Amazon Quick provides you with information about whether the target element expects a measure or a dimension. Amazon Quick also provides you with information about whether that element is available for field assignment. For example, when you drag a measure to the value drop target on a new single-measure line chart, you see the drop target color-coded green. That green color coding indicates that the drop target expects a measure. The drag label indicates that the target is available to add a field. When you drag a dimension to the x-axis or color drop target on a new line chart, you see a label color-coded blue. That blue color coding indicates that the drop target expects a dimension. The drag label indicates that the target is available to add a field. You can also drag a measure or dimension to a drop target on a line chart where the element is already associated with a field. In this case, the drag label indicates that you are replacing the field currently associated with the drop target. # Adding or removing a field You can add a field to a visual by choosing it on the **Fields list** pane. You can also drag it to a drop target on the visual or to a field well. There is a 1:1 correspondence of drop targets to field wells for each visual type, so you can use either method. On some charts, the **Axis title** field is hidden when there are two or more fields in the **Value** field on any side of the chart. This effect can happen with the following charts: + Bar charts + Line charts + Box plots + Combo charts + Waterfall charts To remove a field from a visual, clear selection from it in the **Fields list** pane. Or choose an on-visual editor or field well that uses that field, and then choose **Remove** from the context (right-click) menu. ## Adding a field by selecting it in the fields list pane You can also let Amazon Quick map the field to the most appropriate visual element. To do so, choose the field in the **Fields list** pane. Amazon Quick adds the field to the visual by populating the first empty field well that corresponds with that field type (either measure or dimension). If all of the visual elements are already populated, Amazon Quick determines the most appropriate field well and replaces the field in it with the field you selected. ## Adding a field by using a drop target To add a field to a visual by using a drop target, first choose a field in the **Fields list** pane. Then drag the field to your chosen drop target on the visual, making sure the drop indicator shows that the field is being added. ## Adding a field by using a field well To add a field to a visual by using a field well, choose a field in the **Fields list** pane. Then drag the field to the target field well, making sure that the drop indicator shows that the field is being added. 1. Drag a field item into a **Field well**. 1. Drag the field that you want to add from the **Fields list** pane to the appropriate field well. **Note** You can add the same value to the same visual multiple times. You can do so to show the same value with different aggregations or table calculations applied. By default, the fields all display the same label. You can edit the names by using the **Properties** panel, which you open by choosing the **V**-shaped icon at top right. # Changing the field associated with a visual element You can change the field assigned to an element in a visual by using the field wells, drop targets, or the on-visual editors on the visual. For pivot tables, use field wells or drop targets because this visual type doesn't provide on-visual editors. ## Change a field mapping by using an on-visual editor Use the following procedure to modify the mapping of a field to a visual element. **To modify the mapping of a field by using an on-visual editor** 1. On the visual, choose the on-visual editor for the visual element for which you want to change the field. 1. On the on-visual editor menu, choose the field that you want to associate with that visual element. ## Changing a field mapping by using a drop target To modify the mapping of a field to a visual element by using a drop target, choose a field in the **Fields list** pane. Then drag the field to a drop target on the visual, making sure that the drop indicator shows that the field is being replaced. ## Changing a field mapping by using a field well Use the following procedure to modify the mapping of a field to a visual element. **To modify the mapping of a field by using a field well** 1. Drag a field item into a **Field well**. 1. Choose the field well that represents the element that you want to remap, and then choose a new field from the menu that appears. # Changing field aggregation You can apply functions to fields to display aggregate information, like the sum of the sales for a given product. You can apply an aggregate function by using the options in either an on-visual editor or a field well. The following aggregate functions are available in Amazon Quick: + Average – Calculates the average value for the selected field. + Count – Provides a count of the number of records containing the selected measure for a given dimension. An example is a count of Order ID by State. + Distinct Count – Provides a count of how many different values are in the selected measure, for the selected dimension or dimensions. An example is a count of Product by Region. A simple count can show how many products are sold for each region. A distinct count can show how many different products are sold for each region. You might have sold 2,000 items, but only two different types of items. + Max – Calculates the maximum value for the selected field. + Min – Calculates the minimum value for the selected field. + Median – Calculates the median value of the specified measure, grouped by the chosen dimension or dimensions. + Sum – Totals all of the values for the selected field. + Standard Deviation – Calculates the standard deviation of the set of numbers in the specified measure, grouped by the chosen dimension or dimensions, based on a sample or on a biased population. + Variance – Calculates the variance of the set of numbers in the specified measure, grouped by the chosen dimension or dimensions, based on a sample or on a biased population. + Percentile – Computes the *n*th percentile of the specified measure, grouped by the chosen dimension or dimensions. All aggregate functions can be applied to numeric fields. *Count* is automatically applied to a dimension if you choose to use it in a field well that expects a measure. If you have used a dimension in that way, you can also change the aggregate function applied to it. You can't apply aggregate functions to fields in dimension field wells. The visual elements that support aggregated fields varies by visual type. ## Changing or adding aggregation on a field by using an on-visual editor Use the following procedure to change or add aggregation on a field. **To change or add aggregation on a field** 1. On the visual, choose the on-visual editor for the field that you want to apply aggregation to. 1. On the on-visual editor menu, choose **Aggregate**, then choose the aggregate function that you want to apply. ## Changing or adding aggregation to a field by using a field well Use the following procedure to add aggregation to a field for a pivot table visual. **To add aggregation to a field for a pivot table visual** 1. Drag a field item into a **Field well**. 1. Choose the field well containing the field that you want to apply an aggregate function to. 1. On the field well menu, choose **Aggregate**, then choose the aggregate function that you want to apply. # Changing date field granularity You can change the granularity for a date field on a visual to determine the intervals for which item values are shown. You can set the date field granularity to one of the following values: + Year + Quarter + Month + Week + Day (this is the default) + Hour + Minute + Second Hour and minute are available only if the field contains time data. ## Changing date field granularity by using an on-visual editor Use the following procedure to change date field granularity by using an on-visual editor. **To change date field granularity with an on-visual editor** 1. On the visual, choose the field well for the date field whose granularity you want to change. 1. On the field well menu, choose **Aggregate**, then choose the time interval that you want to apply, as shown following: ## Changing date field granularity by using a field well Use the following procedure to change date field granularity by using a field well. **To change date field granularity with a field well** 1. Drag a field item into a **Field well**. 1. Choose the field well containing the date field, and then choose **Aggregate**. Choose the date granularity that you want to use. # 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**.