Dear Customers,
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
Recent Topics
How to block a WhatsApp user for sending spam
Is there a way to block those whatsapp users that just come to play and annoy our service, they also spam us. We have a waba service with sales iq
Inquiry regarding auto-save behavior for Zoho Sign Embedded Sending
Dear Zoho Support Team, I am currently integrating Zoho Sign's Embedded Sending functionality using iframes on my website. I would like to know if there is a way to ensure that the document state (including any added fields) is automatically saved as
Introducing Connected Records to bring business context to every aspect of your work in Zoho CRM for Everyone
Hello Everyone, We are excited to unveil phase one of a powerful enhancement to CRM for Everyone - Connected Records, available only in CRM's Nextgen UI. With CRM for Everyone, businesses can onboard all customer-facing teams onto the CRM platform to
Automation#17: Auto-Create Tasks in Zoho Projects Upon Ticket Creation in Zoho Desk
Hello Everyone, This edition delivers the solution to automatically create a task in Zoho Projects when a ticket is created in Zoho Desk. Zylker Resorts uses Zoho Desk for bookings and handling guest requests. Zylker resorts outsources cab bookings to
Automation#20 : Auto-Add Ticket Tags based on Keywords
Hello Everyone! Welcome to unveiling custom functions on our Community series. This week's post lets you add tags to your tickets automatically based on the keywords in the ticket subject and the ticket thread. Discover how this custom function helps
Automation#21: Track Ticket Transfers Across Departments
Hello Everyone! With Halloween just around the corner, we'd like to let you know the Zoho Desk team is always there to sweep away your customer service troubles! This week, we’re excited to introduce a custom function that tracks tickets moved between
Email Integration - Zoho CRM - OAuth and IMAP
Hello, We are attempting to integrate our Microsoft 365 email with Zoho CRM. We are using the documentation at Email Configuration for IMAP and POP3 (zoho.com) We use Microsoft 365 and per their recommendations (and requirements) for secure email we have
Homepage not assignable to group
MS Teams for daily call operations
Hello all, Our most anticipated and crucial update is finally here! Organizations using Microsoft Teams phone system can now integrate it effectively with Zoho CRM for tasks like dialling numbers and logging calls. We are enhancing our MS Teams functionality
Automation#22 Track Ticket Duration at Specific Status
Hello Everyone! Welcome back to the Community Learning Series! Today, we explore how Zylker Techfix, a gadget servicing firm, boosted productivity by tracking the time spent at a particular ticket status in Zoho Desk. Zylker Techfix customized Zoho Desk’s
Automation#23: Automate Guided Conversations in Zoho Desk with Business Hours
Hello Everyone, This week's edition introduces a custom function designed to automate Guided Conversations in Zoho Desk, based on your business hours. With this feature, you can align the bot's behavior with your business schedule, ensuring a smooth and
Address changes in quote form
When entering a quote, the first piece of information required is the Account, which properly populates the billing and shipping address fields. Then I use the lookup function to select a contact, and when I do, the billing and shipping addresses are
Automation#24: Auto-Update custom field from Accounts to Tickets
Hello Everyone! Welcome back to the Community Learning Series! This episode dives into how Zylker Techfix streamlines account-related ticket references. Previously, employees had to manually check account details to retrieve specific customer information,
Kaizen #227 : Client Script Support for List Page (Canvas)
Hello everyone! Welcome to another week of Kaizen. In today's post lets see how Client Script can be used in Canvas List Page to mask sensitive information from specific roles and add colors to Canvas List Page records based on custom criteria.This use
Automation#25: Move Tickets to Unassigned When the Owner Is Offline
Hello Everyone, Welcome to this week's Community Series! 'Tis the holiday season—a time when work often takes a brief pause. The holiday spirit is in full swing at Zylker Techfix too, with employees taking some well-deserved time off. During this period,
Automation#27: Retain Ticket Owner on Moved Tickets
Hello Everyone! This week, we present to you a custom function that retains the ticket owner when a ticket is moved from one department to another. Here’s more to help you understand the custom function: At Zylker Techfix, Alex, the Support Engineer manages
Automation#28 Notify Agents on Article Expiry
Hello Everyone! This week, we’re bringing you a feature that notifies your team when articles in the Knowledge Base are set to expire to keep your content relevant and helpful for customers. The Zoho Desk's Knowledge Base is an asset for customers to
Automation#29 Retain ticket status on moved tickets
Hello Everyone, Hear out Zylker Techfix’s Success Story on Smoother Ticket Transitions! Zylker Techfix, a gadget servicing firm committed to quick repairs and timely deliveries, faced a challenge when ticket statuses changed automatically while moving
Automation#32:Auto Add New Portal Users to the Help Center User Groups
Hello Everyone, Introducing a custom function that automates the process of adding new portal users to Help Center user groups, making user management effortless! By default, Zoho Desk allows you to assign new portal users to groups manually. But with
Automation#34 : Automate Email threading for Ticket notification
Hello Everyone, It's been a while since we've presented an automation. However, our community has been buzzing with ideas, use cases, and discussions with our community experts and Ask the Experts session. So, here we are again, presenting an automation
Automation#35 : Auto-Add Comments under the Owner's Name in Tickets via Macros
Hello Everyone, This week's custom function provides simple steps to configure a Macro for adding comments to tickets with the name of the Comment owner. When managing tickets, you can use the Comment feature to communicate internally with your team and
Automation#36: Auto-create time-entry after performing the Blueprint transition
Hello Everyone, This week’s edition focuses on configuring a custom function within Zoho Desk to streamline time tracking within the Blueprint. In this case, we create a custom field, and request the agent to enter the spending time within the single
Automation#33: Automate Splitting Names for Existing Contact Records
An organized directory – who doesn't love one? Previously, we explored how to split contact names into First Name and Last Name for new contacts in Zoho Desk. But what about existing contacts already in your database? This week, we bring you a custom
Workqueue
I really like the idea of the Workqueue generally - it will be really useful. What it seems to lack however, is the ability to customise it properly. I want to be able to show a custom view rather than just "My Leads" and "Leads Assigned in Last 3 hours".
Webform & spam
Hi, We set up 2 webform on our website, fowarding the content to Zoho CRM. Since it has been opened up, we are getting lot of spam message (for now about 20 a day). To lower the amount of false new leads we added the captcha field and new enquieries are
Zoho CRM Web form page URL
Hi there, I am getting quite a bit of spam through my Zoho CRM Web form and want to restrict the URLs it is submittable from. I can see that I can add Location URLs but I need to be able to just add a domain so can I enter mydomain.com/* to cover all
Receiving too many Spam Leads. Why?
I am receiving so many junk leads from web forms created by zoho's platform. The junk queries are increasing day by day and are affecting our business. I am continuously following up with zoho team from the past one year but not getting any satisfactory
Mail Merge is not working properly as far as the AUTOMATE section is concerned
Hi there, I created a Mail Merge template for the Deal module. I would like Deal owners to mail merge their Deal records, download the Mail Merge document as a Word doc and make a few changes before sending it to the customer. Thing is, neither the "Merge
Canvas Detail View Related List Sorting
Hello, I am having an issue finding a way to sort a related list within a canvas detail view. I have sorted the related list on the page layout associated with the canvas view, but that does not transfer to the canvas view. What am I missing?
project name field issue- n8n
Hey guys, I have a question. I want to create a new product using the workflow. The problem is with the product name field; I don't know how to fill it in. The workflow starts with retrieving information from the leads table, retrieving links to scrape
Critical:- Eneble TDS filing for 26Q from the zoho book
We currently extract TDS data from Zoho Books and manually input it into a separate TDS software to generate the FUV file and file returns. Previously, while using Tally, we benefited from an integrated feature that seamlessly recorded transactions and
How to track repeat customers?
I own a food business and every order is entered into Zoho with: a unique Customer ID total order amount date of order With this information, I want to be able to see a list of my "best" customers. In other words, descending lists arranged according to:
Zoho Books - Breaking A Working App
We've been using Zoho for many years now. Across all apps, entering phone numbers in standard formats was enabled in all apps. These formats are: xxx.yyy.zzzz xxx-yyy-zzzz (xxx) yyy-zzzz and we were able also to add extension numbers in these formats:
Build data protection into your support
At Zoho, privacy is our principle. Every Zoho product is built with privacy as the foundation and the finishing touch, guiding every decision we make. Security, privacy, and compliance are woven into the software development lifecycle, starting from how
Conditional formatting: before/after "today" not available
When setting conditional formatting, it only allows me to set a specific calendar date when choosing "Before" or "After" conditions. Typing "today" returns the error "Value must be of type date". Is there a workaround? Thanks for any help!
Display Client Name in Zoho Creator Client Portal Dashboard
Hello Zoho Creator Team, We hope you are doing well. Zoho Creator recently introduced the option to set a client’s display name in the Client Portal settings, which is very helpful for providing a personalized portal experience. However, there is currently
Customizable UI components in pages | Theme builder
Anyone know when these roadmap items are scheduled for release? They were originally scheduled for Q4 2025. https://www.zoho.com/creator/product-roadmap.html
Amazon.in FBA multiple warehouse integration with Zoho Inventory
My organisation subscribed to Zoho One looking at the opportunity to integrate Amazon.in with Inventory. But during the configuration, we understood the integration has severe limitations when it involves multiple warehouses in the same Organisation.
Feature Request - Set Default Values for Meetings
Hi Zoho CRM Team, It would be very useful if we could set default values for meeting parameters. For example, if you always wanted Reminder 1 Day before. Currently you need to remember to choose it for every meeting. Also being able to use merge tags
Ability for admin to access or make changes in zoho form without asking for ownership
Currently in zoho form only form owner can make the changes in the form and if someone else has to make changes then we have to transfer the ownership to them and even admin also cant access it . So i think admin must have the ability or option to access
Next Page