We know that data can be stored in a variety of formats. Data types in Numetric allow you to store data in a uniform way that can be used for reporting. When you determine a data type, you are telling Numetric how to handle your data.
This data type is one of the most common. It supports any character, number, or symbol (even emojis!). It can be used for email addresses, store names, or any numeric variable on which you will not perform calculations as in an id number. If Numetric cannot determine which type of format the data is already in, it defaults to text. (Examples: Fresh Fruit, JoeSmith@email.com, 654XT6, 1234 Sesame Street, etc.)
Integer / Number
Integers are usually used to keep track of counts. They do not have decimal places but can still be used in calculations. Use the number format to list the number of purchases in a customer table or to display ages of employees. Note: You may see Number as an option, but this is being transitioned to say Integer. If you are unsure if your data consists entirely of integers, use the Decimal data type.
Decimals are used when the data is numeric but not necessarily a whole number. This is the most common data type for storing numeric values. Variables in the number format can be divided by each other to create a new variable with decimal formatting.
Use this data type when dealing with currency. The data is stored with the same precision as Decimals, but it will be displayed rounded to two decimal places with a dollar sign. (examples: revenue, profit, transaction amount, etc.)
A date field will hold strictly date values as opposed to a date and time value. Values that are formatted as dates allow the end user to filter and group based on date intervals (examples: day, week, month, quarter, year, etc.), as well as customize the Workbooks and metrics to a specific time frame or date range (example: from 1 August 2016 – 1 August 2017).
If the date is formatted as “Text” or “Number”, filtering and grouping by date interval or specific ranges is not possible. If, for some reason, your date column does not allow you to filter and group by date, first check to make sure the data format is set to “Date” or “Date and Time.”
Date Side Notes:
Numetric will allow a Date and Time value to be correctly formatted as just a date.
Dates are sometime formatted as a really long number like: 1479768170. This is called Epoch format and basically creates today’s date by counting the number of milliseconds that have passed since 1 January 1970. When your dates are in Epoch format, Numetric will know what to do and converts them correctly providing the data type is set to either “Date” or “Date and Time.”
This can be used to record the time of day an event takes place or a transaction occurs. As with dates, they can be used to calculate the amount of time between events. Using value mapping, times can also be grouped into ranges (examples: Morning, Afternoon, Evening, etc.). Times can be formatted using military standards (example: HH:MM:SS.FFF) or 12-hour (examples: 4:55PM, 11:22AM).
Time Side Notes:
This data field currently does not support grouping by a period of time. We suggest converting periods of time to a common unit, either seconds or minutes, and then using a formatter to display it in an HH:MM:SS format. If you want to group by hour of day, you can add a column using the hourOfDay formula.
Date and Time
A single variable holding both date and time information. If a variable only holding date information is made into a Date and Time variable, Numetric will automatically set the time as 12:00AM. When both date and time information is included in a dataset it is more beneficial to use the Date and Time format.
This field can only take on two values, true or false. 0’s and 1’s can also be used in this column and they will be converted to False and True respectively. All variations of True (true, T, TRUE) and False (false, F, FALSE) will be converted to the boolean true and false.
Geo Shape (Lat/Lon)
Contains Geo shape data, usually an array of geographical points. This is the most common geographical data type.
Example: 40.370125, -111.776454
See more formatting examples here: https://geojson.org/geojson-spec.html#appendix-a-geometry-examples
Geo Point (Lat/Lon)
Mainly used for Heat Maps
Note: Longitude and Latitude are switched for the Geo Point data type.
Note: With Numetric, you can create a heat map and group by state, zip code, country, or another value. Unfortunately, we do not currently have documentation for grouping by text values and displaying them on a map. If you need help, please chat with customer support inside of Numetric's platform and we will be happy to assist you!