Creating Custom Filters in Zoho Analytics
Example: How to enable custom opportunity stage filter in Zoho Analytics.
 Step 1: Go 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 ...