https://www.growthbook.io/ logo
#ask-questions
Title
# ask-questions
c

cuddly-kilobyte-92191

12/14/2023, 7:25 AM
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
f

future-teacher-7046

12/14/2023, 11:57 AM
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?
c

cuddly-kilobyte-92191

12/20/2023, 3:34 PM
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
b

brief-honey-45610

12/29/2023, 11:30 PM
Hi Aksinia, we looked into this and haven't been able to reproduce it yet. If it happens again, please let us know.
👌 1
4 Views