Zoho Reports - New features rolled out on Sept. 20, 2013

Zoho Reports - New features rolled out on Sept. 20, 2013

The following new features were out on Sept. 20, 2013 in Zoho Reports service.




More Advanced Summary Functions for Chart
With this build, more advance summary functions have been added for Charts. They are:

  • Moving Calculation
  • 100% Group

Moving Calculation
Calculates the moving value of each data point based on the inputs you provide. The summary function selected will be taken as the basis for calculation. You can perform sum, average, minimum and maximum calculation using this.

This will be useful to visualize the trend of the your data. The example at the left illustrates the impression of your website vs. moving average of the impressions for the last 30 days.


100% Group
Applies the selected summary function and displays each data point as a percentage of the total in a group. This will be useful for creating 100% Stacked Bar and 100% Stacked Area Chart.

When you create a chart for sales across years categorized by region, then using this function you could get the percentage of sales in each region as seen with the example at the left.




Column Sub-total Support in Pivot Table
So far, sub-total was available only for rows. Now Zoho Reports supports sub-total for columns too.

In a Pivot View with multiple columns, you can now show or hide sub-total for each column.




More In-built Functions for Formula Columns
Now Zoho Reports supports more in-built functions for formula column and aggregate formula and this enables creating insightful reports using these advanced calculations.

The following are the newly supported in-built functions.

  • ADD MONTH - Add the specified number of months to the given date value. 
  • ADD QUARTER - Add the specified number of quarters to the given date value. 
  • ADD WEEK - Add the specified number of weeks to the given date value.
  • ADD HOUR - Add the specified number of hours to the given date value.
  • ADD MINUTE - Add the specified number of minutes to the given date value.
  • ADD SECOND - Add the specified number of seconds to the given date value.
  • CONVERT TIMEZONE - Converts the date from one timezone to another.
  • DATE - Returns only the date part of the given date-time expression.
  • QUARTER NUMBER - Returns the quarter of the given date in numeric format.
  • CONVERT BASE - Converts the number from one number system to the other. 
  • COUNT WITH BLANK (Aggregate) - Returns the count of values including null or empty value.

Enhanced Sorting option for Pivot column with Advanced Summary Function
Previously the pivot columns with advanced summary function can be sorted only by the base column. From now on you can directly sort these columns.