Groups data by values in two columns creating a matrix with as many rows as there are distinct values in field1 and as many columns as there are distinct values in field2. The matrix contains the sum of values in the specified value field that belong to the corresponding value combination of field1/field2
hsGroupBy2Fields(frmData, strValField, strField1, strField2, boolDesc1 = FALSE, boolDesc2 = FALSE)
| frmData | data.frame containing data to be grouped. |
|---|---|
| strValField | name of value field (= column in frmData) |
| strField1 | name of first field to be grouped by |
| strField2 | name of second field to be grouped by |
| boolDesc1 | if TRUE, columns in result matrix will be ordered according to decreasing values of field1 |
| boolDesc2 | if TRUE, rows in result matrix will be ordered according to decreasing values of field2 |
matrix with as many rows as there are distinct values in field1 and as many columns as there are distinct values in field2 of the input data.frame. The matrix contains the sum of values in the specified value field of the input data.frame that belong to the corresponding combination of values in field1/field2