Column types determine how column data is sorted and displayed. By default, column data is treated as a text string sorted alphabetically. Some macros, like the SQL and CSV macros, may automatically generate more precise types. When the default behavior is less than optimal for your situation, the columnTypes parameter can be set specifically. This describes the behavior of the various types. In addition, numeric types are right aligned and can result in a total row entry.
Navigate to Column settings > Formatting > Column type in the respective macro to select from the list of available column types.
Table plus |
---|
Image Removed | FC Separated Separated numbers, like phone numbers or TCP addresses. Valid values are multiple integer numbers separated by '-'. | Numeric on each separated value |
|
| / | Separated numbers, like phone numbers or TCP addresses. Valid values are multiple integer numbers separated by '/'. | Numeric on each separated value |
|
| Hide the column (H) | Indicates to hide the column. |
|
|
|
Column types: S,I,F"0,0",F"$0,0 |
Tip |
---|
|
00" |