What is a Table?
A Zoho Analytics workspace could contain a collection of tables. Two tables could be related to each other using lookup columns, thus enabling you to model a relational Workspace (Refer Relating tables using Lookup columns). You can create any type of reports over these tables which contain the actual data.
Type of a column defines the nature of values a column can contain and the operations that can be done over the same. e.g., an Age column could be "Positive Number" type.This column can contain only positive numbers and you could apply arithmetic operations over the same. Click to read more about the data types supported by Zoho Analytics.
A workspace would typically contain one or more tables containing logically related datasets. e.g., a Sales workspace could contain Products, Sales, Purchase etc., tables. Users are recommended to have logically related datasets stored within the same workspace, with each distinct dataset stored as a separate table. As mentioned earlier we can also define the relationship between two tables using Lookup columns.
Access your files securely from anywhere
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 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 Workerly Home
- Forums
- Connect With Us:
- Zoho Recruit Home
- Forums
- Connect With Us:
Create. Review. Publish.
You are currently viewing the help pages of Qntrl’s earlier version. Click here to view our latest version—Qntrl 3.0's help articles.
Zoho Sheet Resources
Zoho Forms Resources
Zoho Sign Resources
Sign, Paperless!
Zoho TeamInbox Resources
Design. Discuss. Deliver.
Related Articles
Pivot Table
Pivot Table allows you to dynamically rearrange, group and summarize data for easy analysis of large sets of data. You can transform data in a table(s) into interactive and meaningful summaries easily by using intuitive drag and drop interface ...Creating a New Table
Zoho Analytics provides different options to create a table to store your tabular data. As already discussed, once you create a workspace you can create any number of tables within it. Please note that only Server Administrators and Managers can ...Customizing a pivot table
When designing a pivot table, Zoho Analytics offers a wide range of options to customize it and improve the overall appearance in different ways. In this section we will discuss about various options provided by Zoho Analytics to customize a pivot ...Creating a new pivot table
A Pivot Table allows you to dynamically summarize large amounts of data for easy analysis and visualization. You can transform data in a table(s) into meaningful summaries easily by using the intuitive drag and drop interface provided by Zoho ...Importing Data into an Existing Table
You can easily import data stored in local drives, web URLs, or cloud storages/drives in various file formats into existing tables in Zoho Analytics. This allows you to update and modify the records in existing tables in a workspace. You could also ...