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
'Statement of Accounts does not exist' error received, when creating PO using api in Zoho Inventory
Here is request json -- JSONString = { "date": "2019-09-24", "purchaseorder_number": "PO-6-1", "delivery_date": null, "delivery_org_address_id": 36221200000056XXX, "vendor_id": 362212000000564XXX, "attention": "Testing", "line_items": [{ "unit": "Pieces", "account_id": 36221200000003XXX, "quantity": 1, "item_id": 362212000000049XXX, "tax_type": "", "tax_name": "", "name": "One HD", "purchase_rate": 85, "tax_percentage": 0, "item_total": 85.00, "tax_id": "", "warehouse_id": 362212000000564XXX }] }
Zoho Projects API 100 requests/2 min. Limit
Hi Requesting clarification on the API documentation. "You can invoke or call an API for 100 times in a span of two minutes. If you invoke more than 100 times, the particular API request will be locked for the next 30 minutes. " Does this limit apply
Integrate your Outlook/ Office 365 inbox with Zoho CRM via Graph API
Hello folks, In addition to the existing IMAP and POP options, you can now integrate your Outlook/Office 365 inbox with Zoho CRM via Graph API. Why did we add this option? Microsoft Graph API offers a single endpoint to access data from across Microsoft’s
Zoho Projects - Attachments added to Task and Bug emails are not saved
Hi Projects team, I have been experimenting with emails into projects to create tasks and bugs. I have noticed that attachments added to the emails are not saved to the task or bug. Is this normal behaviour? Thanks, Ashley
Zoho Inventory's latest shipping integration updates at a glance.
Hello Users, We would like to share some important news about our latest improvements in the Shipping integration capabilities of Zoho Inventory that we achieved in 2024 with some of our major integration partners in key editions across APAC, North America,
Sorting a list of record acquired from the zoho.crm.searchRecords function.
This is something for which I'm trying to figure out a straightforward way to do. The searchRecords does a great job fetching me the records that I want. However, in some cases, where it returns multiple records, I want it to sort the returned list by date of creation of that record, so that when I do records.get(0), I get the most recent record. As an example, here's my sample pseudo code: records = zoho.crm.searchRecords("Clients", "Office_Number:equals:123456"); Now the "records" list above contains
Zoho Inventory Custom Field Update
Hello All, In this post I am describing how can we Update the Custom Field Value in Zoho Inventory. // Get Org ID orgid = organization.get("organization_id"); // Field Value resvp = ifnull(item.get("purchase_rate"),null); // Record ID iid = item.get("item_id");
Alphabetically
How can i arrange alphabetically - (Manage Manufacturer) Field in Item Master
Can i set a default value for country and state in address field in zoho creator?
Can i set a default value for country and state in address field in zoho creator?
Convert HTML to PDF & Send as Email Attachments in Zoho Creator (Deluge)
This approach is useful for sending welcome letters, instructions, or promotional offers after order creation. // 1. Define the variables using the submitted input
customerName = input.Customer_Name1;
orderID = input.ID;
customerEmail = input.Email_Address;
//
Redirect after submission is not working after a few submission
I have setup redirect url correctly and everything works as expected. However, it seems that there's a limit to the number of submissions before the redirect stops working. After the "limit" is reached, the page redirects to a seemingly zoho hosted page,
Enhancement Request for Multi-Asset Work Order Feature
Hello Latha, Thank you for your continued support. The multi-asset Work Order feature is extremely helpful. I did some testing based on our requirements, and during the process, I noticed a few areas where we need your team’s support to improve the feature
Marketing Tip #8: Run limited-time offers
Exclusive offers that don't last long make shoppers purchase right away instead of waiting. Run a flash sale or limited-time discount to convert interest into sales. Try this today: Set up a "Buy X Get Y" coupon in Zoho Commerce valid for a limited time
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
Zoho Projects - Email notification relabelling of modules not present on default templates
Hi Projects Team, I noticed that in the default email template notification, the word "bug" was not renamed to the lable I am using in my system. As many users may used the Bugs modules for various purposes including Changes, Revisions, Issues, etc...
Include the "Added Email ID" to the Filters of a Report
Hi, With a Report and lots of entries, a normal thing is to filter entries by the submitter, but that is not included in the Auto Filter of Reports and you can't add a custom filter to a Report without specifying the actual value. I would like to be able
Loops in Deluge
Hi, Can someone tell me how I do a simple loop in deluge? For example, if i have a variable "X" containing a number of loops to perform, i would like to perform an action X amount of times. X = 10; do while (Y < X){ // ... do something } to further explain, the equivalent in PHP of what i am trying to acheive would be: $X = 20; for($Y = 1; $Y < $X; $Y++ ){ // ... do something } Thanks
I am facing a problem with an if-else condition
If I use if, else if, and else conditions in Deluge with the same variable name, sometimes the variable causes an error because the same variable name is present in every block
Zoho Projects - Reply by email to @ mentions posted on the Feed.
When mentioning someone on the Feed (Status), it would be great if that mentioned person could reply to the email notification to update the Feed thread.
Product Updates in Zoho Workplace applications | October 2025
Hello Workplace Community, Let’s take a look at the new features and enhancements that went live across all Workplace applications this October. Zoho Mail Create Signature from Compose window You can now effortlessly create a Signature using the Create
Subform data to Sheets
I have been trying to setup a Zoho Flow automation to bring any Subform input to a Zoho Sheets but it seems impossible to post the subform entries to a Zoho Sheet. Is there any way to do it via Zoho Sheet API? https://www.zoho.com/sheet/help/api/v2/#CONTENT-Insert-row-with-JSON-data
Edit Contact Roles in the Potentials Mod
New to ZOHO so I need some help. I work the same people on different projects concurrency. Their contact info remains the same but their role changes from project to project. In the Potential Mod you can pick contacts and assign a Role to them. I know
Is there a way to disable the Activity Reminders Pop-Up Window every time I log in?
Just wondering if there is a setting to disable the window from opening every time I open my CRM? Thanks Chris
Rich-text fields in Zoho CRM
Hello everyone, We're thrilled to announce an important enhancement that will significantly enhance the readability and formatting capabilities of your information: rich text options for multi-line fields. With this update, you can now enjoy a more versatile
Font Size 11 - Zoho CRM Email Templates
Our company communicates with our vendors exclusively using Calibri Font Size 11, as this is the standard formatting for professional emails. Since the CRM only allows for the selection of font sizes 10 & 12, we have been unable to utilize the CRM email
Error 400 Booking
Added a custom domain to Booking. Am Getting a SSL Error that has some other domain on the SSL and giving a 400 error. Followed instructions and it stated it verified our domain.. However it is not working. Please Help!
Zoho Projects - Email Notifications for Feed Updates
Hi Projects Team, I'm working with a client who wants a simple way to communicate with their customers on projects. Getting the customer to add comments to Tasks or Bug records is not ideal, as we need a way which is easy with minimal training, and has
Zoho Analytics Export API
Hi Team, I’m working on some integration tasks and wanted to confirm if it’s possible to retrieve a Zoho Analytics table as JSON data using a Deluge script. I’ve already stored my custom data from multiple sources and combined it into a single source.
Request to Remove LinkedIn Verification from My Emai
I would like to submit a complaint regarding my Zoho Mail account. I previously used this email address to verify a LinkedIn account, but that LinkedIn account has now been closed. I need to remove or cancel the verification associated with the closed
Introducing the all-new email parser!
Greetings, We are pleased to introduce to you, a brand-new, upgraded version of the Zoho CRM Email Parser, which is packed with fresh features and has been completely redesigned to meet latest customers needs and their business requirements. On that note,
Extracting Images from a Zoho Creator Report into a Pages
If you’ve uploaded images in a form and can see them in your report, you might also want to display those same images inside a Page (custom HTML page). This is useful for dashboards, profile pages, or any place where images should be visible dynamically
Zoho is blocking emails I subscribe to from one sender
About 4 months ago I stopped receiving newsletters that I subscribe to from @thedispatch.com. They tell me that zoho's server is blocking them. I've added them to my contacts list, but they're not even reaching my inbox. I don't know how to troubleshoot
Inactive Items - Make Less Prominent by Default
Currently, when one marks an Item as "Inactive", it really doesn't do much of anything to hide it or get it out of the way. Search and reporting within Finance should, by default, hide inactive Items from standard reports, searches, etc. If one specifically
How to calculate GST based on "Ship To Address"
We into the interior designing work, providing "Works Contract Services" to our clients across India. We are registered under GST in Maharashtra state. For works contract services as per the GST rule, we need to decide place of supply based on "Ship to
I NEED TO NUMBER TO TEXT NO HERE
=NUMBERTEXT NEEED
Auto-fill New Row with Previous Row Values
rowsize = input.Order_Items.count();
for each row1 in input.Order_Items
{
rowsize = rowsize - 1;
if(rowsize == 1)
{
row.Door_Model = row1.Door_Model;
row.Door_Color = row1.Door_Color;
row.Materials = row1.Materials;
API question - adding a thread to an existing ticket
Hi Is there an API function for the customer to add to an existing ticket thread? example, customer puts in new support ticket. support replies and ask for more details. customer replies with more details -what api function is used for this (will add record append to same ticket number?) Thanks
Calendar week view: Today + 6
Is there anyway to have the calendar change dynamically based on the date? Due to the amount of events, we only display a week at a time, but towards the end of the week, we can no longer see ahead to next week (without changing it manually every time).
How to restrict user/portal user change canvas view
Hi , I would like to restrict user / portal user change their canvas view because I hide some sensitive field for them. I dont want my user switch the canvas view that do not belong to them But seems Zoho do not provide this setting?
How to add to Subforms via Zapier with Zoho Writer?
I have the following layout for a Zoho Writer Document. As you can see there is a repeating subform taking in "Items". I am trying to make a Zapier integration with it, and I can see there is 1 field saying: "Items", but it does not specify how I'm supposed
Next Page