Pivot 2.0 is an alpha feature that is disabled by default. See About experimental features for more information about alpha features.
Pivot 2.0 overview
Pivot 2.0 is a new, alpha-stage visualization engine that simplifies and accelerates building visualizations from data that you query. The visualizations in Pivot 2.0 are also highly configurable. With Pivot classic, generating a visualization involved fetching the entire data set returned by a query. This doesn't always scale for very large data sets. Pivot 2.0 works in a way that is comparable to "infinite scrolling" websites, in which data is retrieved dynamically.
Pivot 2.0 features
Pivot 2.0 includes a variety of visualization types to help you draw insights from your data. In addition, it offers these new capabilities:
- Most visualizations can display more than two dimensions.
- You can add multiple tiles to a visualization to compare values of a given dimension, such as in this line chart example.
- You can compare against a relative time, a specific time, and against other measures.
- You can reliably download the data behind any visualization.
Use Pivot 2.0
You can use Pivot 2.0 as follows:
Enable Pivot 2.0 from the Feature flags tab in Settings. See Feature Flags for more information.
In the data cube, choose Pivot 2.0 from data view options menu.
To exit Pivot 2.0, choose Pivot Classic from the data view options menu.
Visualizations in Pivot 2.0
New types of visualizations are regularly added to Pivot 2.0, and the following types are currently available:
- Table view
- Line chart
- Vertical bar chart
- Total value
The table view is the default view for string dimensions. This view makes it easy to see totals and subtotals for the dimensions that you choose. You can expand and collapse nested values to drill down on the values that you want to see. For example, the following table view shows the total number of Wikipedia edits in the latest day. It has nested rows for the dimensions "Country Name" and "City Name", and the rows for cities in the United Kingdom are expanded:
You can add as many dimensions and measures as you want by adding them to the Rows, Columns, or Measures fields in the right sidebar. If you want to reorder nested rows or columns, you can click and drag individual dimension or measure names in the right sidebar to move them.
A line chart shows how a trend changes over time. Therefore, in Pivot 2.0, the X-axis of a line chart must be a continuous dimension, such as
__time. The following example shows the number of Wikipedia edits over the last day:
You can also add more than one tile to a Pivot 2.0 line chart visualization by adding one or more dimensions to the Multiples field in the right sidebar. The above example is comparing the number of edits made in various countries. You can also add more than one line to a line chart by adding a dimension to the Layer field of the right sidebar to compare values of that dimension. Each tile in the above example is comparing how many edits were made in various cities within each country.
You can further customize your line chart by clicking the Paint icon in the right sidebar.
Vertical bar chart
The vertical bar chart in Pivot 2.0 lets you stack different values of a given dimension so that you can compare them. For example, the following graph shows the number of events stacked by browser version for the latest day:
Pivot 2.0 lets you specify the data that you want to download. When you click the download icon in the top navigation bar, the Download data page appears:
|Filename||Specify the name of the file you want to download|
|Max columns to download||Specify the maximum number of columns you want to download|
|Max rows to download||Specify the maximum number rows you want to download|
|Format||Specify the file format you want your download to have|
|Include metadata||Check this if you want your download to include metadata|
After you click Download, you see a bar that indicates the progress of your download.