The functions allowed inVizard are described below along with their Syntax, Synonyms, Return Valueand Exampleusage.

SUM

This function is used to calculate sum of parameters at row level.

Syntax: Sum(a), Sum(a,b), Sum(a,b,...)

Synonyms: Total(), Add()

Return Value: Number

Example:

CALC

This function is used to nest functions inside it. If no functions are present inside it, it behaves similar toSUMfunction

Syntax: Calc(a), Calc(a,b), Calc(a,b,...)

Synonyms: Calculate()

Return Value: Number or String depending on arguments

Example:

DIFF

This function is used to calculate difference of parameters at row level.

Syntax: Diff(a,b)

Synonyms: Difference(), Subtract()

Return Value: Number

Example:

PRODUCT

This function can calculate the product of parameters (ab..) at each data row OR on aggregated values.

Syntax: Product(a), Product(a,b), Product(a,b,...)

Synonyms: None

Return Value: Number

Example:

RATIO

Ratio(a,b) function can calculate the ratio of parameters (a/b) at each data row OR on aggregated values.

Syntax: Ratio(a,b)

Synonyms: None

Return Value: Number

Example:

MIN

This function can calculate the minimum of parameters (a,b,..) at each data row OR on aggregated values.

Syntax: Min(a), Min(a,b), Min(a,b,...)

Synonyms: Minimum(), Min()

Return Value: Number

Example:

MAX

This function can calculate the maximum of parameters (a,b,..) at each data row OR on aggregated values.

Syntax: Max(a), Max(a,b), Max(a,b,...)

Synonyms: Maximum(), Max()

Return Value: Number

Example:

AVERAGE

This function can calculate the average of parameters (a,b,..) at each data row OR on aggregated values.

Syntax: Average(a), Average(a,b), Average(a,b,...)

Synonyms: Average(), Avg()

Return Value: Number

Example:

COUNT

This function can calculate the distinctcount of parameters (a,b,..) at each data row OR on aggregated values

Syntax: Count(a), Count(a,b), Count(a,b,...)

Synonyms: Count()

Return Value: Number

Example:

COUNTALL

This function can calculate the non-distinctcount of parameters (a,b,..) at each data row OR on aggregated values.

Syntax: CountAll(a), CountAll(a,b), CountAll(a,b,...)

Synonyms: Count()

Return Value: Number

Example:

ABSOLUTE

This function can calculate the absolute value (positive value) of parameter (a) at each data row OR on aggregated values.

Syntax: Absolute(a)

Synonyms: Absolute()

Return Value: A positive number

Example:

LATEST

This function can calculate the latest value (value with highest timestamp) of parameter (a) of document level parameters.

Syntax: Latest(a), Latest(a, t)

Synonyms: Latest()

Return Value: Number or String depending on arguments

Example:

STRINGCONCAT

This function returns concatenated string of parameters (a, b,...) of document level parameters as well as aggregated values.

Syntax: StringConcat(a), StringConcat(a, b,...)

Synonyms: StringConcat()

Return Value: String

Example:

PERCENTAGE

This function can calculate the percentage of parameters (a, b) at each data row OR on aggregated values

Syntax: Percentage(a)

Synonyms: Percentage()

Return Value: Number

Example:

PERCENTAGEINCREASE

This function can calculate the percentage increase of parameters (a, b) at each data row OR on aggregated values

Syntax: PercentageIncrease(a, b)

Synonyms: PercentageIncrease(), PercentageInc()

Return Value: Number

Example:

YEARDIFF

This function can calculate the time difference in years of parameters. When there is only one parameter, it returns difference from now.

Syntax: Yeardiff(a), Yeardiff(a,b)

Synonyms: Age(a)

Return Value: Number

Example:

MONTHDIFF

This function can calculate the time difference in months of parameters. When there is only one parameter, it returns difference from now.

Syntax: Monthdiff(a), Monthdiff(a,b)

Synonyms: None

Return Value: Number

Example:

WEEKDIFF

This function can calculate the time difference in weeks of parameters. When there is only one parameter, it returns difference from now.

Syntax: Weekdiff(a), Weekdiff(a,b)

Synonyms: None

Return Value: Number

Example:

DAYDIFF

This function can calculate the time difference in days of parameters. When there is only one parameter, it returns difference from now.

Syntax: Daydiff(a), Daydiff(a,b)

Synonyms: None

Return Value: Number

Example:

HOURDIFF

This function can calculate the time difference in hours of parameters. When there is only one parameter, it returns difference from now.

Syntax: Hourdiff(a), Hourdiff(a,b)

Synonyms: None

Return Value: Number

Example:

YEAR

This function returns year value of parameters at each data row.

Syntax: Year(a)

Synonyms: None

Return Value: Number

Example:

MONTH

This function returns month value of parameters at each data row.

Syntax: Month(a)

Synonyms: None

Return Value: Number (January is 1, december is 12)

Example:

WEEK

This function returns week value (week of year) of parameters at each data row.

Syntax: Week(a)

Synonyms: None

Return Value: Number

Example:

DATE

This function returns date value (1 to 31) of parameters at each data row..

Syntax: Date(a)

Synonyms: None

Return Value: Number (From 1 to 31)

Example:

DAY

This function returns day (weekday) value of parameters at each data row.

Syntax: Day(a)

Synonyms: None

Return Value: Number (Sunday is 0, monday is 1, etc)

Example:

HOUR

This function returns hour value of parameters at each data row..

Syntax: Hour(a)

Synonyms: None

Return Value: Number (From 0 to 23)

Example: