Pivot Data

Hardik Chheda Updated by Hardik Chheda

In Tellius, data aggregation is a process in which the data is presented in a summary form for the purpose of statistical analysis.

You create data aggregation within solution to get more information about particular groups on a specific variable.

You can aggregate the data by grouping particular columns, by grouping date and time columns, or by creating pivot on certain columns.

This topic explains about the Pivot Data Aggregations.

  1. On the dataset Edit page, click the Aggregate icon.
  2. On the Aggregate Columns page, click the Pivot tab.
  3. Enter the appropriate values in the following fields:
    • Select rows: Select the field that you want to displays in rows.
    • Select columns: Select the field that you want to displays in rows 
    • Aggregate column: Select the column that you want to calculate for aggregate.
    • Aggregate type: Select the mathematical function that you want to use for calculation.
    • (Optional) Add an aggregation column to add additional aggregate column and type.
    • (Optional) Advanced Filters to add filter condition for your aggregate.
  4. Click Next.
  5. Select the option whether you want to modify the existing dataset or create a new dataset for this aggregation.
    1. To create a new dataset, select the option whether you want to create a link to the original dataset (Link) or save the dataset to the server (Save).
  6. Select Count or Ratio and enter the count or percentage of records that you want use from the dataset.
  7. Click in the Dataset name field and enter the unique name for the dataset.
  8. Click Submit.

Did we help you?

Time-Series Aggregation