Hello, I am trying to recreate some of my “legacy” metrics on a fact table. Could someone show me how to add the following parts of my WHERE clause in the new method?

WHERE (
   "mediacontent_component_target_page_id" = split('{{experimentId}}', '-')[2] 
   AND "internal_user_id" is not null)

--> The first one I tried adding as row filter but that seems to be making everything a string. --> The second one I would not know how to do so

You can create a Custom Filter on the fact table page with any where statement.

To add. These filters are available under the Saved Filters tab.

Ahhhh, only now I understand that these saved filters can then be used when creating a metric. That was not clear to me even after diving/swimming in the docs. Thank you for your help!

Yeah, we need to make this clearer! Glad it helped