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

    • smtppro.zoho.como eror

      En nuestras cuentas de empresa desde hace unos dias estamos experimientando problemas con los correos IMAP outlook, generando un error en el smtppro.zoho.com 465 /SSL Todo estaba trabajando bien y sin problemas. Alguien mas con el mimo problema y/o encontró

    • Outgoing Email blocked

      Hi Support Team, My outgoing emails has been blocked, Appreciate your help to unblock it. Hartron Trade

    • Sheet view ignores layout rules / How to restrict fields in sheet view

      Hi Problem 1: When editing records in sheet view, layout rules are ignored. This is a problem, because it allows users to ignore some mandatory fields (mandatory in a Layout Rule). (Mass Update does not allow updating of fields with Layout Rules, so why

    • Portal users embed access

      So I have a page with a form, and two reports on either side. The reports are embedded as html snippets. So basically, it's set up that when I select a material from the form lookup field, it reloads the report embeds but filters the records with the

    • Importing Accounts with Parent Accounts

      I would like to import accounts that contain parent accounts.  I see a Parent Account but do not see a Parent account number in the Zoho fields and will need this to make sure the correct unique parent is imported. Can you help explain how to accomplish this?

    • Merge item

      As a follow up on a request point raised 7 years ago I would like to submit an official request to enable a "merge item" option. Discussion: https://help.zoho.com/portal/en/community/topic/merge-items submitted by user 4001007559351 Our business has several

    • Canvas Fit to Screen

      Hi, is it possible to have the Fit to Screen tickbox unmarked as a default?

    • Banking - User Roles - Access To Single Bank Account

      Hi, We have different locations with each location having a specific bank account for Expenses/Etc... Can you please confirm on whether it's possible to give a user (non accountant), specific access to only a single bank account as opposed to all accounts

    • Zoho Account search not finding account even thought account is created

      Hi Over the last week I cannot find a account on a lookup field, the account exists as when I check in the module its there. Any lookup filter, in a lookup field fails to find the appropriate account, im not sure if you have a Regex issue but its clearly

    • How to send an alert when there have been no leads for 2 days

      Hello, I want to be alerted when there have been no new leads created for, say, 2 days. It seems like it should be a simple thing to achieve but I'm struggling. I tried asking Zia and this was the answer, but it doesn't fit what I'm seeing on the workflow

    • How to get bulk write to work as expected

      I need to move data from our systems into Zoho. I have created a sandbox to test the usage of migrating our data to Zoho and confirmed everything worked there. When attempting to do the same with our production CRM I was met with an error saying Zoho

    • Zoho Sign embedded iframe

      Hello, we are looking for any of these options: a) some iframe that we can paste into our website for every signer, for onpage signing document. b) or get direct link for signers from Zoho sign API which we can redirect manually. Is any of these options

    • SIGNATURE FIELD INSIDE CRM MODULE

      I need to have a signature field inside CRM MODULE This can be used into my Post Sales Module that i´ve created to make Meetings Summary I need my client to sign this Meetings Summary during my visit and that ain´t possible with Zoho crm I know we have

    • email and username change

      HI, I'd like to change my email and username for my zoho store, please help me on this issue.

    • "Extra keys limit has exceeded"

      Hello, Has anyone encountered the below message before in a workflow log failure: "Update Record Response is {\"code\":52,\"message\":\"Extra keys limit has exceeded\"}" The script is supposed to generate an invoice for a deposit when a deposit payment

    • Collapsible Sections & Section Navigation Needed

      The flexibility of Zoho CRM has expanded greatly in the last few years, to the point that a leads module is now permissible to contain up to 350 fields. We don't use that many, but we are using 168 fields which are broken apart into 18 different sections.

    • use of comma as a decimal separator

      Hello, I wish to find a way to customize the number format for my proper use. I have to use french data, where the "," is used as the decimal separator : for example the french way to write "3.99�" is "3,99�" Is it possible to do it in Zoho Sheet ? If this is not actually the case, I'd love this feature to be implemented !

    • Zoho meeting api not working in trial version

      I have and free trial meeting access. When i have tried to create a authentication code for meeting it shows Invalid OAuth Scope error. My code: $client_id = 'client_id'; $redirect_uri = 'site_url'; $scope = 'ZohoMeeting.organize.CREATE,ZohoMeeting.organize.READ';

    • Why is Nordic No Longer Available as a Translation Service for Email

      I routine receive email in Nordic but now it has been removed from the list of available translations. Why?

    • Create WorkDrive Folder with specific Sub-Folders when new Zoho CRM entry in "Accounts" Module

      So, my flow creates a WorkDrive Folder in the required Team Folder, but I want the same flow to create four Subfolders within the new folder. Man, Woman, Boy & Girl sub-folders I was looking at this below but how do I identify the new Parent folder as

    • Live webinar: 2024 recap of Zoho Show

      Hello all, 2024 has been an incredible year for Zoho Show! We've listened to your feedback and worked continuously to strengthen the tools you use to create, collaborate, and deliver presentations. From rolling out new features to enhancing existing ones,

    • Changing Customer Currency

      It seems so silly that you can't change a customer's currency after a transaction is recorded. We work with companies all over the world and sometimes they might request an invoice in a different currency. To do this I have to create another customer

    • Bulk payment of bills from multiple vendors

      Is there a way to pay multiple vendors bills in one transaction?  It appears that you have to deal with each one as a seperate transaction.  Is there a way to export the transactions to the bank using an ABA file?

    • Line_Items not appearing in invoice arrays

      When i use the Zoho API to pull an invoice, it doesnt show the Line_items array... In the documentation it shows that it should appear but it does not. Is there any way to fix this?

    • Active Customer List 2024

      Hello everybody, i am just a beginner :) how can i create a customer list of all active customer in 2024? Active customer means, all customers, who received an invoice in 2024 of us. Just tried already in CRM. Can i do that also in ZOHO books? I am looking

    • Notifications on mentions in comments

      If another user mentions me (e.g. @mustafa... which autocompletes) in a comment on a ticket, how do I get notified? If I don't get notified, what on earth is the point of the mention feature???

    • [New] Create invoices and contracts in minutes with Zoho Writer's Merge Templates for Bigin!

      Do you often find yourself manually entering customer information in your business documents like invoices and contracts? This can be a time-consuming process that can take up valuable time from your business operations. With Zoho Writer's Merge Templates

    • Setup for a service based business

      I apologise if this has been asked before but a search of the forums didn't turn up what I was looking for. I am looking at setting up Zoho CRM for a consultancy based business and so there are no products as such. This is fine as I can create a product which is time based. However, I do not seem to be able to get rid of the concept of having quantity in stock. I have a unlimited supply of time! How can I bend Zoho to my will and get rid of the stock control? Thanks Neil

    • Introducing the New SalesIQ Live Chat Widget: Twice as Fast, Fully Optimized for Engagement!

      Hello everyone! To celebrate our 10-year milestone, we're thrilled to unveil the new and improved SalesIQ Live Chat Widget! Redesigned at both the User Interface and performance levels, this enhanced widget is not only optimized but also 2X faster than

    • Search terms from ASAP widget are not showing up in my Zoho Desk analytics

      When people perform searches in the Zoho Desk ASAP widget, the search terms do not show up inside my analytics report. But when people access the KB website directly and then do the search, the keywords ARE showing up. Is this a known issue, or am I just

    • Microsoft Loop integration

      Hi has anyone had luck getting any components of Microsoft Loop integrated into Zoho One, for example Follow-up tasks into Zoho Projects or other app, or perhaps Loop notes into Zoho Notes? cheers

    • Searching for content within courses

      Hello, I have been testing out Zoho One for my company have been exploring Learn. I've noticed that you cannot search for content within a course. You can only locate the title of the course. Example: Course: How to Make Your Bed Chapter: Pillows Lesson:

    • Cohort - Zoho Analytics

      I am developing a cohort analysis in Zoho Analytics for Tickets/Service Desk, which tracks the number of tickets created each month and when those tickets were closed. I have added a user filter for classification. When I change the classification using

    • Helper Functions and DRY principle

      Hello everyone, I believe Deluge should be able to use 'Helper functions' inside the main function. I know I can create different standalones, but this is not helpful and confusing. I don't want 10000 different standalones, and I dont want to have to

    • Automation Issue with Email Templates in Workflow

      Hello Zoho Support Team, I’m currently facing an issue with the automation setup in my workflow for following up with applicants. I have configured the workflow to send out emails with different templates, which work perfectly when sent manually. However,

    • Disable Private Reply.

      Is it possible to disable the option to do "Private Reply" for tickets? The reason is that sometimes we click on reply or "reply all," but the system automatically selects "private." Am I doing something wrong? Thanks Rudy

    • Zoho Books | Product Updates | October 2024

      Hello users, We're back with fresh feature updates in Zoho Books. Starting from associating an applicable period for TDS taxes to minimised tab view for web tabs, discover the latest enhancements that will streamline your workflow and elevate your accounting

    • Merge Items

      Is there a work around for merging items? We currently have three names for one item, all have had a transaction associated so there is no deleting (just deactivating, which doesn't really help. It still appears so people are continuing to use it). I also can't assign inventory tracking to items used in past transactions, which I don't understand, this is an important feature moving forward.. It would be nice to merge into one item and be able to track inventory. Let me know if this is possible.

    • Failures installing Unattended Agent using Microsoft Intune

      Hello, I configured Zoho Assist Unattended Agent using Microsoft Intune, following the steps outlined in this article, using a .MSI installer. I added a pilot group of users and for 6 of them it installed correctly and I see their computers in Zoho Assist

    • Crear tarea CRM con recordatorio desde Zoho Flow

      Hola, estoy intentando crear desde Zoho Flow una tarea en CRM. Lo he logrado hacer pero sin recordatorio, ya que no se como se debe escribir el string adecuado. He probado varias alternativas, pero ninguna me funcionó hasta ahora. - FREQ=NONE;ACTION=EMAIL;TRIGGER=DATE-TIME:${FechaVto}

    • Next Page