Adding Formulas (Calculations)
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 ...
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. ...
Report Formula
Zoho Analytics provides an option named Report Formula. This enables you to perform specific calculations in the report using the metric in the report. What is Report Formula? On what views can I create a Report Formula? How do I create a Report ...
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 ...
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 ...
In-built Aggregate Functions
Aggregate Formula allows you to create powerful metrics to address your business needs. In this section let's learn about the wide range of powerful in-built functions that are supported by Zoho Analytics. Aggregate Functions The following table ...