Niels Thomsen
Articles
-
Minimum value (as a row)
Type: Inserted as a rowDescription: For each column, returns the minimum value among all row values.Range:Columns: Each columnRows: All rowsMeasures: Each measureSyntax:min(0, all, 0)Sample crossta...
-
Maximum value (as a row)
Type: Inserted as a rowDescription: For each column, returns the maximum value among all row values.Range:Columns: Each columnRows: All rowsMeasures: Each measureSyntax:max(0, all, 0)Sample crossta...
-
Accumulated count of values (as a measure)
Type: Inserted as a measureDescription: Calculates an accumulated count of cells (excluding empty cells) from first row to each row.Range:Columns: Each columnRows: From first row to each rowMeasure...
-
Accumulated count of members (as a column)
Type: Inserted as a columnDescription: Calculates an accumulated count of cells (including empty cells) from first row to each row.Range:Columns: Last columnRows: From first row to each rowMeasures...
-
Count row values (as a measure)
Type: Inserted as a measureDescription: Counts number of values (excluding empty cells) in each column.Range:Columns: Each columnRows: All rowsMeasures: First measureSyntax:count(0, all, m1)Sample ...
-
Count column values (as a column)
Type: Inserted as a columnDescription: Counts number of values (excluding empty cells) in each row.Range:Columns: All columnsRows: Each rowMeasures: First measureSyntax:count(all, 0, m1)Sample cros...
-
Count column members (as a column)
Type: Inserted as a columnDescription: Counts number of cells (including empty cells) in each rowRange:Columns: All columnsRows: Each rowMeasures: First measureSyntax:allcount(all, 0, m1)Sample cro...
-
Count row values (as a row)
Type: Inserted as a rowDescription: Counts number of values (excluding empty cells) in each column.Range:Columns: Each columnRows: All rowsMeasures: Each measureSyntax:count(0, all, 0)Sample crosst...
-
Count row members (as a row)
Type: Inserted as a rowDescription: Counts number of cells (including empty cells) in each column.Range:Columns: Each columnRows: All rowsMeasures: First measureSyntax:allcount(0, all, m1)Sample cr...
-
75th percentile (as a measure)
Type: Inserted as a measureDescription: Calculates the 75th percentile of all values in the range.Range:Columns: Each columnRows: All rowsMeasures: First measureSyntax:percentile(0, all, m1, 0,75)S...