Freetype Filter & IN clause

1

More help required,

I am trying to use a filter with an IN clause (Number format) when metabase’s parses my query through to BiqQuery the IN clause is showing (‘11 12’)

[[AND format_timestamp('%H', timestamp) IN ({{Hour}})]]

How do I resolve this, I have tried different strings to no avail unfortunately.

Thank you in advance

2

Hi @Antonio89
It looks like you’re using simple Text filter - not Number filter, correct?
You would have to split that string with your query. I don’t know BigQuery, but from their Standard SQL docs, you can use SPLIT():

[[AND format_timestamp('%H', timestamp) IN (SPLIT({{Hour}}," "))]]