Visualize Charts Using Groupby and Aggregate functions

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!

    Access your files securely from anywhere




          Zoho Campaigns Resources

                Zoho Developer Community

                    Bootcamp
                    Community
                    Pricing
                    Webinars
                    What's New
                    Integrations
                    Contact Support
                    Contact Sales

                      Zoho Survey Resources
                        Features
                        Survey Templates
                        Integrations
                        Community
                        iOS Mobile Surveys
                        Pricing
                        Android Mobile Surveys
                        Insurvey Blogs
                        Insight Blogs
                        Tips & Tricks






                                      Latest Feature Updates

                                        • Desk Community Learning Series


                                        • Digest


                                        • Functions


                                        • Meetups


                                        • Kbase


                                        • Resources


                                        • Glossary


                                        • Desk Marketplace


                                        • MVP Corner


                                        • Word of the Day


                                        • Ask the Experts




                                            Zoho SalesIQ Resources

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

                                                  • 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

                                                  • Introducing Org Fonts in Zoho Writer

                                                    Hey Zoho Writer users! We're excited to share that you can now add custom fonts (from web fonts with publicly accessible URLs) using Zoho Writer's Org Fonts. This option allows all users across your organization to use the custom font without the hassle


                                                  Manage your brands on social media
                                                  Access Zoho Social

                                                    Zoho Pagesense Resources


                                                        Zoho TeamInbox Resources

                                                          Zoho DataPrep Resources


                                                            Zoho CRM Plus Resources

                                                              Zoho Books Resources


                                                                Zoho Subscriptions Resources

                                                                  Zoho Projects Resources


                                                                    Zoho Sprints Resources


                                                                      Qntrl Resources


                                                                        Zoho Creator Resources



                                                                            Zoho CRM Resources

                                                                            • CRM Community Learning Series

                                                                              CRM Community Learning Series


                                                                            • Kaizen

                                                                              Kaizen

                                                                            • Functions

                                                                              Functions

                                                                            • Meetups

                                                                              Meetups

                                                                            • Kbase

                                                                              Kbase

                                                                            • Resources

                                                                              Resources

                                                                            • Digest

                                                                              Digest

                                                                            • CRM Marketplace

                                                                              CRM Marketplace

                                                                            • MVP Corner

                                                                              MVP Corner





                                                                                Design. Discuss. Deliver.

                                                                                Create visually engaging stories with Zoho Show.

                                                                                Get Started Now


                                                                                  Zoho Show Resources


                                                                                    Zoho Writer Writer

                                                                                    Get Started. Write Away!

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

                                                                                      Zoho CRM コンテンツ








                                                                                        Nederlandse Hulpbronnen


                                                                                            ご検討中の方




                                                                                                  • Recent Topics

                                                                                                  • Problem with currency field in Zoho CRM

                                                                                                    Hi Guys Zoho Books has a feature in currency fields that automatically converts decimal numbers with commas ( , ) to period format ( . ) when pasting them. For example: R$ 2,50 --> R$ 2.50 Is this behavior available in Zoho CRM? I couldn't find any configuration

                                                                                                  • ZUG Meetup 2025 - India: Meet Zoho Workplace Experts in your city and learn the smart ways to go digital.

                                                                                                    Dear Zoho Mail Community, We are very much glad to meet you all in person in the Zoho User Group (ZUG) meetups across 7 cities in India, this year. Come meet us in your city or the ones nearby to yours and learn first hand the smart ways to go digital

                                                                                                  • Multiple office locations in Zoho Recruit

                                                                                                    Hi, we have just started to use Zoho Recruit for our recruitment company. Im a little confussed to how we add multiple office bases for the same company name. For example, if it was company ABC, they also have an ABC Manchester, ABC Bristol and so on....

                                                                                                  • I need to know the IP address of ZOHO CRM.

                                                                                                    The link below is the IP address for Analytics, do you have CRM's? https://help.zoho.com/portal/ja/kb/analytics/users-guide/import-connect-to-database/cloud-database/articles/zoho-analytics%E3%81%AEip%E3%82%A2%E3%83%89%E3%83%AC%E3%82%B9 I would like to

                                                                                                  • Customer Parent Account or Sub-Customer Account

                                                                                                    Some of clients as they have 50 to 300 branches, they required separate account statement with outlet name and number; which means we have to open new account for each branch individually. However, the main issue is that, when they make a payment, they

                                                                                                  • Generate a link for Zoho Sign we can copy and use in a separate email

                                                                                                    Please consider adding functionality that would all a user to copy a reminder link so that we can include it in a personalized email instead of sending a Zoho reminder. Or, allow us to customize the reminder email. Use Case: We have clients we need to

                                                                                                  • Project Change Orders and Additions

                                                                                                    We are in the process of migrating from QuickBooks Online to Zoho Books. We have Zoho One and like the ability to sync all of our data across everything. And I like that projects work in a way that's less dumb than QuickBooks. I'm trying to figure out

                                                                                                  • Invite External Users to Zoho Projects Without a Full Zoho One License

                                                                                                    Dear Zoho Projects Team, I hope you're doing well. We would like to request a feature that allows external users (such as freelancer developers) to be added to Zoho Projects with a more flexible access model—similar to what is available in Jira. Currently,

                                                                                                  • Columns language changed

                                                                                                    Hello, As you can see in attachment in Zoho analytics some colums of field have change from language to french and some are still in English. We have no idea why but we would like it to be in English all again. how can we do that please ? Thanks

                                                                                                  • How to install Widget in inventory module

                                                                                                    Hi， I am trying to install a app into Sales Order Module related list, however there is no button allow me to do that. May I ask how to install widget to inventory module related list?

                                                                                                  • Introducing Keyboard Shortcuts for Zoho CRM

                                                                                                    Dear Customers, We're happy to introduce keyboard shortcuts for Zoho CRM features! Until now, you might have been navigating to modules manually using the mouse, and at times, it could be tedious, especially when you had to search for specific modules

                                                                                                  • Disable Subform Actions using Client Script Add Row, Edit, Delete

                                                                                                    Currently we cannot disable subform actions such as Add Row, edit row using client script It will be really beneficial if we can disable these actions from Client Script

                                                                                                  • Product Updates in Zoho Workplace applications | Feb 2025

                                                                                                    Hello Workplace Community, Let’s take a look at the new features and enhancements that went live across all Workplace applications this February. Zoho Mail Group Tags for Shared Mailbox Within Shared Mailbox, Moderators can now create group tags, accessible

                                                                                                  • How to integrate Zoho Sign with Zoho CRM

                                                                                                    Hi， I am starting to use Zoho sign for CRM inventory template signature collection. is there any way to fetch CRM inventory template and auto send to specific mailbox by using Zoho Sign API(or other)? I know we can click "Send with Zoho sign", but we

                                                                                                  • Unexpected Error in Reports (Pivot Chart, Pivot Table)

                                                                                                    Dear Zoho Support Team, I am facing an issue while creating reports (Pivot Chart, Pivot Table, etc.) in Zoho Creator. When I try to access the report, I receive an unexpected error, and an alert message saying "Undefined" appears with the loading UI.

                                                                                                  • Client Script | Update - Introducing Subform Events and Actions

                                                                                                    Are you making the most of your subforms in Zoho CRM? Do you wish you could automate subform interactions and enhance user experience effortlessly? What if you had Client APIs and events specifically designed for subforms? We are thrilled to introduce

                                                                                                  • POS System

                                                                                                    Has anyone had any luck integrating a POS system with the zoho crm? Any advice where to look for a zoho proven solution? Thanks in advance.

                                                                                                  • Line chart customization

                                                                                                    Hi, is there any way to draw multiple lines on a single line chart. Now on te x-axis im displaying dates and on the y-axis dispalying total records count. I want to display multiple lines on the same chart. The sample image is attached

                                                                                                  • Introducing an AI-driven CAPTCHA for Help Center that offers improved accessibility and enhanced security | Zoho Desk | Product Update

                                                                                                    Captcha protects your help center from fraud and abuse without creating friction. What is a CAPTCHA? CAPTCHA is a test used in computing to verify that a user is human by requiring them to complete a challenge. It helps prevent bot attacks and reduce

                                                                                                  • Does Zoho Docs have a Line Number function ?

                                                                                                    Hi, when collaborating with coding tasks, I need an online real time share document that shows line numbers. Does Zoho's docs offer this feature ? If yes, how can I show them ? Regards, Frank

                                                                                                  • Dark Mode for ZOHO Recruit

                                                                                                    Please make a dark mode for ZOHO Recruit. The white is SO BRIGHT!

                                                                                                  • Free webinar: Using Zoho Sign with Zoho Flow to streamline document workflows and signature collection

                                                                                                    Hello, Do you find yourself constantly switching between different apps to simply get a document signed? Attend our free webinar to learn how you can streamline and automate this process by connecting Zoho Sign, our digital signature app, with other apps

                                                                                                  • Territory view for custom modules?

                                                                                                    I have recently activated territories however I can't seem to find how to use territories for custom modules? These modules have territories:  Contacts /  Accounts / Opportunities These modules don't have territories:   Buildings (custom module) and 

                                                                                                  • Why can't you make a layout rule based on a lookup field?

                                                                                                    Hello :) I am wanting to build a layout rule based on the selection of a lookup field. I have 3 fields that I want to hide for all options, but only show one if the lookup is one of the 3 options needing the extra field. It doesn't seem to give me the

                                                                                                  • Access demo forms other than developers in Zoho Creator 6

                                                                                                    Can zoho creator 6 users other than developers test forms in the development/stage? just want to see the form view. The current condition of the form is being released, and want to make changes. But the user wants to see the changes first before publishing

                                                                                                  • Bigin_Email Notification not being sent when a new lead is created

                                                                                                    I have a workflow in BIGIN set to send an email notification when a new lead is created via a webform (integrated with ZohoForm) The trigger is whenever a contact is "Create or Edit". Conditioning was applied for contacts which source is "Website" If

                                                                                                  • CRM x WorkDrive: File storage for new CRM signups is now powered by WorkDrive

                                                                                                    Availability Editions: All DCs: All Release plan: Released for new signups in all DCs. It will be enabled for existing users in a phased manner in the upcoming months. Help documentation: Documents in Zoho CRM Manage folders in Documents tab Manage files

                                                                                                  • Prevent subform editing on a module's detail's page

                                                                                                    Hi everyone, We would like to prevent any editing of the subform data in the : Create page Edit page Details page (as subform editing is now allowed by the recent UX update) We are able to prevent editing by making the subform fields read only in the

                                                                                                  • I'm so confused by the new (?) look

                                                                                                    I've been off Notebook for a long time, neglecting the app and never visiting the website. I decided to renew my commitment to it. It looks completely different! When I logged on before (app or browser page) I'd see a very pretty display of my multiple

                                                                                                  • Custom CSS in Zoho Form

                                                                                                    Hi, Please let me know, how we can add custom css in Zoho Form.  Thanks

                                                                                                  • Deluge Script to Reopen Ticket if Tasks are not Completed

                                                                                                    I have the following script, my goal is to have it automatically reopen the ticket when the ticket is closed if there are Activities assigned to the ticket that are not "Completed". This script seems to reopen the ticket if there are any tasks at all,

                                                                                                  • Zoho Desk & Tasks

                                                                                                    Hi, I'd like to be able to create a set of tasks each time a customer request comes in, as I understand it, currently each would need to be create manually. Project is too much of an overhead for what we want to use. Effectively in various use cases we

                                                                                                  • Urgent: Assistance Required for Domain DNS Configuration (planb-hub.com)

                                                                                                    Dear Zoho Support Team, I hope you are doing well. I recently purchased the domain planb-hub.com through Zoho, but I am experiencing difficulties configuring its DNS settings. When I tried accessing the DNS management panel in Zoho, I could not find the

                                                                                                  • Export all Zoho desk tickets for past 3 months

                                                                                                    Hi I need to export ticket data from Zoho Desk. Specifically, I'm looking to: Export the last 3 months of tickets⁠ include ticket categories, timestamps, resolutions, agent responses (basically as much data as possible) the ticket content being the most

                                                                                                  • Zoho CRM <> Zoho Desk Account Sync

                                                                                                    I have had custom fields in Zoho CRM for a time and would like that data to sync to Zoho Desk. However, since the accounts are all synced to Zoho Desk already, the newly mapped fields are not updating in Zoho Desk. Is there a way to force the sync to

                                                                                                  • Count Function in Zoho Table

                                                                                                    Hi Zoho Team, Hope you're doing well. We would like to request the addition of a Count function in Zoho Table, similar to what exists in Excel, Google Sheets, and Airtable. Currently, there is no built-in way to count the occurrences of unique values

                                                                                                  • Configuring ZMA Webhook for Zoho Flow : Missing Key Information Error

                                                                                                    I'm looking to send a webhook to Zoho Flow at the end of a Marketing Automation journey in order to perform more actions that I can't do with just a journey. I have the Webhook created in Flow and set up in ZMA, however when I test it I get the error

                                                                                                  • Generate a Zoho Sign link

                                                                                                    From time to time I get a response "I never received your you e-document for electronic signature" is there a way to generate a Zoho Sign link to share.

                                                                                                  • Zoho Billing Record Refund vs Refund

                                                                                                    When looking at a paid invoice, the payment record can be viewed. In the more actions, there is a "Record Refund" option. If you click the payment referernce you see a "Refund" option. They bring up different forms. It appears as if "Record Refund" is

                                                                                                  • Emoticons to Slack in Zoho Flow

                                                                                                    When using the Slack integration in Zoho Flow, is there a way to send emoticons in the message? When I tried :emoticon: it didn't translate it to the emoticon.

                                                                                                  • Next Page