Roll up

Definition

Returns a GroupBy clause and extra rows that represent the subtotals for all combinations of grouping columns. Roll up does not create all possible grouping sets.

Options

1. Roll up columns (+add):

2. Agg function (+add):

Parameters

1. Column input:

   • Def: Specify the name of the column.

2. Column output:

   • Def: Specify the name of the column.

3. Function:

   • Def: Specify the function to use.

Additional Comment

The ROLLUP assumes a hierarchy among the input columns. See example

Functions:

1. count:

   • Def: Count the element in the Column input for each group.
     Link to the Count page.

2. sum:

   • Def: Sum all the element of the Column input for each group.
     Link to the Sum page.

3. avg:

   • Def: Returns the average of the Column input for each group.
     Link to the Average page.

4. mean:

   • Def: Returns the mean of the Column input for each group.

5. var:

   • Def: Returns the variance of the Column input for each group.
     Link to the Var page.

6. std:

   • Def: Returns the standart deviation of the Column input for each group.

7. max:

   • Def: Returns the maximum value of the Column input for each group.
     Link to the Max page.

8. min:

   • Def: Returns the maximum value of the Column input for each group.
     Link to the Min page.

Example

ROLLUP(YEAR,MONTH,DAY)
->
YEAR,MONTH,DAY
YEAR,MONTH
YEAR