I have a variable "customer" in my grafana dashboard. It has the multi-value option enabled.

Now I want to use this variable in my query. When multi-value was not enabled my query looked like this:

SELECT count(product.type)
FROM "product_sale"
WHERE $timeFilter
AND product.customerLastName = $customer
GROUP BY time($__interval)

Now however this will not work anymore as $customer is (presumably) a list of multiple items.

So how would I go about converting my query to support multi-value?

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.