Number Data Type¶
Number data types allow users to add numeric values in different formats.
This prototype might be outdated due to global component updates. Please refer to the link under ‘Setting Options’ for an updated version of the shared components.
User sets number data type options¶
A user can access the data type configuration of a field through the column menu. Depending on which data type is selected, the content of the configuration panel will change.
The following is an interactive representation of the various options that users can set for this type: Number Type Options
User sets different data type formats¶
When setting a number type, a user can pick from different formats, including decimals, floats, integers.
User filters the values of a number data type column¶
A user can filter the values of a number data type column. The filtering options will vary depending on the type selected.
User groups records according to numeric values of a column¶
A user can create groups based on the numeric values of a column. The User can choose to group by unique values or automatic ranges. Range options can be set so that groups are created by size or number of groups.
User defines range manually¶
A user can set a min and max value for a range and the increment size
User defines ranges automatically¶
A user can set the number of groups or the size for each group. If the parameter for the number of groups is set to 2, the range will be divided into two equal groups. If the group size parameter is set to 5, the values will be divided into ranges with an equal number of unique values. In this case, 5, not all groups will have the same number of equal values, as the total might not be divided into equal parts.
‘Friendly’ and ‘Database’ type display¶
We want to make sure users of all levels can understand and use the appropriate data types. Because the distinction between database types is sometimes not evident to beginner levels, we want to map them to more familiar categorizations. The design ensures that information will be available but prioritizes the user-friendly types in terms of visibility.
Number type alignment¶
Number types should be aligned to the right for easier reading of numbers with decimals.