Tile Tool

Use the Tile tool to assign a value (tile) based on ranges in the data. Each range of data in your dataset is a tile. These tiles can be grouped. You can select one of the following grouping methods: Equal sum, Equal records, Smart tile, Unique value, and Manual tile.

The Tile tool appends two columns to the data. Tile number is the assigned tile of the record or row. Tile sequence number is the record number of the row's position within the Tile. Each row is considered a record.

Configure the tool

In Properties, select a Tile method. Optionally, select which columns to group by.

  • Equal sum: Creates tiles with equal total values. It does this by assigning tiles to cover a range of values where each tile has the same total of the Sum column based on the sort order of the incoming rows.
  • Equal records: Divides rows equally by dividing input rows (records) into the specified amount of tiles. Each tile is then assigned the same number of rows.
  • Smart tile: Creates tiles based on the Standard Deviation of the values in the specified column. The tiles assigned indicate whether the row's value falls within the average range (=0), above the average (1) or below the average (-1), etc.
  • Unique value: Creates tiles for unique values. For every unique value in a specified column or columns, a unique tile is assigned. If multiple columns are specified, a tile is assigned based on that combination of values.
  • Manual: You can set up rules manually. To do this, specify the cutoffs for the tiles by typing a value on a new line for each range.

Grouping by columns: Tile rows based on a group column. By selecting a Group or Groups of columns, a series of tiles is created for every row within the specified group.