Visualize your data with a new set of charts: Treemap, Butterfly, Sankey, and Cluster charts in Zoho CRM

Visualize your data with a new set of charts: Treemap, Butterfly, Sankey, and Cluster charts in Zoho CRM

Dear customers,

When it comes to analytics, it's not just about the numbers; it's about understanding the story behind them. 

With that philosophy in mind, we’re excited to introduce a line of representations to the existing array of chart types in Zoho CRM: Treemap, butterfly, sankey and cluster charts. Let's go!

Treemaps

Treemap charts are used to visually represent hierarchical datasets in a rectangular layout. It aligns its parent categories as larger tiles with their sub-categories nested within them. The size of each tile is proportional to its corresponding value, making it easy to compare different segments within the hierarchy.

This is how a treemap chart looks:


These structured data representations help you understand overall performance and contributions, as well as compare participating entities at a glance.
 
Unlike traditional bar charts or pie charts, treemaps can be used if your datasets are large and exhibit parent-child relationships.
 
Here are some examples to better understand their usage:
 

Comparing revenue distribution between functions

A company's revenue is distributed among its functions before it gets further disbursed to its employees. Treemap charts can be used to depict this distribution and compare it between functions. As you can see below, the hierarchy can be represented as a treemap to compare it directly with other functions:


The hierarchy at the top shows just the numbers and levels, but the treemap chart represents the numbers proportionally, allowing leaders to visualize the difference in distribution.
 
Interpretation: As you can easily see in the treemap, sales and marketing receive the same amount of revenue, while engineering is given significantly more than the other two.

Likewise, with treemap charts, you can:
  • Compare popular lead sources with lead counts is the measure and lead source being the participating entity—a classic single-grouping configuration.
  • View cost savings achieved across departments. With the departments as the grouping parameters and the cost saved as the measured amount, the chart lays out all the departments as tiles in proportion, based on money saved.
  • Compare ad spends across channels, where channels are the parent grouping and ad spend is the measured unit.

Butterfly

Butterfly charts are used to compare two related datasets side-by-side, resulting in a representation that looks like a butterfly or tornado.
 
Now, how does it differ from bar charts?
 
The standard bar chart can compare two entities for a given measure. Say, you are comparing the performance of Mary and Charles. The two users' data is represented using bars, and the length will denote their performances. But, when it comes to comparing their performances over a period or their contribution across different stages, a bar chart is not sufficient.
 
A butterfly chart, though, will let you visually compare Mary and Charles' contributions directly and compare their own metrics across duration or other attributes.

With butterfly charts, you can:
  • Compare revenue between two of your branches each month. With branches being compared for sum of sales revenue, grouped by closing date.
  • Compare the performance of two reps in a given quarter. Compared between two users for average of amount of deals, grouped by closing date until today.

In addition to the user-based comparison above, butterfly charts are well-suited to visualizing other types of data comparisons, like:
  • Picklist-based comparisons
  • Duration-based comparisons
  • Aggregate-based comparisons

Business scenario


Comparing the number of deals closed for each lead sources: Duration-based comparison

You can identify the productive lead source by comparing the number of deal closures for every lead source in your organization based on their closing week.


Analyzing effective sales methodology, inbound vs. outbound: Picklist-based comparison


Businesses use both inbound and outbound lead generation strategies, and each of these methods can reap different results based on the season and occasion. By comparing inbound versus outbound each month, you can identify which works best at what time.

Analyze the amount versus the expected revenue between accounts: Aggregate-based comparison


Expected revenue is a result of a deal's progression in the sales pipeline. Comparing the amount versus their expected revenue will not only help visualize the expected revenue of participating accounts but also indicate the accounts' stage in the sales pipeline.


Sankey

A Sankey Chart is designed to visualize the movement of data across different data groups. Unlike traditional charts—such as bar, column, pie, or donut—that mainly provide a static distribution of values, the Sankey Chart focuses on illustrating the flow between multiple segments or grouping fields. This makes it an ideal choice when you want to track how values (like lead counts, revenue, or deal statuses) move from one category to the next.

Info
Key features
  • Flow visualization: With the Sankey Chart, you can observe the movement of data between different groups.
  • Multiple grouping fields: This chart works best when you have at least two grouping fields. You can go even further and add a third grouping to see an even more detailed mapping of your data flow.
  • Simple configuration: The configuration for the Sankey Chart is as simple as any other chart type in Analytics. 
Business scenarios:

Imagine you’re a sales manager trying to get a better handle on your team’s performance and your company’s pipeline. You want to understand not just how many deals are coming in, but also which sources are contributing the most value—and how those deals are progressing through different sales stages.
Let’s say you want to understand which lead sources are driving the most deal activity and how those deals progress through the pipeline. You can create a Sankey chart that maps the count of deals from Lead Source to Stage.

Let’s say you want to understand which lead sources are driving the most deal activity and how those deals progress through the pipeline. You can create a Sankey chart that maps the count of deals from Lead Source to Stage.



After analyzing the chart, you might notice that Online Store brings in a high volume of early-stage deals, while sources like External Referral contribute fewer deals that are more likely to reach advanced stages like Proposal or Negotiation.

This insight helps you prioritize nurturing the most profitable channels.

Sankey charts can also be helpful in other operational scenarios where understanding transitions across stages or teams is essential:
  • Regional revenue distribution: Visualize how revenue flows across different regions, product categories, and their corresponding annual revenue. This helps you compare which regions contribute the most to each product line and where your high-value segments lie.
  • Ticket handling flow: Visualize the flow of support tickets from their origin channel to internal departments and finally to resolution statuses. This can reveal workload imbalances or common points of delay in your support process.

Cluster  

A cluster chart is similar to stacked column charts, but instead of stacking horizontally, the data is represented as vertical bars. As you create a column chart with multiple groupings, you can change the type of column chart to a cluster chart to achieve this representation.
 
In the above image, you can see the stacked column chart compares the number of lead conversions based on popular sources between countries. The stacks appearing on top of existing stacks ask you to calibrate the record count (y-axis) based on the previous stacks, which can lead to inaccurate interpretations. In this case, a cluster representation will paint a clearer picture of the analyses.

Other minor enhancements:

In addition to the three charts we mentioned above, we've also made the following minor changes:
  • Display total summary: Thus far, for all charts, each participating measure included labels. Now, to better understand overall contributions, a check box to display the total summary is provided under More options on the Chart Configuration page. Based on the configuration, the total revenue or the rolled-up quantities will be prominently displayed.


  • Merge Y-axis: For charts that use two y-axis measurements, the intention is to view the progression of one entity against these two measures. Despite the scale, if the y-axis on the left is disproportionate to the values of the y-axis on the right, the plotted graph will result in a graphically and logically incorrect representation.

    As you can see in the image below, the plot area of the sum of amount bar and the sum of expected revenue aligns close together, while, the difference between $700,000 and $40,500 is drastic, creating inaccurate interpretations.

    In this enhancement, we're allowing neighboring values of measures to merge so that the interpretation can be more visually accurate.

  • Clone components to a different dashboard: Dashboards in Analytics serve in unique ways for various audiences—there can be separate dashboards for the sales team, marketing team, engineering team, and so on, and the chances of using the same measure for reference is common. Thus, when you clone a chart, you can now determine the target dashboard in which the cloned chart can be placed.

That's about treemap, butterfly, Sankey, and Cluster charts in Zoho CRM. With Waterfall chart following suit, we will open these charts for all customers gradually. For now, these are open for customers in the US DC. 

Resource: Help document

Thanks and have a good one!

Kind regards,
Saranya Balasubramanian


    Nederlandse Hulpbronnen


      • Recent Topics

      • Formula fields not refreshing until page is reloaded

        I need help/advice about the formula fields and how I can refresh the information in real-time. We have two formula fields on our deals page which show calculated prices: One formula is in a subform which calculates the subform total + 1 other field amount

      • How can I setup Zoho MCP with Chat GPT

        I can set up custom connections with Chat GPT but I cat an error when I try to set it up. The error is: "This MCP server can't be used by ChatGPT to search information because it doesn't implement our specification: search action not found" Thoughts?

      • Export Invoices to XML file

        Namaste! ZOHO suite of Apps is awesome and we as Partner, would like to use and implement the app´s from the Financial suite like ZOHO Invoice, but, in Portugal, we can only use certified Invoice Software and for this reason, we need to develop/customize on top of ZOHO Invoice to create an XML file with specific information and after this, go to the government and certified the software. As soon as we have for example, ZOHO CRM integrated with ZOHO Invoice up and running, our business opportunities

      • API ZOHO CRM Picket list with wrong values

        I am using Zoho API v.8. with python to create records in a custom module named "Veranstaltung" in this custom module I've got a picket list called "Email_Template" with 28 Values. I've added 8 new values yesterday, but if I try to use on of those values

      • Group Emails

        I have synced Zoho CRM to Campaigns but there are certain email not synced. showing it is Group Emails, but this email ids belongs to different individuals. please provide a solution as i nedd to sync the same.

      • Enable Password Import option in ulaa browser

        Dear Ulaa Team, I noticed that the Ulaa Password Manager currently offers an option to export passwords, but not to import them. This limitation poses a challenge for users like me who have stored numerous credentials in browsers like Chrome. Manually

      • "Is Zoho CRM customer" vs "Is linked with Zoho CRM"

        Recently while building a Flow, I was setting up a Decision action following a Zoho Invoice Fetch record action. There were 2 choices that I had not seen as something I could manually action in Zoho Invoice: "Is Zoho CRM customer" and "Is linked with

      • Client Script | Update #13 - Introducing ZRC: Simplified HTTP request library

        Hello Developers! Are you tired of juggling different methods to make API calls? Are you confused with multiple syntaxes and version restrictions? Have you ever wished for one simple way to make all API calls in CRM? We heard you :) Here comes ZRC (Zoho

      • Selection Filed for Data Export section

        Hi FSM Team, I hope you are all doing well. I would like to share an idea for future development based on my experience. Currently, in FSM, we can only download up to 5,000 records at a time. If the development team could add a selection option to choose

      • Text wrap column headers in reports?

        Is it possible to auto wrap column headers so that a longer multi-word header displays as two lines when the column is narrower than the width of the header title?

      • What if I dont see contacts on the left side list

        My CRM does not show the contacts tab. In order to create list this is needed and I cant find it.

      • Comments Vs. Replies

        I'm curious as to the difference between a "Reply" and a "Comment" on a ticket. It appears that "Replies" are what's used to determine response time SLA's and there are also used to automatically re-open tickets. I'm just trying to understand the key differences so I can educate both our clientele and our back-end users on which function/feature to use to better improve the ticket lifecycle. If anyone has any insight it would be appreciated. Thanks!

      • Transitioning to API Credits in Zoho Desk

        At Zoho Desk, we’re always looking for ways to help keep your business operations running smoothly. This includes empowering teams that rely on APIs for essential integrations, functions and extensions. We’ve reimagined how API usage is measured to give

      • Add Custom Reports To Dashboard or Home Tab

        Hi there, I think it would be great to be able to add our custom reports to the Home Tab or Dashboards. Thanks! Chad

      • Resetting auto-number on new year

        Hi everyone! We have an auto-number with prefix "D{YYYY}-", it generates numbers like D2025-1, D2025-2, etc... How can we have it auto-reset at the beginning of the next year, so that it goes to D2026-1? Thanks!

      • Microsoft Phone Link

        Does anyone know if you can use Microsoft Phone Link to make calls through Zoho?

      • Voip Phone system that integrates with Zoho

        Just checking to see if anyone could tell me what phone system they are using with Zoho that is on the list of systems that integrate with Zoho.  I use Vonage and have been with them for quite a few years but their service has really gone down hill and

      • Removing Related Modules Lookup Fields Assignment / Relationship

        Issue: When creating a related list, I accidently selected module itself creating a circle reference. See attached. Situation: I wish to relating a custom module called "Phone Calls" to Leads and Contacts. Outcome: 1) I either want to remove the this

      • [Product Update] TimeSheets module is now renamed as Time Logs in Zoho Projects.

        Dear Zoho Analytics customers, As part of the ongoing enhancements in Zoho Projects, the Timesheets module has been renamed to Time Logs. However, the module name will continue to be displayed as Timesheets in Zoho Analytics until the relevant APIs are

      • Kaizen #210 - Answering your Questions | Event Management System using ZDK CLI

        Hello Everyone, Welcome back to yet another post in the Kaizen Series! As you already may know, for the Kaizen #200 milestone, we asked for your feedback and many of you suggested topics for us to discuss. We have been writing on these topics over the

      • Can you prevent closing Ulaa window when the last tab is closed (inadvertently)?

        Most browsers have started to bring this feature in to prevent closing their windows when the last tab is closed (inadvertently). I hope Ulaa should get this in too.

      • Seriously - Create multiple contacts for leads, (With Company as lead) Zoho CRM

        In Zoho CRM, considering a comapny as a lead, you need us to allow addition of more than one contact. Currently the Lead Section is missing "Add contact" feature which is available in "Accounts". When you know that a particular lead can have multiple

      • can I link a contacts to multiple accounts

        can I link a contacts to multiple accounts

      • Rotate an Image in Workdrive Image Editor

        I don't know if I'm just missing something, but my team needs a way to rotate images in Workdrive and save them at that new orientation. For example one of our ground crew members will take photos of job sites vertically (9:16) on his phone and upload

      • Free webinar! Digitize recruitment and onboarding with Zoho Sign and Zoho Recruit

        Hello, Tired of being buried in onboarding paperwork? With the integration between Zoho Sign and Zoho Recruit, a powerful applicant tracking system, you can digitize and streamline the entire recruitment and onboarding process, all from one platform.

      • is it possible to add more than one Whatsapp Phone Number to be integrated to Zoho CRM?

        so I have successfully added one Whatsapp number like this from this User Interface it seems I can't add a new Whatsapp Number. I need to add a new Whatsapp Number so I can control the lead assignment if a chat sent to Whatsapp Phone Number 1 then assign

      • Open Activities view.

        I really like the new views for the open and closed activities inside the deals. But when you are in the tab view instead of the column view you can only complete and edit the open activity there isn't the 3 dot option to be able to delete the activ

      • Potentially Outdated and Vulnerable Chromium Engine Installed by Ulaa Browser Installer

        I just installed Ulaa Browser a few minutes ago. Whats My Browser page shows I am using an outdated Chromium engine meaning I might be vulnerable for security exploits that might have got fixed in the new version.

      • Potentially hardcoded list of Browsers to import from (after Ulaa Setup)

        I have just installed Ulaa Browser and found that the list of browser to import data is potentially hardcoded ones rather than looking at the system. I do not have FF, IE and Edge is not my default itself. I would appreciated if Ulaa detected my browsers

      • From Layout to Code: Finding Custom Field IDs in Zoho Projects.

        Hello everyone! Ever found yourself wondering how to get the API names and IDs of custom fields in Zoho Projects while working on custom functions? Here’s a simple and effective way to do it! This method makes it super easy to locate the right field details

      • How to notify all members on any updates to zoho crm?

        Hi, I am using the free version of zoho CRM and currently seeing this will work for our company. We are a small company and wanted to be more informed about all the changes in zoho.   1. How do I set notifications that go to the team for any and all changes made in Zoho. At this point, we'd rather be over-informed than under-informed. 2. Create a custom field (or rename an unused field) to be able to capture any "Product Feature Requests" from customers or prospects we're talking to. I have anyone

      • Zoho Mail Desktop App Not Loading + Can’t Manage Multiple Accounts

        Hi everyone, I’ve been having ongoing issues with the Zoho Mail desktop app for the past few weeks. The app starts to load but gives up midway and never actually opens — there’s no error message, it just stops loading. The main reason I use the desktop

      • How can I transfer data from Production to Development environment?

        Hi, I am using Creator V6 and would like to bring all the data in production to the Development and Testing environments? Is there an easy way of doing that or I have to export and import each table?

      • Billing frequency is not displayed correctly.

        Hello There is an issue while displaying the billing frequency on a subscription quote. I am able to activate the subscription details and get this lovely overview: If I am adding a Plan which I charge quarterly, first of all it should be possible to

      • Calling Function via REST API with API Key gives 401 using Zoho Developer

        Hi, I created a couple of functions using the one month trial of Enterprise edition, which I was able to call using the API Key method from Postman and from an external site. Now that my trial has expired, I have created the same functions in the Developer

      • Session Expired

        I constantly get "Session Expired" and need to relogin or close and open the application again. This gets really frustrating during the day. Is this something that can be solved? This really makes me want to leave the app as it is no go to need to reopen

      • Employee type and source translation

        In Zoho People, when I fill in the employee’s information, there is the option to determine the type of employment (employee type) and the hiring source. Both options ALWAYS appear in English. It is extremely inconvenient to deal with poorly translated

      • Sync Issue Between Zoho Notebook Web App on Firefox (PC) and Android App

        Hi Zoho Notebook Community, I'm facing a sync problem with Zoho Notebook. When I use the web version on Mozilla Firefox browser on my PC, I create and save new notes, and I've synced them successfully. However, these new notes aren't showing up in my

      • Request for Clarity on Timeline for True GPT/Zia Auto-Response Capabilities

        I appreciate Zoho’s steady innovation, but I’m concerned that Desk and Zia remain well behind modern AI capabilities. For years, GPT-based tools have been able to generate and send contextual responses, yet Zoho Desk only supports summarization or suggested

      • Notebook audio recordings disappearing

        I have recently been experiencing issues where some of my attached audio recordings are disappearing. I am referring specifically to ones made within a Note card in Notebook on mobile, made by pressing the "+" button and choosing "Record audio" (or similar),

      • Next Page