The prod function returns the product of the column, evaluated within groups defined by the group parameter if required.
The attribute used to evaluate the product. Multiple attributes can be specified, as long as they are enclosed in double brackets, i.e. column((column1, column2)). The column parameter is mandatory.
The attribute by which you want to group your results. Multiple attributes can be specified, as long as they are enclosed in double brackets, i.e. prod(column,(group1,group2)).
The following example uses the Prod dataset.
In this example, we want to evaluate the product of all the values within the Var_2 attribute, grouped by the Var_1 attribute’s values. Add a new attribute, then type the following formula:
The results can be read as follows: