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





        • Recent Topics

        • Connecting Zoho Inventory to ShipStation

          we are looking for someone to help connect via API shipStation with Zoho inventory. Any ideas? Thanks. Uri

        • Subform edits don't appear in parent record timeline?

          Is it possible to have subform edits (like add row/delete row) appear in the Timeline for parent records? A user can edit a record, only edit the subform, and it doesn't appear in the timeline. Is there a workaround or way that we can show when a user

        • New in Cadences: Option to Resume or Restart follow-ups when re-enrolling records into a Cadence, and specify custom un-enrollment criteria

          Managing follow-ups effectively involves understanding the appropriate timing for reaching out, as well as knowing when to take a break and resume later, or deciding if it's necessary to start the follow-up process anew. With two significant enhancements

        • Im Stuck in an EDIT ONLY WITH WIZARD issue

          So I found Wizards to be a really helpful tool in minimizing the exposure of redundant, superfluous fields to staff that would never otherwise have to edit those fields. My issue is, that when the record (in this case a lead) is created with a wizard,

        • Account upgrade

          Good evening, I upgraded my account and paid for it. From standard to professional. Unfortunately after the paiment my account was not upgraded. Please your advise. Best Regards Erik van Staverden

        • How to set ALL default dates of my organization to DD-MM-YYYY format?

          All replies to this question comes from a time where the UI was different. It's extremely frustrating not being able to find how to do this simple setting change. I want everything and everyone in my organizations to have DD-MM-YYYY date format by default.

        • How can I sync from Zoho Projects into an existing Zoho Sprints project?

          Hi I have managed to integrate Zoho Projects with Zoho Sprints and I can see that the integration works as a project was created in Zoho Sprints. But, what I would like to do is to sync into an existing Zoho Sprints project. Is there a way to make that

        • Can we generate APK and IOS app?

          Dears, I want to know the availability to develop the app on zoho and after that .. generate the APK or IOS app  and after that I added them to play store or IOS store.. Is it possible to do this .. I want not to use zoho app or let my customers use it. thanks 

        • Zoho Subform Workflows onAdd of Row

          Suppose I have a form with attached workflows onLoad. If I use the form as a subform, will it inherit the workflows or do I need to create new ones onAdd of row?

        • 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

        • Super Admin removal

          I brought a sub, and I gave the Super admin rights to a person who is no longer with us, so I need to change, and I need to make myself the Super admin

        • Better Notes Commenting

          Hi, I'd like to suggest better collaboration tools for NOTES. The current notes section for Accounts, Contacts and Deals is not ideally suitable for any degree of communication or collaboration. When responding to a note, there is no ability to leave

        • Exporting Templates

          I have just spent 2 hours creating a project template for a Netsuite configuration, and want to share it with other Zoho Projects users - who have a different account. Is there any way to do this?

        • Power of Automation:: Streamline Associated Teams based on the Task Owner update.

          Hello Everyone, A Custom function is a user-written set of code to achieve a specific requirement. Set the required conditions needed as when to trigger using the Workflow rules (be it Tasks / Project) and associate the custom function to it. Requirement:

        • No Response from Zoho Support in 8 Days - Typical?

          I have a couple of issues I'm trying to work through. Initially, I was getting support from support@zohofsm.com, but I have not received a response in 8 days (11 on another question). Is this typical? Can I pay for support? For context, I am not spamming

        • Add QUOTE OWNER profile image to a Quote Template

          I can add their email address.. phone number, DOB. I need to add a users profile picture so when they assign a template to a quote they own it adds their picture to the cover page. I've tried hacking a solution together but there has to be an easier way.

        • Zoho Connections Desk API relative URL PATTERN_NOT_MATCHED

          While i am trying to do this: async function fetchTicketsFromDesk(timeFilter = 'current_month') { try { const response = await ZOHO.CRM.CONNECTION.invoke("desk_connection", { url: "/api/v1/tickets", method: "GET", }); const data = response.details ? JSON.parse(response.details)

        • Zoho CRM - Custom Views for Portal Users

          I'm looking for an option to customise custom views for portal users in CRM. It would be great if "portal user" was a permission on custom views.

        • 【参加無料】10/17(金) 東京 ユーザ交流会 Vol.3 参加登録 受付開始！

          ユーザーの皆さま、こんにちは。コミュニティチームの藤澤です。 10/17(金)に、東京・新橋で「東京 ユーザー交流会 Vol.3」を開催します！ 今回のユーザー事例セッションのテーマは、「Zoho Flowを活用した他社の決済サービスとの連携事例」です。 さらに、Zoho Flowに限らず、Analytics や Campaigns などの多彩なZohoサービスの活用方法について、豊富なご経験をもとにご紹介いただきます。 また、Zoho社員セッションでは、Zoho CRMを活用して日々の営業業務を効率化する具体的な事例をお話しします。業界を問わず、幅広い方にご参考いただける内容となっています！

        • Zoho Meeting Plug compatibility with newer versions of Outlook

          Documentation states that the zoho meeting plug in for outlook is only compatible with versions up to Outlook 2019 What is available to users of more up to date versions of outlook/office 365?

        • Getting Attachments in Zoho Desk via API

          Is there a way to get attachments into Zoho Desk via an API?      We have a process by which a zoho survey gets sent to the user as a link in a notification.    The survey has several upload fields where they can upload pdf documents.    I've created

        • Introducing Zoho's own SMS gateway

          We're thrilled to announce the launch of our own SMS gateway feature within Zoho Marketing Automation! This new feature enables seamless SMS campaign management alongside your email marketing initiatives, providing a more integrated and efficient way

        • Embedding in Desk articles

          We would like to embed documents in our Desk articles. When we use an iframe for the embed, we get scrollbars and a frame border. Neither of those is acceptable. I've spoken with the Desk Support team about what we want and they tell me that it cannot

        • Zoho CRM button to download images from image upload field

          Hello, I am trying to create a button in Zoho CRM that I can place in my record details view for each record and use it to download all images in the image upload fields. I tried deluge, client scripts and even with a widget, but feel lost, could not

        • Mass Update Contacts In Zoho Campaigns

          Is there a way to mass update contacts in zoho campaigns? I want to be able to change the content of a field for a few hundred contacts, and can't go through all of them individually.

        • report showing assignment type

          Hi, We've created a number of workflows to allow us to auto assign tickets to agents based on keywords and other criteria. I'm struggling to create a report that would show me what is the percentage of tickets that are assigned automatically via workflows

        • Option to Disable Knowledge Base Section in Feedback Widget Popup Hello Zoho Desk Team

          Hello Zoho Desk Team, How are you? We are actively using Zoho Desk and would like to make more use of the Feedback Widget. One of the ways we implement it is through the popup option. At the moment, the popup always displays the Knowledge Base section,

        • Placeholders in Ticket Templates

          We should be able to use placeholders in ticket templates. When we create a new ticket, our description field is shown to the client in the email they receive.  It would be very handy to be able to personalize that description field in our ticket templates to pull in the name of the client that the ticket is for. Using them in the subject field as well, so we can auto populate Account Names, etc. 

        • when the record is created the tag want to Show as Opportunity how i achive this using Deluge Script

          In the quotation i have the work flow schedule for create opportunity record in the module , on that time the quotation tag select as opportunity created. How i achive this using Deluge Script . this like i want to Do tag1 = Map(); tag1.put("name","Nurturing

        • Delete a channel

          I need delete a channel in tickets.

        • Copy / Duplicate Workflow

          I have workflows setup that are very similar to each other. We have a monitoring system watching servers, and all notifications - no matter what client it is about - will come from a  noreply@ address which is not very helpful in having it auto assigned to the right account. I have setup a workflow that will change the contact name of the ticket (currently it would say noreply@) to the correct customer which is based on the subject line, as that mentions which server the alert it is about. I need

        • Subtasks don't update parent task's times

          Hi there: I've recently upgraded to premium and check that subtasks completion % don't update the proportional completion of the parent tasks related to it.  We've been challenging with the problem of having to update twice or sometimes 3 times the completion of the related tasks. I've seen posts similar to this, of 3 years old.  Is there any roadmap for making this happen in a future release? Thanx César Ratto Lima, Perú.

        • Should I Use DMARC?

          When I configure Zoho Mail's DMARC settings, it's mandatory to fill in the RUA and RUF (Aggregate notification email address*, Forensic notification email address*) addresses. When we enter an email address in these fields, we receive reports from the

        • Mail ToDo & Tasks Webhooks

          Our company uses Zoho ToDo inside Mail to manage our tasks. When I create a task and assign it to a team member it does not notify them unless I add a reminder via mail. I'm trying to create a webhook for when a task is created to send a cliq message

        • Can't upload attachments.

          I can't upload attachment in Zoho Mail.

        • Tip #44 – Get Deeper Insights with Zoho Assist’s Custom Reports – ‘Insider Insights’

          In today’s fast-paced IT environment, having a clear view of your remote support activities is more important than ever. Zoho Assist’s Custom Reports feature gives IT teams the ability to generate tailored reports that provide actionable insights and

        • Message "...does not support more than 100 distinct values..." WHY????

          I get this message on one of my reports: Sorry, Zoho Reports currently does not support more than 100 distinct values in columns. 'Account Name * Sum(Amount),Count(Amount Tier)' contains more than 100 distinct values.  Possibly, you can apply filter to reduce the number of distinct values in 'Account Name' or drop the 'Account Name' field in Rows. I want to list all ACCOUNT NAMES (about 500) with SALES BY ACCOUNT.  What is blocking this?

        • Need Easy Way to Update Item Prices in Bulk

          Hello Everyone, In Zoho Books, updating selling prices is taking too much time. Right now we have to either edit items one by one or do Excel export/import. It will be very useful if Zoho gives a simple option to: Select multiple items and update prices

        • Let's Talk Recruit: Super-charge hiring with Zoho Recruit add-ons

          Welcome back to our Let’s Talk Recruit series! This time, we’re diving into something that might seem like a small upgrade but has a huge impact on recruiter productivity: Zoho Recruit add-ons. Think about how much of your day is spent in your inbox or

        • Vendor Signatures Needed for Purchase Orders

          Hello everyone, We have a unique requirement that necessitates that Vendors & Suppliers formally acknowledge our Purchase Orders upon receipt. I was hoping that there would be an option to do so in Zoho Books, but that does not appear to be the case.

        • Next Page