How to build a closed funnel graph?

[igor-okuyama]

I have data from Google Analytics in my Bigquery project which is linked to Looker. I was trying to figure out how to create a closed funnel analysis (similar to what GA4 does, but I want to do it in Looker), in which each user must start from the first step and go through the next ones, in order to be counted in the funnel metrics. I've seen some examples of building funnels only by counting the number of events of each step, but this does not enforce the users to sequentially go through each step or start from the first step. Is there an easy way to create closed funnels?

I understand that it is needed to build a query with many joins (as done in this link), but I was wondering how to do this in Looker in an easy way, maybe without having to copy this large code and adapt it to every funnel report with distinct event steps.