Report specific data formatting options

Zoho Reports now allows you to set report specific formatting for data columns displayed in your reports. Till now you could set column formatting only in the Tables in which these columns are part of which was just inherited to every report that was created involving these columns. Hence it was not possible to change the formatting at the report level. The new reports specific formatting options addresses this limitation.

You can set this using Setting section of the report you create. This feature is available for Charts, Pivot View and Summary View. In Charts this will format the data displayed as tooltip.  The following screenshot is from a pivot table settings dialog.

Data Formatting in KPI Widgets 

You can now format the data metrics displayed in KPI widgets that you add in your dashboards, as shown below. Formatting in another very handy visual customization option for KPI widgets.  

Dashboard PDF Export Enhancements

Zoho Reports has now enhanced the dashboard PDF export with the following features.

Zoom Factor in % (Font size) 

With this option, you can scale the font size of the reports in your dashboards to fit to the page size appropriately. This could be scaled between 1 to 100%.

Column Width Ratio

This allows you to define the column width radio for the table styles reports (pivot, summary, table etc.,) in your dashboard. You can either choose to have equal width for all columns or set proportional column width based on the design of the original report. 

Support for Custom Modules in Salesforce Advanced Analytics Add-on

Salesforce Advanced Analytics Add-on now supports pulling data from custom modules setup in your Salesforce account into Zoho Reports. You can add up to five custom modules from Salesforce into Zoho Reports.

Schedule Imports in your own Time Zone

So far data imports can be scheduled only in GMT time zone. Now Zoho Reports allows you to set these schedules in your own time zone of preference.

New Functions in Query Table

Zoho Reports Query Table has now been enhanced with the following new functions.

• ADDHOUR - Adds the specified number of hours to the given date value.
• ADDMINUTE -Adds the specified number of minutes to the given date value.
• ADDSECOND - Adds the specified number of seconds to the given date value.
• ADDWEEK - Adds the specified number of weeks to the given date value.
• ADDMONTH - Adds the specified number of months to the given date value.
• ADDQUARTER - Adds the specified number of quarters to the given date value.
• ADDYEAR - Adds the specified number of years to the given date value.