Filter a date column with values from row

Hi there,

I am trying to setup a funnel analysis of the following funnel:

  • “Event E” is done by a user
  • After the “Event E” is done, “Event F” is done within 2 days
  • After the “Event F” is done, “Event H” is done within 5 days

The whole funnel would need to be completed in 30 days. I was trying to find a way to do this with Metabase Editor but I cannot find it. It is of course doable with custom SQL, but I’d rather have this in the Editor. Other tools in the market have this as a built-in feature in their GUI. I’m wondering how you guys think about this?

I couldn’t find another topic on this and I was a bit surprised since it’s something that is somewhat state-of-the-art.

Thanks!

Hi @mvdb
I think it depends on your data.
It is possible to do with the new expressions in 0.35:
https://www.metabase.com/docs/latest/users-guide/expressions.html

case(between([Created At], "2016-01-01", "2016-12-31"), "Event A", between([Created At], "2017-01-01", "2017-12-31"), "Event B", "Event C")

1 Like

Thanks @flamber for pointing this out. I’ve upgraded our Metabase to the latest version and it now works :pray: