![]() Output verbose name column: In addition to the descriptors mentioned above, the value range that the tile indicates is listed in parenthesis.Descriptors include Average, Above Average, High, Extremely High, Below Average, Low, and Extremely Low. Output name column: An additional descriptive output field name is appended to the output.Do not output name column: No additional output field name is generated.Select the naming convention applied to the output field:.Tile Numeric Column (Must be Numeric): Choose the field to tile by.The range always starts at -0.5 and ends at +0.5: The tile numbers explain the range directly. The tile value represents the mean of the data range. Sort Records by Variance from the Average 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. This is based solely on the record's position in the input file unless the Sort field is specified.Ĭreates tiles based on the Standard Deviation of the values in the specified field. The number of records in the input might not be equally divisible by the number of tiles you specify. Set the sorting method that you want to use. Sort Method: This option shows only if you select Sort Column (above).Sort Column (Optional): If you select a field from this drop-down list, the data will be sorted (in descending order for numbers and ascending order for all other field types) on the specified field before it is assigned to a tile.If no field is selected, the tile # takes preference over the specified field data, thus potentially splitting groups. Do not split tile on column (Optional): If you select a field from this dropdown list, a tile is not split across this field.Select the Number of Tiles to assign to the data.Input records are divided into the specified amount of tiles so that each tile is assigned the same amount of records. Dictionary Order: English, French, German, Italian, Portuguese, and Spanish languages.Sort Method: This option shows only if you select Sort Column (above).If no field is specified, the records are assigned to tiles based on their incoming sort order. Sort Column (Optional): If you select a field from this dropdown list, the data is sorted on the specified field before it is assigned to a tile.Sum Column: Specify the field to tile by that results in ranges where the sum of this number is equally distributed across the tiles.Number of Tiles: Specify how many groups to assign to the data. ![]() The total of the Sum field is as close as it can be for each tile without breaking a record. 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 incoming records. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |