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.
- Number of tiles: Specify how many groups to assign to the data.
- Sum column: Specify the column to tile by that results in ranges where the sum of this number is equally distributed across the tiles.
- Sort column: If you select a column from this drop down list, the data will be sorted on the specified column before it is assigned to a tile. If no column is specified, the rows are assigned to tiles based on their in-coming sort order. Optional.
- 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.
- Select the Number of tiles to assign to the data.
- Do not split tile on column: If you select a column from this drop down list, a tile will not be split across this column. If no column is selected, the tile # takes preference over the specified column data, thus potentially splitting groups. Optional.
- Sort column: If you select a column from this drop down list, the data will be sorted (in descending order for numbers and ascending order for all other column types) on the specified column before it is assigned to a tile. Optional.
- 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.
- Tile numeric column: Choose the numeric column to tile by.
- Select the naming convention applied to the output column:
- 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.
-
Unique column: Select the column or columns to tile by.
-
Leave unsorted: Select if you do not want to sort the table by the selected columns.
- 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.
- The numeric column: Select the numeric column to tile by.
- Enter one or more tile cutoffs: Type each tile's upper limit on a new line in the box provided.
Create tiles with equal total values
The total of the Sum column is as close as it can be for each tile without breaking a row.
Divide rows equally
The number of rows in the input may not be equally divisible by the number of tiles you specify. This is based solely on the row's position in the input file, unless the Sort column is specified.
Sort rows by variance from the average
The tile value represents the mean of the data range. The tile numbers explain the range directly. The range always start at -0.5 and end at +0.5:
| Tile | Range |
|---|---|
| 0 | -0.5 to 0.5 |
| -1 | -1.5 to -0.5 |
| 1 | 0.5 to 1.5 |
Do not output name column: No additional output column name is generated.
Output name column: An additional descriptive output column name is appended to the output. Descriptors include: Average, Above Average, High, Extremely High, Below Average, Low, Extremely Low.
Output verbose name column: In addition to the descriptors mentioned above, the value range that the tile indicates is listed in parenthesis.
Create tiles for unique values
Set up rules manually
Tiles are applied in Manual mode but the rows are not sorted. You must add a Sort Tool and specify the columns to sort by, if that is how you want the data displayed.
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.