One or more mandatory variables of query is not filled Popup
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.