Niels Thomsen
Articles
-
25th percentile (as a measure)
Type: Inserted as a measureDescription: Calculates the 25th percentile of all values in the range.Range:Columns: Each columnRows: All rowsMeasures: First measureSyntax:percentile(0, all, m1, 0,25)S...
-
75th percentile (as a column)
Type: Inserted as a columnDescription: Calculates the 75th percentile of all values in the range.Range:Columns: Last columnRows: All rowsMeasures: First measureSyntax:percentile(d-1, all, m1, 0,75)...
-
25th percentile (as a column)
Type: Inserted as a columnDescription: Calculates the 25th percentile of all values in the range.Range:Columns: Last columnRows: All rowsMeasures: First measureSyntax:percentile(d-1, all, m1, 0,25)...
-
Rank Descending (as a measure)
Type: Inserted as a measureDescription: Ranks values, in each column, according to their numeric size. Highest value equals rank 1.Range:Columns: Each columnRows: All rowsMeasures: First measureSyn...
-
Rank Ascending (as a measure)
Type: Inserted as a measureDescription: Ranks values, in each column, according to their numeric size. Lowest value equals rank 1.Range:Columns: Each columnRows: All rowsMeasures: First measureSynt...
-
Rank Ascending (as a column)
Type: Inserted as a columnDescription: Ranks values according to their numeric size. Lowest value equals rank 1.Range:Columns: Last columnRows: All rowsMeasures: First measureSyntax:rankasc(d-1, al...
-
Rank Descending (as a column)
Type: Inserted as a columnDescription: Ranks values according to their numeric size. Highest value equals rank 1.Range:Columns: Last columnRows: All rowsMeasures: First measureSyntax:rankdesc(d-1, ...
-
Median (as a measure)
Type: Inserted as a measureDescription: Calculates the median value of all row values in each column.Range:Columns: Each columnRows: All rowsMeasures: First measureSyntax:median(0, all, m1)Sample c...
-
Median (as a row)
Type: Inserted as a rowDescription: Calculates the median value of all row values in each column.Range:Columns: Each columnRows: All rowsMeasures: Each measureSyntax:median(0, all, 0)Sample crossta...
-
Accumulated sum within each hierarchy group (as a measure)
Type: Inserted as a measureDescription: Calculates an accumulated sum of values from first row to each row, within each hierarchy group, in each column.Range:Columns: Each columnRows: From first ro...