Data Types are used by Numetric to determine what type of information is contained in a particular column of a Table. For example, if a column contains numbers, Numetric knows that you can complete calculations on those fields (e.g. sum, average, min, max, etc.), whereas these same calculations cannot be conducted on a column that contains text.

Each column in your Table must have a designated Data Type, this will help tell Numetric what actions can be completed with the data in this field. Numetric will try and determine the most effective Data Type, and automatically assign it to your Table when it is created. However, you should ensure that your Data Types are correctly identified in each Table.

Each Data Type, along with a brief description of that Data Type is provided below:

Text

Supports any character, number, or symbol.

Often used for email addresses, names, or numeric values that will not be used in calculations (e.g. ID numbers).

If Numetric cannot determine which type of format the data is already in, it will default to text.

Integer

Supports whole numbers (no decimal places), and can be used in calculations.

Often used for counts, ages, number of transactions, etc. 

Only use Integer if there is no possibility of a decimal or fractional value.

Decimal

Supports numbers, including decimal places, and can be used in calculations.

This is the most common data type for numbers stored in Numetric.

Currency

Supports numbers, displays a dollar sign ($) and two decimal points where applicable.

Often used for revenue, profit, cost, transactional amount, etc.)

Date

Supports only date values, including ‘Epoch format’ (a date displayed as a whole number, counting the number of days that have passed since 1 January 1970).

Date values support filters and groups based on date information (e.g. day, week, month, quarter, year). This filter and group function is not supported if date values are identified as a Text or Number Data Type.

Time

Supports both 24 hour format (HH:MM:SS.FFF), and 12 hour format (HH:MM AM/PM). 

Time values support filters and groups based on time information (e.g. morning, afternoon, evening).

Date and Time

Supports data values that hold both date and time information.

If the value only contains date information, Numetric will automatically display the time as 12:00AM.

True/False

Supports 0,1; T,F; or TRUE,FALSE. 

All columns with this Data Type will be displayed as the boolean true or false value.

Geo Shape (Lat/Lon)

Supports Geoshape data, usually an array of geographical points, including the following examples:

40.370125, -111.776454

{"coordinates":[[-10.1234567,10.1234567],[-10.0123456,10.0123456],"type":"LineString"}

{"coordinates":[[[-118.408,33.874],[-114.693,35.050],[-114.536,33.650],[-117.584,33.386],[-118.408,33.874]]],"type":"Polygon"}

Did this answer your question?