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
Subscribed Calendar
Hi i have subscribed to a calendar for Holidays in Canada it shows all the holidays perfectly but every one of them has the word Canada before the rest of the name is there a way to remove that word Canada? It takes up a lot of space in the square on
The year that was at Zoho Calendar 2023- Part 1
Hello, amazing community members! Happy new year from all of us here at Zoho Calendar. As we begin the new year, we'd like to thank each and everyone of our community members for your unwavering support and love that you have shown for Zoho Calendar.
Zoho Calendar 2024: A Year in Review
Hello, community members! Happy new year from all of us here at Zoho Calendar. As we turn the page to a new year, we extend our heartfelt gratitude to every member of our Zoho Calendar community for your continued support and enthusiasm. Your feedback
Zoho Calendar not syncing correctly with personal Google Calendar
Coming to this forum as Zoho Calendar support team is not responding, any more. For the past 8 weeks, I have been having an issue with Zoho Calendar not syncing with my personal Google Calendar correctly. I subscribed to Zoho Calendar iCal in my personal
Zeptomail API error 500 internal server error
Hi Everyone, getting this eror continuously! Can anyone please guide around the same! Zeptomail API error 500 internal server error Best Regards
Waiting multiple days to buy credits, causing my website to suffer
So I own a fairly large website that gets a lot of registered users. I use transmail send activation emails, and also forgot password emails. I sent an email to zoho's presales team when I was only at 4K/10K emails sent, hoping to buy more credits before
Follow up
Hello, I sent a message 2 days ago but I don't receive any response and I cannot find my ticket here. this is the ticket: Your ticket has been created with the ticket ID 68925465 and subject "Fwd: Fishing-alert" looking forward to seeing your response.
What's new in TransMail!
Note: TransMail is now ZeptoMail. Click here to know more. Hello again, everyone! We've recently crossed the 6 months mark of TransMail's launch. In this time post our launch, we have been constantly working on updating our platform and adding new features
June 2021 in TransMail!
Note: TransMail is now ZeptoMail. Click here to know more. Hello again, everyone! Hope you and your loved ones are doing well. If you're doing less than fine, we truly hope that things only get better for you. We've had a few updates in the past month
TransMail has a new name—ZeptoMail!
Tried navigating to TransMail's community forum but see a different name now? That's because TransMail has a new name. TransMail is now ZeptoMail! As we’ve grown from an internal service used mainly by other Zoho products to an up-and-coming competitor
July 2021 in ZeptoMail!
Note: TransMail is now ZeptoMail. Click here to know more. Hello again, everyone! Hope you and your loved ones are doing well. We've had a few updates in the past month in ZeptoMail—some new features and some important announcements. Take look at what
Send Email From the ZeptoMail BY API
What is Zeptomail:- Transactional email service with reliable and fast delivery How we can Create a Connection for Zeptomail in Zoho CRM Go to the Setup Click on Connection Enter Connection Details:- Generate Consumer Key & Consumer Secret Using Zoho
Customer email on Opencart 3
When I place an order, 2 emails are sent: 1) administrator 2) to the user The administrator receives a beautiful letter, but the user receives a damaged letter (see screenshot). What could be the problem?
[Announcement] Insert image from URL changes in Zoho Writer
Hi Zoho Writer users! We'd like to let you know that we've changed the behavior of the Insert image from URL option in Zoho Writer for security reasons. Earlier behavior Once you inserted an image URL in a Writer document, the image would be fetched from
Dynamic Signature - Record owner
Hi everyone, I’m using Zoho Writer merge templates from Zoho CRM and have two questions: Owner signature: How can I automatically insert the CRM record owner’s signature in the merged document? I’m not sure where this signature is stored or how to reference
Writer sing up problom
Zoho writer sing up prolom face
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
[Webinar] Live demos and user Q&A with Zoho Writer product experts
Join us on June 12, 2025 for live demos based on your use cases and real-world scenarios raised via form. This is also an opportunity to get your questions answered directly by product experts from the Zoho Writer team. Webinar agenda Live demos based
Zoho Writer's built-in citation and bibliography generator
Hey researchers and writers! Do you manually format citations and bibliographies, spending hours jumping between apps and tabs? If so, then check out Zoho Writer's built-in "Citations and Bibliography" feature. Imagine you're writing a thesis on the future
Single and group checkboxes in Zoho Writer's fillable forms
Hey Writer Fam, Are you making the most out of single and group checkboxes in fillable forms in Zoho Writer? Here is a handy tip to optimize your use of checkboxes, both single and group, and enhance your data collection process. Single checkboxes: Single
Collaborate efficiently with Zoho Writer's track changes feature
Hi Zoho Writer Community, Zoho Writer's track changes feature is a simple, built-in solution that helps you and your team work together efficiently. Instead of juggling multiple versions of a document or building up a long email chain of comments, each
Zoho Writer's WordPress extensions
Hey Zoho Writer users! Say goodbye to all your WordPress content publishing woes with Zoho Writer's WordPress extensions. Publish content with all your formatting and images, republish content when you update a document, and more—from a single window
Time-saving table hacks
Hey Zoho Writer Community, Do you find yourself using a lot of tables in your documents? We're here to share some of our time-saving hacks that will help you work more efficiently, organize your data, and make your documents look neat and professional.
Automating document approval and signing with Zoho Writer and Zoho Sign
Hey Zoho Writer Community! Here's another automation tip to make your processes more efficient! Question: Can I send a document for client approval first, then automatically send it for signing with Zoho Sign if they approve? Since it's the same person
Customization hacks in Zoho Writer - Part 2
Hey community, We're back with some more tricks to personalize your documents, save time, and get in the zone when you work in Writer. Check out part 1 of this post if you haven't already. Let's dive right in! Document ruler units Imagine you're creating
Simplify your tax calculations with Zoho Writer
Hello Zoho Writer Community! Tax season can be stressful, but with Zoho Writer, managing your income tax calculations becomes straightforward and efficient. Here’s an example of how you can use the tables and formulae of Zoho Writer to calculate income
Enhance document navigation with headings and TOC
Hey Zoho Writer Community! We're back with some useful features in Zoho Writer that can simplify your document creation and navigation process. Let's dive right in! Check out our video on how to make the most of Zoho Writer's heading and table of contents
Use and download in PDF format of Zoho wirter Merge template using deluge
Hello Zoho Developers. Here is some information about Zoho Writer. Writer is not just another online word processor, it's a powerful tool for editing, collaboration, and publishing. Even with its wide range of features, Writer's pared-down user interface
Customization hacks in Zoho Writer - Part 3
Hello everyone, Welcome back to Part 3 of our customization tips in Zoho Writer! In this third installment, we'll be diving into some essential customization settings that can enhance your document creation experience. Sender email address in mail merge
Daytime saving timezones messing up writer pdf
Hi, I need help for something I can't figure out. I created a Form to collect data and it is set up with my current Daylight Saving Time (GMT-3). This form is used to generate a contract (pdf Writer) with dates from an event that is being held in 4 months
Issue with locked content in Writer
Hi, I have seen the documentation which outlines how to lock specific content within a Writer document so that it can't be modified by collaborators, but I have come across an issue. When the editor locks a paragraph for example, then a collaborator can't
Deprecation of certain URL patterns for published Zoho Writer documents
Hi Zoho Writer users! We'd like to let you know that we have deprecated certain URL patterns for published and embedded documents in Zoho Writer due to security reasons. If the published or embedded documents are in any of these URL patterns, then their
Using Mail Merge Template to Print Documents with One Subform Record's Fields per Document
Hello, We have a Mail Merge template created in Zoho Writer which is not able to perform the functionality which is currently required to automate the documentation task portion of our process. The CRM module we are primarily using is based on a "Loans"
Problem with Writer and Workdrive
Hi team, I’m the super admin for our Zoho One org. WorkDrive is active, and Zoho Docs is deprecated for our org. However, Zoho Writer cannot connect to WorkDrive at all — we’ve cleared cache, tried incognito, and restarted several times. I was able to
Set to Review for all
We are testing the use of Writer as part of an internal review process for statement of work documents and have found that when the document is changed from Compose to Review by one person, that is not reflected for all others who view the document. Is
I’ve noticed that Zoho Sheet currently doesn’t have a feature similar to the QUERY formula in Google Sheets or Power Query in Microsoft Excel.
These tools are extremely helpful for: Filtering and extracting data using simple SQL-like queries Combining or transforming data from multiple sheets or tables Creating dynamic reports without using complex formulas Having a Query-like function in Zoho
stock
bom/bse : stock details or price =STOCK(C14;"price") not showing issue is #N/A! kindly resolve this problem
SOME FEATURES ARE NOT IN THE ZOHO SHEET IN COMPARISION TO ZOHO SHEET
TO ZOHO sir/maam with due to respect i want to say that i am using ZOHO tool which is spreadsheet i want to say that some features are not there in zoho sheet as comparison to MS EXCEL like advance filter and other Features which should be there in ZOHO
Zoho sheet for desktop
Hi is zoho sheets available for desktop version for windows
Tip #18: 6 Trendlines and when to use them in your spreadsheet data?
Charts are a great tool for visualizing and interpreting large chunks of data in spreadsheets. Zoho Sheet offers you 35+ chart options, along with AI-powered chart recommendations based on the data set you select. There are various chart elements that
Next Page