Waterfall component in Zoho CRM: Visualize how individual contributions build the result

Waterfall component in Zoho CRM: Visualize how individual contributions build the result

Dear Customers, 

We recently introduced three new chart types — Sankey, Treemap, Cluster and Butterfly — to offer you fresh ways to visualize your CRM data and gain new perspectives.

In line with that, we’re excited to bring you a new component—Waterfall in Zoho CRM Analytics.

What is a Waterfall component?
Waterfall is a powerful visualization tool, similar to charts, that illustrates how an initial value evolves through a series of positive and negative changes.
  • Unlike a simple column chart that displays isolated values, the Waterfall component shows cumulative progress, making it easy to pinpoint exactly how each value contributes to the outcome.
  • It doesn’t just present numbers—it shows you the flow of data, helping you pinpoint where gains are made or losses occur, which is critical for informed decision-making. 
Let's say you’re tracking revenue fluctuations, monitoring process efficiencies, or forecasting future trends; a waterfall component will offer a clear, intuitive way to understand the dynamics of your data.


Let’s say you want to understand how your total subscriber count is impacted by different subscription status. A Waterfall component that shows the number of subscribers across statuses like Active, Trial, Upgraded, Churned, and Expired gives you a clear idea of the total subscription.


For example, you might see that while Active and Trial users drive major gains, losses from Churned and Expired users reduce the net total. This helps you identify how much total value is effected by churned and expired subscriptions and whether it needs attention to retain or recover subscriptions.

To cater to the wide range of analytical needs, the Waterfall component comes in four distinct variants.

What're the different variants?

Basic variant: Visualizes categorical changes where each stage is assigned as either a positive (adding) or negative (reducing) factor. The final bar represents the net result after accounting for all additions and subtractions. 

  • Useful for cases where predefined picklist values represent distinct stages, such as sales stages or process steps.
Let’s say you want to understand how revenue accumulates or drops across different stages in your sales pipeline. A Waterfall component showing the revenue by stage helps you track how each stage contributes to—or reduces—the overall revenue.

For example, you may notice that stages like Qualification, Proposal, and Negotiation add significant value, but stages like Closed Lost and Closed Lost to Competitor pull down the total. This view helps you identify where your pipeline gains most of its value and where you're losing potential revenue.



Cumulative variant: Focuses on tracking cumulative changes over time. Users can optionally enable intermediate sums (quarterly, yearly) for better clarity. The final bar represents the total cumulative value at the end of the period.
  • Useful for scenarios where values accumulate over time—such as monthly profits, expenses, or revenue trends—making it easier to track growth, fluctuations, and periodic performance.
Let’s say you want to monitor how profit has grown or declined over time. A Cumulative Waterfall that shows profit across months, with quarterly intermediate sums, helps you track month-over-month changes and quarterly performance in one view.

For instance, while you may see steady growth in Q1 and Q4, Q2 and Q3 show noticeable dips in specific months like May and October. This helps you quickly spot which months drove growth, which pulled performance down, and how each quarter contributed to your overall profit.

Breakdown variant: The Breakdown variant is similar to Cumulative but provides a more granular view by breaking down each time period into different segments based on the business requirements.
  • It's useful for tracking various subcategories within each time period — the breakdown is among the picklist options like product type, regions, etc. even though the grouping is a time-related field.
Let’s say you want to compare product-wise subscription trends over the past few years. A Breakdown Waterfall component showing the product wise subscriptions across the year and broken down by product category gives you a clear picture of which product lines grew or declined year over year.

For instance, you might find that Mobile subscriptions dropped sharply in 2022, while Tabs showed consistent growth across all three years. This helps you evaluate product performance within each time period and understand what’s driving your overall subscription trend.



Projection variant: Perfect for financial forecasting and scenario planning, this variant starts with a user-defined initial value and tracks incremental changes over time. The initial bar’s value can be set as "All Time" (historical total) or "Previous Period" (last period’s final value). The final bar will show the total after incorporating all positive and negative changes over time.
  • It is ideal for scenarios where past values influence the present and future.
Let’s say you want to visualize how profit is expected to grow across the current year, starting from an initial value. A Projection Waterfall that shows the profit across quarters, with an initial value set from all-time data, helps you track projected gains quarter over quarter.
For example, you might see consistent growth of 3k each quarter, building toward a total profit of 15k by year-end. This helps in forecasting quarterly performance and understanding how current trends may shape your overall annual outcome.

That's all for the enhancements. Let us know your feedback in the comments below.

Release plan: We will open this for customers in phases over the week. 

Thanks and have a good one!

Kind regards,
Saranya Balasubramanian


      Zoho Campaigns Resources


        • Desk Community Learning Series


        • Digest


        • Functions


        • Meetups


        • Kbase


        • Resources


        • Glossary


        • Desk Marketplace


        • MVP Corner


        • Word of the Day


        • Ask the Experts


          Zoho CRM Plus Resources

            Zoho Books Resources


              Zoho Subscriptions Resources

                Zoho Projects Resources


                  Zoho Sprints Resources


                    Zoho Orchestly Resources


                      Zoho Creator Resources


                        Zoho WorkDrive Resources



                          Zoho CRM Resources

                          • CRM Community Learning Series

                            CRM Community Learning Series


                          • Tips

                            Tips

                          • Functions

                            Functions

                          • Meetups

                            Meetups

                          • Kbase

                            Kbase

                          • Resources

                            Resources

                          • Digest

                            Digest

                          • CRM Marketplace

                            CRM Marketplace

                          • MVP Corner

                            MVP Corner




                            Zoho Writer Writer

                            Get Started. Write Away!

                            Writer is a powerful online word processor, designed for collaborative work.

                              Zoho CRM コンテンツ




                                ご検討中の方

                                  • Recent Topics

                                  • 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.
                                  • Is there an API to "File a Ticket" in Desk

                                    Hi, Is there an API to "File a Ticket" in Desk to zoho projects?
                                  • Store "Sign in with Google/Microsoft/GitHub etc." details

                                    Quite often now, users are using a sign-in provider like Google or Microsoft to sign into various apps and services. It would be great if Vault could remember which providers you use for each website and sign you in with that provider instead of a username
                                  • Critical Issue: Tickets Opened for Zoho Support via the Zoho Help Portal Were Not Processed

                                    Hi everyone, We want to bring to your attention a serious issue we’ve experienced with the Zoho support Help Portal. For more than a week, tickets submitted directly via the Help Portal were not being handled at all. At the same time no alert was posted
                                  • Tip of the Week #72– Assign thread ownership to avoid confusion.

                                    When teams handle a large volume of emails, managing threads becomes important to stay organized. Without a clear system, duplicate replies, missed follow-ups, or confusion over responsibilities can happen. Thread assignment solves this by designating
                                  • Unarchive tickets

                                    How can I manually unarchive tickets?
                                  • Optimize your Knowledge Base for enhanced accessibility by adding alt tags for images

                                    Let's learn why alt tags are crucial for your articles. You can add alternative tags (alt tags) and alternative text (alt text) to the images you share on your community forums or when embedding them in articles. Alt tags refer to the HTML attribute,
                                  • FSM trying again

                                    have not linked FSM yet to the rest of out Zoho suit. It certainly looks like the apointment and service part is more manageable for our staff. The question is that our engineers multi task examples 1. deliver products to customers not fitted 2. Service
                                  • Feature Request: Conditional Field Mandatoriness Based on Display Status

                                    Hello Zoho Creator Team, I would like to suggest an enhancement to improve the flexibility of form validations. Currently, when we need a field to be mandatory only if it's displayed on the form, the only option is to: Set the field as not mandatory in
                                  • Data Migration Strategies for Moving to a Cloud Solution

                                    Hi everyone, I’ve been working on moving some of our critical systems, including CRM and project data, to a Zoho cloud solution, and one of the biggest challenges I’ve encountered is data migration. Transferring large volumes of data while keeping it
                                  • Commerce Order as Invoice instead of Sales Order?

                                    I need a purchase made on my Commerce Site to result in an Invoice for services instead of a Sales Order that will be pushed to Books. My customers don't pay until I after I add some details to their transaction. Can I change the settings to make this
                                  • How to set different item selling prices for Zoho Commerce and Zoho Books

                                    Item selling prices for Zoho Commerce and Zoho Books are in sync. If we update the Item selling price in Books, the same will happen in commerce and vice versa. I need a separate commerce selling price for online users and a separate books selling price
                                  • Time Entry Notifications

                                    Hi All - I have support staff who place notes of their work in the time entry section of Zoho Desk. Is there a specific workflow or setting I need to enable to have the ticket holder updated via email when an entry is saved?
                                  • How to report 'Response violation' OR 'Resolution violation'

                                    Hi, I want to report on SLA Violation Type. I grouped my tickets on this column. It seems I only get 'Response and Resolution Violation' or 'Not Violated'. The former seems to be given to a ticket if only the Response Time was violated. I would expect
                                  • [Webinar] Automate sales and presales workflows with Writer

                                    Sales involves sharing a wide range of documents with customers across the presales, sales, and post-sales stages: NDAs, quotes, invoices, sales orders, and delivery paperwork. Generating and managing these documents manually slows down the overall sales
                                  • Power of Automation :: Quick way to associate your Projects with Zoho CRM

                                    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 complex tasks and
                                  • Date triggering Workflow rule

                                    I have a function triggered by a workflow rule. The function takes a date and creates a task for that date and fills in a field with the name of the day for that date. It also updates the status field of the record. The workflow rule is set to run whenever
                                  • Restricting contact creation

                                    Hi all! I am looking to use Zoho Desk in a part of the business that takes end user enquiries. These are generally single interactions, and not linked to an account name. As Desk is Account centric, has anyone designed a way to manage these incoming emails
                                  • Import Holiday Calendars

                                    HI Zoho Is there anyway of importing an online calendar like https://www.calendarlabs.com into the business hours calendars, to speed up setup of holiday calendars. Also could we also request a feature where you can specify a Holiday as hours, i.e it could be that the company is on a 1/2 day due to a holiday or when it is Eid in the UAE and they are only allowed to work restricted hours so we need the calendar to be flexible to allow for this. Regards Jamie
                                  • Filtering Tickets based on Email headers

                                    We're starting to get a lot more junk coming into our Zoho Desk, which is then triggering unnecessary email alerts to agents. Once thing we could do to cut this junk in half, is to filter tickets based on email headers. Any email containing the `List-Unsubscribe`
                                  • Error 550 5.4.1

                                    I’ve tried sending an email to someone but keep receiving this back. Any help would be greatly appreciated 
                                  • Billing Management: #2 Fair way of Billing- Prorated Billing

                                    Hello, From speaking about the traditional ways of billing in the previous post, we are moving into the deep sea of billing. We are now in a zone to break out the most complex yet, I would call it the fairest way of billing, the Prorated Billing. Prorated
                                  • Automatic Matching from Bank Statements / Feeds

                                    Is it possible to have transactions from a feed or bank statement automatically match when certain criteria are met? My use case, which is pretty broadly applicable, is e-commerce transactions for merchant services accounts (clearing accounts). In these
                                  • Has Anyone successfully integrated Zoho and Sage Intact?

                                    Hey all, We’re evaluating Zoho One + Sage Intacct and I’m trying to connect with anyone who has actually implemented the two together.Specifically, I’d love to know: -- Which functions you kept in Zoho vs. Intacct (e.g., Product Catalog, AR/AP, invoicing,
                                  • How can I filter a field integration?

                                    Hi,  I have a field integration from CRM "Products" in a form, and I have three product Categories in CRM. I only need to see Products of a category. Thanks for you answers.
                                  • Adding image in HTML report page

                                    Hi, I want to know two things: 1. Can anyone advise how to add an image in HTML report. The tagged used is <img> but what path do I mention for the image to be added in the HTML report. 2. Also, I want to know if I am creating an application for the market
                                  • How to change view of HTML report based on device but always print in A4

                                    Hello everyone, I am aware that HTML report view can be configured to adjust according to the screen size like Laptop, Tablet and mobile using media queries. But my concern is no matter on which device the reports is opened when printed should always
                                  • Age Calculation

                                    I've attempted to calculate the age of someone based on their birthday input by using the formula field. It works but I don't want all those decimals on there. I then tried to use "set variable" after birthday input but I get a field type mismatch, long vs. floating. Any ideas would be wonderful.
                                  • Search on Custom Field

                                    We're working on an integration with the Zoho FSM API and are trying to retrieve companies based on a custom field we added to the Companies module. However, we can't find a way to filter or query records using custom fields through the API. We have a
                                  • Sendmail function / custom action?

                                    I've setup a function hoping to email various business departments the details of a record once all work in that record is complete so gone about setting up a custom action in such way that each record line on the report has a button to click. Question is how do I actually include data from that record in the email that is sent when the button is clicked? I had thought that since this were being sent per record the email would include the data which had been entered
                                  • API to post drafts for social media

                                    I we want to post draft posts to our zoho social account and then approve and schedule them within Zoho social. is this possible with for example: https://apis.zoho.com/social/v2/post TIA Jon
                                  • Canvas View in Zoho Recruit

                                    Is it possible or would it be possible to have the new 'Canvas View' in Zoho Recruit?
                                  • What impactful sales coaching techniques have you used to boost your team's performance?

                                    I'm curious about the real-world impact of sales coaching on team performance. What specific techniques or strategies have you found most effective in driving consistent improvement and growth in your sales team? Any success stories or lessons learned
                                  • Adding Taxes to paid consultations in Zoho Bookings

                                    I created a 'paid' consultation under Zoho Booking and integrated it with payment gateways for online/instant payment before a booking is done. How can I add 'taxes' to the price of consultation? I can add taxes to other Zoho apps (liks Books, Checkout,
                                  • Zoho Finance Suite - Customer Custom Tabs - Dynamic Link

                                    Hi Finance Suite team, When creating a Custom Tab for a Client Portal, there is no option to add dynamic parameters. This would be very helpful for adding Zoho Analytics dashboards which can be dynamically filtered through the URL to only show information
                                  • Next Page