Solved

How to create a historgram in Insights with typecast data?

  • 5 February 2020
  • 1 reply
  • 302 views

I am running Insights > Profile Analysis.

I did a breakdown by a property and typecast the value to a Number.

The resulting output groups data into two bucks.

  1. Numbers 0-1M
  2. Numbers -1M-0

I am trying to group the numbers into ranges that I define.

Example

  • 0-800
  • 801-1200
  • 1201-2000
  • etc

How do I perform custom grouping for typecast numbers in Insights of Profile Analysis?

icon

Best answer by stephanie 11 February 2020, 22:51

@Taylor Wimberly By default Mixpanel tries to group number type properties together to make them easier to extrapolate data from. When typecasting these to a string, you will prevent Mixpanel from grouping them up as a range.

However, if you like the values grouped but to define the grouping,  custom properties will resolve this use case. Here is the public documentation for this feature. 

Example use-cases include:

  • Create custom buckets to group your property values into.

    • Example: An insurance company wanted to calculate the total claims by age group, but is only tracking the age of the claimant. With this release, they can create a new property where they can track age groups as “0-15” as “Underage Drivers, “16-25” as “Young Adult Drivers”, “25-60” as “Adult Drivers” and “60+” as “Senior Drivers”.

  • Merge property values to fix implementation issues

    • Example: A marketing manager wants to understand what portion of the user base is coming through a social traffic acquisition path. They want to group all social channel values into a single value, and keep the rest of the channels as-is. With this release, they can now create a new property (for e.g. Modified channel) and start mapping Facebook, Twitter and LinkedIn channel parameters into a new value ("Social") and keep the rest of the values the same, and run their analyses on this new property. 

  • Create new properties based on the values of different properties

    • Example: A marketplace company wants to track total purchase amount for an order, but the per-unit price and the number of items are passed as properties and not the total price. With this release, this company can create a new property called Total Purchase price, which is calculated as a product of the per-unit price and the number of items.

Hope this helps!

View original

1 reply

Userlevel 4
Badge +4

@Taylor Wimberly By default Mixpanel tries to group number type properties together to make them easier to extrapolate data from. When typecasting these to a string, you will prevent Mixpanel from grouping them up as a range.

However, if you like the values grouped but to define the grouping,  custom properties will resolve this use case. Here is the public documentation for this feature. 

Example use-cases include:

  • Create custom buckets to group your property values into.

    • Example: An insurance company wanted to calculate the total claims by age group, but is only tracking the age of the claimant. With this release, they can create a new property where they can track age groups as “0-15” as “Underage Drivers, “16-25” as “Young Adult Drivers”, “25-60” as “Adult Drivers” and “60+” as “Senior Drivers”.

  • Merge property values to fix implementation issues

    • Example: A marketing manager wants to understand what portion of the user base is coming through a social traffic acquisition path. They want to group all social channel values into a single value, and keep the rest of the channels as-is. With this release, they can now create a new property (for e.g. Modified channel) and start mapping Facebook, Twitter and LinkedIn channel parameters into a new value ("Social") and keep the rest of the values the same, and run their analyses on this new property. 

  • Create new properties based on the values of different properties

    • Example: A marketplace company wants to track total purchase amount for an order, but the per-unit price and the number of items are passed as properties and not the total price. With this release, this company can create a new property called Total Purchase price, which is calculated as a product of the per-unit price and the number of items.

Hope this helps!

Reply


Mixpanel