Adding or removing a field - Amazon QuickSight

Important: We've redesigned the Amazon QuickSight analysis workspace. You might encounter screenshots or procedural text that doesn't reflect the new look in the QuickSight console. We're in the process of updating screenshots and procedural text.

To find a feature or item, use the Quick search bar.

For more information on QuickSight's new look, see Introducing new analysis experience on Amazon QuickSight.

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 Axistitle 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 QuickSight map the field to the most appropriate visual element. To do so, choose the field in the Fields list pane. Amazon QuickSight 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 QuickSight 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. Click anywhere on the Field wells to expand them.

  2. 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 Format Visual panel, which you open by choosing the V-shaped icon at top right.