Skip to main content

Pivot and Flat Tables

Overview​

Rill's multi-dimensional pivot provides lightning fast Excel style pivot tables across multiple dimensions, time granularity and metrics. The interface allows users to drag and drop any combination of fields for quick comparison and report generation. While the Explore view is great for data discovery, the Pivot view serves other use cases like:

  • Regular reporting: Monthly financial reports, campaign reporting, client reports
  • Time analysis: Dimensions by time columns for daily or weekly comparisons
  • Data export: Scheduled exports for generating CSVs for external analysis (coming soon)

Using Rill's Pivot View​

Pivots can be split by time, measures and dimensions. You can drag and drop any of these options to rows and columns to create your pivot table (and can drag between columns/rows as well). Dimensions are also searchable in the top left or select the + to see the dimension list. As each dimension is added, you can track the kernels on the top left to see which rows have been added to the table. Each column dimension will also be visualized in the pivot. Like Time Dimension Detail, the same filter bar can be used to filter the pivot table overall.


Measures as splits

Measures can only be used as columns splits to define which metric is to be used in the table and cannot be added to the rows filter

As new dimensions are added to the table, the comparison will aggregated by default and can be expanded as you navigate the table. Pivot tables can then be scrolled through to quickly navigate the row/column combinations. If a given split does not have any valid data, no data will be displayed in the cell. Select the window button on the top left of the pivot table to expand the view to full screen. To quickly reset all the expanded rows in the pivot table, you can select collapse all in the top left.


Flat Tables​

While Pivot tables are a powerful tool to splice and dice your data into different configurations, sometimes a simple flat table is all you need. By selecting the toggle next to Columns you can swap between pivot and flat tables. Unlike Pivot, where it gives you options to add both row and columns dimensions, a flat table will only allow you to add columns.