How to use Total in Funnel visualization

How do I use the Total value (38,484) instead of the max value (29,449) here as the top of the funnel?

c26ab658-f758-4247-b690-32a73095591c.png
0 1 217
1 REPLY 1

Naomi_Johnson
Participant III

Hi angelahuang,

When using a funnel visualisation,  the profiles should be counted in every step they’ve been through, to ensure the conversion is correct. For example, the second activity type should also include the profiles who have passed this step, up to completing the funnel (11,912 + 10,639 + 4,894 + 450 + 244) as all of these profiles have technically completed the second step.

You are able to do this with a table calculation:

sum(offset_list(${conversion_metrics.count_distinct_profile},0,max(row())))

You can then hide your original measure and use this table calculation in your visualisation.

I hope this helps.

Naomi

Top Labels in this Space
Top Solution Authors