Data Views

While Data Pools provide endpoints for ingesting data, Data Views provide endpoints for retrieving data. A Data View is linked to a a single Data Pool and exposes select fields

Grouping

When a field is grouped, aggregated records will be returned for each grouped field. The exact number of rows returned depend on the Data Shape. For Time Series views, this is one record per interval per grouped field. For aggregated views, this is one record per grouped field.

Data Shape

When requesting data from a Data View (via the egress api) the Data can be returned in a few different styles.

Time series

Time series views process data by a time interval. The output will contain one record per interval time (minute, hour, day, etc), per grouped field. The interval is based on a specific field from the data pool and other non grouped fields will be aggregated by a specified aggregation function.

Time series views are helpful for displaying trend charts like line and bar charts.

Aggregated

Aggregated views will return a single record for the entire dataset. All non-grouped fields will be aggregated based on the specified function.

Records

Record views will display raw Data Pool data. Nothing will be aggregated and the Data Pool records will each be returned.

Grouped output

When creating a DataView the GorupedOutput option can be enabled. When output is grouped, egress endpoints will render the data in a hierarchical structure. The output structure is based on grouped fields.

Consider a view with the following fields:

Without output grouping the endpoint will render tabular data:

[
  {date: "1/1/2025", item_name: "item A", sales: 2500},
  {date: "1/1/2025", item_name: "item B", sales: 1800},
  {date: "1/2/2025", item_name: "item A", sales: 1620},
  {date: "1/2/2025", item_name: "item B", sales: 567}
]

With grouped output enabled the output is structured:

{
  "1/1/2025": {
    "item A": [
      { "sales": 2500 }
    ]
    "item B": [
      { "sales": 1800 }
    ]
  },
  "1/2/2025": {
    "item A": [ 
      { "sales": 1620 }
    ],
    "item B": [ 
      { "sales": 567 }
    ]
  }
}