One or more mandatory variables of query is not filled Popup

[Former Member]

Hello Guys,

We have a Dashboard with 6 Queries.

5 queries  have filters (no variables). One query has  Variable as input. ( A dynamic filed from spreadsheet is mapped to Variable s in definition tab of data manager.

When the dashboard is executed. We are getting error with popup "One or more mandatory variables of query is not filled".

I observe that query is executing before the spread sheet is loaded.

Though the pop up is coming the values are correct.

Hence I would like to know,

if there is any way to disable this popup or

If we can make sure the query is executed after the spreadsheet values are loaded.

Best Regards

Raj Kumar.

[Former Member]

Hi Raja,

Try giving a default value for the mandatory variable(in the query) for only start-up of the dashboard, I think this should solve it.

Regards

Guru Saran