Prompt not working in a logical sql analysis
Summary:
I created a logical sql analysis (see image1).
And I also created a dashboard prompt (see image2).
I filtered the "Calendar_Year" as 'Is Prompted' but for some reason the prompt is not filtering the analysis.
Can anyone help on this?
Content (please ensure you mask any confidential information):
Hi,
I created a logical sql analysis (see image1).
And I also created a dashboard prompt (see image2).
I filtered the "Calendar_Year" as 'Is Prompted' but for some reason the prompt is not filtering the analysis. Do I have to add something to the Logical SQL of the analysis?