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.
- Numbers 0-1M
- Numbers -1M-0
I am trying to group the numbers into ranges that I define.
How do I perform custom grouping for typecast numbers in Insights of Profile Analysis?
Best answer by stephanie
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!