Binning & Regrouping Aggregates / Creating a "histogram"

[conner (Conner from Omni)]

A common workflow is taking a table, aggregating it, and then analyzing patterns in the aggregation. For example: take an orders table, aggregate it to count of orders per user, and then understand % of users per count of lifetime orders. Often, this results in a histogram-type chart that plots the number of values that fall into a given range.

In Omni, this binning & regrouping workflow is simple with our Saved Views feature:

1. Aggregate your table (i.e. aggregate orders to orders per user)
2. Save the query as a view
3. Navigate to all views & fields to find the table
4. Bin values using the Bins UI
5. Select the binned field and the count field, and then visualize

Here’s a quick video showing how this works in practice: