No key drivers for 'Why' questions in topic?

Question & Answer
,
1

I have the exact same topic in two different environments (production, development), yet in production, I cannot get Q to answer my ‘Why’ question - I get an error stating ‘No key drivers found for this topic’. In my development environment, this question works perfectly fine.

I have enabled many different dimensional attributes, I have set up synonyms, entities etc.

The data source is a redshift direct query.

I’ve tried refreshing the topic multiple times.

I’m not sure why I am getting this error - any ideas?

2

Hi @adam.r

Welcome to QuickSight Community .

Could you please check the following criteria are met for Q to answer WHY questions.

How to ask a why question

A why question needs three things:

  • To start with the word “why.”
  • A numeric measure, such as sales, enrollment numbers, profit, price, and so on.
  • A date or time span, such as last quarter, January 2022, or last month. Note that at this release the time span should be complete, but asking about ongoing spans such as “this week” or “this year” or specifying the current month will not yet work.

And please check this blog for additional examples .

if its still not working recommend to include a screenshot from both dev & prod for us to suggest better .

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

Thanks
Vinod

3

Hi Vinod,

Unfortunately there is nothing in the post that states how to debug the error ‘No key drivers found’.

Here is the screenshot of the question I am asking, and the response from Q in the production environment. ‘Cost’ has been defined as a measure. The error is fairly ambiguous and doesn’t provide any context to debug further.

Capture2
Capture2860×615 14.5 KB

I can provide a screenshot of my development environment, where Q has returned an answer to this question in a subsequent post.

4

Here is a screenshot of my development environment, where an answer is returned to the same question.

Capture
Capture1192×481 63.8 KB

5

Hi @adam.r, I would recommend filing a case with AWS Support where we can dive into the details so that we can help youfurther. Here are the steps to open a support case. Ifyour company has someone who manages your AWS account, you might not have direct access to AWS Support and will need to raise an internal ticket to yourIT team or whomever manages your AWS account.They should be able to open an AWS Support case on your behalf. Hope this helps!