Hey, im using literally this code with one of my tables and the second filter parameter is not working when used in a dashboard
SELECT count(*)
FROM mytable
WHERE true
[[AND id = {{id}}]]
[[AND category = {{category}}]]
Is this like a bug or I'm doing something wrong here?
when you say "it's not working", what do you mean? which version are you running?
Check the image, when I want to use filters in the dashboard for that question, It wont allow me to filter it by "dates" I have my WHERE clause this way
WHERE true
[[AND column1= {{filter1}}]]
[[AND column2 = {{date}}]]
It only works for column1, but column2 appears the message you see in the screenshot shared
