Visualize Charts Using Groupby and Aggregate functions

Hello!

 

Have you been using tables to present data in mail merged documents? If so, it maybe time to try a more interesting alternative. Charts help you present data in an exciting way, and make it easy to highlight specific aspects of your data.

 

With Writer, adding charts to mail merged documents is simple. Easily create and edit charts to meet your needs using different chart types, built-in aggregation functions, and chart customization options.

 

 

Aggregation in charts / Aggregate functions in charts

Pull data from your data source and choose an aggregate function to present it within your document. Writer offers Count, Count Distinct, Sum, Average, Min, Max, and Median functions to process your data however you need.

 

1. Numerical data aggregation

Data comprised entirely of numbers (such as the number of cars sold by a company) is numerical data. Compared with raw or individual data (like a list of all cars sold), aggregated data (such as the number of a specific type of car sold every month) is more useful. Writer helps you instantly aggregate data with built-in chart functions.

Writer's charts support the following aggregate functions: Count, Count Distinct, Sum, Average, Min, Max, and Median. For example, you can apply the Count function to the monthly sales data to get the number of cars sold per month. Similarly, the Average function will show the average number of sales per month. Click here to learn what each aggregation function does.

Aggregated data helps reveal patterns, and charts make the patterns easy to understand. In the case of our example, a chart provides an overview of the car company's monthly sales performance.

2. Non-numerical data aggregation

Any data without numbers (such as yes/no answers, or answers to open-ended questions) is non-numerical data. Let's say a fast food restaurant wants to add ice cream to its menu. It can run a survey among its customers asking for their favorite ice cream flavors. From there, it can use Writer to aggregate the responses, and present them in the form of a pie chart to easily understand customers' preferences.

 

 

3. Group By and Aggregate

For detailed analysis and insights, you may choose to split data into separate groups before aggregating them. For example, in addition to the total number of cars sold in a month, you might also want to know the number of hatchbacks, sedans, and coupes sold in a month. With Writer's Group By function in charts, segregating raw data into different groups and then aggregating them becomes simpler.

 

Advanced chart tools

Make your data visually appealing and easy to understand. After choosing a chart type, use various customization options, such as colors, wrap style, margins, position of legends and data labels, and font sizes.

That's all for now! Tryout Writer's charts, advanced chart tools, and aggregate functions in mail merge, and let us know what you think.

Need any help working with charts? Write to us at support@zohowriter.com or simply leave a comment.

Happy writing!

• Topic Participants

• Shri Rakkshaa Gk

  

• Sticky Posts

• Easily perform calculations using dates with the new DATEDIF function

  Hey Zoho Writer users! We've enhanced Zoho Writer's formula capabilities with the new DATEDIF function. This allows you to calculate the difference between dates in days, months, and years. Function syntax: =DATEDIF(start_date, end_date, unit) Inputs:

• 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

• Date-based conditions and filters

  Configure conditions with date  Hi everyone! We are excited to announce that you can now compare and filter data with date-based conditions. This update lets you compare date fields in a document to a reference date and display a text or value if the

• Introducing group by, aggregation, and repeating regions in mail merge templates

  Display data exactly the way you want and highlight key insights with Zoho Writer's enhanced merge templates. We've supercharged Zoho Writer's merge templates with the capability to dynamically group, aggregate, and repeat data as blocks. You can now

• Say hello to an improved way to merge documents!

  Automating all your documents from start to finish is now easier than ever with Writer's new merge tools.   If you haven't seen it yet, you can read the main announcement here. Here is the full list of the features we've rolled out: 1. Dynamic Table Headers

• Recent Topics

• Zoho Writer - Option to Export as .zdoc format

  I've noticed that it's not possible to export a Zoho Writer Document in the .zdoc format. Isn't zdoc, Zoho Writer's own format? My use case is that I sometimes need to create quite complex documents with floating elements, which sometimes need to become

• [Announcement] Enhanced Merge APIs of Zoho Writer for automating document generation using Zoho Apps data

  Hi users, With the record_id parameter in Zoho Writer's Merge APIs, fields related to the given record id is automatically fetched from the Zoho app. You don't have to spend time manually mapping the records and fields in the Deluge code. Here is a sample

• Pin multiple columns and adjust column widths in CRM subforms

  Hello all, Subforms act as secondary forms or tables in which you can associate multiple line items to a primary record and thereby ensure more structured and comprehensive data organization. We've made some recent enhancements to subforms. Here's what's

• [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

• Automate insurance document workflows with Zoho Writer

  Insurance companies have to deal with creating and managing complex documents and forms, such as policy applications, explanation of benefits documents, brochures, renewals, and claim forms. Handling all of this manually is hugely time and effort intensive,

• Latest updates in Zoho Meeting | New End of session notification to remind everyone about the session end time

  Hello everyone, We’re excited to share a new feature for Zoho Meeting ; End of session notification. With this new setting, you can choose to remind all participants or only the host about the scheduled end time of a meeting. You can also choose when

• [Webinar] Zoho Writer for SCM and logistics

  Creating, sharing, and distributing complex documents are constant challenges in the SCM and logistics industry. That's why our next webinar is focused on how to simplify these document workflows. Join us on Jul 10, 2025 for a Zoho Writer webinar designed

• [Webinar] Zoho Writer for the manufacturing industry

  Creating, sharing, and distributing complex documents are constant challenges in the manufacturing services industry. That's why our next webinar is focused on how to simplify these document workflows. Join us on May 8, 2025, for a Zoho Writer webinar

• Add Comprehensive Accessibility Features to Zoho Writer

  Hello Zoho Writer Team, We hope you are doing well. We would like to submit a feature request to enhance Zoho Writer with a full set of accessibility tools, similar to the accessibility options already available in the Zoho Desk agent interface. 🚧 Current

• [Webinar] Simplifying document workflows in financial services with Zoho Writer

  Creating, sharing, and distributing complex documents are constant challenges in the financial services industry. That's why our next webinar is focused on how to simplify these document workflows. Join us on April 10, 2025, for a Zoho Writer webinar

• [Zoho Writer Webinar] Learn how to simplify your HR operations: Part 2

  Hi Zoho Writer users, We're excited to announce the Zoho Writer webinar for July 2024: Learn how Zoho Writer can simplify your HR operations: Part 2. This webinar will focus on how Zoho Writer can help HR teams streamline and automate their entire hiring

• [Zoho Writer Webinar] Learn how to simplify your day-to-day HR operations

  Hi Zoho Writer users, We're excited to announce the Zoho Writer webinar for June 2024: Learn how Zoho Writer can simplify your day-to-day HR operations. This webinar will focus on how to automate your entire hiring process and generate various types of

• Branding of native system emails

  Make system emails adjustable in terms of branding. We want our system to be completely white label, because it is not a CRM anymore, it's way more than that. We are following the strategy of "CRM for everyone" to use the CRM in all departments, not only

• Support “Never End” Option for Recurring Meetings in Zoho Meeting

  Hello Zoho Meeting Team, Hope you are doing well. We would like to request support for creating recurring meetings with no end date in Zoho Meeting. Currently, when scheduling a recurring meeting, Zoho Meeting requires us to select a specific end date.

• [Important announcement] Removal of Zoho Writer's DocuFiller Add-on

  Hi users, Effective 21st Feb. 2025, we will be removing the DocuFiller add-on for Zoho Writer's Fillable Templates. From that point on, the add-on's functionalities, such as sharing or publishing fillable forms for data collection and receiving submissions

• Weekly Tips: Manage External Images in Zoho Mail

  When you receive emails every day, whether from clients, newsletters, or services, many of them contain external images that automatically load when you open the message. While this can make emails look more engaging, it can also impact your privacy and

• Implementing a Self-Invoicing/Vendor Portal in Zoho Creator

  Hello Zoho Community / Creator Experts, We would like to build a Self-Invoicing Portal (Vendor Portal) in Zoho Creator for our external contractors. Our goal is to allow approved contractors to log in, submit their invoice details (hours worked, project

• Function #32: Schedule low stock notifications on a timely basis to specific users of the organization

  Hello everyone and welcome back to our series! For a business that heavily relies on inventory, monitoring the stock levels and getting timely notifications of low stock items will ensure a smooth sail. Zoho Books allows you to always keep a check on

• SINCH HUB MESSAGEMEDIA with ZOHO DESK

  1) what I need from MessageMedia, 2) what I want to confirm on the Zoho Desk Dev Forum. MessageMedia – needs and requirements Goal: Send SMS from a Zoho Desk widget for EU users. Auth: HTTP Basic (API Key + Secret). Keys must not live in the browser.

• Function #46: Auto-Calculate Sales Margin on a Quote

  Welcome back everyone! Last week's function was about displaying the discount amount in words. This week, it's going to be about automatically calculating the sales margin for a particular quote, sales order or an invoice. Business scenario Where there is sales, there's also evaluation and competition between sales reps. A healthy rivalry helps to better motivate your employees to do smart work and close deals faster and more efficiently. But how does a sales rep get evaluated? 90% of the time, it's

• Invalid URL error when embedded sending url into iframe for my website when using in another region

  Hi team, My site is currently working on integrating your signature feature as part of the system functionality, it's working great but recently there's been a problem like this: After successfully creating the document, i will embed a sending url into

• New features released: Data from Picture for Web, Pattern Fill, and Translation in Zoho Sheet!

  Hello Sheet users, In 2024, the Zoho Sheet team focused on research and development to bring new features that add to functionalities like productivity, data management, collaboration, and more. This year, we're all set to roll them out incrementally

• Kaizen #59 - Creating alerts and custom messages using Client Script

  Hello everyone! We are happy to resume our Zoho CRM Developer Community series - The Kaizen series! Welcome back to the new start of Kaizen! This post is about Client Script and its simple use cases involving ZDK Client functions. What is Client Script?

• Universal search

  Hi, it would be useful if the search bar was universal-so if you entered a term, it would bring up results from contacts, candidates, clients etc all at the same time (but broken down under the relevant headings)

• Attachment reminder?

  My team and I often need to attach files to our messages, e.g. an explanatory screenshot or a shipping label. More often that I want to admit I mention the attachment but forget to actually attach it. Some email clients have a check-for-missing-attachments

• ZIA in Zoho Cliq

  Is It possible to use the ZIA feature from Zoho Analytics in the Zoho Cliq?

• Automating CRM backup storage?

  Hi there, We've recently set up automatic backups for our Zoho CRM account. We were hoping that the backup functionality would not require any manual work on our end, but it seems that we are always required to download the backups ourselves, store them,

• Multiple upload field CRM

  I desperately need the functionality to add more than one upload field to web to contacts form. How can I do this?

• Collections Management: # 1 Payment Collection is All About Convenience

  "Sir, can you come tomorrow? My manager wasn't available for the cheque sign-off", the customer said, avoiding eye contact. Ravi forced a polite smile, but inside, he felt a sense of defeat. He had already visited the customer's office twice in the last

• Can the Product Image on the Quote Template be enlarged

  Hello, I am editing the Quote Template and added ${Products.Product Image} to the line item and the image comes up but it is very tiny. Is there anyway that you can resize this to be larger? Any help would be great! Thanks

• Audio/video quality issues with Zoho Meeting – Any roadmap for improvement?

  Hi Zoho Team, We’ve been using Zoho Meeting for both internal and external meetings, and unfortunately, the experience has been consistently poor. The video and audio quality are so unreliable that it often renders meetings ineffective—especially with

• Cash based businesses cannot use the new fixed asset module

  Hello all, If your bookkeeping is reporting in cash, you cannot use the new fixed acid module, as it does all the depreciation bookings accrual and not cash. This is definitive and you can't turn them into a cash booking. They will never appear in your

• Zoho Learn & Zoho Connect

  Hi, Is there a way to sync the knowledge base we have in Zoho Learn with the manuals section is Zoho Connect? Thanks,

• Apply Payment Received Amount Zoho Books Invoice

  Hello team here is the sample code How can apply the payment received record over a unpaid zoho books invoice. //......................... paymentID = customer_payment.get("payment_id"); organizationID = organization.get("organization_id"); paymentmaplist

• [Live Webinar] New in Zoho WorkDrive: AI enhancements, Data Loss Prevention, Version Controls, and more

  Hello everyone, We're excited to bring you another round of powerful updates in Zoho WorkDrive! Join us on May 15 for an exclusive live webinar where we’ll unveil the latest features designed to enhance your team’s productivity, collaboration, and data

• Live webinar: Streamlining legal operations: Leveraging Zoho WorkDrive for law firm success

  Hello everyone, Managing legal documents across departments and jurisdictions can be complex, but it doesn’t have to be. Join us on March 6 for an exclusive webinar where we’ll show you how Zoho WorkDrive empowers legal teams to stay compliant, organized,

• Live Webinar: Optimizing back-office operations in the manufacturing industry to maximize profitability

  Hello everyone, We’re excited to invite you to our upcoming live webinar on February 6! Discover how Zoho WorkDrive can help manufacturing businesses optimize back-office operations, improve efficiency, and boost profitability. Our product experts will

• Live webinar: 2024 recap of Zoho WorkDrive

  Hello everyone, We’re excited to invite you to our year-end live webinar! This session will take you through the transformative features and updates we’ve introduced in Zoho WorkDrive this year, helping you streamline document management like never before.

• Live webinar: Explore WorkDrive's seamless integrations with key Zoho apps

  Hello everyone, We’re excited to invite you to our upcoming live webinar, where we'll delve into the seamless integration of WorkDrive with other key Zoho applications! This is a fantastic opportunity to enhance your productivity and streamline your workflows

• Live webinar: Getting the most out of WorkDrive in Zoho Workplace

  Hello everyone, We’re excited to invite you to our upcoming live webinar, where we’ll explore how to maximize your use of WorkDrive as part of the Zoho Workplace bundle. This is a fantastic opportunity to elevate your productivity and streamline your

• Next Page