Custom Filters in Zoho Analytics

Creating Custom Filters in Zoho Analytics

Example: How to enable custom opportunity stage filter in Zoho Analytics.


 Step 1Go to Opportunities master table in the Analytics Workspace.



Step: 2  Select "Aggregate Formula"



Step 3 :  Enter Formula Name, Data Type and formula in the below format:

For multiple values:
countif(("Table Name"."Field Name") IN ('value1', 'value2', 'value3'))

For single values:
countif("Table Name"."Field Name"='value')  

Field Name should be a picklist or multi-select from Zoho CRM. value1, value2, value3 are the picklist values. 



Step 4: The custom filter will appear whenever you are creating a report. The default filters will not work because it tries to combine data with other Y-axis elements. Hence the need for a custom filter.



    • Related Articles

    • SimPRO - Zoho CRM Integration Overview and SyncEzy Portal User Guide

      Integration Portal User Guide simPRO - Zoho CRM Integration - Overview Summary In summary, the integration offered by SyncEzy between simPRO and Zoho can achieve the following: 1. Sync Accounts, Contacts, Sites, Quotes, and Jobs automatically from ...
    • simPRO to Zoho CRM integration FAQs

      This document addresses the variety of questions we encounter while helping clients. If you have a question that’s not addressed here please write to us at support@syncezy.com About the simPRO to Zoho CRM integration How often does the sync run? ...
    • Zoho CRM to Google Sheets integration FAQs

      This document addresses the variety of questions we encounter while helping clients. If you have a question that’s not addressed her please write to us at support@syncezy.com About the Zoho CRM to Google Sheets integration Share Link - ...
    • Zoho Desk to Simpro (Standalone) Overview and Setup Guide

      Overview The Zoho Desk to Simpro integration allows you to send your tickets from Zoho Desk to a Quote or a Job in Simpro. The integration uses the email to search for a Customer or Contact and also allows you to choose a Site that is linked to them. ...
    • Zoho Desk to Simpro (CRM Integration Users) Overview and Setup Guide

      Introduction The Zoho Desk to Simpro integration allows you to send your tickets from Zoho Desk to a Quote or a Job in Simpro. The integration uses the email to search for a Customer or Contact and also allows you to choose a Site that is linked to ...