Four Useful Ways To Chart Numerals

There are lots of uses for sending numbers to Mixpanel, especially in Insights reports.

Let's say you were instrumenting a music sharing site, and with every “Song Played” event you sent a property that recorded the length of the song in seconds. Let's call this property "Length". If you send the property as an integer or decimal (122 or 3.45), Mixpanel will detect it as a number.

Your event call and the associated "Length" property could look something like this:

mixpanel.track("Song Played",{"Length":122});

Build Histograms to Review Your Data

Building a histogram is an excellent way to see how your data is distributed. How many times are long songs being played? Building a histogram is as simple as opening an Insights report and choosing the "song played" event then segmenting based on your numeric "Length" property.

Here's an example of such a histogram. You can see the distribution of the length of all songs which have been played on my app:


Dive Deeper into Your Data with Filters

Maybe you only care about how many times people play long songs. To dig deeper into this data, you can select certain subsets by filtering with greater than or less than operators. To better understand the distribution of long songs and develop a more granular report, use the "Length" property as a filter!

So, how many times are songs between 150 and 250 seconds being played?


It looks like a lot of users are listening to longer songs!

Averages, Maxes, and Mins

Seeing how many long songs your customers play may be useful, but what if you wanted to know what the typical length of a song played is? Sounds like you need an average! To calculate averages, instead of applying a filter or creating a histogram, you can change the "TOTAL" drop-down to "AVERAGE". In a time-series, this will show how your average song length fluctuates over time. Use this same drop down to investigate changes in mins, maxes, median, unique users, and total users as well!


Relabel Your Properties by Typecasting

Sometimes — though not often — Mixpanel might miss that the property you are sending is in fact a number. If you are sending a property as a number but Mixpanel is not detecting it as a number, you can typecast it by selecting the typecast button next to the property and selecting the Number option.


Related: What data types does Mixpanel accept as properties?

Is this article helpful?
3 out of 13 found this helpful



Article is closed for comments.