Column Types Supported l Zoho Analytics Help

Column Types Supported

Data Type/Column Type of a column in a Table defines the nature of values a column could contain and the operations that could be done over the same. Eg., an Age column could be "Positive Number" type. This column can contain only positive numbers and you could apply arithmetic operations over the same.

The data type of a column also determines the formatting options that are possible for displaying the values in the column in various reports created in Zoho Analytics. To learn about changing the data type of a column, refer to this document.

Zoho Analytics supports the following data types (column types) currently.


Data Type Description
Plain Text Holds a line of simple text that contains less than 100 characters
Multi Line Text Holds multiple lines of text. This data type can hold text of more than 100 characters
E-mail Holds an Email Address
URL Holds a clickable Hyperlink / Web URL address. eg.,


Auto Number Holds 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
Number Holds an integer value (both positive and negative values)
Positive Number Holds only positive integer values
Decimal Number Holds decimal values (both positive and negative)
Currency Holds a currency value in different country denominations
Percentage Holds a percentage value

Geo Location

Continent Holds the names of continents.
Country Holds the names of countrys.
State/Province Holds the names of state or province.
County Holds the names of counties.
District Holds the names of districts.
City Holds the names of cities.


Date Holds Date and Time value
Decision Box Holds a binary value eg., Yes/No, True/False, On/Off
Looked Up Column Refers 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. The data will be encrypted and saved in our servers. 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.

Click here to learn more.

    Zoho CRM Training Programs

    Learn how to use the best tools for sales force automation and better customer engagement from Zoho's implementation specialists.

    Zoho CRM Training
      Redefine the way you work
      with Zoho Workplace

        Zoho DataPrep Personalized Demo

        If you'd like a personalized walk-through of our data preparation tool, please request a demo and we'll be happy to show you how to get the best out of Zoho DataPrep.

        Zoho CRM Training

          Create, share, and deliver

          beautiful slides from anywhere.

          Get Started Now

            Get started with Zoho Sign

            in a few quick steps!

            Download Help Guide

                      Still can't find what you're looking for?

                      Write to us:



                        Zoho Marketing Automation

                          Zoho Sheet Resources


                              Zoho Forms Resources

                                Secure your business
                                communication with Zoho Mail

                                Mail on the move with
                                Zoho Mail mobile application

                                  Stay on top of your schedule
                                  at all times

                                  Carry your calendar with you
                                  Anytime, anywhere

                                        Zoho Sign Resources

                                          Sign, Paperless!

                                          Sign and send business documents on the go!

                                          Get Started Now

                                              Zoho SalesIQ Resources

                                                  Zoho TeamInbox Resources

                                                          Zoho DataPrep Resources

                                                            Zoho DataPrep Demo

                                                            Get a personalized demo or POC

                                                            REGISTER NOW

                                                              Design. Discuss. Deliver.

                                                              Create visually engaging stories with Zoho Show.

                                                              Get Started Now

                                                                                    • Related Articles

                                                                                    • Supported Functions

                                                                                      Zoho Analytics provides you with a variety of inbuilt functions which are predefined mathematical formulas designed to perform specific well-known calculations easily.  This section lists the supported inbuilt functions.  Formula Column In-built ...
                                                                                    • Chart Types Primer

                                                                                      You can create various types of charts such as Area, Bar, Bubble, Line, Pie, Stacked, Scatter, Funnel, Web and 3D charts by simply dragging and dropping the required columns into the respective shelves in the design area.  Before we proceed any ...
                                                                                    • Importing from JDBC Driver Supported Databases using Zoho Databridge

                                                                                      If you have data in JDBC Driver Supported Databases, then you can easily import your data into Zoho Analytics using the Zoho Databridge. The Zoho Databridge bridges your JDBC Driver Supported Databases and Zoho Analytics server to fetch data from ...
                                                                                    • My date columns are imported as a string column. How do I resolve this?

                                                                                      Do ensure that the column type is set as DATE, DATETIME or equivalent types in the source table. In case your column type is set as string or similar types, then your data column may get imported as a string column. In this case you can convert it ...
                                                                                    • Formula Column

                                                                                      Zoho Analytics allows you to define your own powerful formulas to meet your specific reporting requirements. This enables you to easily perform from simple calculations such as addition and subtraction to a complex combination of in-built functions. ...
                                                                                    Wherever you are is as good as
                                                                                    your workplace



                                                                                      Watch comprehensive videos on features and other important topics that will help you master Zoho CRM.


                                                                                      Download free eBooks and access a range of topics to get deeper insight on successfully using Zoho CRM.


                                                                                      Sign up for our webinars and learn the Zoho CRM basics, from customization to sales force automation and more.

                                                                                      CRM Tips

                                                                                      Make the most of Zoho CRM with these useful tips.

                                                                                        Zoho Show Resources