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.
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 @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!