I am looking to write a query when I have an error field that is filled when a user cannot continue to make a payment in the last page in funnel. However, not all errors in this field stops the user from proceeding to the last page (payment page)
How can I write a query to find ONLY these errors that stop users from reaching the last page (assuming that funnel is 4 pages where 1st page is homepage, 4th page is payment)?
Example of a valid case: a user who visited home page, proceeded to second page then got an error on 2nd page and could not proceed to 3rd or 4th page.
Example of an invalid case: a user who visited home page, proceeded to second page then got an error on 2nd page but was still able to proceed to 3rd or 4th page.
As you can see the difference of errors are that the first case is blocking the user and the second case, it is not.