I think that what you want is a single value count, you can put two things to make this work
"Count" and "where"
SELECT count(useraction.name) FROM usersession where useraction.name="AppStart (easyTravel)"
This query will bring to me the count of the user action name AppStart (easyTravel)"
Thanks for your feedback, but the number will not be accurate,
I want for sur the count for the last step, but for whome that are followe the specific journey.
Journey: action A, action B, action C
with your query, the count of (c) will be made even if the user wasnt make the action A and/or B whcih is not what I want.
oh okay, got it.
You can do this with "and" expression like this
in this query you get what you want action A, Action B, Action C but only will show up the value of action C.
SELECT COUNT(*) FROM usersession where useraction.name = "AppStart (easyTravel)" AND useraction.name = "searchJourney" AND useraction.name = "bookJourney"
SELECT FUNNEL (useraction.name = "AppStart (easyTravel)", useraction.name = "searchJourney", useraction.name = "bookJourney")
The result of the two queries above will be almost the same but when we use "and" expression we bring only the journey that passed thru Action A,B, C
When we use funnel we see the Journey that passed the thru A, A And B and A,B,C