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](Pivot Classic, generating a visualization involved fetching the entire data set returned by a query, which 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. Therefore, you can add filters, measures, and dimensions to your visualization without slowing performance.
Pivot 2.0 versus Pivot Classic
Pivot 2.0 helps you draw insights from your data using a variety of visualization types: . Pivot 2.0 contains all the features of Pivot Classic. Additionally, Pivot 2.0 offers new capabilities that include the following:
- 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.
- Pivot 2.0 includes a new show bar that lets you drag and drop dimensions and measures as rows or columns for your visualization. You can also add a comparison to the show bar: .
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 in the visualization menu:
- Table view
- Line chart
- Vertical bar chart
You can add any view to a dashboard. You cannot mix dashboard panels from Pivot Classic and Pivot 2.0 in a single dashboard.
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 States 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:
In Pivot 2.0, you can view your data at the record level to see all dimensions that are in each record. This view can be useful for certain debugging issues. You can also view your records in groups for specific values of one or more dimensions by adding the dimensions to the show bar.
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.