Hi Team! I'm having trouble creating filters in the fact table. It seems that when you add a filter to the fact table, you forget to add a second closing bracket at the end, which makes the check script not work, so I can't add a filter and run the necessary experiment. script to be checked, and it's obvious that we need another bracket at the end:

WITH __table as (

SELECT * FROM (

-- my original script:

SELECT ...

FROM ...

WHERE ...

)

SELECT * FROM __table LIMIT 5

My related question: https://growthbookusers.slack.com/archives/C01T6Q1SVFV/p1702024610825169?thread_ts=1701962008.808219&cid=C01T6Q1SVFV

Can you share steps to reproduce this? When I try adding a filter locally I'm not getting that same error. Also, which data source are you using?

I have no idea how this bug resolved, but now I found a new one, and I can't reproduce it: When I had a Fact table ending on commented rows (3 commented rows), you added new filters to the wrong place of the script - right after the last comment, so it automatically marked as a comment too. I tried to do it again, but now it is working

Hi Aksinia, we looked into this and haven't been able to reproduce it yet. If it happens again, please let us know.