Niels Thomsen
Articles
-
How to handle null values in dates when calculating on dates
Note: This article doens't explain how to do general calculations on dates - that's explained here: Date calculations – TARGIT CommunityOnce you figured out how to calculate on dates, using the ref...
-
Spread of data (as a column)
Type: Inserted as a columnDescription: Calculates the difference between maximum value and minimum value.Range:Columns: All columnsRows: Each rowMeasures: First measureSyntax:max(all, 0, m1) - min(...
-
Spread of data (as a row)
Type: Inserted as a rowDescription: Calculates the difference between maximum value and minimum value.Range:Columns: Each columnRows: All rowsMeasures: First measureSyntax:max(0, all, 0) - min(0, a...
-
Index last column based on second last column (as a column)
Type: Inserted as a columnDescription: Calculates last column value as index of second last column value.Range:Columns: Last column as index of Second last columnRows: Each rowMeasures: First measu...
-
Difference percentage between current row and previous row (as a column)
Type: Inserted as a columnDescription: Calculates the difference, as a percentage, between two values, current row and previous row.Range:Columns: Last columnRows: Current row minus Previous rowMea...
-
Index first column based on second column (as a column)
Type: Inserted as a columnDescription: Calculates first column value as index of second column value.Range:Columns: First column as index of Second columnRows: Each rowMeasures: First measureSyntax...
-
Centered 3 months average (measure)
Type: Inserted as a measureDescription: Calculates the average of 3 months' intervals - from 1 month before to 1 month after any month, in each column.Range:Columns: Each columnRows: 3 rows interva...
-
Centered 3 months average (as a column)
Type: Inserted as a columnDescription: Calculates the average of 3 months' intervals - from 1 month before to 1 month after any month.Range:Columns: Last columnRows: 3 rows intervalsMeasures: First...
-
Maximum value (as a column)
Type: Inserted as a columnDescription: For each row, returns the maximum value among all column values.Range:Columns: All columnsRows: Each rowMeasures: First measureSyntax:max(all, 0, m1)Sample cr...
-
Percentage within each hierarchy group (as a column)
Type: Inserted as a columnDescription: Calculates each row value as a percentage of the total of all row values within each hierarchy group.Range:Columns: Last columnRows: Each row (siblings)Measur...