Saturday, April 1, 2023
HomeProduct ManagementPivoting Knowledge Tables - Adam Greco

Pivoting Knowledge Tables – Adam Greco

When Amplitude launched its new Knowledge Tables reporting interface, it created a brand new method for Amplitude clients to visualise their knowledge. Knowledge Tables enable clients so as to add a number of occasions/metrics to a desk and see them aspect by aspect. Knowledge Tables additionally present a method to view occasions/metrics by a number of properties by property breakdowns.

Since its launch, Knowledge Tables has shortly grow to be the fourth hottest knowledge visualization in Amplitude’s analytics product. That is the quickest {that a} new visualization has risen in recognition over the previous ten years! We anticipate the Knowledge Desk visualization to be much more well-liked when extra clients uncover it over time.

However like every little thing in Amplitude, our clients all the time ask us for extra. Amplitude prides itself on listening to buyer suggestions and utilizing that suggestions to enhance its product. As a product-led development firm, we imagine that our clients’ suggestions is the gas that helps us constantly construct higher merchandise.

One of many characteristic requests we acquired from clients associated to Knowledge Tables was the power to pivot the columns and rows. Many purchasers are specialists in spreadsheet pivot tables and needed to carry that performance into Amplitude. The flexibility to pivot Knowledge Tables simply went reside, 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 whenever you wish to view a number of metrics/occasions aspect by aspect or totally different variations of a metric/occasion. For instance, chances are you’ll wish to see Lead Kind Completions from totally different cities. To do that, you’ll add the Lead Kind Accomplished metric/occasion to the desk after which add a special 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 may in a spreadsheet. For instance, you may wish to view the Lead Kind Accomplished metric/occasion by the day of the week on which the occasion occurred. When you carry all of this collectively right into a Knowledge Desk, you may need a view like this:


The Knowledge Desk proven above makes it simple to see the intersection of Metropolis and Day of Week for Lead Kind Completions. However there could also be occasions whenever you would wish to pivot this knowledge 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 preserving folks in our product. As soon as you’re taking knowledge out of Amplitude, it turns into harder to dig deeper into the info and ask secondary and tertiary questions.

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


As soon as the Knowledge Desk has been pivoted, you’ll be able to resize one or all columns or use the auto-fit perform to measurement every column appropriately. Here’s what the ensuing Knowledge Desk may appear to be after being pivoted:


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


The Fantastic Print

There are some conditions the place pivoting knowledge in Knowledge Tables isn’t possible. Usually, these are conditions the place you carry out extra superior reporting in Knowledge Tables, and pivoting the info would produce advanced outcomes. These embrace:

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

In case you have one among these eventualities in your Knowledge Desk, the pivot perform might be disabled and you will note the next warning:


Different Pivot Desk Use Instances

Whereas pivoting knowledge will be helpful for visualizing your knowledge in numerous methods, there are some particular use circumstances the place pivoting Knowledge Tables will be particularly useful:

  • In case you have 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 permits you to view extra on one display (vertically as a substitute of horizontally)


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


  • Viewing dates as columns as a substitute of rows is an effective method to see knowledge over time. For instance, chances are you’ll create a Knowledge Desk that appears like this:


Then you’ll be able to pivot the info to appear to be this:


We stay up for seeing how our clients make the most of this new pivot performance!


Most Popular

Recent Comments