When you select from another query which contains a filter and the second query doesn’t select the filter value, than the filter isn’t shown.
I have this Query:
SELECT “target_id”, “virtualdevice” AS “virtualdevice::multi-filter”
FROM “sensstats”.“viewers”, UNNEST(“values”) t(“vals”)
GROUP BY “target_id”, “virtualdevice”
And it works. Now the query I want is:
SELECT “target_id” FROM (
SELECT “target_id”, “virtualdevice” AS “virtualdevice::multi-filter”
FROM “sensstats”.“viewers”, UNNEST(“values”) t(“vals”)
GROUP BY “target_id”, “virtualdevice”)
GROUP BY “target_id”
But now in the redash gui the filter input field isn’t shown anymore.
Can you fix this?