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

    • Feature Enhancement Request – Text Formatting Options in Item Description (Zoho Books/Quotes Module)

      Dear Zoho Development Team, Greetings from Radiant360 Integrated Technical Services LLC. We would like to bring to your attention a functional limitation we've encountered within the Item Table / Quote Description section of Zoho Books (and Zoho CRM Quotes).

    • Add Option to Mass Dispatch by User

      Hello! We are using the dispatch console to dispatch service appointments to our service ressources. Right now, the process is our dispatcher verifies each ressource's route for the day and dispatches it after validation. Sadly, there doesn't seem to

    • Bank Receipt Catagorization

      Hi, how can I match a bank deposit to multiple customer's invoices ? For e.g. A single person paid to us on behalf of different five customers. I need to keep the separated invoices for each customer

    • Per Level Approval for admins

      We need Process admins like Zoho CRM in Zoho Books for per stage approval Currently in books, admins only have the option for Final Approval But for example, in cases like when an employee is on leave, we can't just approval one level we only have option

    • Payment on a past due balance

      Scenario: Customer is past due on their account for 4 months. We suspend their billing in Zoho books. Customer finally logs into the portal and enters a new credit card. We associate that cardwith their subscription, which will permit the card to be used

    • How to export all line-item descriptions for a specific item in Zoho Books?

      I am trying to audit a specific item (“Item X”) that has been invoiced multiple times with different line-level descriptions. Here’s the situation: I am using Zoho Books (Professional). Each invoice may contain the same item but with different descriptions

    • List of hidden features

      Hi Friends, I had another support chat today and low and behold the feature that I wanted just simply needed to be "enabled". I thought I'd share, and maybe see if others had some similar experiences. 1. This one is from 5 ish years ago. I asked if there

    • How to change a BAS that has been filed

      I have discovered that a group of expense transactions were accidentally placed in a asset account rather than an expense account. As a result I need to adjust the transaction and consequently most of my BAS to correct the error. Because the BAS have

    • How to Export PDF with a custom Template

      I need to export Sales Order with a Custom Template I have created How can I do it? I see an API to export the PDF but how can I choose which template to choose to generate the PDF

    • Associate email with a potential or project.

      I have a pivotal requirement to associate emails from various suppliers (contacts) with different potentials or projects, on an email by email basis as they come in. This question appears to have been raised before but I cannot find a definitive yes "it can be done". Could anyone please tell me, yes or no.  If the later I can stop wasting time and look at alternative crm systems. I would love not to have to do this. Thanks in advance.

    • MTA - BAD IP reputation by outlook/hotmail

      Messages to Microsoft email servers are bouncing back due to poor reputation. Message: 4.7.650 The mail server [136.143.188.206] has been temporarily rate limited due to IP reputation. For e-mail delivery information see https://postmaster.live.com (S775)

    • Function with Search Records was working until a few weeks ago, around when "Connected Records" was released

      I have a custom function that has been running for nearly a year now, which suddenly stopped working around the time Zoho released the "Connected Records" update. The function is no longer finding the record using the searchRecords function. I've changed

    • Is CRM On Premise available

      Hi Zoho team, Can you please let me know that CRM Zoho is available for On Premise as well? Thanks, Devashish

    • How to sync from Zoho Projects into an existing Sprint in Zoho Sprints?

      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

    • Online Assessment or any aptitude test

      This video is really helpful! I have one question — if I share an assessment form link (through email or with the application form on my career page), how does Zoho Recruit evaluate it? Can a candidate use Google or external help while taking the test,

    • Editing the Ticket Properties column

      This is going to sound like a dumb question, but I cannot figure out how to configure/edit the sections (and their fields) in this column: For example, we have a custom "Resolution" field, which parked itself in the "Ticket Information" section of this

    • Incoming Threads Report

      From data to decisions: A deep dive into ticketing system reports Customers raise questions and issues through multiple channels, such as email, chat, or tickets. To monitor the number of queries received on a specific day from each channel, leads can

    • Conditional layouts - support for multi-select picklists

      Hi, The documentation for conditional layouts says the following: "Layout Rules cannot be used on the following field types: Auto Number Lookup Multi Select Lookup User Lookup Formula File Upload Multi Line" I have a custom module with a multi-pick list

    • Samsung Keyboard Issues with Notebook

      Dear Users, We're sorry to inform you that some of our users are experiencing certain issues like scrolling, delay/lag, cursor placement especially within the text notes. This occurs mainly due to Samsung Keyboard compatibility with Android 13 and some

    • How to apply customized Zoho Crm Home Page to all users?

      I have tried to study manuals and play with Zoho CRM but haven't found a way how to apply customized Zoho CRM Home Page as a (default) home page for other CRM users.. How that can be done, if possible? - kipi Moderation Update: Currently, each user has

    • Cloudflare Turnstile is now available in Zoho Forms!

      Hello form builders! We have added a new layer of protection to help you keep your forms free from bots. Instead of forcing users to prove they are human, Cloudflare Turnstile quietly checks browser signals in the background. Your real users glide through,

    • Power of Automation :: Unique Task & Issue Prefix Format and Sequencing Rule

      Hello Everyone, A custom function is a software code that can be used to automate a process and this allows you to automate a notification, call a webhook, or perform logic immediately after a workflow rule is triggered. This feature helps to automate

    • 【Zoho CRM】キャンバス機能のアップデート

      ユーザーの皆さま、こんにちは。コミュニティチームの藤澤です。 今回は「Zoho CRM アップデート情報」の中から、キャンバス機能のアップデートをご紹介します。 目次 グリッドについて フォーム表示のタブについて 1. グリッドについて ビジュアルデザインは細部の調整に手間がかかりますが、キャンバスのグリッドを使えば要素を整理し、バランスよく配置できます。 画像やデータなどの要素をグループ化せずに簡単に配置できます。 余白を調整することで、要素間の視覚的なバランスを保つのに役立ちます。 「表示切り替え基準の幅」を設定すると、デザインをレスポンシブに調整できます。

    • Deleting unwanted ticket replies

      Hello, In a Zoho Desk Ticket thread, sometimes one of the recipients has auto-reply activated. This creates a new message in the Ticket thread that not only pollutes the thread, but most importantly cannot be replied properly because usually auto-reply e-mails don't do "reply all", so the other recipients are not included. I want to delete such a message in the Ticket thread. I searched the help of Zoho Desk, but only found a way to mark as Spam (https://help.zoho.com/portal/kb/articles/marking-support-tickets-as-spam)

    • Issue: Ticket Export Does Not Include Ticket Threads

      Dear Zoho Desk Support Team, I hope you’re doing well. I wanted to bring to your attention that the current ticket export feature in Zoho Desk does not seem to include the ticket threads or conversation history. When exporting tickets, only the summary

    • Ability to Set Client Name During Portal Invitation

      Hi Zoho Team, We would like to suggest an important enhancement to the Zoho Creator Client Portal functionality. Zoho Creator recently introduced the option to set a client’s display name in the Client Portal settings, which is very helpful for creating

    • スマホでキャンペンメールを見ると正しく表示されない

      キャンペーンのメール（HTML）を作成しましたが、スマホ表示に切り替えると正しく表示されません（添付参照）過去に作成したキャンペーンでは特に意識してませんでしたが、問題なく表示されていたようです。うまく表示される場合とされない場合の違いは何でしょうか？

    • 136.143.188.51 blocked by spamcop

      Zoho mailserver seems to be blocked by spamcop. Cant send mail to my customer. Not sure what to do.

    • Zoho Calendar Integrated Into CRM?

      I've searched around the forums but couldn't find anything addressing this . . .  Is there a plan to integrate Zoho's stand alone calendar solution into Zoho CRM?  The CRM calendar does an OK job but is very basic and the Zoho calendar is great, but I've only figured out to subscribe to my CRM calendar within ZCalendar - there is no 2-way sync. My preferred solution would be for ZCal to become the default calendar/event solution within Z CRM. Is this on the roadmap? Thanks

    • Can I Create Different Page Layouts Based on a Specified Module Pick List Field

      I am trying to work out how to create different page layouts based on a specified module pick list field value, like the Salesforce feature where you can define multiple record types and then create custom page layouts for each record type. This is a super important feature as for almost all the modules we are using (Leads, Potentials, Accounts) we need to be able only show fields relevant to the record type. E.g. We need a very different page layout for a consumer lead Vs a commercial lead, same

    • Scheduling Tasks in Relation to Project End Date

      I use Zoho project  to help manage tasks that relate to a number of specific business events that take place.  I would like to be able to have my project end date be the date of the event and then work "back" from that date to say...   Add a task 2 weeks before the project end date to remind me to XYZ.  Does anyone know if there is a way to base task timings back from a project due date rather than a project start date?

    • Notes of Tasks in Zoho CRM

      Hello, Is there a way to filter the Notes that appear on a Task to only show the notes related to that specific Task and not display all the Notes of the objects related to that Task (Accounts, Contacts, Deal, etc). In essence, our team struggles to understand

    • Passing the CRM

      Hi, I am hoping someone can help. I have a zoho form that has a CRM lookup field. I was hoping to send this to my publicly to clients via a text message and the form then attaches the signed form back to the custom module. This work absolutely fine when

    • How to next stage blueprint in Zoho Creator

      Hello, I have question, its possible to next stage blueprint? in case, Start - (first stage) Leader 1 (with condition 1) - (second stage) Leader 2 (with condition 2) - (third stage) Leader 3 (with condition 3) - (fourth stage) After first stage, i want

    • Feature Request: Email Follow-Up Sequences Similar to Zoho CRM

      I’m wondering if Zoho Recruit is planning to introduce a feature similar to the Email Automation – Follow-Up Sequences that is available in Zoho CRM. In CRM, this allows users to send a series of timed follow-up emails triggered by specific actions (for

    • Duplicated Notebooks

      Out of the blue, almost all of my notebooks got duplicated and the different copies contain different information. Some seem like older copies than the others. I use the linux desktop app and sometimes the Android app. I assume that the sync failed at some point and was unable to merge the two versions together. But I'm afraid to add anything else to my notebook because if it can't properly sync 5 notebooks with only a handful of notes each, what will happen when I have hundreds of notes and I lose

    • Currency limitation when integrating Zoho CRM & Zoho Books

      Brief Video of Problem: https://www.loom.com/share/d61d1d07d0904e149d80c1901a22418e. Background ·       Our business is based in Australia and we have to have Zoho Books in AUD to comply with tax and reporting regulations in Australia. ·       We sell

    • Multi-select Lookup does not have Advanced filter options in CRM

      With much fanfare Zoho announced the advanced filter options for CRM lookup fields which was a nice addition. This feature is not available for Multi-Select lookup fields. Will it be rolled out in the next 3-6 months, considering the standard lookup filter

    • Experience effortless record management in CRM For Everyone with the all-new Grid View!

      Hello Everyone, Hope you are well! As part of our ongoing series of feature announcements for Zoho CRM For Everyone, we’re excited to bring you another type of module view : Grid View. In addition to Kanban view, List view, Canvas view, Chart view and

    • Unable to copy into a new document

      Whe I create a new Writer doc and attemp to copy and past I get this message. The only way to copy into a document is I duplicate an existing document, erase the text and save it under a different name and then paste the information. Not ideal. Can you

    • Next Page