Column Types Supported

Data/Column Types in Zoho Analytics

The data type or column type of a table column defines the nature of values that can hold and the operations performed over the same. It also determines the possible formatting options to display the column values in various reports.

The following are the supported data types or column types in Zoho Analytics.

Text

Data TypeDescription
Plain TextHolds a line of simple text that contains less than 100 characters
Multi Line TextHolds multiple lines of text. This data type can hold text of more than 100 characters
E-mailHolds an Email Address
URLHolds a clickable Hyperlink / Web URL address. eg., http://reports.zoho.com

Numeric

Auto NumberHolds auto generated incremental numeric values, which are unique. This would be helpful when you need to have a unique identifier associated to each row/record in the table.
Auto Number column value starts with 1 and each new value will be incremented by 1. Auto Number values will always be unique
NumberHolds an integer value (both positive and negative values)
Positive NumberHolds only positive integer values
Decimal NumberHolds decimal values (both positive and negative)
CurrencyHolds a currency value in different country denominations
PercentageHolds a percentage value

Geo Location

ContinentHolds the names of continents.
CountryHolds the names of countrys.
State/ProvinceHolds the names of state or province.
CountyHolds the names of counties.
DistrictHolds the names of districts.
CityHolds the names of cities.

Others

DateHolds Date and Time value. Click here to learn more.
DurationHolds the time duration value. Click here to learn more.
Decision BoxHolds a binary value eg., Yes/No, True/False, On/Off
Looked Up ColumnRefers to a column value in another table. Helps to relate two tables. Click to know How to create a Lookup Column.

Formatting columns

Zoho Analytics offers options to change the format of a column like an alignment, decimal places, date formats, currency symbol etc., depending on its data type. Using these options you can choose how you would like to have your column data displayed in your table. Click to learn more.

Marking Columns as Personally Identifiable Information

Zoho Analytics allows you to mark columns as Personally Identifiable Information (PII). This could be any information that could potentially identify an individual, for example. Name, Email, Job role and Company name etc. When a column is marked as PII, additional care will be taken in handling such data, such as with data encryption. The below-animated image shows how to mark a column as PII. 

Alternatively, you can also click the Edit Design button in the toolbar and change the value of the corresponding Column Name to 'Yes' under the PII column.