Thanks for you support on the following topic.
I have a dashboard linked to a MySQL data source in which there is a query based variable.
This variable can have, in some cases, hundreds of values so the All value gets translated into a very long IN (value1, value2, value3, … valueN) SQL condition.
This can easily become quite ineffective mainly when the value list is actually a partition of the whole set of data, in this case just removing the IN clause in the WHERE condition would lead to a much faster query.
Is there any way to modify the query based on the value of the dashboard variable?
I apologize if I was not clear and thank you for your time