Combine related grouping values into categories in CRM analytical components

Combine related grouping values into categories in CRM analytical components

Hello everyone,

Analyzing large datasets can be challenging when dealing with numerous individual data points. It's often difficult to extract meaningful insights when information is scattered and ungrouped.

To address this, we're adding options to create categories for each grouping field in analytics components, which enables you to group related values for clearer and more insightful data analysis.

For example, let's say you're analyzing leads based on their sources and recognize that you've received leads from various channels, such as cold calls, advertisements, employee referrals, trade shows, and chats. To determine which leads were generated through active engagement versus passive engagement, you can categorize them as follows:

Active engagement: Cold calls, employee referrals, chats
Passive engagement: Advertisements, trade shows

This categorization helps classify records and analyze which sources involve direct interaction and engagement with potential leads (active) versus those that provided information or opportunities without direct interaction (passive).
Idea
How does this benefit you?
  • Simplified data analysis: Grouping similar data points reduces complexity and makes it easier to spot trends and patterns.
  • Enhanced visualizations: Categories make your charts and reports more readable and focused.
  • Custom groupings: You have the flexibility to define categories that make sense for your specific business needs.
You can create categories for two types of grouping fields:
  • Picklist fields
  • Numeric fields (currency, number, long integer, decimal, percent, formula, roll-up summary)
Let's look at categories for each of these grouping field types.

Categories for picklist fields



Imagine you have a picklist field called Country as a grouping field in a chart component. Analyzing each country individually can be overwhelming and time-consuming. Additionally, you might have business goals that require that you monitor or analyze these deals by grouping them into certain subcategories, such as regions/continents.
  • By creating categories, you can group countries into broader categories, like continental regions, or other custom categories based on your business needs.



    In this context, the Continent is set as the category field, with Asia, Europe, Africa, and North America set as its categories.



  • Instead of focusing on each country's performance, you can quickly see how the continents or regions are doing as a whole, which helps you make more informed decisions.

Categories for numeric fields



Another valuable enhancement to the category feature is the ability to categorize numeric fields, which enables you to organize numerical data into meaningful ranges that provide clearer insights and make analysis more intuitive.

Let's say you're working with an analytical component that includes the Deal Amount for all deals. Analyzing individual deal values can be overwhelming, especially with a large dataset. By categorizing deal amounts into ranges, you can quickly see which deals fall into higher or lower revenue brackets to make it easier to spot trends and act based on these insights.

For instance, you can create a category field called Deal size for the Amount grouping field. You can then group the values into categories such as Low-value deals for deals with amount below $15,000, Medium-value deals for deals ranging from $15,000 to $50,000, High-value deals for deals between $50,000 to $100,000, and Enterprise deals for deals exceeding $100,000.



When creating categories for a numerical field, range values are designed to be continuous to ensure no value unintentionally falls into the uncategorized "Others" section.



Alert
Points to be noted:
  • The category fields and categories you create are specific to an analytical component.
  • For a category field, you can add up to 10 categories and up to 20 values within each category.
  • The Others category includes grouping values that aren't assigned to any category, as well as records with no values for the field for which the category was created.
  • Category creation is supported for all types of analytical components except Anomaly Detector and Stage Component.
Info
Release plan:
These enhancements are currently available to all users across all DCs except the IN DC. The release status for the IN DC will be updated soon.
That's all for this enhancement. Please share your feedback in the comments. 


Thanks,
Nizamuddin

    • Recent Topics

    • Updating sum of subform

      I encountered another problem for updating of sum of fields in a subform. on a main form (Make_claim), I have a dynamic drop down (approved_budget_purpose) list to which filters the the items display in a subform (expense_claim_history1). In the subform,

    • IP Addresses for Whitelist

      Hi,  Where can I get a list of the IP addresses I need to whitelist for accessing Zoho Desk? TIA

    • Ability to rename community tabs as own preference

      Current zoho desk community tabs unable to rename however i see it has as suitable standard for most communities But it will be more better and beneficial if possible to modify(rename) then we can use the community for various purposes and able to change them as very convenient for, various product & services various fields organizations push(add) many topics types into one community instead host several community forums or portals. Setup > Channels > Community > Preference > Topic Type This's an

    • How to a customise the support email id to our custom domain

      we need to have support email address in our custom domain email id. how to do it?

    • Enhanced Anti-Spam Capabilities for Zoho Desk

      Dear Zoho Team, We appreciate the existing feature in Zoho Desk that detects and automatically marks suspicious email tickets as spam, moving them to the spam tickets view. Additionally, the ability to auto-mark associated contacts as spam is helpful.

    • How to Associate multiple contacts with deal in Sales Inbox

      Hello, I have many deals that have multiple potential customers associated with a single deal, for example an engineer and a manager. The manager is the Deal's primary contact in CRM and the Engineer is added to the deal in the "Contact Roles" Associated

    • Trying to sort tickets in "Status" mode by age

      Struggling with an odd issue, hoping someone can help. Trying to use the basic "Status" ticket-view, but can't find the setting that will put the oldest tickets at the top of each "Status" column. I found this in other ticket-view options (classic, compact,

    • Why is Zoho Meeting quality so poor?

      I've just moved from Office 365 to Zoho Workplace and have been generally really positive about the new platform -- nicely integrated, nice GUI, good and easy-to-understand control and customisation, and at a reasonable price. However, what is going on

    • Associate all "Active" users to a newly created project... (Zoho Projects API Documentation lacking)

      Today I spent almost 3 hours trying to do something which I discovered has been asked for for over 14 years in Zoho Projects, that is when a new project is created to assign all active users to the project. My first thought was, okay this should be fairly

    • (MAJOR ISSUE?) Chat GPT integration. Wrong endpoints in API integration for embedding models.

      There seems to be a issue with the API endpoints with the ChatGPT, Zoho Flow integration. When using the model 'text-embedding-ada-002' the endpoint should be v1/embeddings but instead it's v1/chat/completions. Here's an example of the history on a failed

    • Undocumented System Variables

      Hi, The documentation that I'm aware of for Zoho Analytics system variables is found here. However, I don't see the system.timeline.date.from and system.timeline.date.to variables listed. Where can I find a list of all the system variables in Zoho Analytics

    • UK payroll entries

      Hey guys, Nett payroll payments are imported direct into the bank, using an external payroll system (will be glad for Zoho to have a UK payroll app) At present I have monthly recurring bills for HMRC which are auto entered & paid when due. This seems

    • Calculating Active Months and Recurring Monthly Revenue

      Hi everyone, as part of my offering I have a membership community that people pay monthly for. This is hosted on Squarespace. In my Zoho CRM I have added a field for the date a person becomes in active. This means there is a "closing date" which is the

    • Accounting on the Go Series:58-Effortless Compliance: Download XML for Invoices & Credit Notes on Mobile

      Hi there! In Mexico, XML files are crucial for electronic invoicing and fulfilling SAT (Tax Administration Service) requirements. These files ensure your transactions are accurately recorded and tax-compliant. Now, you don’t need to rely on the web app

    • Zoho Developer Community Monthly Digest - November 2024

      Hello everyone! Welcome back to the November edition of the Developer Community Monthly Digest. Dive in to explore the upcoming events, hands-on training sessions, exciting product updates, insightful discussions, and more to keep you informed and inspired!

    • Process FOR loop for subform items in the order of the manual sorting

      Hi Guys, I have searched everywhere and tried everything, but I still not able to resolve one particular challenge. I have a subform in my Invoice with rows for each item. I made it so that we can change the order of the items manually. I need to be able

    • Address Input and Map Functionality Challenges in Zoho: Need Advice

      I just started using the Zoho ecosystem for my business. Everything seems to be working fine, except for the map features built into the applications. It's quite difficult to input an address when creating a new lead. Some of you might suggest using extensions

    • Accounting on the Go Series-57: Effortlessly Add and Manage Bank Accounts from the Zoho Books Mobile App

      Hi all, Great news for our users in the US and Canada! Managing your finances just got a whole lot easier. Zoho Books has always made it seamless to integrate bank accounts and fetch feeds automatically. Now, we’re taking it up a notch—directly from the

    • Foreign currency Bank Account month end revaluation

      I have a question i have 2 bank accounts one in USD and the other in EUR , how to make the month end journal entries for exchange rate revaluation , also how to maintain the exchange rates daily on Zoho books for the foreign currencies . I made transfer

    • Zoho Forms Integration with Sign

      Hi there, following recent feedback that Zoho Sign is really not very useful friendly when using a mobile device I am exploring integrations with Zoho Forms. I have managed to create a form and integrate this into Sign pretty easily when a form is just

    • [Free Webinar] Creator Tech Connect Series - Product Release Updates in Zoho Creator

      Hello Everyone! We welcome you all to the upcoming free webinar on the Creator Tech Connect Series. The Creator Tech Connect series is a free monthly webinar that runs for around 45 minutes. It comprises technical sessions in which we delve deep into

    • Need code format to specify default values

      Can someone please direct me to the code syntax or the proper translation per the instructions circled below. These instructions don't seem correct.

    • A quicker way to provide accountants access to Zoho Books, similar to Xero and Quickbooks

      Hey guys, I'm finding the procedure to give access to an external accountant to Zoho Books less than ideal. Having to create an account by Zoho instead of myself, and then wait for it to be given a license to then pass to the accountant seems a bit time

    • Introducing color coding feature of picklist fields in Meetings

      Dear All, Greetings! As part of the ongoing UI enhancement, we are excited to introduce color coding of picklist fields in Meetings. 'Meetings' is a great way to collaborate with peers and stay productive. You can block the calendar, invite participants,

    • Importing old Invoices into Zoho Books - Hitting the limit

      I'm currently working on importing historic invoices and payments made records from one Zoho Books premium instance into another however i'm hitting the 25,000 per year limit issue, these invoices go all the way back to 2019, and i understand that generating

    • Accounting on the Go Series-56: e-Way Bill Module in the Mobile App – A Handy Solution for Indian Businesses

      Hello everyone, Managing e-Way bills just got more convenient with the Zoho Books mobile app! For businesses operating under the GST regime, e-Way bills are essential for tracking the movement of goods. Previously, you had to log in to the web app to

    • Why Zoho Campaigns have massive more limitations like other software?`

      Hello, it was a time we managed +300 zoho campaigns accounts. But after only 3 years we handle now only +70 accounts. The reason? Because other solutions integrate much faster new functions. And not only this: They do not only release a new function -

    • Limit tasks per due date

      I am trying to figure out a way to limit the number of Tasks users can set on any given due date. But the number of tasks will differ for different users. Example - User 1234 will be permitted 100 tasks on each due date User 5678 and User 9012 will be

    • ZOHO CRM API changing timestamp format

      I'm working on integrating ZOHO CRM API with USM anywhere. USM anywhere supports only a few timestamp formats. the current timestamp format( yyyy-MM-ddTHH:mm:ss±HH:mm) is not supported by USM. Is there a way I can change this format to for example(yyyy-MM-ddTHH:mm:ss)?

    • Formula field update

      In a Blueprint, I have a stage called 'Plan inspection date'. At this point there is a fork, which depends on the number of days between now and the installation date. If there are less than 21 days, then the inspection should be planned urgently, if

    • Automating Employee Birthday Notifications in Zoho Cliq

      Have you ever missed a birthday and felt like the office Grinch? Fear not, the Cliq Developer Platform has got your back! With Zoho Cliq's Schedulers, you can be the office party-cipant who never forgets a single cake, balloon, or awkward rendition of

    • Accounting on the Go Series-55: Seamlessly Add New Vendors While Creating Transactions from Scanned Documents

      Hi there! We’ve made handling documents and vendors in Zoho Books even simpler. Now, when you upload a document and scan it, if the app detects a vendor that isn’t already in your organization, you don’t have to leave the page to add them manually. With

    • Surpress Zoho warnings in Customer Portal

      I'm experimenting with the Customer Portal. When I log in as a customer, this message shows up, completely covering the menu bar at the top. Can such messages be surpressed? I know, it is very easy to get rid of it, but when I demonstrated the portal

    • Default Sorting on Related Lists

      Is it possible to set the default sorting options on the related lists. For example on the Contact Details view I have related lists for activities, emails, products cases, notes etc... currently: Activities 'created date' newest first Emails - 'created

    • Send email to all contacts related to a module

      My use case: I have a module named products, the records of which contains a related list of contacts associated with subscribing to that product. In cases where i need to trigger emails manually to give specific unprecedented updates of that product,

    • Custom Modules Support for Zoho Creator Integration

      The title says it all. We have to create custom coded widgets for every little thing because this is not supported. Zoho Creator does not support custom modules. Zoho Forms does not support Multi-select-lookups. The point of Zoho is to not have to code

    • C# SDK net8.0 compatibility

      The NuGet packages seem to be targeting .net4.6.1 only. Are there any plans to target .net8.0, which is the current LTS version? Which package should I be using to interact with the API when targeting .net8.0, if any? If the SDK does not readily support

    • Notifications

      I am facing a problem with notifications, the mobile crm app does not notify me at all for any mail, task, activity, ... etc., the web is slightly better as i can see a notification on the bell icon however with a delay from real time and without a sound,

    • Disable All

      I want to disable all the fields on the form when it loads.  I know there is a way to do this by listing all the fields as follows: disable Name; disable Address; disable City;  ... I have over 50 fields on my form and i am wondering if there is a single command or way to just disable all fields on load.   On load = disable All Thank you for any help.  

    • Zoho Mail - CRM Widget

      When I click on Associate this email to a contact within the CRM widget, I get "Oops! Something went wrong". This happen when I try to associate an email in a shared mailbox. The widget detect correctly the contact and show his informations from the CRM

    • Next Page