Correcting wrong answers provided by Amazon QuickSight Q - Amazon QuickSight
Correcting wrong answersWhat to do when Q can't provide an answerSaving corrections to an answer

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.

Correcting wrong answers provided by Amazon QuickSight Q

 Applies to: Enterprise Edition 

   Intended audience: Amazon QuickSight Dashboard subscribers or viewership 

When you ask a question in the Q bar, Q identifies terms in your question and links them to the appropriate data fields to give you an answer. Sometimes, Q doesn't understand your question, or misinterprets your question and answers it with the wrong data. When this happens, you can make the following corrections to teach Q how to answer your question correctly:

  • Define terms in your question by linking them to the appropriate fields.

  • Adjust to how Q uses a field to answer your question.

  • Customize the visual you receive as an answer.

  • Manually link an existing visual to a question.

For more information, see following.

Correcting wrong answers

When Q gets an answer wrong, there a few things you can do. Following are your options.

1. Define unrecognized terms in your question

When Q doesn't recognize a term in your question or interprets a term incorrectly, either link the term to the correct field or tell Q to ignore the term. If you're an author, you can also add a filter to the term or link the term to a calculated field you create.

To define unrecognized terms

  1. In the Q bar, highlight the term that you want to define, and then choose Define this term.

  2. In the What did you mean? menu that appears, choose a field from the list.

    Animated image of correcting a wrong term.
To correct a term that Q got wrong, or to update a term

  • In the Q bar, choose the term that Q got wrong, and then choose a field from the list.

    Animated image of correcting a wrong term.
To remove a term that Q got wrong

  • In the Q bar, choose the term that Q got wrong, and then choose Skip this term.

    Image of choosing to skip a term in a question.
To add a filter to the dataset and link it to a term (QuickSight authors only)

  1. In the Q bar, choose the term that you want, and then choose Add a filter.

    Image of adding a filter.

    This opens the filter configuration page in the Data tab in a separate window.

  2. On the Filter configuration page that opens, do the following, and then choose Save.

    1. For Name, enter a name for the filter.

    2. For Dataset, choose a dataset from your topic.

    3. For Field, choose a field from the dataset.

    4. Depending on the type of field you chose, do one of the following:

      • If you chose a dimension, choose a Filter type.

      • If you chose a measure, choose an Aggregation, choose a Rule for the aggregation, and then enter a value.

    5. (Optional) Select Apply the filter anytime the dataset is used.

      You can choose to always apply the filter any time the dataset is used. Or you can choose to always apply the filter any time the dataset is used unless a question results in an explicit filter from the dataset.

    After you save the filter, it appears in your list of fields in the Data tab. You can then assign the filter to the term in the Q bar. For more information about adding filters to datasets in a topic, see Adding filters to a topic dataset.

To add a calculated field to a topic and link it to a term (QuickSight authors only)

  1. In the Q bar, choose the term, and then choose Add a calculated field.

    Image of adding a calculated field.

    The calculation editor opens in a new window.

  2. In the calculation editor, enter a name for the calculated field.

    The term that you highlighted is used as the name of the calculated field by default, but you can change it.

  3. Enter a calculation in the editor.

    For more information about the functions and operations that you can use to create calculations, see Calculated field function and operator reference for Amazon QuickSight .

  4. When finished, choose Save.

    After you save the calculated field, it appears in your list of fields in the Data tab. You can then assign the calculated field to the term in the Q bar. For more information about adding calculated fields to topics, see Adding calculated fields to a topic dataset.

2. Adjust how Q uses a field

Sometimes Q links a term to the correct field, but it uses it incorrectly in the answer. Q might use the wrong aggregation or data type. If this happens, you can correct how Q uses the field in the answer.

To change the field aggregation

  • In the answer in the Q bar, choose the description of the field, choose Aggregation, and then choose the aggregation that you want Q to use for your answer.

    Image of changing a field aggregation in an answer.
To remove a field from being used in the answer

  • In the answer in the Q bar, choose the field, and then choose Remove from answer.

    Image of removing a field from an answer.

3. Customize a visual

You can customize the visual used for an answer if the visual that Q uses isn't what you expect.

To change the sort order in the visual

  • In the answer in the Q bar, choose the field that you want to change the sort order for, choose Sorted by, and then choose a sort order.

    Image of changing the sort order for a field in an answer.
To change the number format in the visual

  • In the answer in the Q bar, choose the field to change the number formatting for, choose Format, and then choose the format and decimal places.

    Image of changing the number format for a field in an answer.
To change the visual axis

  • In the answer in the Q bar, choose the chart axis, and then choose a field.

    Image of changing the axis field.
To change the chart type

  • In the answer in the Q bar, choose the chart type icon at right, and then choose the chart type that you want.

    Image of changing the chart type for an answer.

What to do when Q can't provide an answer

Sometimes Q can't provide an answer, even if you try to make corrections. When this happens, you can manually link the question to a visual from an existing dashboard. This is called creating a linked answer.

Use the following procedure to create a linked answer.

To create a linked answer

  1. In the answer in the Q bar, choose Link to visual.

    Image of the link to visual option in an answer.

  2. On the page that opens, go to the visual that you want to link the answer to and then choose Link Visual.

    The linked visual appears as the answer to the question. From here, you can edit the link to the visual or add question variants.

    Question variants are questions that return the same reviewed answer. To add a question variant to a linked visual, choose Edit question variants, choose Add new variant, enter a question, and then choose Save variant.

Saving corrections to an answer

When you change an answer, it's saved as an improvement suggestion and a notification appears next to the improvement suggestion icon. You can choose to save or dismiss these changes.

To save or dismiss corrections to an answer

  1. In the answer in the Q bar, choose the improvement suggestion icon.

    Image of improvement suggestions icon.

  2. On the Improvement suggestions pane that opens, choose the change that you want to save or dismiss. Choose Save to save the changes, or choose Dismiss to dismiss the changes.