See video version of the tutorial

Integer columns are used when you need to render numeric values without any decimal part. Even if in the input data source you have non-integer values for this column (not just numbers, or numbers with some decimal part), if you define a column as integer, it will cast and render all the values as integers – cut all non-numerical chars, and the decimal part.

Rendering rules: none, value is casted as a number as rendered with formatting rule applied (formatting rule can be chosen in the settings page).

Sorting rules: arithmetical.

Applicable filter types: text (will also work), number, number range, selectbox, checkbox.

Issues to note: none.

Example:

Amount purchased” column in this table is an integer column.

If you don’t need the formatting for the column (e.g. it represents a year, or product SKU, or vendor code, etc.) just tick the “skip thousands separator” checkbox in the column settings block.

Excel table example



Never miss new features!

Join 2000+ newsletter subscribers

Never miss notifications about new cool features, promotions, giveaways or freebies - subscribe to our newsletter! We send about one mail per month, and do our best to keep our announcements interesting.

We never spam or disclose your address to anyone.