Aggregate with Roll-ups

Deephaven's Roll-up tables allow you to pinpoint and display a specific dataset from a table. We've already covered how to create Roll-ups programmatically using DQL, but in Deephaven Classic you can also create a roll-up directly from the user interface.

Create Roll-ups in the UI

In Deephaven Classic, creating a Roll-up of your table data is as easy as a few clicks.

Right-click anywhere within the table data and select Create Roll-up:

The dialog offer several options to group and aggregate your data.

The Column Grouping tab controls how the table will roll-up. The left side shows the available columns in the table, and you can drag any column to the right to make your selections.

The Aggregations tab configures the aggregation operations in the resulting Roll-up table.

First, select an aggregation from the drop down menu on the left, then click Add Aggregation. A list of available columns with checkboxes will appear on the right; select which columns should be aggregated for each type of aggregation.

You may select as many aggregations as you like. Finally, selecting Apply will create and display the configured Roll-up.

Right-click your Roll-up to see more options - you can edit your parameters or save your Roll-up settings to reapply them again.

To learn more about Roll-up tables, such as their linking behaviors, see Create Roll-ups in the User Guide.