Big picture: I’m trying to build a funnel report that shows me the number of users who viewed page A -> page B -> page C.
In my view, there is a measure that counts the number of distinct users
distinct_users. I can easily create a filtered measure if I want to see how many users viewed page A, by filtering on
page=A. Further, to make the choice of page dynamic, I can use templated filters as well.
However, I want to be able to use the same measure multiple times in the report with different dynamic filters i.e. I’d like to use the
distinct_users measure 3 times on the Look, once each for pages A, B and C.
In theory I could duplicate the measure, but that doesn’t seem like a scalable solution if my funnel is extended to 5 steps. What are some possible elegant solutions to this?