What's new in Zoho Analytics?

Sharing user-created views with the administrator

Zoho Analytics now allows users to share the reports they create with administrators. The shared views will appear in the administrator's Shared Views folder, along with the name of the user who shared the report. Click here to learn more.

Enhancements to Top/Bottom N rank filters for reports

Identify top and bottom performers across various dimensions. Zoho Analytics' ranking feature helps you find the highest and lowest performers within and across data groups without the need for complex formulas. Click here to learn more.

Copy or move views across dashboards

Zoho Analytics now allows you to copy and paste views across different dashboards using keyboard shortcuts (Ctrl+C and Ctrl+V). Click here to learn more.

Define alerts based on threshold and anomalies

You can now configure data alerts to receive notifications for threshold breaches and anomalies, detect critical shifts in key business metrics quickly, and address potential problems. Click the corresponding links to learn more.

Conditional formatting advancements in Pivot table

With the latest update, you can now apply conditional formatting based on values from other than the primary column. Click here to learn more.

Inline embed component for dashboards

Zoho Analytics now features an inline embed component within the dashboard designer page to add, modify, or delete embed custom HTML code effortlessly. Click here to learn more.

Image and custom icon support in KPI widgets

You can now add images and custom icons to the dashboard widget to provide visual cues about the type of information in the widget without the need for lengthy descriptions. Click here to learn more.

Dashboard layout advancements

Customize your dashboard layout to your preference with the new resizing options. You can choose from a variety of options, including web, A3, A4, Letter, and Tabloid, or set a custom width to tailor the layout to your needs. Click here to learn more.

Report formula now supports text data type

Zoho Analytics now supports the creation of report formulas using the Plain Text data type right from the chart builder interface. Click here to learn more.

Enhanced geo location picker for Geo Maps

Zoho Analytics now simplifies the process of resolving unidentified locations. You can search for the location or enter latitude and longitude information with a single click.

Enhancements to Workspace Migration

With the latest enhancements, you can now migrate workspace configurations including Import Schedulers, Users, Groups, Sharing Settings, Alerts, Snapshots, Email Schedules, Slideshows, and Public views.

Announcing support for the Arabic language

Zoho Analytics' user interface now supports Arabic language in addition to other languages. Click here to know about the supported languages.

More enhancements

• Auto Analysis option is now available under the Create New option within the respective table view to analyze data and create reports/dashboards automatically.
• When importing Excel files, you now have the option to select all the sheets at once, rather than having to choose them individually.
• Zoho Analytics now allows you to create workspaces that combine both live connect and schedule sync data sources.

Spot anomalies in charts effortlessly

With Zoho Analytics, identifying variations in your data becomes seamless. You can easily detect spikes or drop in values when they display a high degree of deviation from the norm. Click here to learn more.

Dashboard Enhancements

1. Auto-merging of user filters

When Zoho Analytics auto-adds report user filters to the dashboard, filters with the same column name and type will now merge automatically without any manual mapping. Click here to learn more.

2. Inline text editor

Zoho Analytics now includes an inline text editor, allowing you to add richly formatted text and images directly within the dashboard editor for a seamless user experience. Click here to learn more.

3. Wrap text

With the new wrap text feature, you can easily prevent text from overflowing into adjacent dashboard components and enhance readability. Click here to learn more.

Chart advancements

In charts, the column that serves as a dependent or base column for summarizing values can now be freely moved to any other field in the chart editor.

Aggregate formula now supports new data types

Zoho Analytics now supports the creation of aggregate formulas using data types like Plain Text and Date. Click here to learn more.

Change scale type and summary functions in real-time

Dynamically switch scale types and apply advanced summary functions to numeric data columns directly from the chart's view mode. Click the corresponding links to learn more.

Renaming columns in query table

In query tables, you can now rename columns even if they have dependent views or other query tables based on them. Click here to learn more.

Hide vertical lines in pivot table

Zoho Analytics now provides an option to hide vertical lines in pivot tables, enhancing the readability and clarity of reports for a more insightful data analysis experience. Click here to learn more.

Enhancements in managing email schedule

You can now easily oversee and manage all email schedules for the workspace from one location. Zoho Analytics offers simplified email schedule management by centralizing all the controls within the workspace settings page. Click here to learn more.

Currency formatting enhancement for Formula Column and Aggregate Formula

When you create a formula column or aggregate formula column over a column that is marked as a currency data type, the newly created formula column inherits the same data type (currency) automatically. Click here to learn more.

Introducing Live Connect support for HSQL local database

Zoho Analytics now allows you to connect live with HyperSQL(HSQL) local database. Click here to learn more.

Workspace Level Currency Formatting

You can now have a unified and consistent currency format across all reports and dashboards. Zoho Analytics allows you to configure and modify the display format of currency data types directly from the workspace settings. Click here to learn more.

Interact with Ask Zia in French (Beta)

You can now engage in conversations with Ask Zia in French (Beta) language. Click here to learn more.

Show missing values in Charts

The Show Missing Values option is now supported in Heat Map reports. On enabling this option, Zoho Analytics assigns a color to the missing values to create a complete visualization without any white or blank spaces. Click here to learn more.

Get dynamic insights from Zia based on the legend filters

Zia insights now display insights dynamically based on the selection made in the legend. Click here to learn more.

Visualize state-specific charts in Geo maps

The geo maps offer support for both country-level and state-level layouts. Click here to learn more.

Display forecasts on KPI widgets

Zoho Analytics now lets you present forecasted values on dashboard widgets. Click here to learn more.

Introducing Duration format to represent time intervals

In addition to being able to represent time values as whole numbers, Zoho Analytics now allows you to display time intervals in a more readable format using the Duration data type. Click here to learn more.

Data Synonyms for Ask Zia

No more struggling to remember specific data values when asking questions - Ask Zia's synonyms support is now available for values in the data tables. You can now specify other terms or synonyms for row-level values in each column of your data table. Click here to learn more.

Chart Styling Enhancements

Elevate your data visualization with the following enhancements in charts that align with current global design trends: A brand-new default color palette, captivating area chart gradient effects, stylized markers for scatter, line, area, and web charts, dotted gridlines, and clutter-free view with the removal of the Y-axis line. Click here to learn more.

Enhancements in pivot view

1. Column header alignment

Zoho Analytics enables you to change the alignment of the column header in the Pivot view. Click here to know more.

2. Show/Hide rows

Zoho Analytics allows you to Show or Hide totals even when the data are added in Data as row format. Click here to learn more.

Dashboard advancements

1. Move views across tabs

Zoho Analytics now lets you move views across the dashboard tabs. Click here to learn more.

2. Set margin between cards

In the dashboard custom theme, you can now set a desired, or no margin/spacing between views. Click here to learn more.

Introducing Live Connect support for additional databases

Zoho Analytics now offers Live Connect support for the Denodo and IBM Informix local databases. Click the corresponding links to learn more.

Import data from Parquet files

Zoho Analytics now lets you import data from Parquet files stored in local drives, web URLs, and FTP servers. Click the corresponding links to learn more.

Enhancement to User management

Zoho Analytics administrator can now help other users reset their password by creating a temporary one-time password. Click here to learn more.

Settings page revamped

We've revamped the user interface of the Settings page. We've also categorised the settings and included new sections like help and support, troubleshoot and miscellaneous to improve the user experience. Click here to learn more.

Introducing new language support

Zoho Analytics user interface is now available in Romanian language in addition to the other languages.

Support for new mail server types

Zoho Analytics now supports OAuth authentication in SMTP and Microsoft's Exchange Web Services (EWS) as mail servers to trigger email notifications when an action is performed. Click here to learn more.

Redesigned getting started screens

Zoho Analytics' getting started screens have been redesigned to enhance the user experience. Click here to learn more.

Database upgrade

Zoho Analytics' backend PostgreSQL database which is used to store data is upgraded to version 11.14.

Advanced columnar engine

Experience 2x faster read operations in Zoho Analytics with the new and improved columnar engine.

Boosted performance

Zoho Analytics can now support larger workloads with the introduction of horizontally scalable architecture.

Enhancements to Google Ads integration

The Google Ads integration now requires a developer token to authenticate with Google Ads APIs for data collection. Click here to learn more.

Support to import GZIP files

You can now import data from GZIP files stored in your local drives, web URLs, or any FTP servers.

Enhancements to data backup

Zoho Analytics enables you to choose the retention period for your data backups. Click here to learn more.

Support to enable/disable emails triggered on user addition

You can now choose to enable or disable the welcome email being triggered while adding SSO or Active Directory users to Zoho Analytics. Click here to learn more.

Updated Xero authentication process

The key-based authentication mechanism for Xero has been replaced with OAuth mode. Click here to learn more.

Retain source workspace's column data type

While importing data from other Zoho Analytics workspaces, the columns' data type will also be retained as in the source workspace.

Updated Jira Software Cloud authentication process

The authentication mechanism for Jira Software Cloud has been changed from being key based to OAuth mode. Click here to learn more.

Revamped Zoho Analytics login page

Zoho Analytics' login page has been revamped to feature product-related announcements. Click here to learn more.

Remove a table's data source

You can now remove an individual table's data source, to stop the table from updating new data from the source. Click here to learn more.

Sync meta data changes instantly

You can instantly reflect the source database's meta data changes to individual tables in Zoho Analytics easily. This is only applicable for data imported using live connections. Click here to learn more.

Support for AND/OR logical operators in data alerts

You can leverage AND and OR logical operators while creating data alerts. Click here to learn more.

Enhanced custom sort interface

The custom sort option in reports has been revamped to enhance user experience.

Modifications to the Annual Maintenance and Support license format

Zoho Analytics is moving to an xml-based Annual Maintenance and Support (AMS) license format that allows for notifications before AMS expiration. Click here to learn more.

Apply multiple user filters simultaneously

You can now choose to apply multiple user filters simultaneously in a dashboard. Click here to learn more.

Choose the required data center

You can now choose the data center associated to your Zoho account while setting up the integration with Zoho Creator, Zoho DataPrep and Zoho CRM. Click the corresponding links to learn more.

Revamped getting started screens

Zoho Analytics' getting started screens have been revamped to enhance the user experience. Click here to learn more.

Enhanced forecasting engine

You can choose to generate forecasts for the columns used in a chart's Color shelf. Click here to learn more.

Support for lookup columns in live connections

You can now create lookup columns while importing data using live connections. Click here to learn more.

Introducing enhancements in reports

The following enhancements have been made to reports in Zoho Analytics:

1. A chart's Edit Design mode displays contextual menu options over columns used in the chart builder (on mouse hover). Click here to learn more.

2. You can now display images in the place of text in a chart's axis. Click here to learn more.

3. The creating a tabular view screen has been revamped for easier navigation.

Launching advanced analytics for additional modules in ServiceNow

Zoho Analytics now offers out-of-the-box analytics for ServiceNow's release management, change management and configuration management modules. Click here to learn more.

Enhancements to Ask Zia

The following enhancements have been made to Ask Zia.

1. Introducing Zia Insights - you can now access actionable insights on your visualizations instantly. Click here to learn more.

2. Our AI assistant, Ask Zia, now supports inputs in Spanish.

Customize forecasting models

You can now customize the mathematical models involved in forecasting your data. Click here to learn more.

Enhancements to charts

The following enhancements have been made to charts:

1. When a chart has multiple axes, you can now choose to merge specific axes. Click here to learn more.

2. You can now apply various effects on your chart to modify its overall appearance. Click here to learn more.

Expand and collapse user filters

You can now expand and collapse the user filters in your dashboards. Click here to learn more.

Enhanced user interface

There are also several minor enhancements in the Zoho Analytics user interface, designed to enhance your experience.

Import data in batches (Pagination)

You can now import large amounts of data in batches from web URLs. Click here to learn more.

Introducing enhancements to Ask Zia

The following enhancements have been made to Ask Zia:

1. Ask Zia now supports predictive analytics and generates reports with forecasted values. Click here to learn more.

2. Introducing conversation mode: Ask Zia allows you to post follow up questions to help you dig deeper into your data.

3. Ask Zia is now exclusively available in conversation mode within dashboards, to answer any dashboard-specific questions.

4. Ask Zia will list existing reports as answers to your questions where applicable.

5. You can now map terms in your questions to corresponding columns in the data table while entering your questions. Click here to learn more.

Introducing enhancements to dashboards

The following enhancements have been made to dashboards:

1. You can now add multiple tabs to your dashboards. Click here to learn more.

2. The merge user filters functionality in dashboards has been enhanced to support all data types. Click here to learn more.

Introducing enhancements to sort functionality in charts

You can now sort your multi-axis charts with both X and Y-axes values. Additionally, the Sort option in your chart's toolbar has been revamped for easier navigation. Click here to learn more.

Introducing enhancements to the Export feature

1. You can now export multiple views from the Explorer easily.

2. Zoho Analytics also allows you to export all the views under a particular folder.

Automate scheduled application backups

You can now automate scheduled backups of the Zoho Analytics application easily. Click here to learn more.

Import data from more local databases

You can now import data into Zoho Analytics from the following local databases:

• SQLite
• Progress OpenEdge
• Hive
• Firebird
• YugabyteDB
• Microsoft Access
• SAP HANA

Click here to learn more.

Import data from cloud databases into existing tables

You can now import data from cloud databases into existing tables in Zoho Analytics. Click here to learn more.

Introducing enhancements to Ask Zia

The following enhancements have been made to Ask Zia:

• The AI assistant can now understand questions that are grammatically unstructured or incomplete.
• Ask Zia now features typo tolerance, to understand words that are spelled incorrectly.
• Ask Zia can now interpret the mathematical function that is best suited for your question.
• The AI assistant's knowledge of dates is now enhanced - the term "weekend" and the abbreviated versions of months can now be used.

Click here to learn more.

Support for date-based lookup column

Zoho Analytics now allows you to configure a date column as a lookup column between two tables. Click here to learn more.

Introducing enhancements to charts

The following enhancements have been made to charts:

1. A new chart type has been introduced: Histogram. Click here to learn more.

2. You can now apply patterns to your charts, and choose from a range of pre-built ones or create your own. Click here to learn more.

3. You can now create a 100% stacked bar chart, and charts with horizontal stacked bars that can have multiple Y axes.

4. Zoho Analytics allows you to switch your chart's axis dynamically, to view the chart per your requirements. Click here to learn more.

5. You can now choose to disable the Dynamic Drill Down option in charts. Click here to learn more.

Introducing enhancements to pivot views

The following enhancements have been made to pivot views:

1. You can now hide specific columns in pivot views easily. Click here to learn more.

2. You can now expand and collapse the rows, columns and cells in your pivot views. Click here to learn more.

Introducing enhancements to sharing and publishing options

The following enhancements have been made to the sharing and publishing functionality:

1. You can now request access to views that haven't been shared with you. Click here to learn more.

2. Zoho Analytics now allows you to set expiration dates for views that are published without login credentials. Click here to learn more.

3. While publishing a table, you can now choose to publish only selective columns from that table. Click here to learn more.

4. The Export and Email dialog boxes have been revamped for easier navigation.

Introducing enhancements to Explorer view

The following enhancements have been made to the Explorer View:

1. You can convert a parent folder to a sub-folder, and vice versa. Click here to learn more.

2. You can now mark sub-folders as default folders in your workspace. Click here to learn more.

Bookmark views easily

You can now bookmark important views when accessing them, using the icon found beside the view's name.

Introducing enhancements to user filters

The following enhancements have been made to user filters:

• The existing List only relevant values option can now be used to configure cascading user filters, wherein the subsequent user filter's values are dependent on the preceding user filter's value.
• Conversely, the Show All option can be selected to list every value in the subsequent user filter, regardless of the preceding user filter's value.

Click here to learn more.

Create data snapshots with forecasted values

Easily create Data Snapshots of charts containing forecasted values. Click here to more about data snapshots.

Auto-generate reports over a table's related data

Auto-generate reports over data from both the selected table and its connected tables easily, using the Similar to Another Table feature.

Pivot or unpivot your data tables easily

The below keywords are now supported while creating query tables:

• Pivot: Converts rows into columns by turning the unique values in the input column to multiple output columns.
• Unpivot: Converts columns into rows by changing multiple columns to values in a single row.

Customize alignment of KPI widgets

You can now customize a KPI widget's alignment in a dashboard easily.

Introducing enhancements to charts

The following enhancements have been made to charts:

1. Choose to display legends with or without their corresponding values, and customize their format. Click here to learn more.

2. You can now plot charts with percentile function applied over the numeric data. Click here to learn more.

Introducing enhancements to Explorer view

The following enhancements have been made to the Explorer View:

1. Select and move multiple views across folders in a workspace.

2. Move sub-folders from one parent folder to another, and make parent folders as sub-folders within another folder.

3. You can now bookmark important views from the Reports and Dashboards section in the side panel.

4. Creating new views is now easier, with options to create tables, reports, and dashboards from the respective sections in the side panel.

Introducing enhancements to collaboration features

The following enhancements have been made to the collaboration features:

1. The various collaboration options are now grouped under the common Share button.

2. You can now email filtered views to multiple users and groups. Click here to learn more about emailing views.

3. The Embed and Publish URL screen has been revamped to facilitate easy access.

More authentication types supported for import from web feeds

Zoho Analytics now supports the following authentication types while importing data from web feeds.

• AWS Signature
• Digest Authentication
• Hawk Authentication

Click here to learn more.

View dependency details

You can now view the dependency details of a report or a table in Zoho Analytics easily. Click here to learn more.

A compact pivot layout

Zoho Analytics now allows you to customize the pivot layout, to attain a more compact outlook. Click here to learn more.

Improved Manage Groups UI

Managing groups in Zoho Analytics is now easier with the enhanced UI. Click here to learn more.

Introducing enhancements to the sort functionality in charts

1. By default, new pie charts will be sorted in the descending order based on the distribution of values.

2. A chart with its top or bottom 'N' values filtered will also be sorted in the ascending or the descending order accordingly.

3. If a custom sort is configured as the default for a column in a table, new reports created over that column will also be sorted in the same manner.

Import data from more local databases

You can now import data into Zoho Analytics from the following local databases:

• DB2
• Exasol
• Greenplum
• Vertica
• Actian Vector
• Denodo
• Pervasive SQL
• Any Database supporting JDBC Connection

Click here to learn more.

Customize Pivot Summary Position

Zoho Analytics now allows you to customize the positioning of the column and row summaries in Pivot Tables. Click here to learn more.

Enhancement in Report Formula

Zoho Analytics' report-specific formula builder is enhanced to support logical (AND, OR) and comparison operators. Click here to learn more about Report Formulas.

Apply Parent Table's Filter Criteria

You can now apply the parent table's filter criteria while sharing dashboards with users. Click here to learn more.

Unsubscribe from shared workspaces

Zoho Analytics users can now easily unsubscribe from workspaces that are shared to them. Click here to learn more.

Enhanced emailing options

You can now include up to 25 users in each email schedule. The Pick Users / Groups option also lets you pick groups from a list, instead of having to type all the email addresses individually. Click here to learn more.

Introducing enhancements to the Explorer view

1. Use the Shift + Select option (hold down the shift key during view selection) to choose several views at a time.

2. Clicking the speech bubble icons in the Explorer View will take you to the comments section of each view.

Import data from more cloud databases

You can now import data into Zoho Analytics from the following cloud databases:

• Amazon Aurora PostgreSQL
• Amazon Athena
• Microsoft Azure
  • MySQL
  • PostgreSQL
  • Maria DB
  • SQL Databasee
  • SQL Data Warehouse
• Google BigQuery
• Google Cloud
  • SQL
  • PostgreSQL
• Snowflake
• Rackspace Cloud
  • MySQL
  • Maria DB
• Oracle Cloud
• IBM Cloud
• Panoply

Click here to learn more.

Specify accuracy levels while forecasting

Zoho Analytics' forecasting engine has now been enhanced, allowing you to define accuracy levels in your forecast reports. Click here to learn more.

Enhancements in Geo Map charts

The following enhancements are now offered in Geo map charts:

1. New themes have been introduced for map charts- Satellite theme and custom theme. Using the Satellite theme you can now plot a Geo map chart over a satellite view of the area, while the Custom theme allows you to design a customized theme to fit your requirements.

You can invert the colors in your map chart using the Invert Color toggle button. This is not applicable for Geo maps using a Satellite theme. A continuous color range legend can also be applied on map charts. Click here to learn more.

2. You can now create map charts in Zoho Analytics using Airport IATA codes.

3. Country-specific map charts can also be created, where you can display chosen countries and hide the rest. Click here to learn more.

Revamped data import screen

ZThe import from Files and Feeds option has now been split into separate tiles in Zoho Analytics, to simplify the import process.

Enhanced dashboard editor

Zoho Analytics has introduced new functionalities to the dashboard editor to facilitate easy customization. The following enhancements are available:

• Re-organize multiple components together in a dashboard.
• Re-size multiple components at the same time.
• Apply uniform dimensions to several components.
• Apply proportionate width to selected components.
• Fill empty spaces in the dashboard layout by re-sizing components.
• Export specific reports in the dashboard.
• Maximize embedded reports easily.

Improved Chart Color Palette section

The Chart Color Palette section has now been enhanced to facilitate easy access. Click here to learn more.

Enhancements in drill down options

You can now ignore the value in the Color tile and drill down on the entire data present in the chart. Click here to learn more.

Organize views from your side panel

You can now change the dashboard and report listing style (folder view, type view or related view) using Zoho Analytics' side panel.

Rename columns easily

Zoho Analytics now allows you to rename the columns in a table by simply double-clicking the column header.

Support to choose multiple lookup columns

You can now select multiple lookup columns to join two tables. This lets you combine related tables using more than one condition. Click here to learn more.

Generating AuthTokens

The AuthToken required for using the Zoho Analytics APIs is now just a click away.

In-memory columnar engine for faster analytics

In-memory columnar engine has been integrated into Zoho Analytics for high performance at scale. Now experience analytics at speed with faster rendering of reports and dashboards.

Note: The in-memory columnar engine is available only for the Linux platform of Zoho Analytics.

Actian Vector (community and commercial commercial versions available) columnar engine is now supported as a plug-able option for high performance at scale. Users can use this as an alternative to the inbuilt columnar engine.

Note: Actian vector columnar engine is supported in both Linux and Windows platform.

Get in touch with onprem-support@zohoanalytics.com for more details.

Revamped home page

The Zoho Analytics home page has been completely revamped for easy navigation.

1. Dashboards can now be accessed with a single click using the preview cards.

2. The main navigational elements are made bigger and bolder now, with the analytics elements organized into three categories (dashboards, reports & data) for easy accessibility.

3. Zoho Analytics now allows theme customization, enabling you to change the look and feel of the entire application with a single click.

Customized dashboard interactions

You can now enable or disable the following interactions in your dashboard:

• Drill Down in charts
• View Underlying Data in reports
• Sort Menu in grid views
• Show/Hide Columns in tabular views
• Contextual options menu on hover

Coloured KPI Widgets

Using the new widget color options you can select specific colors for each widget in your dashboard. Click here to learn more.

Share selective columns from tables

While sharing tables, you can now exclude columns with personal data to ensure data security and GDPR compliance. Click here to learn more.

Advanced summarizing functions for pivot tables

Zoho Analytics now supports the following advanced summarizing functions in a pivot table.

• % of Row in Group - Displays the data in each cell as a percentage of the total value, of each row within a group.
• % of Column in Group - Displays the data in each cell as a percentage of the total value, of each column within a group.
• Lookup Value - Displays the data in each cell by fetching value from any of Previous/Next/First/Last cell, based on the Base Field selected.

Click here to learn more.

Configure lookup relationships

Zoho Analytics now allows you to customize your reports by revising the default lookup relationship between tables used in creating a report. Click here to learn more.