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

    • Deluge - Can't get phone number SalesIQ

      Hey folks, I’m building a custom plug for SalesIQ that’s supposed to register leads into Zoho CRM. The SalesIQ chat is being implemented on WhatsApp, and in my plug I’m using this line: mobile_clean = session.get("phone").get("value"); From what I understand,
    • Zoho Desk - Community

      As a regular user of Zoho Cares Community I would really love to see the publish date of articles. For example, when I look at Announcements, it would be very beneficial to see which ones were posted recently, over those which have just and a recent comment.
    • access to quartz for my customers

      Hi how can I have access to the application quartz you use for us to send you screen rocording, this feature would be immensely useful for our customers support https://quartz.zoho.com/
    • Issue with Inline Images in Email Reply via Zoho Desk API

      Hi, I am attempting to send inline images in an email reply using the Zoho Desk API, but the images are not being displayed inline for the recipient. I have followed this documentation: https://desk.zoho.com/DeskAPIDocument#Uploads https://desk.zoho.com/DeskAPIDocument#Threads#Threads_SendEmailReply
    • How to search a value stored in a subform?

      Hello, We store serial numbers in subforms but now we would like to be able to search the values to be able to easily find the record with the serial number. I saw that it's not possible to search such values through global search but is it possible to do it an other way? Thank you,
    • Field Dependency Not Working on Detail Page in Zoho Desk

      Hi Support Team, I’ve created field dependencies between two fields in Zoho Desk, and they are working correctly on the Create and Edit layouts. However, on the Detail page, the fields are not displaying according to the dependencies I’ve set — they appear
    • How do the keyword critera work?

      Hi, I'm working on automated assignment of tickets based on keywords. How does this feature work? Where does this criteria look for keywords - email address, subject, email body? Can you please clarify this as I want to avoid overlapping with criteria
    • Error: Unsupported content type: text/html;charset=UTF-8 after tryeing to get the token for n8n automation

      I am working on ZOHO Desk automation and need to get the ZOHO auth token for n8n I have created the app in ZOHO Desk API, got client id and client secret. Added all data required to get a token in n8n. After I sign in with my ZOHO credentials in ZOHO
    • Improving Collaboration Features in Zoho Portal

      Hello Zoho Community, I’ve recently started exploring Zoho services and I’m really impressed with the wide range of features. However, I feel there is still room for improvement in the collaboration area. For example, it would be really helpful if we
    • Automated Shopify Emails Not Being Delivered

      I have an ecommerce store with Shopify. I recently set up my email to be served through Zoho. Since doing this, customers are not receiving some of our automated emails from Shopify itself. Our initial email that confirms their purchase goes through but our Shipping Notification that is automatically sent out upon fulfillment is not going through. Sometimes we get a notice that it's been classified as spam, sometimes nothing. I can send/receive email via Outlook on my desktop and I can send/receive
    • I can't log in to my account on Thunderbird

      I've just had to rebuild my PC (calamitous mess from Microsoft with Win10/Win 11 'upgrade' - they confirmed I had to start with a new build). I have used Zoho mail for years via Mozilla Thunderbird, but now I've had to download the latest version of TBird,
    • Send a campaign to one recipient.

      Very often I speak to a customer and they say they didn't see my email (maybe it went in Junk, maybe they deleted it). Anyway, I just want to go into the Campaign and send it to one person. You already have a feature very close to this - when sending a Test. While developing a campaign, I can send tests to anyone. Why can't we have this AFTER  the campaign has been sent? I know, there's a caveat, and that's in the use of merge tags. Most of the time I only use FNAME, but maybe you could check if
    • Try FSM again for our business

      We already have our customers individual equipment in CRM with serial numbers, install dates, warranty length and importantly next service which is generally 2 years. a month before the service date is due we get get a report and send out service reminders.
    • Use Zoho Books to bill for work done in Zoho Desk??

      I'm trying to see if something is possible (and if yes, how). We use Zoho One to manage our business. We have a lot of clients that will put in a ticket (via portal) to have work done. Out techs will pick up the ticket, do the work, and then log the time
    • Get Cliq Meetings in my O365 calendar

      Hi, we are currently evaluating to replace the Teams Messaging and Meetings with Cliq. We currently still have all our email and calendars in O365. What i want to achieve is, to create a (ZOHO) meeting from Cliq and have this meeting added to my Outlook/O365
    • Issue with Zoho Help Portal – Tickets Missing or Not Answered

      Hi, How are you? I think there may be an issue with the Zoho Help Portal. I opened a few tickets directly in the help portal a some time ago but never received any response I also opened ticket 148356451 by email. I did receive a reply to it, but the
    • DUNS & Bradstreet and Credit risk monitoring integration with Zoho books

      Small businesses not being paid by bigger clients and clients of all sizes is a huge problem. It will be nice if Zoho develops integration with DUNS & Bradstreet(D&B) and Credit risk monitoring integration with Zoho books. That have small businesses can
    • Zoho Forms - Form Rules based on attachment fields

      Many businesses use forms to collect documents and images from customers. In many cases, you may want to trigger a notification or other automation based on whether or not an attachment was added. I've noticed that attachment fields do not appear in Rules
    • Add multiple users to a task

      When I´m assigning a task it is almost always related to more than one person. Practical situation: When a client request some improvement the related department opens the task with the situation and people related to it as the client itself, the salesman
    • Can't open draft email for editing

      Last night I started composing an email and I let it save in drafts. This morning I want to continue working on the email. It is in my Drafts folder but it will not open. The only option there is to delete it. This is not the first time it has happened. On previous occasions I have just deleted the draft and started afresh, but I really want this one back. Windows 10 with Pale Moon 28.10.0 browser.
    • Open filtered deals from campaign

      Do you think a feature like this would be feasible? Say you are seeing campaign "XYZ" in CRM. The campaign has a related list of deals. If you want to see the related deals in a deal view, you should navigate to the Deals module, open the campaign filter,
    • Change scheduling emails time

      When sending an individual email there is a great feature to schedule them to send later. I could only use the one time that is suggested. Is there a way to select another time? Regards, Glenn
    • Zoho CRM: how can I control which contacts to sync with Outlook?

      I was just playing around syncing contacts from Zoho to MS Outlook (MS365 account.) The problem is our firm has hundreds of thousands of contacts and I don't want to bury my contacts list in outlook. Any help with this is greatly appreciated.
    • How to overcome limitations in meetings

      As a company, one of our deliverables is a meeting between two other companies, where we act as facilitators. So, if we recorded this meeting  in Zoho CRM, it should be connected to 2 accounts, 2 contacts, and 1 campaign (a campaign, in our use, is the
    • Different MRP / Pricing for same product but different batches

      We often face the following situations where MRP of a particular product changes on every purchase and hence we have to charge the customer accordingly. This can't be solved by Batch tracking as of now so far as I understand Zoho. How do you manage it as of now? 
    • Add a 'Log a Call' link to three dot icon in Canvas

      Hi, There's a three dot element when creating a canvas called 'More'. I would like to modify this to add a link that says 'Log a Call' in order to quickly record the details of a cellphone call. I'd also like this to be a simple 'contact' selection and
    • Syncing Zoho Forms with Bigin - Embedding issue?

      Hello everyone, I created a Zoho Form for a page on my GoDaddy website to collect leads, which then transfers the data to Bigin. However, I'm facing an issue where it doesn't seem to work properly. I've integrated Zoho Forms with Bigin and tried embedding
    • Can not add fields to a Section

      I feel like I'm missing something obvious: I can add new Sections to my form but I can not add fields to the Sections. I've tried fields already on the form as well as dragging and dropping new fields into the Section but nothing will go into it. What
    • Record Logged in User while using CRM lookup field

      Is it possible, while using the Zoho CRM lookup field, to automatically use the user account logged into Zoho CRM in a hidden field? I was hoping to add employee accounts to my current plan. But would like a record on the Form submission of who submitted
    • Form Rules for Suburb Categories to alternate landing pages or Making a Fields Contents ALL CAPS

      I need to send differentform submissions to two to three different thank-you URLs (for Meta/Google pixels) depending on which suburb a user selects in a form. I have ~400 suburbs split into two categories (A and B, based on business value). Current challenges:
    • Collaps Notes

      There are times when long/large notes are added to a record i.e. Accounts or Deals etc. Currently, the full note is displayed in the notes related list section. It would be great if by default only 5 to 10 rows of the note are displayed when the note
    • Zoho Down

      I have a drop in my Zoho One services.
    • Runing RPA Agents on Headless Windows 11 Machines

      Has anyone tried this? Anything to be aware of regarding screen resolution?
    • Problem for EU users connecting Zoho CRM through Google Ads for Enhanced conversions

      Has anyone else experienced this problem when trying to connect Zoho CRM through Google Ads interface to setup enhanced conversions? Did you guys get it fixed somehow? The Problem: The current Google Ads integration is hardcoded to use Zoho's US authentication
    • Why am I getting event Pop-up Notification for events that have been cancelled?

      Why is Calendar Notification still popping up for events that have been cancelled or changed? Each time events are cancelled or changed, I have observed that I am still getting notifications for them. Below is a sample pop-up notification for one of the
    • Whatsapp Limitation Questions

      Good day, I would like to find out about the functionality or possibility of all the below points within the Zoho/WhatsApp integration. Will WhatsApp buttons ever be possible in the future? Will WhatsApp Re-directs to different users be possible based
    • Create a draft in reply to an email via Emails API

      Hi, I’d like to use the outgoing webhook to automatically create a draft reply to incoming mail. How can I use the Emails API to create a draft reply that is linked to an existing email thread? I couldn’t find the relevant method in the documentation.
    • India Tech Support

      Is there no phone tech support number for India? And no chat facility either?
    • Billing Management: #1 Billing a Universal Business Routine

      Hello, As the saying goes, "Do the hardest job first." We started with the complex subject of finance and revenue management, which is considered the backbone of any business. Now, let's shift our focus and take a deep dive into this Billing Management,
    • Show/ hide specific field based on user

      Can someone please help me with a client script to achieve the following? I've already tried a couple of different scripts I've found on here (updating to match my details etc...) but none of them seem to work. No errors flagged in the codes, it just
    • Next Page