Is it possible to refresh the dependent Dashboard prompts when its parent prompt is selected?
For example, I have got Country and State prompts in my dashboard and State prompt values are limited by Country prompt i.e if India is selected as Country, only Indian states will appear in the State prompt. My requirement is when a country is selected, first value of the State prompt should be selected (displayed) automatically.
As you already have the cascade setup between Country and State set the default value for the state with SQL. The way to do it is use a presentation variable for country and use that variable in the state default sql as a filter. Sort the values and pick the 1st value in the sql. This would return the 1st value in the State prompt.