Post Functions

26 Articles in this category

Print
Dark

Light

Post Functions

26 Articles in this category

Dark

Light

Post Functions - Overview

Description Post Functions allow inter-row calculations to be carried out on the rows returned from a raw multi-function profile result set. Purpose Use Post Functions to; format data plot cumulative graphs calculate logarithms calculate mul...

asint

asint Returns the current row as an integer Purpose Use this function to: Make results more readable to end-user Calculation If current row = 34.12, returns 34 Sample Result Pa...

as(percent)

as% Multiplies current Row by 100 Purpose Use this function to: Quickly format a column to be displayed as a percentage Calculation If current row = 0.34, returns 34.00 Sample Resu...

as(percent)i

as%i Multiples current row by 100 and displays as an integer Purpose Use this function to: Quickly format a result to display as a percentage Calculation If current row = 0.34, return...

cumul

Successively adds the current row to the previous row Purpose Use this function to: Sum information gathered over time Show how sales have increased since the beginning of the year Calculate “how much so far” Calculation cumul(RowX)=...

cumul(percent)

Adds the current row to the previous row and displays it as a percentage of the overall cumulative total Purpose Use this function to: Add a percentage from one period to the percentage of another period. Create Pareto charts Calcula...

cumul7avg

Successively adds the current row to the previous row and returns the average of the previous seven rows. The first 7 rows will return NULL Stage 1: Calculate cumulative running total Stage 2: Calculate average running total of prev...

delta

Post Function: [delta] Returns the difference between RowX and Row(X-1) for the specified measure i.e., Subtracts the previous row from the current row. First row is NULL Purpose Use this function to: See how a measure changes from on...

delta(percent)

PostFunction: [delta%] Returns the change between rows as a percentage of the total change between the first and last rows in the result-table. Calculates the difference between current row and previous row (deltaX) Calculates the total cha...

delta7avg

Returns the difference in 7 row average between current row and previous row Calculates the average for the previous seven rows Calculates average for current row and previous 6 rows Calculates difference between the 2 aver...

delta7avg(percent)

Returns the difference in 7 row average between current row and previous row as a percentage of the sum of all 7 row averages Purpose Use this function to: Calculate changes in rolling 7 day averages as a percen...

lgdelta

Returns the difference between the natural logarithm for the current row and the natural logarithm for the previous row Purpose Use this function to: Calculate the change in logarithm Calculation ...

log

Post Function: [log] Returns the natural logarithm of the specified measure. log=Log_e^.Measure If measure = 97,825, what power must e (2.7182818) be raised to in order to get 97,825? log(97,825) = 11.49 or e^11.49

zdelta

PostFunction: [zdelta] Returns the difference between current row and previous row for the specified measure. i.e., Subtracts the previous row from the current row. First row is 0.00 Note: to have first row returned as null, see Post...

zscore

Returns the Z-score for the current row and result set Purpose Use this function to: Measure the distance of the observation from the average Calculate the standardized distance from the mean Calculation ...

2dcumul

2dcumul Successively adds the current row to the previous row, and restarts the count each time dimension 1 changes Requires 2 dimensions in order to accumulate (2d) Successively adds current row to the previous row’s ac...

2ddelta0

2ddelta0 Returns the difference between the current row and previous row for the specified measure, resetting each time dimension 1 changes Requires 2 dimensions (2d) If only 1 dimensions specified, will always return Curren...

2dzdelta0

2dzdelta0 Returns the difference between the current row and previous row for the specified measure, resetting each time dimension 1 changes Requires 2 dimensions (2d) If only 1 dimensions specified, will always return Curre...

2dratio0

2dratio0 Divides the current row by the row that preceded it. Requires 2 dimensions (2d) Divides the current row by the previous row. (ratio) Resets each time the first dimension changes. (0) Purpose ...

2dseq

2dseq Returns an increment of the number of rows since dimension 1 changed Requires 2 dimensions (2d) (Otherwise will always return 1.00) Increments each row (seq) Purpose Use this function to:&nbs...

2dYTD

2dYTD Adds the current row to the cumulative total and resets when the year changes Adds the current row to the running total (TD) If the year of the date-time field changes (eg from 2019 to 2020), resets the sequence to the runn...

2d12lift0

2d12lift0 (A - B) divided by B, where B is 12 rows prior to A. Calculates ratio of Row(X) -Row(X-12) (12) Divides ratio by Row(X-12) (lift) Resets when dimension 1 changes. (2d) Result of first 12 rows in the sequence...

2d12ratio0

2d12ratio0 Divides the current row by the row that was 12 rows before it. Requires 2 dimensions (2d) Divides the current row by the row 12 rows before it. (12ratio) Resets the row counter when dimension 1 chang...

7avg

Returns the mean of the previous seven rows Takes the previous 7 rows, adds them up, and divides by 7. The first 7 rows will return NULL Purpose Use this function to: Calculate moving 7 day average Smooth out peaks and troughs in data s...

7avg(percent)

Returns the 7avg (mean of previous seven rows) as a percentage of the sum of all 7avg values The first 7 rows are returned as NULL The sum of all 7day values is calculated by adding together the 7day values for each row in the...

(percent)

% Returns the current row value as a percentage of the resultset total i.e., the percent of the overall total that is returned by the current row Purpose Use this function to: Calculate the row as a percent o...