How to filter the data in quicksight Q

I have data like payment count with status in a table
Like
|payment count|Status|
|2 |Sucess|
|6 |Failed|
|7 |Sheduled |

When I ask a question like how many transactions are processed, I expected a result as 2
But I am getting 15 (2+6+7)

Please help me how to get filter the data based on status quick sight Q

Hello Jaya,

First of all Welcome to the QuickSight community !
May be you could use to define Field value Synonyms for the fields that may be used while asking the questions.

Please see the best practices for Q here - Best practices for enabling business users to answer questions about data using natural language in Amazon QuickSight | AWS Business Intelligence Blog

Hope this helps.

Cheers,
Deep

Hi Deep, I defined the field synonyms, still it is not consider while asking the question
Please refer below screenshot

Hi @jayakumarim, can you try this question, “How many transactions are processed by status?” or “How many payments are processed by status?”

We hope this solution worked for you. Let us know if this is resolved. And if it is, please help the community by marking this answer as a “Solution.” (click the check box under the reply)

Do you have the Status field in your Q topic and does it have “Success”, “Failed” and “Scheduled” as values? Your screenshot is showing a different field has has numbers as values.

Hi Xclipse,
I tried as per your suggestion, but it gives all statuses. Please refer to the below screenshot.

But I am trying to get the data with status =6 only (i.e. processed payments).
Please suggest how to do this

Hi @jayakumarim – try “How many payments with status of processed in Jan 2024?”

Did this solution work for you? I am marking this reply as, “Solution,” but let us know if this is not resolved. Thanks for posting your questions on the QuickSight Community!

This has worked. Thank you @Xclipse

1 Like