Please enter your comment!
Please enter your name here

When Amplitude launched its new Knowledge Tables reporting interface, it created a brand new manner for Amplitude prospects to visualise their information. Knowledge Tables permit prospects so as to add a number of occasions/metrics to a desk and see them facet by facet. Knowledge Tables additionally present a method to view occasions/metrics by a number of properties via property breakdowns.

Since its launch, Knowledge Tables has rapidly change into the fourth hottest information visualization in Amplitude’s analytics product. That is the quickest {that a} new visualization has risen in recognition over the previous ten years! We count on the Knowledge Desk visualization to be much more standard when extra prospects uncover it over time.

However like every part in Amplitude, our prospects at all times ask us for extra. Amplitude prides itself on listening to buyer suggestions and utilizing that suggestions to enhance its product. As a product-led progress firm, we imagine that our prospects’ suggestions is the gas that helps us repeatedly construct higher merchandise.

One of many characteristic requests we acquired from prospects associated to Knowledge Tables was the power to pivot the columns and rows. Many shoppers are specialists in spreadsheet pivot tables and wished to carry that performance into Amplitude. The power to pivot Knowledge Tables simply went stay, so on this publish, I’ll share the way it works and supply an instance of its use.

Knowledge Tables

For these not acquainted, Amplitude Knowledge Tables are helpful while you wish to view a number of metrics/occasions facet by facet or completely different variations of a metric/occasion. For instance, it’s possible you’ll wish to see Lead Kind Completions from completely different cities. To do that, you’ll add the Lead Kind Accomplished metric/occasion to the desk after which add a unique cohort for the cities you wish to concentrate on. As well as, the columns of metrics/occasions will also be damaged down by your Amplitude properties. Property values are usually added within the leftmost column as you would possibly in a spreadsheet. For instance, you would possibly wish to view the Lead Kind Accomplished metric/occasion by the day of the week on which the occasion occurred. For those who carry all of this collectively right into a Knowledge Desk, you might need a view like this:


The Knowledge Desk proven above makes it straightforward to see the intersection of Metropolis and Day of Week for Lead Kind Completions. However there could also be instances while you would wish to pivot this information to see the columns as rows and the rows as columns. A method to do that can be to export the Knowledge Desk to a CSV file and create a pivot desk there, however at Amplitude, we’re followers of conserving folks in our product. As soon as you’re taking information out of Amplitude, it turns into harder to dig deeper into the info and ask secondary and tertiary questions.

As talked about earlier, now we have made it straightforward to pivot Knowledge Tables by merely clicking a button. Right here is how the previous desk may be pivoted:


As soon as the Knowledge Desk has been pivoted, you possibly can resize one or all columns or use the auto-fit perform to dimension every column appropriately. Here’s what the ensuing Knowledge Desk would possibly appear like after being pivoted:


If wanted, it’s also possible to rearrange the order of the columns to fulfill your wants. For instance, it’s possible you’ll wish to reorganize the Day of Week columns to be in a extra logical order. This may be completed by merely dragging the columns as wanted. You may select to kind on any column. If wanted, you possibly can export the info as soon as information is pivoted.


The Tremendous Print

There are some conditions the place pivoting information in Knowledge Tables is just not possible. Sometimes, these are conditions the place you carry out extra superior reporting in Knowledge Tables, and pivoting the info would produce complicated outcomes. These embody:

  • Utilizing session metrics
  • Utilizing metrics with attribution utilized
  • Utilizing rows which have nested properties
  • Utilizing columns that present non-absolute numbers

When you’ve got considered one of these eventualities in your Knowledge Desk, the pivot perform will likely be disabled and you will notice the next warning:


Different Pivot Desk Use Circumstances

Whereas pivoting information may be helpful for visualizing your information in several methods, there are some particular use instances the place pivoting Knowledge Tables may be particularly useful:

  • When you’ve got many metrics/occasions you wish to view collectively and don’t have a necessity to interrupt these occasions down by a property, viewing occasions as rows as a substitute of columns lets you view extra on one display screen (vertically as a substitute of horizontally)


  • Viewing metrics/occasions as rows as a substitute of columns so you should utilize the kind perform to view occasions by quantity (descending or ascending)


  • Viewing dates as columns as a substitute of rows is an efficient method to see information over time. For instance, it’s possible you’ll create a Knowledge Desk that appears like this:


Then you possibly can pivot the info to appear like this:


We stay up for seeing how our prospects benefit from this new pivot performance!

Pivoting Knowledge Tables – Adam Greco