Data Modifiers in IntelliBoard NEXT

One of the advanced IntelliBoard NEXT builder features is data modifiers. With the help of modifiers, you can operate with the table column data at your preference. 

IntelloBoard NEXT divides the data into a few types. In the "Layout" menu, when adding a new column to your table, you can see the column data type as highlighted below:

Each data type has a list of the data modifiers which can be applied to it.

Ein Bild, das Kalender enthält.

Automatisch generierte Beschreibung

NOTE: It is not possible to apply modifiers to bool and enum data types.


Please find a list of all modifiers explained below:

Average (Including Nulls as 0)  Counts average meaning while counting NULL values as 0. Simply, counts the average meaning of all columns which have value, hiding NULL values.
Average (Mean) Returns an average meaning of all rows, dividing the sum of the row values by their number.
Count Counts the number of all rows in the table, ignoring NULL values.
Count Null Counts the number of all rows in the table including NULL values.
Group Concantenate Returns a string result with the concatenated non-NULL values from a group.
Inter-Quartile Range It is a measure of where the bulk of values lie (spread of the middle 50% of the values). Preferred over many other measures of spread when reporting school performance or SAT scores.
Maximum An extreme maximum value of the table data.
Median Tells where the middle of the data set is.
Minimum  An extreme minimum non-NULL value of the table data.
Minimum (Including Null as 0) An extreme minimum NULL value of the data.
Modifier First Returns first non-NULL modified data in the table.
Modifier Last Returns last non-NULL modified data in the table.
Range The difference between the largest and smallest values. Can be used for the dispersion of the class's test scores.
Standard Deviation It is a single number that summarizes the variation or dispersion in a dataset. Simply, it shows how spread out the numbers are.
Sum Returns a total sum of a sequence of any kind of numbers.


For additional assistance, please email 

Was this article helpful?
2 out of 2 found this helpful