Visualize Charts Using Groupby and Aggregate functions

Visualize Charts Using Groupby and Aggregate functions

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 or simply leave a comment.

Happy writing!

    • Sticky Posts

    • Post your documents to from Zoho Writer

      Hi Zoho Writer users, We've rolled out a new WordPress extension that will enable you to post Zoho Writer documents to your self-hosted WordPress site. Here's how you can use the extension: Install the Zoho Flow WordPress plugin in your organization's
    • 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
    • Easily create personalized Writer documents in bulk with your Zoho Creator data

      Hi everyone, We're excited to share that we've added Zoho Creator as a data source for mail merge templates in Zoho Writer. Zoho Creator is a powerful low-code application that collects different types of data. By configuring Creator as a data source
    • Introducing Zoho Writer's new ChatGPT extension

      Hi everyone, We're happy to unveil the ChatGPT extension for Zoho Writer. Now, harness the power of AI to elevate your writing and enhance your productivity. Seamlessly integrate ChatGPT with Zoho Writer so you can chat with the bot and use its responses
    • New in Writer: Write in Arabic, Hebrew, and Other Right-to-left Languages

      We're happy to introduce complete support for right-to-left languages like Arabic, Persian, Hebrew, and Urdu. This update opens Writer to more than 300 million people in 20 countries across the world, and we couldn't be more excited.   Here's everything that's new, improved, and fixed:   I. Enhanced Writing Experience    Working with bullet points, punctuation, even comments and tracking changes—we've refined and rewritten so many little things to enhance your writing experience in all right-to-left