Mixpanel Community Icon
Join Our Community
Community Questions

How to Calculate Median Core Product Actions Before User Upgrades

Avatar of Jens W.Jens W.
·
·

Hi there, I'm trying to keep track of a funnel:

  • Trail Sign Up

  • Core Product Action

  • Paid Plan Upgrade

I want to know the median count of the Core Product Action before a user Upgrades. Does anyone know how I best can do this? I've been trying out JQL, but with limited success and I can't find it in the dashboarding option. I'm hoping I don't have to migrate all my data to a datawarehouse to run some queries on it.... Any thoughts?

4 comments

  • Avatar of Tomas G.
    Tomas G.
    ·
    ·

    what about a breakdown by frequency? its not exactly median, but you could somehow calculate it?

  • Avatar of Jens W.
    Jens W.
    ·
    ·

    Oh this is amazing!! Thank you

  • Avatar of Jens W.
    Jens W.
    ·
    ·

    Do you know if there is a way to create buckets manually? E.g. [0-1 times], [2-4 times] [5+ times]?

  • Avatar of Tomas G.
    Tomas G.
    ·
    ·

    Jens W. yeap just select customize buckets

    🦸1