Loading...
 
Skip to main content

Grouped Data

See: https://en.wikipedia.org/wiki/Grouped_data

See also Derived Attribute of a date and Date-based aggregations

It can be very useful to group tracker data in smaller units. For example, when using in PluginPivotTable


Below are some examples to be used in Mathematical Calculation Tracker Field

Nearest 100 rounding

Copy to clipboard
(mul (round (div (substring AmountPaid 0 -3) 100 ) ) 100 )

substring is need if you use it on a currency formatted field (with 3-letter currency symbol at the end). Be sure to use it on the proper currency field - e.g. containing a CAD converted value.

Number range (11-20, 21-30, etc.)

Copy to clipboard
(concat (mul (sub (ceil (div (substring AmountPaid 0 -3) 10 ) ) 1 ) 10 ) (str -) (add (mul (ceil (div (substring AmountPaid 0 -3) 10 ) ) 10 ) 1 ) )

Age group

Copy to clipboard
(if (less-than (substring Age 0 -3) 18 ) (str "0-17") (if (less-than (substring Age 0 -3) 36 ) (str "18-35") (if (less-than (substring Age 0 -3) 54 ) (str "36-53") (if (less-than (substring Age 0 -3) 72 ) (str "54-71") (if (less-than (substring Age 0 -3) 90 ) (str "72-89") (if (less-than (substring Age 0 -3) 108 ) (str "90-107") (str "wow, how did you do it?") ) ) ) ) ) )