Tile Tool

The Tile tool assigns a value (tile) based on ranges in the data. It does this based on the user specifying one of 5 methods.

Two fields are appended to the data. Tile number is the assigned tile of the record. Tile sequence number is the record number of the record's position within the Tile.

Configure the tool

Tile Method: Select the range pattern used to assign tile value.

  • Equal Sum: Assigns tiles to cover a range of values where each tile has the same total of the Sum field based on the sort order of the in-coming records.
  • Equal Records: Input records are divided into the specified amount of tiles so that each tile is assigned the same amount of records.
  • Smart Tile: Creates tiles based on the Standard Deviation of the values in the specified field. The tiles assigned indicate whether the record's value falls within the average range (=0), above the average (1) or below the average (-1), etc.
  • Unique Value: For every unique value in a specified field or fields, a unique tile is assigned. If multiple fields are specified, a tile is assigned based on that combination of values.
  • Manual: The user can specify the cutoffs for the tiles by typing a value on a new line for each range.

Grouping Fields (Optional): Tile records based on a group field. By selecting a Group or Groups of fields, a series of tiles is for every record within the specified group.