Creating Your Own Metrics with Formulas
Zoho Analytics provides a set of in-built functions for well-known specific calculations. You can simply apply these functions over your data or create your own formula expression with these functions for complex computations.
Formula Column
Formula column allows you to create a new computed column in your data table based on a formula expression that you provide.
Zoho Analytics provides a wide range of Logical, Statistical, Date and String functions. You can combine these functions along with arithmetic operators like +, -, / and * to formulate the formula column. The result of the calculation will be saved as a new column in your data table.
Example: The below is an example of Grading the sales based on sales amount using a Nested If formula. The gradings derived are Excellent, Very Good, Good, Poor, and Others.
The defined formula columns can be used in any report creation similar to other columns in the data table. Click here to know more about Formula Columns.
Aggregate Formula
Aggregate Formula allows you to create powerful metrics using formulas to address your business needs. These metrics often serve as the Key business performance indicators in your analysis & reporting.
The result of an Aggregate Formula is always a numeric value and will be computed for each data record/group in a report in which it is used. Unlike Formula Column, this will not be added as another column in the base table. They will just be associated with the table on which they have been created and can be used in creating reports (Charts, Pivot Tables, and Summary Views) like any other table column.
Example: The below example will calculate the Won Amount in sample CRM data. It sums the amount of all leads whose stage is "Closed Won"
Click here to know more about Aggregate Formula.
Report Formula
Report Formula is an aggregate formula specifically created within a report. Report Formula allows you to use the basic arithmetic operators such as +, -, * along with a nested IF condition, over the columns used in the report. The Report formula will be added as a metric in the report. This can be used only within the report its created and not in other reports.
Click here to know more about Report Formula.
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:
Zoho FSM Video Tutorials
All-in-one knowledge management and training platform for your employees and customers.
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
Formulas (Calculations)
Zoho Analytics provides a powerful formula engine to perform various calculations over your data. It enables you to derive business-specific metrics/insights from complex data and helps you visualize them as useful reports. Zoho Analytics formula ...Creating a Tabular View
A Tabular View as the name implies is a simple table-like report, that can be created with an intuitive drag and drop interface, over your data tables. With Tabular View, you can easily summarize, structure, group, filter, and customize data the way ...Aggregate Formulas
In reporting the most common data analysis that we do is to apply aggregate functions over the data (like SUM, AVG, COUNT etc.,) and analyze the same. The important aspect to be taken care in such calculations is to compute the aggregation in the ...Creating Reports
Zoho Analytics, as a reporting software, offers a wide variety of reporting options such as Charts, Pivot tables, Summary views and Tabular views. This enables you to easily analyze your data and derive great insights. The intuitive drag and drop ...Basic Concepts of Zoho Analytics
Zoho Analytics is a self-service BI and data analytics software that lets you analyze your data, create stunning data visualizations, and discover hidden insights in minutes. This guide will help you to learn the concepts specific to Zoho Analytics. ...