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

      Summary This is a user guide to walk you through some of the basic functionalities of the Zoho Desk to simPRO extension, an overview on how to install and setup the extension and to detail functionalities of the extension. Note: This extension is ...
    • Zoho Desk to SimPRO (CRM Integration Users) Overview and Setup Guide

      Summary This is a user guide to walk you through some of the basic functionalities of the Zoho Desk to simPRO extension, an overview on how to install and setup the extension and to detail functionalities of the extension. Note: This extension is ...