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) fill(null)
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?