When Amplitude launched its new Knowledge Tables reporting interface, it created a brand new method 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 aspect by aspect. Knowledge Tables additionally present a technique 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 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 the whole lot 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 gasoline that helps us repeatedly construct higher merchandise.
One of many function requests we obtained from prospects associated to Knowledge Tables was the flexibility to pivot the columns and rows. Many shoppers are specialists in spreadsheet pivot tables and wished to deliver 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 if you need to view a number of metrics/occasions aspect by aspect or completely different variations of a metric/occasion. For instance, you could need to see Lead Type Completions from completely different cities. To do that, you’ll add the Lead Type Accomplished metric/occasion to the desk after which add a distinct cohort for the cities you need to give attention to. As well as, the columns of metrics/occasions may also be damaged down by your Amplitude properties. Property values are sometimes added within the leftmost column as you would possibly in a spreadsheet. For instance, you would possibly need to view the Lead Type Accomplished metric/occasion by the day of the week on which the occasion occurred. Should you deliver all of this collectively right into a Knowledge Desk, you may 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 Type Completions. However there could also be occasions if you would need to pivot this information to see the columns as rows and the rows as columns. A technique 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 individuals in our product. As soon as you’re taking information out of Amplitude, it turns into tougher to dig deeper into the information and ask secondary and tertiary questions.
As talked about earlier, we’ve made it straightforward to pivot Knowledge Tables by merely clicking a button. Right here is how the previous desk might 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 would possibly appear like after being pivoted:
If wanted, you can even rearrange the order of the columns to fulfill your wants. For instance, you could need to reorganize the Day of Week columns to be in a extra logical order. This may be carried out by merely dragging the columns as wanted. You may select to type on any column. If wanted, you’ll be able to export the information as soon as information is pivoted.
The Tremendous Print
There are some conditions the place pivoting information in Knowledge Tables isn’t possible. Usually, these are conditions the place you carry out extra superior reporting in Knowledge Tables, and pivoting the information would produce advanced outcomes. These embody:
- Utilizing session metrics
- Utilizing metrics with attribution utilized
- Utilizing rows which have nested properties
- Utilizing columns that present non-absolute numbers
If in case you have one in every of these situations 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 might be helpful for visualizing your information in several methods, there are some particular use circumstances the place pivoting Knowledge Tables might be particularly useful:
- If in case you have many metrics/occasions you need to view collectively and don’t have a necessity to interrupt these occasions down by a property, viewing occasions as rows as an alternative of columns permits you to view extra on one display (vertically as an alternative of horizontally)
- Viewing metrics/occasions as rows as an alternative of columns so you should utilize the type perform to view occasions by quantity (descending or ascending)
- Viewing dates as columns as an alternative of rows is an effective technique to see information over time. For instance, you could create a Knowledge Desk that appears like this:
Then you’ll be able to pivot the information to appear like this:
We look ahead to seeing how our prospects benefit from this new pivot performance!
