Skip to main content
Version: Python

How to create rollup tables in the UI

A rollup table combines Deephaven's powerful aggregations with an easy-to-navigate hierarchical structure. This guide will show you how to create a hierarchical rollup table in the UI, using the Rollup Rows feature in the Table Options menu. To learn how to create rollup tables via queries, see How to create a hierarchical rollup table programmatically.

Rollup Rows

Simply drag the column by which you want to group the table into the Group By section of the dialog:

img

In the result table, only the first and second levels are initially expanded. Levels can be expanded by clicking on the right-facing arrow in a corresponding by column. Hover over a column header for details. For example, we can see that the "Size" column is aggregated by "First" by default:

img

To change the aggregation, go back to the Table Options menu and select a different aggregation from the Aggregations dropdown:

img

Selecting multiple grouping columms will create a multi-level rollup table. In the example below, the table is grouped by "Exchange" and "Instrument".

img

When the Consitituents box is unchecked, the rows from the original table that were aggregated are hidden:

img

Similarly, all the original columns in the table are shown by default. To hide the non-aggregrated columns, uncheck the Non-Aggregated Columns box:

img