ToolZ - Dynamic Web Reporting

Once you have your basic report structure set up, there are quite a few ways in which you can manipulate their properties: Aggregates - Basic SQL aggregat...

COUNT(object/property/group_id[, group][, group]) COUNT_DISTINCT(property/group_id[, group][, group]) AVG(property[, group][, group]) SUM(property[, grou...

PREV(property[, num records back]) NEXT(property[, num records forward]) It is often helpful to put data in context by displaying what that data was in a ...

POS(property[, index]) Sometimes you need to reference data at a specific position in your data set. This can be used to: Sort a crosstab report by a ...

PERCENTAGE(VALUE, DIVIDED BY) To calculate a percentage, it is necessary to specify both a value and what it should be divided by. The PERCENTAGE functi...

RANK(value, direction, [precision,] grouping) Ranking provides information about a group member’s or datapoint’s standing when compared against other me...

CALC(expression) Calculations allow for additional flexibility in your reporting. They can be used to: Compare a value to its previous value Compare ...

Although ToolZ does support combining several functions with each other, not all combinations are currently supported. Read this table as "Can a [row h...