Funnel Dashboard - Mask step (s) from the result

[Malaik]

Dear Community members,

I know you missed me :).

I have a FUNNEL Dashboard, but I want to display in the result only the last step.

Is there any way to mask the other first step (s) to be displayed?

Thanks for your help in advance.

BRs,

[natanael_mendes]

I think that what you want is a single value count, you can put two things to make this work

"Count" and "where"

like this

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)"

[Malaik]

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.

Example:
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.

[natanael_mendes]

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"

X

SELECT FUNNEL (useraction.name = "AppStart (easyTravel)", useraction.name = "searchJourney", useraction.name = "bookJourney")
FROM usersession

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

[Malaik]

Thanks for your effort,

But this is not 100% correct, the case is more complicated than that.

The and, will count the journey A, B, C but also A, C, D and all other combinaisons.

So the result with and will not be equal 100% to the FUNNEL