What's New in Zoho Reports
Trail on Zoho Reports feature and service evolution.
| 'User Filter' for Dashboards
User filters can now be placed at the dashboard level. When such user filters are applied at the dashboard level, all the reports in the dashboard are affected by them. Makes your job much easier, as you need not apply the filter for each and every report of the dashboard.
|
 1s | Aggregate Formula Enhancements
1. We now support 'Date' functions in aggregate formulas, and so you can drop any Date columns.
2. We have added three new aggregate functions - SumIf, AvgIf and CountIf.
|
| Changes to the Default Folder 'Table & Reports'
We have brought in flexibility to the default 'Tables & Reports' folder.
- You can now rename 'Tables & Reports' as you wish.
- 'Tables & Reports' need not be your default folder anymore. You can make any one of your folders as the default folder.
|
| 
| Aggregate Formula Column Enhancements
You can now add Aggregate Formula columns in Query Tables. Aggregate formulas can be added using Add > Aggregate Formula menu and edited using Add > Edit formulas menu.
Aggregate Formulas now support AND, OR, LIKE, IN and NOT IN operators.
|
| 
| Custom Sort in Charts
In addition to arranging axis values of bar charts in Ascending or Descending order, you can do custom sorting too.
|
| Aggregate Formula
We have added a new powerful calculation model called Aggregate Formulas. This is in addition to the existing Custom Formula option which enables you to add formula columns to a table.
Aggregate Formulas are formulas where you use aggregate functions (SUM, AVG..) in the calculation. It will be mainly useful when you create reports with aggregations applied. These Aggregate formulas can be used in Charts, Pivot Tables and Summary View report types.
Aggregate Formulas are different from Custom Formula columns in the following ways:
- In Aggregate Formulas you need to definitely use aggregate functions (SUM, AVG..) in the calculation
- Will not be added as a column in the table, but will be available for report creation on the associated table.
Aggregate Formula can be added by using Add -> Aggregate Formula option in the toolbar of the table or can be added when you create a report (charts, pivot tables, summary views) using Add Aggregate Formula link provided under column list pane in edit design mode of a report |
 | Edit Formulas A new option to easily view and edit all your formulas defined for a tables is provided now. You can access this option using the option Add -> Edit Formulas option in the toolbar of the corresponding table. From this option, you can 'Edit', 'Delete' as well as 'Format' the existing custom and aggregate formulas in a table. |
Additions to Manage Users Page
Now, you can view and export the list of databases and users who have access to the respective databases with their roles in your account. View by: Database and Export List options has been provided under Manage Users tab in Subscriptions page.
Jan 30, 2012 Multiple Language Support
Zoho Reports user interface is now available in nine different languages. The languages supported are:
- Chinese [zh]
- English [en]
- French [fr]
- German [de]
- Italian [it]
- Japanese [ja],
- Portuguese [pt]
- Portuguese (Brazil) [pt_BR]
- Spanish [es]
Note: When a user logs in to Zoho Reports, one of the above languages gets set based on the browser's locale setting. Users can switch to any of the other languages, from their Zoho Accounts (https://accounts.zoho.com/) Profile page.
| Alternate Text for URL Data Zoho Reports now allows you to add alternate text to URL columns in a table. Alternate text is a substitute reader-friendly text that will be shown instead of the actual URL. To provide alternate text to all the URL's in a column:
- Select the column by clicking on the its header.
- Select Column Properties -> Format Column option from the tool bar or select Format Column option in the right click context menu.
- In the dialog box that appears, enter your text that describes the URL in the Alternative Text box.
- Click OK.
|
 | Importing Hidden rows/columns from Excel File Previously, when importing data from Excel file, if the excel table contains hidden rows or columns, only the visible rows will be imported in to the Zoho Reports table by default. Now, Zoho Reports allows you to choose to import the hidden rows/columns by providing Import Hidden Rows/ Columns option in the second step of the Import wizard. Options provided are:
- Import Hidden Rows: By selecting this option, any hidden rows in the excel sheet will be imported.
- Import Hidden Columns: By selecting this option, any hidden columns in the excel sheet will be imported.
|
 | More Import Settings You can now choose your own thousand and decimal separator symbol to be used in your data while importing data into your database. Following options are made available under More Settings link for configuring the separators.
- Thousand Separator: Option to choose your own thousand separator to be used for number, positive number, decimal number and percentage data type columns. The default value is NONE.
- Decimal Separator: Option to choose your own decimal separator to be used for decimal number and percentage data type columns. The default value is DOT.
|
Uploading ....