What's New In Zoho Analytics
TIMELINE
2023
Dec
Dec 21, 2023
Zoho Analytics provides you with sophisticated reporting and analytical capabilities, over the data you collect using Typeform. Zoho Analytics provides comprehensive insights, allowing you to analyze survey responses, customer feedback, and form submissions in a centralized and powerful analytics environment.
Zoho Analytics has extended its support to import data from the following cloud databases,
We are thrilled to announce that you can now easily oversee and manage all email schedules for the workspace in one convenient location. Zoho Analytics offers simplified email schedule management by centralizing control within the Workspace Settings page.
Extend your analytics capabilities by using the Ask Zia skill in Alexa. Seamlessly integrate Zoho Analytics with Alexa, to get insights directly through voice commands.
Nov
Nov 24, 2023
Advanced Analytics for Jotform enables you to understand the preferences and opinions of the targeted audience, gauge satisfaction and engagement rates, and identify areas that may need improvement.
Workspace Level IP Restrictions
Add a layer of security by configuring workspace-level IP restrictions for enhanced security, and to prevent unauthorized access. Previously, IP restrictions were available only at the account level.
Zoho Directory
Zoho Analytics' integration with Zoho Directory allows administrators to handle identity and user access management with ease. Manage varying login credentials using one tool to strengthen online account security.
Denodo - Live Connect
Zoho Analytics now supports live connect for Denodo databases. Live connect helps with real time analysis.
Share to Cliq
We are excited to announce a significant enhancement to the Zoho Analytics - Zoho Cliq integration. The Share to Cliq option enables users to send reports to any user or Cliq groups within the organization seamlessly, in a variety of file formats.
New Modules in LinkedIn Ads
Zoho Analytics now supports the below new modules to effectively analyze the LinkedIn Ad campaigns.
- Industry Performance
- County Performance
- Job Function Performance
- Job Title Performance
- Company size Performance
- Job seniority Performance
- Country/Region Performance
- Location Performance
- Company Performance
New APIs
A comprehensive set of new APIs (2.3.0) are now available in various categories to enhance your experience with Zoho Analytics.
Meta data API
Data Modeling
- Create Query Table
- Edit Query Table
- Add Custom Formula
- Edit Custom Formula
- Delete Custom Formula
- Add Aggregate Formula
- Edit Aggregate Formula
- Delete Aggregate Formula
Sharing and Collaboration
Oct
Oct 20, 2023
We're thrilled to announce that Zoho Analytics now supports Tree Map visualization. Tree Map helps you to explore your data hierarchically with ease and uncover trends with precision.
Chart Styling Enhancements
Elevate your data visualization with these exciting enhancements that align with current global design trends. Enjoy a brand-new default color palette, captivating area chart gradient effects, stylized markers for scatter, line, area, and web charts, dotted gridlines, and a clutter-free view with the removal of the Y-axis line.
Change in default report for single metric
Previously, when you generate a chart for a single aggregate or numeric column dropped in X or Y axis, the chart was a pie or bar chart with aggregate range/count. Now, it is changed to a single bar chart.
IBM Informix - Live Connect
Zoho Analytics now supports live connect for IBM Informix database. Live connect enables real time data analysis as any changes in the source is immediately reflected.
Data Synonyms in Ask Zia
No more struggling to remember specific data field names or worrying about exact terminology – Ask Zia now understands your intent and fetches the data you want. With Data Synonyms, you can now use synonyms or alternate terms when asking questions, making it even easier to retrieve the insights you need from your data.
ChatGPT Integration
We are excited to announce that the ChatGPT integration is now accessible across all data centers. You can use the ChatGPT integration to find and access public datasets directly within Zoho Analytics without switching tabs, receive formula and SQL query assistance, and get column name synonym suggestions within Zoho Analytics.
New notification types in Zoho Analytics - Dashboards App
We are introducing three new notification types to enhance your Zoho Analytics - Dashboards app experience:
- Integration Actions: Get notified about the status of data integration in your workspaces.
- Manage User Actions: Stay informed about user management and access control actions.
- Account Actions: Stay updated on critical activities related to your Zoho Analytics account.
New APIs Released
We're delighted to inform you that we've introduced new APIs, aimed at enriching your experience with Zoho Analytics API 2.0.
Sep
Sept 15, 2023
We're happy to introduce the Advanced Analytics connector for Mixpanel. It enables you to import data from all your events in Mixpanel and create reports to visualize trends. It'll help you get deep insights into your user behavior across the digital products and services, and to take informed decisions to improve user experiences.
From now on, more fields will be synced in the following business app connectors.
Zoho Projects
- Tasks
- Recurring Frequency Time Span
- Recurring Frequency Type
- Recurrence Count
- Occurred Recurrence Count
Teamwork Desk
- Companies
- Id
- Name
- Details
- Industry
- Website
- Avatar Path
- Permission
- Kind
- Customers Count
- Created At
- Updated At
- Created By
- Updated By
- State
- Tickets
- Company Id
- Customers
- Company Id
Zoho Campaigns
- Survey ID (Zoho Survey)
- Survey ID (Survey Monkey)
Moving Views between Dashboard Tabs
You can now move views between the tabs in a dashboard. This allows you to rearrange views in a multi-tab dashboard easily.
Click here to learn more on Organizing Dashboard.
Set Margin between Cards
Dashboard custom Theme now allows you to set the card Margin between 0-10. This enhancement allows you to place cards at a desired distance. Previously, a minimum distance was maintained between views. Now you can place them without any space.
Click here to learn more on Dashboard Themes.
Pivot View Column Header Alignment
Pivot View column header can now be aligned as left, right or center. This allows you to enhance the pivot appearance.
Click here to learn more on Formatting Pivot View.
Support for Show or Hide in Data as Row
Show or Hide option is now available in Pivot Views with data set as rows. Previously, it was available only when data is set as columns.
Click here to learn more on Show/Hide columns.
From now on, you can import data from MongoDB with SSL certificate. This allows secure importing of data from MongoDB into Zoho Analytics.
Click here to learn more on Importing from MongoDB.
A component to enter duration data is now added. Click the duration icon that appears on mouse-over (of a column cell with Duration data type). Now, you can increase or decrease the duration value by clicking the up and down arrow.
Aug
August 16, 2023
Advanced Analytics for Klaviyo enables marketers to assess the campaign's performance, helps refine strategies to improve audience engagement, and personalize email campaigns based on demographics to achieve a higher ROI. This connector comes with unique set of hand-picked reports and dashboards to help you get started with your analysis.
With the latest enhancement to the dashboard feature, you can create widgets with the forecast value when the data is grouped by the Date function. You can choose to forecast for the current period or for the upcoming period using the Latest and Next options.
You now have the option to generate a geo map focusing on a specific state of a country when your data includes information related to a particular state.
Zia Insights now provides dynamic information based on the selected legend filter available on the report.
The Show Missing Values option is now enabled for heat maps. Enabling this option assigns a color to the missing value and creates a complete visualization without any white or blank spaces in the report.
We have enhanced our prompt engineering techniques to get more relevant responses.
Zoho Analytics - Dashboards app now supports commenting. You can now collaborate with your team and make decisions on the go. It comes with a variety of interactive options, such as tagging other users to grab attention, liking the messages, attaching files and much more.
Jul
July 10, 2023
We are happy to announce the Advanced Analytics connector for LiveAgent. It enables you to probe and identify bottlenecks within the support process, take measures to solve recurring problems, and optimize resource allocation within the help desk team.
This connector comes with more than 30+ IT & help desk domain specific reports and dashboards to help you jumpstart your analysis. Click here to learn more.
Zoho Analytics now offers Custom Role Management, allowing you to create personalized roles tailored to meet your specific requirements. The pre-defined roles which were available before, might not have fulfilled all your needs. With this new feature, you can design custom roles that align precisely with how you want your organization's data, reports, and dashboards in Zoho Analytics to be shared amongst your diverse set of employees (and sometimes even partners and clients).
You can now embed reports from the Tableau BI application to create unified portals for your organization's business needs. Having a unified portal improves collaboration, promotes centralized accessibility, and makes it easy for C-level executives to make robust business decisions.
Now, Zoho Analytics allows you to apply What-If Analysis specifically to forecasted data alone, rather than applying it to the entire report as before. This update provides more focused and targeted capabilities for conducting What-If Analysis in Zoho Analytics.
As you know, you can have natural language conversations with our AI Assistant Zia and get reports instantly. You can now drag and drop these Ask Zia generated reports into dashboards with ease.
Creating query table is now made easier with SQL Query Grammar Based Suggestion. Zoho Analytics provides suggestions for keywords, table & column names as you type your query.
Jun
Jun 15, 2023
We are happy to announce the release of Advanced Analytics connector for ShipStation. The connector comes with 50+ hand-picked reports and dashboards that provide deep insight into your order and shipping management data.
It enables you to easily track product order patterns, observe customer behavior, and monitor shipment activities & costs. It helps you enhance your operational efficiency and to make informed decisions, backed by data.
Zoho Analytics now allows you to add aggregate Data either as Rows or as Columns. This opens the possibility to layout the pivot in two different formats, and to get a clear presentation of your data.
We have enhanced the ways to handle deleted views from Dashboard. In case a view present as part of a dashboard is deleted, you can now choose to restore or remove it from the dashboard.
Data import option has been extended with the following sources.
- Cosmos DB - You can import data from Cosmos DB.
- Intranet URL - You can import data from CSV, TSV, JSON, and XML files available in your organization intranet.
You can now generate Permalink for the Data Source page of Advanced Analytics connectors. This allows you to check the last data sync status of business app connectors.
User Interface of the White Label portal Home page is revamped now. This enhances the appearance of the portal.
May
May 23, 2023
- To email - This helps you convert text columns in email format to email data type.
- Round Duration - This helps round off the duration values to given duration scale - seconds, minutes, hours, days.
Apr
April 28, 2023
We are excited to announce the release of two new business applications connectors.
Zoho Analytics empowers your Google Analytics 4 (GA4) data with sophisticated reporting and analytical capabilities. With the help of this integration, you can slice and dice your GA4 data anyway you like, examine important KPIs, and make wise decisions to improve your SEO/SEM campaigns.
This connector comes with a unique set of 65+ hand-picked reports and dashboards that enable you to jumpstart your analytics easily.
Advanced analytics connector for YouTube Ads analyzes the effectiveness of your YouTube adverts and the value you derive from them. It provides important information about campaign outcomes and conversion rates. With it, you can construct campaigns that will be better and more effective.
This connector comes with a unique set of hand-picked reports and dashboards that enables you to jumpstart your analytics easily.
Zoho Analytics now supports the data import from Panoply - Google Big Query into Zoho Analytics.
Now you can use Albers USA Projection in Geo Maps to visualize US-centric data sets more effectively.
Zoho Analytics allows you to use Week & Year Format in its reports and we have new additions to this format - Start Date and End Date. Earlier we had three formats - Short, Medium, and Long.
Zoho Analytics now offers Wildcard Filter support in Tabular View. You can now filter by specifying filter criteria to match strings.
Zoho Analytics now allows you to import your data from IBM Cloud DB 2 using the Stored Procedure.
Zoho Analytics has extended its support to import data from Workgroups in Amazon Athena.
The Share permission in Dashboards is enhanced by listing the Drill Paths for all the reports used in the dashboard.
This one is one of the most asked for features. Zoho Analytics now supports syncing of the "Notes" modules (from multiple CRM modules like Leads, Contacts, Deals etc) in Advanced Analytics Connector for Zoho CRM.
Apr 03, 2023
We are excited to announce the release of two new business applications connectors.
Advanced Analytics for Odoo enables you to gain a complete view about your business operations. It helps you to keep tabs on the financial statements, understand customer preferences using demand forecasting, identify risks, and devise robust business strategies to boost revenue, thereby resulting in improved supply chain management.
This connector comes with more than 60+ essential reports and dashboards to help you with your analysis. You can also create your own custom reports and dashboards.
Click here to learn more.
Advanced analytics connector for Instagram Ads analyses the effectiveness of your Instagram adverts and the value you derive from them. It provides important information about campaign outcomes and conversion rates. With it, you can construct a promising campaign with greater knowledge, which will ultimately help your business develop.
The connector comes with a unique set of hand-picked reports and dashboards that enables you to jumpstart your analytics easily.
Zoho Analytics has extended its support to import data from Microsoft SharePoint.
Zoho Analytics now supports Live Connect for the following databases:
Local Databases
Cloud Databases
Zoho Analytics enables you to migrate the blueprint of your workspaces between different Zoho Analytics accounts.
Click here to learn more.
- A new option Fit to screen is added to Pivot view and Summary view. This option adjusts the column width to fit the table across the entire screen. Click here to learn more.
- A new option is added to customize the Sub-total Label. You can add a prefix or suffix to the Sub-total Label or you can modify the label as needed. Click here to learn more.
User filter for numeric columns now provides List All Values option. In this enhancement, any new value added will be automatically added to the filter value. Click here to learn more.
User filter for actual date period now allows you to set a default filter value that should be applied to the reports. Previously, this option was available for seasonal and relative periods. Click here to learn more.
You can now choose the scale type that should be applied to the chart based on the range of values in the data. The following are the scale types supported in Zoho Analytics.
- Linear
- Log
- Square root
You can now define a formula column to be a lookup column. Click here to learn more.
Feb
Feb 21, 2023
To visualize reports with large data sets, Zoho Analytics has enhanced charts with new interactive options: the overview and scroll bar effects. These enable you to plot large data on a chart to get a clear picture of the peaks and troughs in your data.
The overview effect adds an overall preview chart (also known as an overview chart) to the bottom of a chart. It allows you to select a region to focus on a particular data range on the chart, for more in-depth analysis.
Dynamic and more interactive scroll charts can now be used to replace filters, which are traditionally used in reports with large data sets. This enables you to easily compare data by moving the slider or scroll bar.
Click here to learn more about the overview and scroll bar effects.
We now support displaying images as part of your KPI widgets on your dashboard.
Adding images for your KPIs helps viewers grasp information more quickly. They also enhance the appearance of your dashboards.
Click here to learn more about KPI with Image.
Now you can define a preset/predefined filters for your dashboard by combining multiple user filters. This eliminates the mundane task of clicking and selecting values from multiple user filters every time—and you can setup multiple preset filters, too!
Click here to learn more about Preset Filters.
User filters for all reports now allow you to include or exclude selected items from the user filter values. So far you could only include items but not exclude.
Click here to learn more about User Filters.
Now you can synchronize more field for the following Advanced Analytics Connector:
- Reels
- Profile ID
- Reel ID
- Comments
- Likes
- Plays
- Reach
- Saved
- Shares
- Total Interactions
- Projects
- Is Completed
- Primary Client ID
- Last Modified By
- Created by
- Tasks
- Associated Teams
- Bugs
- Associated Teams
- Project Groups
- Is Private
- Associated Teams
- Users
- Created Time
- Last Updated Time
- Last Accessed Time
- Video Performance
- Day
- Ad ID
- Video title
- Ad group ID
- Device
- Impressions
- Clicks
- Conversions
- Cost
- Ad type
- Network
- Engagements
- Views
- Total conv. value
- View-through conv.
- Video played to 100%
- Video played to 25%
- Video played to 50%
- Video played to 75%
- View rate
- Video duration
- Video Id
- All conv.
- All conv. value
- Conv. rate
- Engagement rate
- Campaign Conversion Analysis
- Day
- Campaign ID
- Conversion category
- Conversion name
- Conversion source
- Conversions
- Network
- Device
- Total conv. value
- View-through conv.
Zoho Analytics has expanded the data import sources by including connectivity to Digital Ocean platform.
- Analyze data stored in DigitalOcean MongoDB
- Analyze data stored in DigitalOcean PostgreSQL
- Analyze data stored in DigitalOcean MySQL
To provide a secure data import option from your local databases, Zoho Analytics now allows you to import data using SSL certificates for local databases. SSL (Secure Sockets Layer) is a digital certificate that secures the transport of information between web servers and clients by establishing an encrypted connection.
Click here to learn more about importing with SSL.
Zoho DataPrep has been enhanced with the following features:
Duplicate Workspaces
Now, while copying workspaces, DataPrep rule sets that was applied over the source workspace will also be copied.
Click here to learn more about duplicate workspaces.
Import Settings Update
Now you can use data settings like delimiter separator, and skip top rows, while using DataPrep to cleanse data. Previously these options would be disabled.
Click here to learn more about CSV import settings.
Analytics portals now support adding pages with three-level hierarchy menus.
Click here to learn more about portal three-level menus.
Shared users and viewers can now access only views that are explicitly shared with them. To make the process easy, Zoho Analytics now prompts admins to associate views when they add users. You can associate views to the user in read-only mode as well as associate groups to grant access to all views shared to the group with the same permission.
Click here to learn more about associating views.
To enable you to manage email schedules more easily, Zoho Analytics now allows you to add 100 users in a single email schedule setup.
However, the email schedule count for pricing will be calculated based on the number of users added in these schedules. Each 25 users in a schedule will be considered 1 schedule. You can view the schedules consumed by each email schedule from the Edit Email Schedule page.
Click here to learn more about emails consumed.
Now you can easily share or publish views from the Zoho Analytics - Dashboards App.
Click here to learn more about sharing and publishing options from Zoho Analytics - Dashboards App.
2022
Dec
Dec 23, 2022
We're happy to release the Advanced Analytics connector for Freshdesk. This helps you monitor and improve your help desk productivity. It enables you to gain a complete view about the ticket trends and keep track of key metrics like ticket volume and distribution, response time, resolution time and customer satisfaction rate.
This connector comes with more than 60+ IT & help desk domain specific reports and dashboards to help you get started with your analysis.
You can now invoke Ask Zia from the Workspace Search field. This allows you to access Ask Zia easily.
Geo Visualization now supports the following data types.
- Imports Latitude & Longitude - Imports Latitude & Longitude data in DMS (Degrees, Minutes, and Seconds) format.
- Identifies Alpha Codes as Geo Data - Identifies the Alpha 2 and Alpha 3 Codes for Country (US and USA as United States of America) and State (NY as New York) as Geo data.
Click here to learn more about Geo Visualization.
Tabular View has been enhanced with the following features.
Format Tabular View as Table
We've enhanced the Tabular View appearance by formatting it as a table. From now, Tabular View will display only rows and columns with data and remove the empty grid cells outside the report.
Support for Relative Period in User Filter
Date based User Filter in Tabular View now supports filtering by Relative period.
Click here to learn more on Tabular View.
We've revamped the user interface of all the Organization Settings page like Organization Details, Manage Users, Feature Control, etc. We've also categorized the settings to improve the user experience.
Nov
Nov 22, 2022
To enable easy collaboration among the members of the organization, we have now integrated Zoho Cliq messaging service in Zoho Analytics.
You can also create a Cliq group for each of your Workspace Groups.
Zia Insights can now predict the future outcomes based on data. Predictive narration is included in medium and high verbosity narratives.
From now on, Account Administrator, and all Organization Administrators can also edit the connector set up. Previously, only the Administrator who created the setup could modify it.
New modules have been added to the following Advanced Analytics connectors.
- Zoho Recruit - Application module
- Zoho Finance - Custom module
- QuickBooks Online - Recurring Bills, Recurring Invoices, Recurring Transfer, Recurring Expenses, Recurring Deposits, Recurring Credit Memos, Recurring Estimates, Recurring Journal Entries, Recurring Refund Receipts, Recurring Sales Receipts, Recurring Vendor Credits, and Recurring Purchase Orders
We now support analyzing data based on the Baseline in Zoho Projects. To avail this, you need to synchronize the following modules in Zoho Projects Advanced Analytics connector.
- Baseline
- Tasks on Baseline and
- Milestones on Baseline
To enhance the user experience, we now allow you to customize the white labeled Mobile App from your Zoho Analytics account (interface) itself. You can submit all the customizing options and download the customized app right from the Zoho Analytics Settings page.
Oct
Oct 14, 2022
Zoho Analytics now supports time Duration as a data type. This opens up a whole new category of time-based data analytics. Now you can get to know how long it took to accomplish something, to complete your projects, closing the tickets, winning a deal. etc., and take appropriate action.
New Duration Functions
To enable advanced analytical options based on duration, Zoho Analytics provides 20+ new functions.
We have expanded the supported data sources for Zoho Analytics. You can now import your data from the following sources too.
Advanced Analytics for HubSpot Marketing provides a completed analysis over your marketing data. As a marketer you analyze how good your Email Campaigns and Blogs are doing. You can also analyze your web traffic and get insight on how you can improve further.
The Advanced Analytics for HubSpot Marketing includes 100+ prebuilt reports and dashboards over your HubSpot Marketing data that help you to jump-start your analytics right away.
Now we support synchronizing the following fields in the Ad Account Insights, AdSet Insights, Ad Insights and Campaign Insights modules.
- Cost per Purchase
- Cost Per Initiate Checkout
- Purchase ROAS
- Offsite Purchase Conversion Value
- Onsite Purchase Conversion Value
- Omni Purchase Conversion Value
Audit all activities performed in a connector configured Workspace for the last 180 days. You can get the Audit History of all actions by all users such as create, edit, add admin, sync data, and connector re-authentication (This includes automated changes like disconnecting or reconnecting of connectors by Zoho Analytics, based on your pricing plan change).
Sep
Sept 14, 2022
Enhancements for Advanced Analytics Connector
Advanced Analytics for Zoho Finance suites now supports Zoho Commerce too. This helps you to manage your online store effectively and market it with ease. You can also deeply analyze various dimensions of your business like managing stores, processing orders, inventory tracking, managing shipments etc.,
The Advanced Analytics for Zoho Commerce includes prebuilt reports and dashboards over your Zoho Commerce activity data that help you to jump-start your analytics right away.
Advanced Analytics for Zoho Finance suites now supports importing data from multiple organizations. Now Premium Users can sync up to 25 orgs, and Enterprise Users can sync up to 100 orgs. Zoho One Subscribers can sync up to 25 orgs.
Advanced Analytics for Zoho Projects now supports synchronizing Task Issue Mapping module data. This allows you to map the Tasks and the associated Bugs to create reports over the same.
Advanced Analytics for Zoho Recruit now supports synchronizing Referral Module data.
Zoho Analytics now supports Time Slicer as Timeline filter. This provides dynamic filtering ability with a different section for each date element such as Year, Quarter, Month, Week, Date and Hour. This enables you to easily select the period for filtering the dashboard. The Time Slicer supports an infinite date range for filtering the dashboard.
A new option to set compact width is added for Pivot View and Summary View. This option tightly packs the columns in the report, thereby helping to save horizontal space and improve readability without the need to scroll sideways.
Aug
Aug 30, 2022
You can now choose to audit the API calls log. This allows you to monitor information such as the API calls that were frequently made, who did it and when it was done, API units consumed by action etc.
You will also get an insightful API Log Analytics Dashboard capturing the essentials of the API call logs such as Units Consumed By Day, Request Count By API Groups, and Top 10 APIs By Units Consumed or By Request Count, etc.
The following changes have been done in Query Table.
User Interface Revamped
Query Table's user interface has been revamped to improve the user experience. Now, the query editor will still be in focus when you insert the functions and columns by clicking from the list.
New Functions
Support for the following new functions are added.
- To Percentage - Converts the data type of the column as percentage.
- To Currency - Converts the data type of the column as currency
- To Decision Box - Converts the data type of the column as decision box
- To Positive Number - Converts the data type of the column as positive number
From now on, you can predict the trend for charts which have a Color column.
The Workspace Explorer has been enhanced with the following options.
- Folder hierarchy is supported for Grid view in both the Explorer and the Reports navigation tab
- Search results include folders too
- Option to select an entire folder is added
A More information dialog has been added to all the Views in Zoho Analytics. Now from a single dialog, you can edit various options of the view, such as title, description, data source, publish and share details, and see dependency details, permalink, etc.
Now you can add Watermarks to reports and dashboards, while exporting as PDF.
Zoho Analytics provides a new option to specify whether the Thousand separators are either as per the International numbering system, or the Indian numbering system.
Jul
July 26, 2022
Advanced Analytics for Teamwork CRM empowers you by providing deep sales analytics over your CRM data. This integration helps you to keep track of your key sales performance metrics and optimize your sales team's execution.
Advanced Analytics for Teamwork CRM includes 50+ prebuilt reports and dashboards over your Teamwork CRM data. The Teamwork CRM Analytics workspace is Ask Zia trained and can answer your questions with appropriate reports within minutes.
Advanced Analytics for Smartsheet enables the users of Smartsheet to efficiently monitor and manage the execution of their projects. It also helps them devise powerful strategies to manage risks, and track their key project metrics to scale up the operational efficiencies of their organization.
Advanced Analytics for Zoho Projects now supports synchronizing the Tags Module data. This enables you to create reports over the Tags in Tasks, Bugs, Milestone, Projects and Timesheet modules.
Previously we can only choose the modules to import data. Now you can select both modules and fields in Zoho Projects which you like to import.
You will now be able to use the unused Users in your account as Viewers. Previously, you need to purchase Viewers as a separate Add-on license. Now to make it user-friendly, we allow you to use the excess Users license as Viewers.
Zia Insights now offers actionable insights in Spanish too.
The Ignore Filters Aggregate Function allows you to specify which filters need to be ignored. Previously, only the User Filters applied over the report were ignored. Now, you can choose to ignore Filters, Users Filters, or both.
Zoho Analytics now allows you to hide empty columns in Pivot and Summary Views. This enhances the look of your reports as only relevant data gets displayed.
In case the forecast based on your report is in negative value, then you can choose to display it as 0.
Jun
June 29, 2022
Now we provide specific features in Zoho Analytics to help you use Zoho Analytics in a HIPAA compliant manner.
Advanced Analytics for Google Ads now supports the following modules and fields.
- Video Performance
- Mandatory fields:
- Day
- Ad ID
- Video title
- Ad group ID
- Device
- Impressions
- Clicks
- Conversions
- Cost
- Ad type
- Optional fields:
- Network
- Engagements
- Views
- Total conv. value
- View-through conv.
- Video played to 100%
- Video played to 25%
- Video played to 50%
- Video played to 75%
- View rate
- Video duration
- Video Id
- All conv.
- All conv. value
- Conv. rate
- Engagement rate
- Mandatory fields:
- Campaign Conversion Analysis
- Mandatory fields
- Day
- Campaign ID
- Conversion category
- Conversion name
- Conversion source
- Conversions
- Optional fields
- Network
- Device
- Total conv. value
- View-through conv.
- Mandatory fields
Zoho Analytics white label solution now supports JWT Algorithm as one of the options for single sign-on method.
You can now embed Ask Zia as a private link in your application. This allows you to use Zia in your own environment securely.
Send Alert mails to your users from an Organization email address.
Support for SSH Tunneling
SSH tunneling is now supported for importing data from both local and cloud databases. This allows you to transfer data from your database into Zoho Analytics more securely.
Data prep for Paginated Import
Data preparation option through Zoho DataPrep is now supported when you import data from feeds with pagination. This allows you to prep (cleanse, enrich and transform) your paginated data feed while importing.
The Zoho Analytics - Dashboard app is now enhanced with the following options.
New Chart Types
The Zoho Analytics - Dashboards app now supports two new chart types - Word Cloud and Bubble Pie.
Zia Insights
Zia Insights is now available for the reports in your dashboards. Zia gives you actionable insights in the form of digestible narrations. This enables you to get the insights immediately instead of you and your users manually interpreting reports.
Sample Gallery
We now provide a sample gallery with dashboards of various business app connectors' data. You can explore and find more about the prebuilt reports that come with each business app connector.
May
May 12, 2022
Enhancements for Business Application Connectors
Business Application Connectors in Zoho Analytics are enhanced with the following options.
We are happy to announce that Advanced Analytics for Zoho Forms is now available. Advanced Analytics for Zoho Forms enables you to proactively research, engage and derive analytical insights over the data you collect using Zoho Forms.
You will be able to import the forms data into Zoho Analytics as a table. Each Forms and Sub-forms will be imported as a table in Zoho Analytics with all sub-forms tables joined using lookup columns.
Click here to learn more on this.
Subscribe to Enterprise plan to sync your data every 1 hour. From now on, users in Enterprise plan will be able to sync data using their business application connectors every 1 hour.
Click here to learn more on synchronization interval.
Now, Zoho Analytics provides an option to view the data synced history for your Business Application Connectors.
Data sync history of the last 45 days will be available in a calendar. The sync success and failure will proportionately highlight the specific data in green and red color respectively. Hover to view the number of times the data had got synced on a specific date.
Click here to learn more on Sync History.
We have refined the procedure to notify in case of Sync failures for user convenience. From now on, when a data sync fails, you will be notified through in-app notification.
In case the sync fails continuously for more than 24 hrs, an email will be sent to you with the reason and appropriate solution for them once in every 24hrs.
Click here to learn more on this.
You can now import data into Zoho Analytics from cloud MongoDB databases. The cloud MongoDB instances can either be MongoDB Atlas (MongoDB's very own cloud service) or hosted on any other cloud services.
From now on, you can access the Organization using a direct URL. Previously, in case of having multiple organization, you need to select the organization to view workspaces on a specific organization. Now you and your users can access the Organization easily using the direct link.
Ask Zia now auto suggests followup questions based on your current question. This is supported in both normal and conversation mode. This allows you to easily construct questions to instantly get reports over your data.
Click here to learn more on this.
Reports designer now supports Undo and Redo actions as a user experience enhancement. This allows you to easily revert the changes while designing a report.
The workspace Settings page now provides shared details.
Apr
April 13, 2022
White Label users can now do the domain mapping and domain verification from Zoho Analytics' user interface itself. This allows them to configure the White Label Solution in a secured and user-friendly manner.
Zoho Analytics now allows you to email views from organization email addresses (in addition to the default notifications@zohoanalytics.com). With this, you will be able to add multiple email addresses as Organization email address, and email reports and dashboards using these addresses.
Dependency Details option for the views has been enhanced with the following items.
- Views now include the Dashboards where the view is embedded.
- Table includes immediate child table.
- Query Table now includes multiple level parent tables and child tables.
- Dependency details can be invoked from Explorer and Model Diagram.
Zoho Analytics now supports importing Keyhole Markup Language (KML) files as spatial data file for creating Geo visualization.
DataPrep functionalities are now available while importing from another Zoho Analytics workspace.
In Data Snapshot, the history of when the snapshots were taken will be maintained only for 45 days now. Previously, it was available for 90 days.
You can now delete rows and columns from tables using the keyboard delete option.
Mar
Mar 12, 2022
New Business Application Connectors
We are happy to announce the following new Business Application Connectors.
The new Advanced Analytics connector enables you to deeply analyze data from Google Search Console. You can track & analyze key metrics relevant to website traffic, its performance, search engine trends and more in real-time or historically allowing you to stay on top of your SEO efforts.
The new connector also includes 50+ prebuilt reports and dashboards to enable you jump start your analytics.
Advanced Analytics for Semrush enables you to analyze your search-driven marketing data in depth. It allows you to measure your online marketing performance by tracking keyword performance metrics over any preferred time line. It empowers marketers with deeper insights into keyword-driven content marketing, competitor analysis interms of domain authority,backlinks and many more.
Advanced Analytics for Semrush includes 50+ prebuilt reports and dashboards over your Semrush data.
Both the above connector workspaces are Ask Zia trained and can answer your questions with appropriate reports within minutes.
Enhancements in Existing Business App connectors
Existing Advanced Analytics connectors have been enhanced with the following.
The limitation for importing default fields from a module in Zoho CRM is extended from 100 to 200.
The following modules are added to the existing connectors.
Advanced Analytics for QuickBooks
- Customer Type Module
Advanced Analytics for Zoho Finance
- Invoiced Estimate
- Purchase Order Salesorder Mapping
- System Mails
- Sms Notification
- User Details
- Budget
- Budget Details
- Landed Costs
- Landed Cost Allocation
- Shipping Bill
- Shipping Bill Item
- Bill of Entry
- Bill of Entry Item
- Sales Receipt
- Sales Receipt Item
- Delivery Challan Invoice
Zoho Analytics now supports importing data from the following databases:
Cloud Databases
Local Databases
You can now also import from MongoDB using Zoho Databridge. This allows you to easily import data from the UI in a few clicks.
You can now avail a 15 day trial for Analytics Portal. The Portal allows you to organize reports & dashboards you have created into pages and publish them as a microsite for easy access to your users.
Avail the trial to experience the benefits of Analytics Portal.
You can now export the blueprint of views in one workspace to another workspace. This reduces the effort and time involved in re-creating similar reports across different departments or business units. You can easily export the views and import new data into the same model.
You can now copy the relevant data sources connectivity settings along with copying a workspace. This reduces the effort to re-configure the data source again in the new workspace. You can easily import data from the same source after just authenticating it.
You can now create both Aggregate Formulas and Custom formulas in workspaces where you have setup Live Connect to cloud databases.
Custom sort dialog in charts now supports a search field when the legend has more items to sort. This helps to find items for easy sorting.
Apply User Filters in Tabular view
You can now choose to apply the default user filters while exporting the Tabular views
Export Row Numbers
Now you can add a row number column to your tabular reports while exporting data. This option will auto generate sequential numbers for all the exported rows.
User Interface has been enhanced with the following options to provide further improve user experience.
- By default, while saving a new view (report/dashboard/table), the newly created folder, or the last accessed folder will be selected as the folder to save the view.
- Now you can open the View Underlying Data pop-up in a new tab by using the corresponding icon on the top right of the dialog.
- From now on, when the browser is refreshed all the open views (tabs) in the workspace will be automatically restored. Previously, only the last opened view will be restored.
2021
Dec
Dec 21, 2021
Multi Language Support for Zia
Enhancement
Ask Zia now supports English and Spanish languages. By default, the language specified in your Zoho Account will be selected as the language for Zia. You can choose to change this when needed.
You can now set custom permissions in an Analytics Portal. This feature allows you to define fine-grained view permissions for each user or group.
Advanced Slideshow now offers a set of cool preset themes to enhance the visual appeal and set a tone for your presentations.
Live Connect for databases is now enhanced with the following options.
Live Connect support for more Cloud Databases
We have enabled Live Connect (Beta) option for the following cloud databases:
Live Connect Support for more Local Databases
We have enabled Live Connect option for the following local databases:
Caching Reports/Dashboards to load fast
You can now load reports and dashboards based on Live Connect tables from cache for a set duration. This reduces the time to load your reports and dashboards, by fetching data from the live database. The local cache will be refreshed after the set duration to keep the reports fresh.
Sync Meta Data for Individual Table
You can now synchronize the meta data changes for each table separately, instead of synchronizing all tables in the workspace. Use the Sync link in the Data Source setting of Live Connect workspace to do this.
All compatible data type changes will be automatically synchronized. In case the data types cannot be synced, it will show a column mismatch. You can resolve the mismatch as mentioned here.
Join Tables in Zoho Analytics
Zoho Analytics now allows you to define lookup relationships among the connected tables easily using the Lookup Column feature. Previously, Live Connect tables were joined only based on the relational data model defined in your database. This will help you perform cross-functional analytics across live connect tables from the same cloud database in Zoho Analytics.
Handy Delete Option
You can now delete views from a Live Connect workspace. You can also restore a deleted view from Trash, within 45 days of deletion.
You can now change the user role for multiple users together. With this feature, you can easily define the same role for multiple users in one go, without repeating the tedious process.
You can now remove the data source for an individual table too. Data Synchronization will be removed for the specified table alone. You can choose to synchronize data from other sources, or manually import data into this table as needed. For the rest of the tables, the same data source will continue to be in sync.
Oct
Oct 18, 2021
From now on, when you are importing data from another Zoho Analytics Workspace, the data types of the columns will be copied as is from the source table.
For example, when you import currency data, it could be be identified as Number or Positive Number based on the first few records. Now, in the following case the numeric columns will be identified as Currency based on the source table. `
Data Alert criteria can now be specified with both AND and OR conditions. This enables you to define more powerful criteria to track the key trend changes.
Tabular functions, also known as Window functions, are now supported in Query Tables. Tabular functions compute the result based on a set of rows than just a single row. These functions really enable you to do more poweful computations on your data set. Example of Tabular functions are RANK, ROW NUMBER, LEAD, etc.,
Custom Sort user interface has been revamped to enable users to easily arrange the values in the desired order using drag & drop or using arrow keys.
Advanced Analytics for Zoho Books now supports the following modules.
- Delivery challan invoice
- Sales receipt
- Sales receipt items
- Bill of entry
- Bill of entry items
- Shipping bill
- Shipping bill items
- Landed cost
- Landed cost allocation
- Budget
- Budget details
- User details
- SMS notification
- System mails
- Invoiced_estimate
Jul
Jul 13, 2021
Zoho Analytics 5.0 What's New
We are extremely delighted to unveil the incredibly advanced self-service AI-powered BI - Zoho Analytics 5.0 to the public. Crafted and molded with 60+ new features to empower every business at every stage of BI workflow.
Experience analytics like never before with the following new capabilities and enhancements:
You can integrate, model, clean, and enrich data from inside Zoho Analytics using our all-new and very own AI-powered advanced self-service data preparation service, Zoho DataPrep. This integration vastly improves the ETL (extract-transform-load) capabilities of Zoho Analytics. Read more.
Explore Data with Augmented Analytics
As you know, Zoho Analytics is augmented deep with AI/ML features. We are adding a lot more features to enhance your experience.
Our smart assistant Zia takes augmented analytics (analytics assisted by AI) a notch higher. Now, Zia provides automatic insights, in easy-to-understand narratives, to facilitate your decision-making. Read more.
Zoho Analytics now provides a chat box, where you can have a more immersive and meaningful conversation with Ask Zia. Read more.
Do you know Ask Zia can now speak to you in Spanish too? Start conversing with Zia in Spanish.
Note: Spanish support in Ask Zia is still in Beta testing.
What-if analysis is a new powerful analytical feature that allows you to simulate complex scenarios, and find optimal business outcomes. Using this feature, you can study how data points change as you change the influencing factors. Read more.
You can now choose the forecast model that best suits your requirements, from the available four models - Exponential Smoothing, Seasonal Trend Loess Decomposition, Regression, and ARIMA.
Also, you can now forecast values for the columns dropped in the Colors shelf. Read more.
Zoho Analytics supports sentiment analysis, a branch of Cognitive Analytics. This feature automatically gauges your data sentiment and creates a sentiment column in your data tables.
Currently, this feature is available only in Twitter Pages and Twitter Competitors' business app connectors. Read more.
We have brought in more features to functions. In windowing functions, we now support Map Groupby, Ignore filters, running total, and rank in aggregate formulas. In granularity functions, we now support include, exclude and filter functions. Read more.
Reimagine Data Storytelling
Data Storytelling is about delivering consumable insights through familiar, everyday business workflows, thereby increasing the adoption of insights. With Zoho Analytics Data Storytelling capabilities, you can craft beautiful presentations, or set up purpose-built high-quality analytical portals for sharing insights.
Craft immersive presentations, blending visualizations created in Zoho Analytics, using Zoho Show our online presentation service. Read more.
Setup purpose-built analytics portal/microsite embedding reports and dashboards along with other web elements. Read more.
Embed Ask Zia at any point in your business workflow and empower decision-making at all endpoints.
Visualizations in Zoho Analytics gets a lot more cooler
The data visualizations list in Zoho Analytics is getting bigger with a set of cool new visualizations coming in.
Want to analyze the frequency of words appearing in a data set? You can use the newly added Word Cloud Chart. It can also be used in tandem with another metric. Read more.
Provide more context & a spin of creativity to your geo-data visualizations using custom image backgrounds. Overlay your geo-data over an image to create geo maps with image backgrounds in Zoho Analytics. Read more.
Introducing 3 new dial chart widgets - Simple dial chart, Speedometer dial chart, and Conditional dial chart, enhancing visualization options in KPI widgets. Read more.
Have extra-long dashboards that require lots of scrolling? Or multiple dashboards with data that needs to be analyzed together? The Tabbed Dashboards option is here to help. Read more.
With a new designer and filter support on Tabular Views, there are more ways than ever to analyze your data from multiple dimensions. Though lightweight, the enhanced Tabular View is a powerful reporting option. Read more.
Previously, you had to choose to either have all axes separate, or all axes merged. Now, you can group axes that you want to merge. Read more.
You can now have images, rendered from Image URL data types, displayed as charts axis values. Read more.
Contextual column-specific settings option is now available for the columns dropped in the Chart Shelf of the Chart Design Area. You can access the options by hovering over the columns dropped in the Chart Shelf of the Design Area.
Until now, you could conditional format the data in pivot view Data series only. Now, Zoho Analytics lets you color-code your pivot views based on conditions for the Row series as well. Read more.
Data Modeling Made Simple
The Edit Design UX has now been revamped with a cool new layout and useful options to enhance user accessibility. The new layout is segmented into three sections - Columns, Lookups, and Formulas. Read more.
The Data Model Diagram UX now comes with a set of handy options. You can now easily rename a table; format, rename, delete, and change data types of your columns from the Data Model Diagram UX.
You can now create lookup relationships based on multiple cardinality options - One to One, One to Many, Many to One, and Many to Many relationships.
Centrally format your data at a workspace level from the workspace Format Settings. This way you can maintain a consistent data format for all the tables available in the workspace. Read more.
Have you found it difficult to duplicate reports across Workspaces? You'll find the new export and import templates feature handy. You can now export a single report—or a bunch of reports—as a template file and import this template back into another Workspace. Read more.
Zoho Analytics prides itself on providing ready-made, advanced analytics connectors to over 50+ popular business apps. The following new business apps are getting added to the list of advanced analytics connectors:
As always all the new connectors come with 100+ pre-packaged domain-specific reports & dashboards each, to jump-start your analytics.
Access Control
Not all Zoho Analytics users create reports and dashboards. Most of us just consume, or view reports. So we have come up with a Viewer role. When a user is added as a Viewer, they can access the reports and dashboards in read-only mode and also interact with them. They cannot create reports of their own. Read more.
Note: The Viewer Role users can be purchased as a separately priced add-on.
As an Account Administrator, you can control the visibility of the Request Access option, which is displayed to users when they access an unauthorized report/dashboard. You can also control who can approve such requests placed. Read more.
User Experience Niceties
As a part of our continuous endeavor in enhancing the user experience, we now support the following cool options in Zoho Analytics
Zoho Analytics UX now supports a trendy night mode theme. You can now toggle the Zoho Analytics interface between Day and Night UX modes.
You can now customize the theme of your overall product based on artistic/gradient palette.
We have added a new mode called the Viewer Mode. When this mode is on, the user is presented with a clean and light interface optimized just for viewing & interacting with your reports & dashboards. Read more.
Analytics Marketplace & Apps
You can now install our analytics app from the following Marketplaces and jump-start your analytics journey right away.
Complement your analytics journey with the apps catalog from Zoho Marketplace. A partner-driven ecosystem that powers an assortment of apps.
Ecommerce analytics app delivered natively on Shopify marketplace for end-to-end store insights.
Service desk analytics app delivered natively on ServiceNow marketplace for comprehensive IT insights.
Jira Software analytics app delivered natively on the Atlassian marketplace, to provide impactful, real-time insights into your projects and improve outcomes.
Re-energized Mobile Apps
Your analytics are more mobile than ever!
Zoho Analytics - Dashboards app is an immersive purpose-built app to access, explore, and get insights on the go from your business dashboards. Enjoy analytics like never before with an intuitive and immersive visual experience. Available on iOS and Android. Read more.
Conversational analytics on mobile
You can now, causally, converse with Zia from your mobile devices using an immersive chat-like interface and get instant insights.
Commenting on mobile
You can now comment and collaborate with your teams right from your mobile app.
An enhanced Zoho Analytics Version 2.0 is now available. The new version is more standard-based with lots more API endpoints and features. Read Documentation.
Explore the enhanced Zoho Analytics 5.0 and share your valuable comments/feedback to support@zohoanalytics.com. We would love to hear from you!
Join the post-launch event with our team of experts and learn everything about Zoho Analytics 5.0 through a live demo and interactive fireside chat with our product managers. Register now!
Apr
Apr 15, 2021
Zoho Analytics now allows you to import data from other Zoho Analytics workspaces. You can import data from one workspace to another using the Zoho Analytics Workspace tile under Import Data. Learn more.
You can now import multiple Zoho Finance organizations' data into Zoho Analytics using the Import Multiple Organizations Data option. Learn More.
Mar
Mar 04, 2021
The Create Slideshow and Manage Slideshows pages have been revamped with more interactive options.
The new UI captures:
- Slideshow Preview: You can now preview a created slideshow in the Copy URL page of the Create Slideshow wizard.
- More Contextual Options: You can modify your slideshow settings from the Manage Slideshows page, which is now enhanced with more contextual options for better usability.
Until now, you could sort the Multi-Y charts based only on the dimensional column (X-axis). Now, Zoho Analytics allows you to sort the Multi-Y charts based on Y-axis values as well. You can choose to sort your chart based on either one of the Y-Axis values.
Also, we've renamed the sorting options using the dimensional column name to provide better visibility on how the chart is sorted.
Feb
Feb 18, 2021
We have revamped the Manage Users interface in both account and workspace level for an enhanced user experience. Now you can easily manage your users without a hassle.
Advanced Analytics for Zoho CRM now supports synchronizing data from the following new modules along with the already existing ones:
- Subforms
- Linking Modules
- Picklist History tracker
Jan
Jan 08, 2021
Now Zoho Finance Analytics extends support for Zoho Expense services (in addition to Zoho Books, Zoho Invoice, Zoho Billing, and Zoho Inventory).
With the Zoho Expense advanced analytics connector, you can gain insights into your organization's expense and trip management data. You can also get details about various expense categories and policy violations.
You can now setup the integration with any of the Zoho Finance apps -- Zoho Books, Zoho Invoice, Zoho Billing, Zoho Inventory, and Zoho Expense -- individually from Zoho Analytics. All these connectors are now available as separate tiles for easy setup.
Ask Zia is now enhanced with the following features to enable Zia to provide more advanced reports as a result.
Predictive Analysis
Ask Zia now supports predictive analysis. You can now ask questions to Zia about future trends/forecast apart from just historical data insights.
Reports as Result
Now Zia also suggests existing reports and dashboards that are relevant to your question as a result.
The answer you are looking for might already be available as a report in the workspace. If your query matches with an existing report, Zia will suggest that as an answer.
Add as Synonyms
Now you can add the unrecognized words in your question as a synonym to a column in your tables in a few clicks. Setting up synonyms enriches the vocabulary of Ask Zia to answer questions.
2020
Dec
Dec 14, 2020
Merge User Filters in Dashboard has been enhanced to support all data types.
Previously, only text column based user filters could be merged. Now you can merge user filters with all data types such as number, date, email, percentage, and others.
This is pretty useful in cases when you have a dashboard with reports created over similar columns from different tables, but still want to have a single common user filter to apply over them.
You can now import huge data files, available in URL/Feeds/REST APIs, in small batches into Zoho Analytics. Choose either one of the following pagination types and have your data files imported in batches into Zoho Analytics.
- Page Number: You can use this option when your data is stored in multiple pages and you want to import them in the same sequence into Zoho Analytics.
- Next Page URL: You can use this option when your data is delivered in pages with each page providing the URL for the next page to import.
- Offset and Limit: You can use this option when you have a huge dataset and want to import them in batches, by providing the start position and batch size of each batch, into Zoho Analytics.
Advanced Analytics for QuickBooks now supports synchronizing data from the Customer Type module.
To enhance the user experience we have introduced the following new export options in the Explorer.
Export Views from Explorer
A new option to export multiple views from the Explorer is added to enable the users to access the option easily. You can select the views in bulk and invoke this option.
Export Views in Folders
Now you can easily export or email all the views in a folder into various formats with a few clicks. Previously, you could export a folder only as a PDF.
When you connect to Zoho Analytics from your zaps created in Zapier, you no longer need to provide the AuthToken from Zoho. You can now directly use Zoho's username and password to connect.
Oct
Oct 06, 2020
Interactive capabilities of charts has been further enhanced with the new Switch Axis feature. Now you can switch the X-Axis column dynamically as required and view the chart in different dimensions.
From now on you will be able to display an alternative text for Web URL columns, instead of actual URLs, in the Pivot Tables and Summary Views. This can be set as part of the column formatting, for columns of type URL.
Zoho Analytics now extends support to import data from the following databases using Zoho Databridge.
Zoho Analytics now supports a new file type import - Spatial Data File. You can now import your spatial data into Zoho Analytics and create geo-maps to analyze your data in detail.
Zoho Analytics supports Shape, TopoJSON, and GeoJSON file formats. Geodata formats namely point, polygon, and multi-polygon will be auto-identified when you import spatial data files.
Sep
Sep 03, 2020
You can now set expiry date for the link generated for a view, using Access without Login permission. After the said date, the link will expire automatically, and the view will not be accessible.
A shared user can now use the newly introduced Request Access option to request for read permissions for a shared view.
When a shared user tries to access a view without proper permission, they will be navigated to the access denied page as shown above. From here, they can request access to the view from the Administrator by clicking the Request Access button. The Account/Organization/Workspace Administrator can approve the access request, and share the view to the requested user.
You can choose to hide columns using the new Show/Hide Columns option in Zoho Analytics' Pivot View.
Aug
Aug 25, 2020
Advanced Analytics for Instagram
The Advanced Analytics connector for Instagram enables you to analyze your user traction and account performance in detail. It allows you to slice & dice your Instagram account data and get insights on your followers (age, gender, and place) and how popular is your brand.
This integration includes 45+ prebuilt reports and dashboards over your Instagram data to help you jump start your analytics right away.
Advanced Analytics for Sage Accounting
Advanced Analytics for Sage Accounting helps you to analyze your key financial metrics such as accounts, expenses, invoices, and many such KPIs. With this connector, you can create insightful reports and dashboards on your financial data and thereby stay well ahead in your financial journey.
The integration packages 75+ prebuilt reports and dashboards over your Sage Accounting data, offering indepth financial analytics.
Both Advanced Analytics integrations are Ask Zia trained and can answer your questions with appropriate reports in seconds.
New Chart Type - Histogram
A new Chart type Histogram is added now. It is a special form of bar chart where the values are plotted over continuous rather than discrete categories and useful to plot frequency distributions.
New Chart Options
We have added new chart options to create horizontal bar, horizontal stacked bar and 100% stacked bar charts.
With this option, you can also create a horizontal bar/stacked chart with multiple Y axes too.
Jul
Jul 22, 2020
A set of cool new features has been added to our already smart Ask Zia. The enhanced AI assistant will now support:
- Ability to Understand Unstructured and Incomplete Queries: Ask Zia can now interpret grammatically unstructured queries appropriately. In the example below, although the query is not properly formed it will still be interpreted rightly as "show me sales by region in the previous year".
- Typo Tolerance: Ask Zia is now typo tolerant. It can even understand misspelt words and interpret your questions right. The example below shows that misspelt words being handled appropriately and the question being rightly answered.
Ability to Interpret Accurate Function Type: Ask Zia can interpret the intent of your questions, derive the functions to be applied on your data, and generate the metric that you are asking for.
For example, the questions "Which region has the highest total sales" and "Which region has the highest number of sales" read very similar, but are subtly different. The first question should get the Region with the highest TotalSales (Sum function type). Whereas the second question should show the Region with the highest Sales Count (Count function type).- Comprehend Short Dates and Weekday/Weekend: You can now ask questions with short dates and weekend notations like "Sales for Apr, May, and Jun 2020" or "Show me the weekend sales for June 2020".
The Organization Administrator role is now available for Zoho One users as well. Earlier, the role was made available only to Zoho Analytics users. Based on the request from many Zoho One users, this role is now extended to Zoho One as well.
The UI of the Export and Email dialogs has been enhanced for better usability. The new UX supports easy user navigation with succinct options.
In Workspace Explorer, you can now make sub-folders as "Default" folders too. Until now you can only make parent folders as default.
Jun
Jun 11, 2020
Now you can apply attractive patterns over your chart to enhance the visual appeal of your chart.
You will find a set of prebuilt, pattern-based palettes. You can also create your own pattern palette to apply in your chart. This feature is of immense benefit for users with difficulty in identifying colors.
So far, Cloud Databases were listed as data source only when importing into a new table. From now on, they will get listed as data source when importing into an existing table too.
May
May 28, 2020
An option to enable/disable Dynamic Drill Down in a chart is now available on the Chart Settings page.
By default, the Dynamic Drill Down option will be enabled for the charts you create in Zoho Analytics. You can now choose to disable it if needed, from the Settings page.
Converting a sub-folder to a parent folder is now possible. You can now convert a sub-folder to a parent folder with just a single click.
Another handy feature that's now available -- you can now easily favorite your reports and dashboards when you are viewing them, by clicking the new favorite icon placed right next to the name of the report/dashboard.
For ease of accessibility, we have enhanced the already existing behavior of cascading User Filters. The option "List only relevant values" is now divided into "List only relevant values" and "List Relevant Values, with "Show All" option".
- List only relevant values: This option is used to set up cascading User Filters i.e., if you want the second (or subsequent) User Filter's value to be dependent on the value that you have chosen in the preceding User Filter(s).
- List only relevant values, with 'Show All' option: This option is similar to List only relevant values, with a Show All link. Clicking Show All will list all the values in the dropdown for filtering.
May 13, 2020
So far you can publish views to entire web users or users within your Zoho Analytics Organization. Now you can also publish reports and dashboard to users in your Zoho Organization.
So far restricting selective columns is available only while sharing. Now you can publish selected columns from your table. This enables you to control what data your users get to see. This will particularly be helpful in case you have sensitive data in your table.
If you have Organization Admin privilege for multiple organizations, now we give you an easy option to import data into any organization right from the Home page. When you import data, it will prompt to choose the organization in which the workspace has to be created and data needs to be imported
Apr
Apr 30, 2020
Until now, any anomaly or change in your key business metrics were brought on a snap to you via Email and In-app notification channels. In addition to the already existing channels, new to join the line of channel notifications are:
- Slack
- Microsoft Teams
- Webhook
Get data alerts any time, anywhere. Stay well-informed and prepared.
Apr 23, 2020
We are happy to announce that Zoho Analytics now supports plotting Trend Lines in your charts. Trend Lines are used to identify the trend present in your data. Zoho Analytics can plot the past and future trend in your time series or number series data.
Zoho Analytics provides five models to derive the Trend Line. They are Linear, Logarithmic, Exponential, Power, and Polynomial.
A new Expand/Collapse option is added in Pivot View. This is a handy feature that helps users to drill into the pivot data using expand/collapse option.
Users can now view the data in a hierarchical manner. i.e., they can view the higher group and gradually move to the groups within or do the reverse.
Now you can define a date column to be a lookup column too.
When reports are created on tables involving date lookup, Zoho Analytics will automatically derive the appropriate date function to be used to join the tables and generate the report.
Mar
Mar 30, 2020
The collaboration options Share this View, Make this View Public, Edit Shared Details, Email, Embed, URL/Permalink, Slideshow have all been grouped and listed inside the Share button for easy accessibility. You can now access all the collaboration options from the Share button.
Mailing view(s) to multiple users after applying the "Share Filter Criteria" has now become easy. So far, it was possible to mail only one user, at a time, applying the Share Filter Criteria. This limitation has been removed. From now on, you can send the filtered view(s) to multiple users and groups.
Feb
Feb 28, 2020
Advanced Analytics for Site24x7
Advanced Analytics for Site24x7 helps to improve your service/platform availability & quality with meaningful insights on outages, alarms, monitors, and infrastructure.
You can easily track the outages by analyzing the key metrics such as downtime count, duration of outage, frequency, and more across locations. This helps in identifying the root cause of downtime and take appropriate steps to maximize website, application and server performance and availability.
The connector comes with 85+ handpicked default reports and dashboards, which provide in-depth insights on various metrics to get a complete overview of all your monitors instantly.
Advanced Analytics for SalesIQ
Advanced Analytics for Zoho SalesIQ helps you to understand your customer actions and their experience by visually analyzing their touchpoints. Analyze KPIs like website traffic sources, visitors' geographic distribution, the average time spent on your website, shared responses, and many more with our prebuilt reports and dashboards. Tracking these KPIs will help you to optimize lead generation, enhance your users' experience, and convert them to customers, thereby helps you to increase your ROI.
Apart from analyzing data from Zoho SalesIQ, you can blend data from other applications such as Zoho CRM, Zoho Desk, Salesforce CRM, Zendesk, etc., along with Zoho SalesIQ to do end-to-end cross-functional analytics.
The Advanced Analytics for Zoho SalesIQ includes 75+ prebuilt reports and dashboards over your Zoho SalesIQ data that help you to jump-start your analytics right away.
Zoho Analytics now supports a new filtering option named Wildcard filter for text columns. Now you can filter the data by constructing filter criteria. This allows you to filter data specifying multiple conditions at the same time. You can join the conditions with AND/OR logical operators.
Zoho Analytics now supports Percentile as a summary function for creating reports. You can now plot a report applying percentile function on column.
e.g., when you plot the 90th percentile of a column, it will show the numbers below which 90% of the column values lie.
You can now get notifications in your Zoho Analytics Mobile App (both iOS and Android) for the following actions:
- When an alert is triggered
- When a view is shared with you
- When you are added to or removed from a group
- When a scheduled import fails
Feb 20, 2020
Amazon S3 is the latest entrant being added to the list of Cloud Storages/Drives supported by Zoho Analytics. You can now analyze data from files stored in Amazon S3 buckets, using Zoho Analytics.
The White Label Settings Page has been revamped with a lot of additional features and enhanced usability. The new UI is divided into Settings and Administrative Action tabs, with each tab containing various customization options.
A gist of the new features introduced:
- Password Policy Settings: Configure and manage users' password settings.
- Ask Zia: Enable the smart assistant Zia. Zia is a search-driven augmented analytics assistant, helping your users create reports instantly, by just asking questions.
- Password Reset Option: Reset users' passwords.
- Account Deletion Option: Delete user accounts.
Jan
Jan 31, 2020
We're happy to announce two new Advanced Analytics connectors--for LinkedIn Ads and Eventbrite--powered by Zoho Analytics.
Advanced Analytics for LinkedIn Ads
Advanced Analytics for LinkedIn Ads, enables you to visually analyze your marketing Ad campaigns, measure the outcomes, and derive actionable insights in minutes. Quickly analyze key performance metrics like traffic, CTR, CPC, CPM, conversion rate, and much more. Apart from analyzing your LinkedIn Ad campaigns, you can also blend data from other sources to get end-to-end insights of your entire business function.
The connector comes with 75+ handpicked default reports and dashboards, which provide visual insights of Ads campaigns. With LinkedIn Ads Advanced Analytics, you can make more informed decisions when running multiple LinkedIn Ads campaigns to grow your business.
Advanced Analytics for Eventbrite
Advanced Analytics for Eventbrite helps you to analyze and draw insights from the key elements of an event, like the registration count, attendees count, tickets sold, etc. By analyzing and tracking these KPIs, you can get insights about how successful was an event conducted and come up with actionable insights for improvement.
The Advanced Analytics for Eventbrite includes 60+ prebuilt reports and dashboards over your Eventbrite data that help you to jump-start your analytics right away.
Now you can choose to display the legend items with or without the corresponding values.
You can also customize the format to display data. This option is available for Pie and Funnel Charts.
Learn More.
Query Table now supports the following keywords in the query.
- Pivot - This rotates a specific column's unique row values into multiple columns of the table.
- Unpivot - This rotates multiple column headers of the table into a specific column's unique row values.
Now KPI widgets support alignment option. By default all KPI will be aligned to center. With this change, the alignment of the existing widgets in your dashboards will be changed to the center.
Jan 20, 2020
The Embed / Publish URL dialog has been revamped for better usability and has also introduced a good set of additional functionalities.
The new UI captures the following:
- Embed and Publish options merged in a single screen
- Access with Login, Access without Login, and Access within Organization / External Users permission controls in the same dialog
- Status of the already published types
- New option to specify URL criteria
Make Views Public Within Organization
You can now choose to make views public only within your organization. Using this option will make a view accessible only to the users within your organization.
URL Criteria
A new option to Specify URL Criteria has been made available in the Embed / Publish URL dialog. Using this option you can apply dynamic filters.
By default, the criteria you provide here will be appended as part of the URL. You can mask the same using Mask Criteria in URL option if required.
For more learning on the new Embed / Publish dialog, do read our help page.
Zoho Analytics has the capability to blend data across connectors for business apps automatically. Now, you can customize auto blending suggestions by customizing the look-up columns suggested between these connectors.
Auto blending is now available for a couple of connectors. You can also define your own look-ups manually, as required.
Now you can snapshot data from your charts which contains forecasts. You can then create reports on the predicted values across timelines and compare them with your actual data.
Zoho Analytics supports new modules and fields for existing connectors. Provided below is the list of newly added modules and fields.
Connector Name | Supported Modules | |
Shopify |
|
|
|
| |
|
| |
|
| |
|
| |
Zoho Campaigns | Campaigns vs Contacts vs URL | |
Xero | Quotes | Quote LineItems |
New Fields Supported
Connector Name | Module | Supported Fields | |||
Zoho Projects & Bug Tracker | Milestone | Budget | Threshold | ||
Users | Profile | Status | |||
YouTube Channel | Time Sheets | Is Timer | Start Time | End Time | |
Videos | Duration (video duration in seconds) | ||||
Facebook Ads | Ad Insights | 40+ new fields | |||
Adset Insights | 40+ new fields | ||||
Account Insights | 40+ new fields | ||||
Campaigns Insight | 40+ new fields |
Moving views across folders has now become easy. You can select multiple views from across folders, and move them to a folder within a Workspace. Also, you can now move the parent folder as a sub-folder and move sub-folders from one folder to another within a Workspace.
Another handy feature that has been added is that you can favorite your most accessed reports and dashboards from the left navigation menu bar.
Similar to another table has been a handy feature, which helps you to create similar reports on a single click, over a new table, similar to the ones already created over an existing table. So far it has supported creating reports only on a single table, not considering the connected tables. This limitation has been removed. From now on, you can create similar reports based on connected tables as well.
A shortcut link Create New Dashboards / Create New Reports is now available in the left side navigation menu bar of Dashboards / Reports tabs respectively.
With the ease of a single click, you can now create a new report or dashboard.
Learn more about Dashboards and Reports.
2019
Dec
Dec 02, 2019 | |
Mark Reports as Filters in Dashboard Zoho Analytics now allows you to set Reports to act as filters in your Dashboard. With this, you can dynamically filter the entire dashboard by clicking on any data point of a report. This further enables enhanced user interactions with the Dashboard. Click here to learn more about Reports as Filters. Activity LoggingZoho Analytics' new Activity Logs feature can now enable you to track user actions/activities performed in your account. You can track activities such as importing data, creating reports, sharing reports etc., in your account. You will also get a Pre-built Activity Insights Dashboard capturing the essentials of user activities such as Daily Activity Trend, Activities Distribution by Category performed in your account. Users with Zoho Analytics Standard plan and above can avail this option. Click here to learn more about Activity Logs. Compact Layout for Pivot TableA new Compact Layout is now available for Pivot Table. This is a close-packed view of the Pivot Table where a table's columns dropped in the Rows shelf will be grouped and arranged in a single column. You can toggle between the Tabular Layout and Compact Layout using the toolbar on the top. Click here to learn more about Pivot Table Layouts. Improvised Chart Sort BehaviourCharts default sorting behavior is improved to enhance the readability of the visual charts:
New Version of Zoho Analytics Mobile AppA new version of Zoho Analytics Mobile App (both iOS and Android) is now available. The following are some of the key features:
Click here to learn more on Zoho Analytics Mobile App. |
Dec 30, 2019 | |
New Role - Organization AdministratorsZoho Analytics now supports a new role - Organization Administrators. Organization Administrators are users who have access to all the workspaces in the Organization, and can perform all the operations inside the Organization, except deleting and renaming an Organization; and adding, activating, and deactivating other Organization Administrators. Organization Administrators are nearly as powerful as the Account Administrator (Owner of the account). You can have multiple Organization Administrators in your Zoho Analytics account. Click here to learn how to add an Organization Administrator to an account. |
Oct
Oct 16, 2019 | |
Introducing Data Snapshot
Data Snapshot periodically snapshots the data from a chosen report, and stores them in a table, for historical report creation & analysis. Let's say you have a report for Leads by Source and Status. With Data Snapshot, you will be able to track the changes in the leads' status over timestamps such as every month, week, day, or hour and create reports over them. Click here to learn more on Data Snapshot. Get Dependency Details for Views
The following are the dependency details available for each view.
Click here for more details on this. Sub-Folders in Workspace
Click here to learn how to create a sub-folder. Notification for Domain ValidationTo enable a secured mailing option (Emailing Reports, Data Alert Mails), Zoho Analytics allows you to send DMARC compliant email. In case you have not validated Zoho Analytics as a valid email source, then you will be notified in the dialog. You can click the Domain not validated link and validate your domain. Click here to know how to validate your domain. Import data from Google Team Drives and Zoho WorkDriveNow you can import data from Google Team Drives and Zoho WorkDrive. This allows you to import data from your business account. Click here to learn how to import from Google Team Drives and Zoho WorkDrive. Tags Module supported in Teamwork Projects ConnectorAdvanced Analytics for Teamwork Projects now supports synchronizing data from the Tags module. For more details about the Teamwork Projects connector, click here. |
Oct 16, 2019 | |
More Authentication Types for Web Import For URL authenticated using OAuth 2 Authentication, you can now specify the Grant Type. Groups UI Revamped
Click here to learn more about Groups. |
Sep
Sep 13, 2019 | |
Introducing Geo Heat Map
|
Aug
Aug 2, 2019 | |
Emailing Reports - Recipients Limit ExtendedNumber of recipients for emailing reports & dashboards has been raised from 5 to 25. You can now specify upto 25 recipient mail ids when you mail reports. You can also add Groups as recipients and no longer need to enter all email addresses every time. Selecting multiple views made easy Shift + Click short cut key can now be used to easily select a contiguous list of views easily in the Explorer. |
Aug 14, 2019 | |
Advanced Analytics for ShopifyAdvanced Analytics for Shopify provides you in-depth e-commerce analytics on your store data in Shopify. With this connector, you can effectively track key business metrics such as product performance, shipment handling, customer preferences, order transactions, inventory management and many more.... This connector is bundled with 100+ pre-built reports and dashboards that provide deep driven insights to grow your e-commerce business. Apart from the pre-built reports, you can also easily create your own ad-hoc reports & dashboards based on not only your Shopify data but also by blending data from other data sources. Zoho Inventory & Zoho Billing - New Addition to Zoho Finance AnalyticsNow Zoho Finance Analytics extends support for Zoho Billing and Zoho Inventory services (in addition to Zoho Invoice and Zoho Books). With Zoho Billing Analytics, you can get a visibility into your subscription transactions with in-depth analytics. You can track subscription trend, customer growth trend, revenue growth, average customer lifetime, cancellations, and customer churn rate. And for Zoho Inventory, you can get insights on sales returns, product inventory, warehouse items, packages and shipments. You can do a deeper analysis of your stock handling for an effective inventory management. From now on, you can also analyze data from joined organizations in Zoho Finance Suite (Zoho Billing and Zoho Inventory along with Zoho Books or Zoho Invoice). Report Formula EnhancementReport Formula now supports formula based on IF conditions. With this, you will be able to construct a Report Formula containing logical conditions (expressions) You can use the following logical and comparison operators hence forth in your expressions:
Comments widget in View Cards
This widget will also highlight unread comments with a red dot to get the user's attention. |
Aug 21, 2019 | |
New Butterfly ChartZoho Analytics now supports a new chart type, Butterfly chart (also be referred as Tornado chart or Divergent chart). This chart will be plotted as two horizontal bars with the same X-axis in the center, resembling the butterfly wings. This will be useful in comparing contrasting data sets such as male vs female, income vs expense, positive vs negative, completed on time vs overdue etc., easily. Click here to learn more. Customize Pivot Summary Position Now you can customize the position to display the summaries (Sub-Totals and Grand-Totals) in Pivot Table. You can choose to display a row summary either on Right or Left position. Similarly, you can display a column summary either in top or bottom position. Click here to learn more. |
Aug 28, 2019 | |
Import Data from Statistical Files
Import from more Local Databases with Zoho DatabridgeZoho Databridge now extends to support importing data from the following databases. Unsubscribe from Shared Organization and Workspace
Click here to learn how to unsubscribe from shared Organization and Workspace. Delete Own Organization
Click here to learn how to delete Organization. Apply Parent Table Filter Criteria while Sharing Dashboards If you have shared a table (parent table) with a specific filter criteria to a user. Let's say you are sharing a dashboard, with dependent views embedded in it, to the same user. You can now choose to apply the parent table's filter criteria to the dashboard. When you apply this option, share filter criteria in the parent table will be joined with the share filter criteria specified for and the dashboard, using AND option. Click here to learn more. |
Jul
July 17, 2019 | |
Prediction Interval for Forecasting Send DMARC Compliant Emails
The Email Settings allows you to configure Zoho Analytics as a valid email source to send mail using your email address. With this, you indicate that the emails sent by you using Zoho Analytics aren't spam. Click here to learn how to configure the email settings. Chart Color Palette Revamped
Double-click to Rename Table Column
|
July 23, 2019 | |
New Data ConnectorsWe're happy to announce that Zoho Analytics is enriched with two new Advanced Analytics connectors: Advanced Analytics for YouTube Channel and Facebook Competitive Analytics. Advanced Analytics for YouTube Channel Advanced Analytics for YouTube Channel allows you to monitor and grow your YouTube channel by analyzing its performance with powerful insights. You can measure video engagement by analyzing your audience interaction such as likes, comments, shares, favorites, and watch time, to know what type of content resonates with your target audience. Also explore traffic stats to get deeper insights like geographic distribution, gender profile, device usage and lots more, which will let you tailor your content accordingly. The Advanced Analytics for YouTube Channel includes 50+ prebuilt reports and dashboards. Facebook Competitive AnalyticsThe Facebook Competitive Analytics connector enables you to analyze and compare the performance metrics across multiple Facebook pages. Marketers can use these insights to study how their page performs in comparison to the competition or with other pages. You can derive key insights to validate competitors' influence and benchmark your growth against them. You can also measure competitors’ engagement (their success and failure) to make sure you are in track with the trend and learn how to be ahead of them. The Facebook Competitive Analytics connector includes a wide range of prebuilt reports and dashboards to get your analysis started immediately.
Apart from the prebuilt reports & dashboards bundled in each of these connectors, you can always create your own ad-hoc reports & dashboards using the easy to use drag & drop interface. You can also blend data across other sources to get end-to-end insights. |
May
May 8, 2019 | |
Dashboard Layouting made easy Dashboard layout has been enhanced with the following flexible layout options:
Allow Export for Reports in DashboardA new option to enable or disable export options for the embedded reports in the dashboard is now added in the Dashboard Settings. You can also choose the export file formats to allow using the Customize link. Maximize Embedded Report in DashboardNow Zoho Analytics allows maximizing the embedded report to view in full dashboard layout. You can also open the report in edit mode from the dashboard. |
Apr
April 3, 2019 | |
View Report in Zoho Sheet Now you can view the Zoho Analytics view in Zoho Sheet. The data in each of the view will be displayed in Zoho Sheet retaining the same structure. In the case of Chart, only the underlying data will be displayed and it will not be displayed as a chart visualization The following view types can be viewed in Zoho Sheet.
For more details refer here. Organize Views in Navigation PanelNow you can choose to organize the views listed in the Data, Reports, and Dashboard navigation panel. The view list can be organized in one of the following order.
For more details refer here. |
April 26, 2019 | |
Geo Maps Visualization EnhancementsZoho Analytics Geo Map Visualization has been enhanced with the following features. New Map ThemesMap themes have been enhanced with Satellite map theme and a custom theme. With Satellite map theme you can now plot a geo map chart over Satellite map. The custom theme allows you to design a theme with your own colors and apply the same on a map chart. The map themes now support an option to invert the land and water color using the Invert Color toggle button. This is applicable for all theme except Satellite map. Airport IATA CodeAirport IATA Code in your data will now be recognized by Zoho Analytics as another geo type column. With this, you can create reports based on airport data. Multiple Country MapThe country-specific map now allows selecting multiple countries in geo maps. Now you can display the map of the countries that are applicable to you and hide the rest. Continuous LegendNow you use a continuous color range legend for map chart and categorize the data values using color range. This will be pretty useful for visualizing data based on the volume of occurrence. Import EnhancementsImport Data from more Cloud DatabasesNow Zoho Analytics allows you to import data from the following Cloud Databases
Import data from Files and FeedsData Import from local files and web/feed are now separated into 2 different options to simplify the import process. Ignore Color Selection in chart drill-downs You can now choose to ignore the specific color which you have clicked and drill down the entire data point using the Ignore Color Selection toggle button. |
Mar
Mar 20, 2019 | |
Security Controls Options Zoho Analytics provides a set of security options that enable you to control and manage access to your account. This includes setting up IP restriction as well as controlling the various sharing & collaboration options being made available.
Click here to learn more about security control options. Social Media Widget for Private ViewsNow you can add social media widget in the private links (without login) published. This allows user viewing reports/dashboards from private links to share the same into social media channels like Facebook, Twitter, and Linkedin. Click here to learn more about Private Link (Without Login). |
Mar 27, 2019 | |
New Chart Type - Bubble Pie A new chart type called Bubble Pie Chart is now added. This is a combination of pie and bubble charts. The data column dropped in the Size determines the size of the bubble. Other aggregation will be plotted as a proportional division of the bubble. This will be useful in displaying multiple pie charts to compare the proportion of data across a series. For more details refer here. Combination Chart - More Chart Types SupportedNow Combination Chart supports more chart types. Previously bar, stacked bar, and lines alone were supported. Now more chart types are supported. You can choose two or more chart types in a single report from the given below.
For more details refer here. Enhancements to Advanced Analytics for Google AdsThe Keyword Performance module is now supported in the Advanced Analytics connector for Google Ads. Now data from this module will be synced into Advanced Analytics for Google Ads workspace for analysis. For more details refer here. |
Feb
Feb 8, 2019 | |
Enhancements to Zoho Projects and Zoho Bugtracker connectorsThe Zoho Projects and Zoho Bugtracker connectors have been enhanced with the following options.
Supports to Format Data as Lakhs and CroresZoho Analytics now supports to format the numeric columns as Lakhs and Crores. This will be specifically useful for users from Indian Subcontinent. The following are the new options added to format numeric columns.
Click here to learn about more Formatting Options. |
Jan
Jan 24, 2019 | |
Country-Specific Map ChartZoho Analytics now allows you to plot a country-specific map chart. So far, Zoho Analytics displays the entire global map even if you have data for one country alone. Zoho Analytics will autofocus on the specific region alone. However, the neighboring regions will be visible. Now Zoho Analytics allows you to choose a country-specific map. This allows you to highlight the relevant region alone. Support to choose Multiple Lookup Column for JoiningNow you can select multiple lookup columns to join tables for a report. So far, you can select one lookup column to join the data for a report. Now you can also select multiple lookup columns between each pair of tables in a path. This allows you to create report over data that meet multiple conditions. Click here to learn more on this. New 50+ In-built FunctionsZoho Analytics has now added 50+ in-built functions to the library for creating both Formula Column and Query Table. Existing functions are also refined to enhance usability. |
2018
Nov
Nov 15, 2018 | |
Zoho Analytics Release 4.0We are happy to announce the much awaited Zoho Analytics 4.0 public release. Zoho Analytics comes with several exciting features and a fresh look that you will love. Here is a summary of what's new in Release 4.0. Reporting to AnalyticsZoho Reports is now renamed as Zoho Analytics!! Since we offer in-depth data analytics beyond reporting already, it is only fitting that we make this name change to reflect the power of the product. Refreshed User InterfaceIntroducing an all new user interface with the following key features. Home PageAll your workspaces in one placeAccess all your owned and shared workspaces in one place. You can preview, search, sort and mark favorite for quick access. Easily access your dashboardsAccess Dashboards across all your workspaces. You can preview, filter and search. View AsView items in the form of preview cards or as a list. Connect to any data sourceOur extensive import options are now grouped for convenience. Theme supportNow we support to customize the Theme for overall product. Learn More about the new Home page. Workspace ExplorerEasy NavigationEasily navigate across all your dashboards, reports and data tables in your workspace. Global SearchSearch across all your views in this workspace using the global search bar. Rename ViewsEasy inline renaming option for views and workspaces. Learn More about the new Workspace Explorer. Personalized DashboardsDashboards has got a major facelift. Here are the key highlights. Flexible Dashboard Layouts Dashboard now supports a flexible m x n layout. With this, you can add multiple views in a single row and have any number of rows. Note: This feature will be incrementally enabled to users very soon. Smart Align WithSmart align option, Zoho Analytics will intelligently auto align the components of the Charts embedded in a Dashboard depending on the space available. This removes clutter and enhances readability. Dashboard Themes PresetsDashboard now offers a set of cool preset themes along with a range of customization options to increase the visual appeal. Learn more Merging User FilterNow you can merge multiple user filters, based on similar text columns from different tables into a single filter. This reduces duplicate filters and enhances user interactions. Learn more Colored KPI widgetsNow you can add background color for your KPI widgets. Ask Zia - AI Powered AssistantAsk Zia is the new search driven analytics assistant. Ask natural questions and get visualization answers. Zia is powered by machine learning and natural language processing. Users can ask Zia questions such as, "What was my monthly sales for the last year across regions?" Zia converts such questions to complex SQL queries in the back end and gives answers in the form of visual reports, without users having to create them manually. Zia can auto-blend data and understand questions that span across business apps - e.g., "Give me the revenue per employee" - where revenue comes from the accounting app, and employee count comes from the HR app. Zia comes up with multiple suggestions as possible answers, from which users can choose the relevant report. Note: This feature will be incrementally enabled to users very soon. Deep AnalyticsAuto Blending of DataData is typically siloed in departmental business apps. If a CEO wants to see this month’s new sales, marketing spend, support tickets got, and invoices sent, she has to go to each of the different apps. Let’s say she also wants to know revenue (data in accounting or CRM app) per employee (data in HR app), it becomes even more arduous. This is where Zoho Analytics can help with its intelligent auto-blending capability. Zoho Analytics makes it easier to analyze data from across apps by automatically identifying the connection between this apps and making it easy to create interactive reports and dashboards. ForecastingForecasting enables you to easily predict your future data trends. It uses powerful forecasting algorithms which analyzes your past data deeply and comes up with the best forecast for the future. Learn more Smart Data AlertsCatch them before it's too late - smart data alerts notifies you of any anomaly or change in your key business metrics as it happens. Configure alerts in a snap, then sit back and relax. Learn More Customizing Lookup PathCustom lookup path selection for every report is now possible in instances where multiple lookups are used. Learn more Report specific formulasCreate a report level formula using "Report Formula" feature to solve a wide range of aggregation challenges. New Summary Functions for Pivot TableNew Advanced Summary Functions, % of Row in Group, % of Column in Group and Lookup Value, have been included in Pivot Table. Learn more New Data ConnectorsZoho Analytics enriches its third-party integrations with seven new connectors for popular business apps, expanding the number of connectors to over 100. Each of these connectors come with more than 100 pre-built domain-specific reports and KPI dashboards that users can benefit from right away.
Enhanced VisualizationsWhat's analytics without cool visualizations? The following new visualization options have been added to Zoho Analytics to enable you narrate. Geo Map chartZoho Analytics now supports location based analysis with Geo Maps. Learn More Heat map chart Heat map is pretty useful for categorizing and visualizing data based on factors like volume of occurence, intensity, performance scale (bad to good) etc., Learn More Dial WidgetsZoho Analytics now provides full and half dial charts as widgets in Dashboards. These dial charts are the best to visualize a key metric in comparison to the target. Learn More New Color PaletteNew vibrant color palates have been introduced for charts. Default color palate has also been changed. CollaborationContextual CommentingCollaborative analytics has taken a new form. No more paperwork or lost email threads. Start commenting in real time and make data driven decisions together. Learn more Access LogsZoho Analytics now enables you to track the activity of all users in your account, from administrator to public users, through Audit Logs. Learn more Column Level SharingYou can control what data your users get to see and create reports upon by sharing selective columns alone. Learn More Zoho Analytics On-Premise Do you have concerns moving data to the cloud for analytics from in-house databases or applications? We heard you. Zoho Analytics now announces the on-premise edition, which can be installed in both Windows and Linux machines. You can easily setup and use in your private network or private cloud. Download now Lots moreNot just the above, Zoho Analytics Release 4.0 is enriched with 50+ new features. As you use the product, you will come across a lot more features. Some key ones:
Try the new Release 4.0. We are sure you will like it. Please do write us your valuable comments/feedback to support@zohoanalytics.com. We would love to hear from you! Note: We are running webinars explaining about what’s new in Zoho Analytics. Please register here. |
Oct
Oct 5, 2018 | |
New settings to customize Interactions in Dashboards As part of Zoho Analytics 4.0 release, we are introducing a new set of options to customize the interactions in Dashboards. You can customize the following:
These options are available only in the new 4.0 interface, which is currently in beta. More exciting dashboard enhancements are awaiting in the Zoho Analytics 4.0 release. Stay tuned... |
Sep
Sept 4, 2018 | |
Share Selective Columns from your TablesZoho Analytics now allows sharing selective columns from your data table to your users. So far when you share a table all the columns will be shared to the user. Now you can choose columns to be shared. This enables you to control what data your users get to see and create reports upon. This will particularly helpful in case you have sensitive data in your table. Click here to know how to share selective columns. Merging User FiltersZoho Analytics now allows you to merge multiple user filters (Text Column) into a single a filter. The below animation shows merging User Filters. Merging User Filters is pretty useful when you have a dashboard with reports created over similar columns from different tables. So far, the Dashboard User Filters are bound to a specific column in a table and will only filter the reports based on them. Now, this can be overridden. You can map similar columns into a single User Filter to filter all reports using the Merged User Filter. This avoids the tedious process of adding multiple User Filter and filtering the dashboard back and forth. Only user filters which are based on Text column types (categorical columns) can be merged. Click here to know how to use the Merging User Filters option. Configure Lookup PathZoho Analytics now allows you to customize the join path to be used for a report. You might have joined multiple tables using various Lookup columns in your Workspace. When creating reports, Zoho Analytics will use the appropriate Lookup column (Lookup path) created between them and generate the report using the auto join capability. However, in some cases this might not suit your specific need. To address this, Zoho Analytics allows you to choose the appropriate Lookup path between tables to be used for report creation using the Configure Lookup Path option. To know more on this refer, to the Customise Lookup path section. Revamped Share and Formula Dialog interfaceWe have completely changed the User Interface of the share and formula dialogs for an enhanced user experience. Share Dialog The new Share dialog allows you to quickly share any view as well as customize the necessary settings. For more details refer to the Sharing Views to Users section. Formula Dialog
|
Sept 14, 2018 | |
Cool Preset Themes for Dashboards Zoho Analytics now introduces a set of six cool preset themes for Dashboards. These elegant preset themes applies specific colors for every element in the Dashboard with single click. Previous Dashboard themes were single color based. Customizing themes has also been enhanced now. The entire dialog has been revamped. A new magic band option, to auto suggest matching colors for all elements based on the selected Dashboard background color, has also been added. This allows you to quickly setup a custom theme for your dashboard. |
Sept 19, 2018 | |
New Advanced Summarizing Functions for Pivot TableZoho Analytics now supports the following advanced summarizing functions in Pivot Table to enhance the analytical ability.
Click here to learn more about the advanced summary function for pivot. |
Aug
Aug 10, 2018 | |
User Access Log DetailsZoho Analytics now enables you to track the activity of all users in your account, from administrator to public users, through Audit Logs. A reporting database will be automatically created in your account and the activity logs will be updated in this reporting database. You will also get an insightful Dashboard, the Access Log Analytics capturing the essentials of user activity such as Daily Access Trend, Access Count by View Type and by Users, etc. This option is available for all paid plans of Zoho Analytics. You can choose to log the users' activities in your account using the Access Logs toggle button in the Settings page Audit tab. Click here to learn more on this. |
Aug 10, 2018 | |
Important Terminology ChangeWe are doing an important terminology change in Zoho Analytics today. Database renamed as Workspace Database Owner renamed as Workspace Administrators
To learn more on user roles in Zoho Analytics, refer here. Note: This is just a terminology change and will not affect any of the existing functionality. If you have any questions please write to us at support@zohoanalytics.com. |
Jul
July 5, 2018 | |
Zoho Analytics Release 4.0 BetaWe are delighted to announce the new Zoho Analytics Release 4.0 Beta. Your favorite Zoho Analytics now comes with a fresh new-look and exciting features. The new Zoho Analytics 4.0 includes the following features: Dashboards in Single Click Easy Navigation Geo Map Charts * Dark Themed Dashboards * Colored KPI Widgets * Zoho Analytics on-premise Those are just some of the major changes done in Release 4.0 Beta. As you use the product to visually analyze your data, you will come across a lot more features.
Not just that, more new exciting features are in development which will be rolled out as part of Release 4.0 public release. Stay tuned... To access the New Zoho Analytics 4.0, login to your Zoho Analytics account at https://analytics.zoho.com, click the Try 4.0 button at the top right. You'll get switched to the 4.0 version (This will not be enabled for trial users. You can avail this once the trial period ends). Please do give Zoho Analytics 4.0 Beta a try and let us know what you think. Post them to support@zohoanalytics.com. Looking forward to your valuable feedback.... * - Some of the features were already enabled in the existing UI. |
July 24, 2018 | |
Enhancement for Dashboard User FiltersNow User Filters in the Dashboard will be anchored as you scroll. So far the User Filters will be available in the place you have added them in the Dashboard. When you scroll down the Dashboard the User Filters will be hidden. Now they will be retained till the end of the Dashboard while scrolling. This allows you to quickly access the User Filter when required. Support to Pick Location for Geo Data
Previously you need to provide the Latitude and Longitude of the location to identify the location for Geo data. From now you can easily pick the location using in the Location Picker map. This also provides a field to search the location in the map. Click here to learn more on this. Enhancements in Teamworks Projects Advanced Analytics Now Zoho Analytics allows you to import data from projects across Companies in Teamworks Projects into a single reporting database in Zoho Analytics. Previously, you need to create multiple databases to import data from each company. Click here for more details.
|
July 31, 2018 | |
Enhancements in ExportingExporting in Zoho Analytics has been enhanced with the following options. Exporting into Zoho SheetNow Zoho Analytics supports exporting Tables, Query Tables, Chart, Pivot Table and Summary View into Zoho Sheet. For Chart, Pivot Table and Summary View you can either choose to export the underlying data or the summarised data of the current view into your Zoho Sheet account. Exporting Personal DataZoho Analytics takes additional care in handling your personal data. From now on, columns marker as personal will be excluded from export by default. This avoids accidentally sharing the personal data with others. However, you can choose to export them by explicitly selecting them. Emailing Reports - Configurable From Address to handle DMARCUntil now, the reports that you mail from Zoho Analytics will be sent to the specified users from your email address. In case your receiver has set up DMARC for mail sender validation, then these emails might be blocked or sent to spam. To avoid this, you can choose to mail the reports directly from Zoho Analytics common mail address (notifications@zohoanalytics.com). You can select this in the From field on Email Setting page. |
Jun
June 7, 2018 | |
Importing from MS Access Database using Import WizardNow you can import data from the MS Access database files you have stored in Local Drives, Web URLs, FTP servers or Cloud Drives right from the Import Wizard in Zoho Analytics user interface. Previously MS Access database files can be imported only using the Upload Tool. You can choose a Single table, Multiple tables or write a custom SQL query to fetch the data for importing. You can schedule the import in periodic intervals if the Access database files are stored in a Web URL or FTP server or Cloud Drives. You can also choose to sync data instantly from your database in a few clicks. To learn how to import data from MS Access database files, refer here. Importing from Secured Web URL with OAuth authenticationSo far you can import data from authenticated Web URLs which supports only basic authentication system. Now, this has been enhanced to support import data from Web URLs using OAuth 1 and OAuth 2 authentication system. Click here to learn more on this. Supporting Dynamic Parameter in Web URL ImportWith this update, you can set dynamic values for the parameter while importing data from Web URLs. You can specify Current Date, Current Time and Current Date & Time as a dynamic value for the parameter of the import URL. Learn how to set dynamic value for import parameter from here. New Options in Importing from Email AttachmentZoho Analytics now provides the following new options for Importing from Email attachment:
Learn more on these options from here. Multi-date Format Support in ImportsNow Zoho Analytics supports importing data with multiple date formats. Previously, when your data has date columns in different date format, then the column with the first date format alone will be identified as a date while importing. The rest of the columns will be imported as text columns. Now Zoho Analytics will identify multiple date columns with their corresponding date formats. You can also choose to modify the identified date format for each column using the Change Date Format option in preview menu. To learn how to configure multiple date format while importing, refer here. |
June 12, 2018 | |
Split Column Option for Data PreparationDo you have a concatenated values in your columns which you want to split for making better sense of your data and analytics? A simple example is splitting a customer name column as a first name and last name. The new Split Column option helps you do this exactly. The Split Column option allows you to split the value in a column into multiple columns based on a separator. This can be applied over the columns with data type Text, Multi-line Text, Email and URL. The split columns will be created as Formula columns with string data type. To learn how to split a column refer here. |
May
May 16, 2018
Geo Maps for Zoho Analytics (Beta)
Zoho Analytics users can now visualize their geographical data using a new chart called Map Chart (also called as Geo Maps). A map chart is a map of a world, continent, or country, with the data values assigned to specific regions through chart visualizations.
At present Zoho Analytics supports 5 types of Geo map types - Map scatter, Map bubble, Map pie, Map bubble pie and Map filled. These map charts will help you in analyzing your geospatial data using cool and interactive chart visualizations. You can easily create a map chart by dragging and dropping the Geographical columns in the X or Y axis of the chart designer.
Note
This feature is currently in public beta testing. Therefore you may encounter certain functional bugs and limitations. We request you to try it out and share your valuable feedback to support@zohoanalytics.com.
Teamwork Desk Advanced Analytics
We at Zoho Analytics are happy to announce the general availability of Teamwork Desk Advanced Analytics. Zoho Analytics advanced analytics for Teamwork Desk enables you to easily analyze your helpdesk data in Teamwork Desk. With this, you can easily slice and dice your helpdesk data, derive key metrics and transform them into actionable insights with the power of analytics.
The integration comes with 75+ reports and dashboards organized functionally as Teamwork Desk overview, agent performance, traffic insights, customer analytics, satisfaction, users, and much more.
Learn More: Teamwork Desk Advanced Analytics | Sample Reporting Gallery
May 28, 2018 | |
GDPR ComplianceIn compliance with the General Data Protection Regulation (GDPR) effective from May 25, 2018, we have made the following enhancement in Zoho Analytics.
Follow the below links to know more
New Enhancements in DashboardsDark Themes:We are excited to introduce 6 Dark themes that will enhance the look and feel of your dashboards. Not just visual appeal, these themes have been designed to increase usability and break monotony on repeated access. You can customize all the elements in the dashboard theme right from background color to picking report colors specific to the dashboard. This enables you to design a theme that not only captures your organization's branding but also add a character/theme to your reports. These dark themed layouts are in addition to the existing 6 light themed dashboards. You can quickly check out the theme types using the radio button in the Dashboard Themes dialog. KPI Widget Themes:From now on, you can apply themes/background colors for both single numbered and chart type widgets. This new feature further enhance the appearance of widgets in dashboard. Secure your Private URLs and Exported Files with PasswordIn this update, we have introduced password protection for exported files and privately embedded views or URLs for enhanced Data security on export and private URLs. Password Protection for Exported FilesYou can choose to protect the exported data from unauthorized access using password protection. Password protection for Privately Embedded Views and URLsYou can protect your private URLs (without Login) with password. This way you will be able to restrict the access only through password. |
Apr
April 10, 2018
New Formatting options for Charts and KPI Widgets:
Zoho Analytics now provides flexible formatting options to format all the elements in charts and KPI Widgets.
Charts:
You can now format all the data elements used in creating a chart. Earlier, Zoho Analytics allowed you to only format the columns dropped in Y-axis shelf. With this new update, you can customize the formatting for all the columns that are used in creating the report. Watch the below video to learn how.
KPI Widgets:
We have added an option to format the 'Group by' column used in creating a KPI widget. With this update, Zoho Analytics allows you to format all the components of a KPI Widget.
New options in Advanced Summary Functions
The widely used Advanced Summary functions in Pivots has become even more powerful with the new set of functions.
Following are the new options that are provided in the Advanced Summary Function:
- Running Total - Until now when you select a Running Total function, you can only compute Sum. From now on you can apply functions like Average, Minimum and Maximum in addition to Sum.
- Difference From - Displays the data value as the difference from the value in the previous cell, based on the base field provided. You can choose to compare the difference from either of Previous Value, Next Value, First Value or Last Value. Previous Value will be selected by default.
- % of Difference From - Displays each data value as a percentage of difference from the previous value (or the specified value). You can choose to compare the % difference from either of Previous Value, Next Value, First Value or Last Value. Previous Value will be selected by default.
Mar
March 13, 2018
Zoho Campaigns Advanced Analytics
We at Zoho Analytics are very happy to announce the release of Zoho Campaigns Advanced Analytics connector. Zoho Campaigns advanced analytics integration powered by Zoho Analytics enables you to easily analyze your email campaigns and derive great insights.
Product marketers and analysts can slice and dice their campaign data and derive key campaign metrics such as campaigns trend, conversion rate, click rate, open rate, unsubscription trend and do much more.
Zoho Analytics also enables you to blend your campaign data with a variety of data sources and popular business applications such Zoho CRM, Salesforce, Dynamics CRM etc to perform cross-functional analytics.
The connector comes with 50+ hand-picked reports and dashboards organized functionally as campaign & email analytics, email domain analytics, subscriber analytics and list analytics, thus enabling you to easily jumpstart on your analysis.
Learn more:
March 27, 2018
New and Improved Google Analytics Integration
We at Zoho Analytics are happy to announce the new version of Google Analytics advanced reporting connector. This new and improved integration allows you to seamlessly import your website data from Google Analytics into Zoho Analytics. It also allows you to create and import custom modules (modules that are created by combining data from selective dimensions and metrics). That apart, we have extended support to data import from E-commerce and Site speed modules.
These improvements will help marketers slice and dice their site's data, analyze key metrics, and make informed decisions in optimizing SEO/SEM campaigns. The new version comes with a refreshed set of pre-built reports and dashboards that will help you jumpstart your analysis.
Note
Henceforth this integration is available only in the paid plans of Zoho Analytics. Users who have set up this integration from a free plan prior to this release can continue to use their existing integration for free. But, if they wish to set up a new integration they will have to upgrade to any of the paid plans.
Learn more about this integration.
Import from Email Attachment
Zoho Analytics now enables you to import data into an existing table from an email attachment. This allows data to be automatically uploaded into a table by just sending an email to a specified email id as an attachment.
This option is available only for Premium and Enterprise plan users.
Support for 'User' module in Zoho Finance apps
Zoho Analytics now supports User module in Zoho Finance apps. From now on, you can import the data from User module either at the time of the setup or by editing the setup.
Feb
Feb 22, 2018
SurveyGizmo Advanced Analytics
We at Zoho Analytics are happy to announce the availability of the SurveyGizmo Advanced Analytics integration. This enables you as an analyst to proactively manage, measure and derive analytical insights from your surveys.
Using this connector you can easily slice and dice your survey responses, derive key metrics and transform them into actionable insights with the power of analytics.
The SurveyGizmo Advanced Analytics comes with a unique set of hand-picked reports and dashboards that enables you to easily jumpstart your analytics.
Jan
Jan 04, 2018
Import Data from Multiple Excel Sheets in a Single Click
Zoho Analytics now allows you to import all the data from your Excel workbook in one go. Earlier, users were allowed to select only one sheet at a time while importing data from an Excel workbook.
From now on, when importing an Excel workbook, you can select multiple sheets at a time to be imported into Zoho Analytics (in Step 2 of the Import Wizard). Each sheet will be stored as an individual table in the Workspace.
Unified Data Sources page to manage all your Data Imports
Zoho Analytics has enhanced the Data Sources page to easily view and manage all the import data sources setup in a Workspace. Earlier this feature listed only the advanced analytics connectors in the Workspace. From now on this page will contain details of all the Import Sources in the Workspace.
You can access this page by clicking the Data Sources button in the Explorer tab of the Workspace.
You can view and manage the data sources from this page by selecting them.
Track Resource Usage and Manage Users of a Workspace
Zoho Analytics allows you to keep a track of the resources that are used at the database level. This feature enables you to monitor and manage the resources used for that particular Workspace.
You can view these details by clicking Settings > Resource Usage.
You can perform operations such as adding, deleting and deactivating a user from the Workspace. Click the Users tab to perform these operations.
Option to Schedule Email on the Last Day of the Month
With this update, you can set schedules to email reports on the last day of the month. Earlier if you had to email a report on the last day of the month, you will either have to select 30 or 31.
Now, you can select the option Last day under the Repeat By section. This will automatically send emails on the last day of the month.
Jan 17, 2018
HubSpot CRM Advanced Analytics
We are happy to announce the general availability of HubSpot CRM Advanced Analytics powered by Zoho Analytics. This integration empowers you with deep sales analytical capabilities and helps you keep track of your Key Sales Performance metrics.
HubSpot CRM Advanced Analytics comes with over 60+ handpicked sales analytics reports and dashboards that you will find of great value. You can also create your own insightful reports to track your sales pipeline, visualize your sales conversion funnels, measure sales team performance, forecast your sales and do much more with ease.
Learn more
Support for Median and Mode Function
You can now apply Median and Mode function over your columns while creating reports.
To apply this,
- Drag and drop the column into the reports designer
- Select Median or Mode function from the drop down as shown in the snapshot
2017
Dec
Dec 5, 2017
Zoho Survey and SurveyMonkey Advanced Analytics
We at Zoho Analytics are happy to announce the availability of the Zoho Survey and SurveyMonkey Advanced Analytics integrations.
These integrations enable you as an analyst to proactively manage, measure and derive analytical insights from your surveys run in Zoho Survey or SurveyMonkey. With Zoho Analytics you can easily slice and dice your survey responses, derive key metrics and transform them into actionable insights with the power of analytics.
These connectors come with a unique set of hand-picked reports and dashboards that enables you to easily jumpstart your analytics.
Zoho Survey Advanced Analytics
SurveyMonkey Advanced Analytics
Show Total As
In Pivot Tables, by default, the summary function used to display the subtotals will be the same as that of the summary function applied on the corresponding data column. With this update you can customize this and apply any other summary functions such as sum, average, min and max on the sub-total and grand total that is displayed.
Nov
Nov 7, 2017
Teamwork Projects Advanced Analytics
We at Zoho Analytics are happy to announce the general availability of Teamwork Projects Advanced Analytics integration. This connector empowers project managers with advanced analytical capabilities thereby giving a greater visibility & control on their project execution.
Users of this application can slice and dice their project data, derive & analyze key project metrics such as project completion rate, resource utilization rate, risk rate and do much more. The connector comes with 50+ hand-picked reports and dashboards organized functionally as Overview, Members/Users, Milestones, Tasks, Risks, and Time-tracking, thus enabling you to easily jumpstart on your analysis.
Read more about the Teamwork Projects - Zoho Analytics integration
Click to learn about:
Nov 29, 2017
Public Announcement: Google AdWords Advanced Analytics
We at Zoho Analytics are happy to announce the general availability of Google AdWords Advanced Analytics integration. This connector provides deeper marketing analytical capabilities for your campaign data in Google AdWords.
Product marketers and SEM analysts can 'slice & dice' their AdWords campaigns data in depth and analyze key performance metrics such as impressions, click rate, conversion rate, cost metrics, growth rate and much more. Not just that, users can blend their marketing data in Google AdWords along with other related data sources such as CRM and perform cross-functional analytics
The connector comes with 80+ handpicked default reports and dashboards organized functionally as Accounts overview, Ad group Performance, Ad Performance, Campaigns Performance and Geo Performance.
Click to learn about:
Oct
Oct 4, 2017
Beta: Zoho Campaigns Advanced Analytics
We at Zoho Analytics are very happy to announce the Beta release of Zoho Campaigns Advanced Analytics connector. The Zoho Campaigns advanced analytics integration powered by Zoho Analytics enables you to easily analyze your email campaigns and derive great insights.
Product marketers and analysts can slice and dice their campaign data and derive key campaign metrics such as campaigns trend, conversion rate, click rate, open rate, unsubscription trend and do much more.
The connector comes with 50+ hand-picked reports and dashboards organized functionally as campaign & email analytics, email domain analytics, subscriber analytics and list analytics, thus enabling you to easily jumpstart on your analysis.
Learn more:
Note
- The Zoho Campaigns Advanced Analytics is currently in public beta testing. Therefore, you may encounter certain functional bugs and limitations.
- This connector is available for testing for all the users in the paid plan.
- If you are a free plan user and wish to evaluate this integration, write to us at support@zohoanalytics.com
Support for Importing OData feeds
Zoho Analytics now extends support to import data from OData feeds. Users can import their data into Zoho Analytics by providing the URL of their OData feed.
Shortened Embed/Permalink URL
The Embed/Permalink URL generated for reports and dashboards using the Publishing option has been shortened such that you can easily share them across channels.
Please do note that the previously generated URL's will continue to work without any glitches.
Oct 12, 2017
Introducing Dynamic Threshold feature for Charts
We at Zoho Analytics are happy to announce the Dynamic Threshold feature. Until now, users could only set a static (constant) value as threshold. With this update, users can apply dynamic functions (value) such as Sum, Avg, Minimum, Maximum over the column in the reference axis or over a different column.
Users can now set the Scope of the threshold to the entire chart or set the threshold value for each data point (cell).
Apart from this, we have also added a new threshold line styles under the formatting option.
Applying Grid Themes at Database level
Recently, we released the Grid themes feature which allows you to customize the look and feel of your Pivot, Summary and Tabular views. This feature enables you to apply colorful and attractive themes over your grid-based views.
To set Grid Themes:
- Open the corresponding reporting database.
- Click the Settings option at the top right corner.
- In the Database Settings tab that opens, click Grid Themes.
Changes in the User Filters interface
We have completely changed the User Interface of the User Filters dialog to enhance the experience. The New UI will allow you to quickly apply the necessary customizations.
Oct 31, 2017
Stripe Subscriptions Advanced Analytics
We at Zoho Analytics are happy to announce the availability of Stripe Subscriptions Advanced Analytics integration. This connector enables you as a business owner to proactively manage and drive your subscription business with deep analytical insights.
With Stripe Subscriptions Advanced Analytics you can slice and dice your subscription data, derive & analyze key SAAS subscription metrics such as revenue, growth rate, churn rate, cancellation rate, customer growth rate and do much more. The connector comes with 75+ hand-picked reports and dashboards organized functionally as Subscription, Churn Analytics, Revenue, and Customer Analytics thus enabling you to easily jumpstart on your analysis.
Click to learn about,
New Edition and Modules Support in QuickBooks Analytics
With this update we have made the following enhancements to Advanced Analytics for QuickBooks Online:
- Support for data import from QuickBooks Online US, UK, IN, CA and AU editions.
- Support for modules such as Tax (Tax Code, Tax Agency, Tax Rate), Budgets and Time Activity
Sep
Sep 7, 2017
Public Release: Microsoft Dynamics CRM Advanced Analytics
We at Zoho Analytics are extremely excited to announce the public release of the Microsoft Dynamics CRM Advanced Analytics connector. This integration empowers you with deep sales analytic capabilities over your data in Microsoft Dynamics CRM. Thereby enabling you to keep track of your Key Sales Performance metrics and optimize your sales execution.
It comes with over 100+ handpicked reports and dashboards that you will find of great value. You can also create your own insightful reports to track your sales pipeline, measure sales team performance, forecast your sales and do much more with ease.
To explore further, please refer to the below links:
Sep 27, 2017
Analytics on the Go: Introducing New Mobile Apps for iPhone and Android phones
We at Zoho Analytics are extremely happy to announce the availability of Zoho Analytics Mobile Apps for both iPhone and Android phones. This is in addition to the already existing apps for iPad and Android tablets.
With the Zoho Analytics Mobile BI app, you can access the reports and dashboards that you create in Zoho Analytics service, on the go.
The Zoho Analytics Mobile BI application provides you with the following capabilities:
Interactive Analytics: Interact and explore reports through an immersive touch experience through actions like drill down, user filters, view underlying data and much more.
Analytics on the go: Analyze the reports and dashboards, keep track of key metrics anytime anywhere from your mobile application.
Easy Access: Easily access and traverse across your reports through visual previews, powerful search and a variety of view categorization options.
Collaborative Analytics: Collaborate with your colleagues by sharing reports and dashboards with fine-grained access control.
You can download the app for free from the Google Play store and the App Store.
Do try it out and share your valuable feedback. Click to learn more.
Aug
Aug 22, 2017 | |
Zoho Desk Advanced AnalyticsWe at Zoho Analytics are happy to announce the general availability of Zoho Desk Advanced Analytics integration. This connector enables Zoho Desk users to easily analyze their help desk data and track their key help desk metrics. The Zoho Desk Advanced Analytics connector comes bundled with over 75+ domain specific default reports & dashboards such as agents' performance, customer analytics, deadline complience, satisfaction rating, and much more. You can also create your own insightful reports & dashboards for in depth analysis. Not just that, if you are a user of Zoho CRM and Zoho Desk, you can combine data from both the domains for cross functional reporting and analysis. Click here to view a sample dashboard created by blending data from Zoho CRM and Zoho Desk. Click to learn more about Zoho Desk Advanced Analytics. Zoho Analytics moves from User based Model to Organization ModelZoho Analytics now allows you to manage your account and collaborate with your colleagues and users with a segregated workspace called Organization. The administrator of the organization is allowed to control the permissions, add/delete the users in his organization and manage the subscription of his organization account. Until now Zoho Analytics has been following a User Based Model where each user will be allocated an individual workspace. From now on, the members of an organization can collaborate and use a shared workspace. Click to learn more about organizations. Powerful Admin Console interface for Zoho Analytics White Label UsersAs you might now, Zoho Analytics offers a powerful Embedded Analytics and White Label Solution for independent software vendors, solution developers, consultants etc., to quickly implement a ready-made BI and analytics solution into their product/service offering. White Label users can now manage their White Label settings through a powerful administrative console from within Zoho Analytics. To access the admin console,
Note The White Label solution of Zoho Analytics is not available for all users by default. It is available to customers only on request. If you are interested in using Zoho Analytics as your White Label Solution or Embedded Analytics Service, write to us at support@zohoanalytics.com |
Aug 30, 2017
Zoho Creator Advanced Analytics
We at Zoho Analytics are extremely thrilled to announce the general availability of the much awaited Zoho Creator Advanced Analytics Integration.
Zoho Analytics Advanced Analytics Add-on for Zoho Creator enables you to easily slice & dice your application data and create insightful reports & dashboards. Users can embed reports and dashboards within your Zoho Creator apps.
Empower your creator applications with deeper analytical capabilities from Zoho Analytics. This integration is available in all the paid plans of Zoho Analytics.
New Modules Support in Xero, Zoho Finance, and ServiceDesk Plus Advanced Analytics connector applications
With this update, we extend to support the following modules in Xero, Zoho Finance applications, and ManageEngine ServiceDesk Plus.
Xero Advanced Analytics
- Journals Cash Basis (in both Accrual and Cash Basis)
- Repeating Invoices and Repeating Bills
- Purchase Orders and Line Items
- Tax Rates
- Overall Budget
Click to view the complete list of modules.
Zoho Finance Advanced Analytics (for Zoho Books and Zoho Invoice apps)
- Vendor Addresses (Zoho Books)
- Customer Addresses (Zoho Books and Zoho Invoice)
- Purchase Receive (Zoho Books)
Click to view the complete list of modules.
ManageEngine ServiceDesk Plus on Premise
- Change Management Module. (Supported from Version 9317)
Jul
Jun
June 1, 2017 | |
Announcing New Charts Visualizations. #MoreVariety - #MoreColors - #MoreImmersive - #MoreModern We at Zoho Analytics are extremely happy to announce the general availability of the brand new version of our charts visualizations. Our new charts brings in more variety, more pleasing & cool color schemes, offers more immersive experience and is built on a more modern technology stack. #MoreVariety: We have now added several new chart types such as Bubble, Packed Bubble, Dial and Bullet to our library, making it more than 30+ charts visualizations to pick from... #MoreColors: Pickup from a wide range of color palettes and customize your charts & pivots to make them look cool & trendy. You can also create your own custom palettes. #MoreImmersive: Indulge into an immersive & exploratory experience with dynamic drill-downs, sleek filters, faster loading, pleasing animations and much more... #MoreModern: New chart visualizations have been built ground-up using the latest web technologies such as HTML 5, Javascript, CSS & SVG making it cooler, faster and lighter. You can also read more on this announcement in our latest blog post. Try the new charts visualizations and let us know what you think about it. We would love to hear your feedback. Also, help us spread the word by tweeting with #VisualizeMore. |
May
May 17, 2017
Homepage - Import Options in a Single Page
The new Zoho Analytics homepage layout will allow you to easily spot all the import options in a single page. Until now, users had to navigate across pages to check out the available import options.
We request you to check out our new layout and share your feedback.
Send Email - Option to Append Email Sent Time
You can now choose to display the exact time when the report was generated in the subject line of the email while emailing reports and dashboards. To use this feature select the option "Append email sent time in subject" in the Email Settings window.
May 09, 2017
Beta Release: Zoho Desk Advanced Analytics Add-on
We at Zoho Analytics are happy to announce the availability of Zoho Desk Advanced Analytics (Beta). This add-on enables Zoho Desk users to easily analyze their help desk data and keep track of their key help desk metrics.
The Zoho Desk Advanced Analytics connector comes bundled with over 75+ domain specific default reports & dashboards such as agents' performance, ticket inflow, satisfaction rating, and much more. Apart from this, you can also create insightful reports & dashboards for indepth analysis.
Note
- The Zoho Desk advanced analytics add-on is currently in public beta testing. Therefore, you may encounter certain functional bugs and limitations.
- This add-on is currently enabled only for customers in the paid plan (Standard and above).
You can quickly review the default reports and dashboards from the Zoho Desk Sample Reporting database.
View Underlying Data Enhancement for Related Tables
So far when you create a report using multiple tables, you will be able to view the underlying data of the tables separately. Zoho Analytics has now enhanced this feature in such a way that when you access the View Underlying Data option, the data from all the related tables will be joined and displayed as a single table. This will be of great use to those who wish to view the joined data in a single shot.
Before this update:
The below screenshot highlights how the data tables used to be listed separately in the View Underlying Data. You need to select each of the table seperately to view the underlying data of that table.
After this update:
By default the View Underlying Data displays the data from the base table joined with the columns from the related table. You can also access the tables individually to view the underlying data.
In the below screenshot the Employee and Related tables (ie.. the Employee and the Department table) is selected by default. If you wish to view the data pertaining to the Department table alone, you can do so by selecting Department from the View Data from dropdown.
While sharing the report you can select the columns that you wish to display under "View Underlying Data" option. Refer Sharing and Collaboration to learn more.
In the user interface, you can also choose to Show/Hide the columns as you wish using the Show/Hide icon as highlighted below.
Click here to learn more about the View Underlying data feature.
May 24, 2017
Improvements in the Lookup Column Feature
We are rolling out a few enhancements to the lookup column feature to further enhance its usability.
Specify data type for lookup column: Users can now change the datatype of the lookup column. Until now, the child column will share the data type of the parent column. With this update, you can set a specific data type for the child column. You can change the data type of the lookup column using the Edit Design option in the table.
Support for Default and Mandatory Values: You can now specify Default and Mandatory values for a lookup column. You can do this using the Edit Design option in the table.
Lookup column over a looked up column: You can now make a looked up column (in the parent table) to also be a lookup column referring to another table (grandparent). This feature was not supported until now.
Behavior change - Action on deleting values in a lookup column: From now on when you create a lookup column, by default no action will be taken on the child column upon deleting the values in the corresponding parent column.
Until now Zoho Analytics provided options to delete the values in the child column when you delete the values in the corresponding parent column. This option has been removed with this update as it was found to be less frequently used and had high performance overhead. For users who have already been using this option, we will continue to support it. However, we would like to emphasize on the fact that "Delete the corresponding values in the child column" option will not be supported for the new lookup columns that you create henceforth.
Apr
Apr 4, 2017
Zoho Finance Analytics expands with support for Zoho Invoice
The Zoho Finance advanced analytics add-on (so far called as Zoho Books Advanced Analytics) gets much more power packed with the Zoho Invoice integration. You can now import your Zoho Invoice organization data into Zoho Analytics for advanced reporting and analysis. Till date, this add-on supported analytics only for Zoho Books. From now on you can import and analyze both your Zoho Books as well as Zoho Invoice modules.
We have plans to support more applications of the Zoho Finance suite in the future.
Renamed Custom Formula to Formula Column
We have renamed the option Custom Formula to Formula Column. The Formula column option adds a new column to your data table, whose values are derived based on the calculation/formula defined. You can define any powerful mathematical formula by invoking Add > FormulaColumn from the table.
Apr 19, 2017
Beta Release: Teamwork Projects Advanced Analytics Add-on
We at Zoho Analytics are very happy to announce the release of Zoho Analytics Advanced Analytics Add-on for Teamwork Projects (Beta). This add-on empowers the users of teamwork app with advanced analytical capabilities thereby giving a greater visibility & control on their project execution.
The Teamwork Advanced Analytics connector comes bundled with over 50+ default reports and dashboards that will help you keep track of your Key Project Metrics. You can also create insightful reports & dashboards over your Teamwork data for indepth project analytics.
Note
- The Teamwork Projects advanced analytics add-on is currently in public beta testing. Therefore, you may encounter certain functional bugs and limitations.
- This add-on is currently enabled only for customers in the paid plan (Standard and above).
Mar
Mar 23, 2017
Microsoft Dynamics CRM Advanced Analytics (Beta)
We at Zoho Analytics are extremely excited to present to you the Microsoft Dynamics CRM advanced analytics add-on (Beta). This add-on empowers you with analytical capabilities over your Microsoft Dynamics CRM data thereby giving you a greater visibility on your Sales data.
The add-on comes with over 100+ handpicked reports and dashboards that you will find of great value. You can also create insightful reports to predict your sales pipeline, know your sales win/loss rate, Top 5/Bottom 5 sales persons and do much more with ease.
To explore further, please refer to the below links:
Microsoft Dynamics CRM Help Document | Microsoft Dynamics CRM Sample Reports
Note
- The Microsoft Dynamics CRM advanced analytics add-on is currently in public beta testing. Therefore, you may encounter certain functional bugs and limitations.
- This add-on is currently enabled only for customers in the paid plan (Standard and above).
New option to Setup Zoho CRM Analytics from Zoho Analytics
You can now setup the Zoho CRM Advanced Analytics Add-on from within the Zoho Analytics interface itself. Till now, this was possible only from the Zoho CRM interface. This feature provides a much easier option for the Zoho Analytics users to setup and manage the integration from within Zoho Analytics.
Watch the below presentation to learn about setting up the Zoho CRM Advanced Analytics Add-on from Zoho Analytics.
Mar 30, 2017
New Packed Bubble Chart type for Zoho Analytics
The Packed Bubble chart type is used to display data in a cluster of circles or bubbles. They are used to display the values disregarding the axes. The difference between a normal bubble chart and a packed bubble is that the latter is tightly packed rather than spread over a grid. You can use a packed bubble chart to visualize large amount of data in a small space.
Please do note that, this chart type is available only as a part of the New Charts feature which is currently in Beta.
Enhanced Chart chooser dialog for Dashboards and Embedded views
We have now revamped our Chart Chooser option for dashboards and Embedded Views. Our new intuitive and smooth Chart Chooser option will help previewing the chart types available and switch between them real fast.
New Edit view option in Explorer
You can now easily edit your reports and dashboards by invoking the Edit option in the contextual menu of the corresponding view in the Explorer. This will directly open the view in the Edit mode real fast, thereby saving few clicks.
Note
- Please do note that this option is not available for tables.
Support to Export upto 3 million cells in Excel file format
You can now export table like views (Pivot, Summary, Tabular View, Tables & Query Tables) with up to 3 million data cells as Excel files. Until now, it was possible only to export up to 1 million cells.
Feb
Feb 23, 2017
Zendesk and MailChimp Analytics - Public Release
We at Zoho Analytics are extremely happy to announce the general release of advanced analytics connectors for Zendesk and MailChimp.
Until now the beta version of these connectors were only available for the paid users of Zoho Analytics. With this general release it is made available for all Zoho Analytics users.
The add-ons are available Free in all paid plans of Zoho Analytics. It is priced at $15 per add-on/month in free edition.
Zendesk Advanced Analytics Add-on - Key Highlights:
- Support managers and technicians can easily analyze the help desk data in Zendesk to track & manage their key help desk metrics.
- Create and analyze reports such as Response & Resolution time, SLA compliance, Agents' performance, NPS score, Satisfaction rating and do much more.
- 75+ pre-built reports and dashboards focussed on help desk analytics, that you will find of great value.
MailChimp Advanced Analytics Add-on - Key Highlights:
- Product marketers and analysts can slice and dice their campaign data in MailChimp to track and manage their key campaign metrics.
- Create and analyse reports such as Open rate, Conversion funnel, Best performing campaigns, Email domain analytics and do much more.
- 50+ pre-built reports and dashboards focussed on marketing analytics, that you will find of great value.
Import Data from popular CRM Solutions using Flatly
Zoho Analytics now allows you to import data from various CRM services using a web automation app called Flatly. You can seamlessly pull data from popular CRM services such as Insightly CRM, Pipedrive and Base CRM into Zoho Analytics for Advanced Sales Analytics.
Jan
Jan 2, 2017
Variable Support for Groups
Zoho Analytics has now enhanced the Variable feature which was introduced recently to setup groups. You can now create variables and map the values to groups. If you have created groups for sharing and collaboration, you can map variable values to them.
To map a variable to a group
- Click the Add User/Group option in the Create New Variable page and select My Groups.
Cloud Databases: Hourly Periodic Import Schedule
Zoho Analytics recently released a very easy and simple approach to import data from Cloud databases. With this update we are supporting hourly periodic schedules to fetch the latest data automatically. The available options are:
- 3 hours
- 6 hours
- 9 hours
- 12 hours
You can set this hourly periodic schedule while setting up the reporting database. Please do note that, this option is available only in the paid plans of Zoho Analytics.
Existing users, who have already setup the reporting database can change the interval using the Edit Setup option. Click to know more.
Check out updates in: 2017 | 2016 | 2015 | 2014 | 2013 | 2012 | 2011 | 2010 | 2009 | 2008 | 2007
2016
Dec
Dec 1, 2016
Public Release: Xero Advanced Analytics Add-on
We at Zoho Analytics are extremely happy to announce the general release of Xero Advanced Analytics Add-on. Till now the beta version of this connector was only available for the paid users of Zoho Analytics. With this general release it is made available for all the Zoho Analytics users.
The Xero add-on is priced at $15/month. This will enable you to import your Xero data into Zoho Analytics, and avail all the features in the Zoho Analytics free plan. This add-on is available free in all the paid plans of Zoho Analytics
Zoho Analytics advanced analytics add-on for Xero enables you to slice and dice your financial data and derive great insights. You can analyze and create reports such as financial overview, bills trend, pending invoices and do much more with Zoho Analytics. You can also combine the data from Xero with the data from other sources/services and do cross functional analytics.
Connect Live with Amazon Redshift Database
We recently released a new and simple method to import data directly from various cloud databases such as Amazon RDS, Amazon Redshift, Microsoft SQL Azure into Zoho Analytics. In addition to that we are introducing a simple and easy method to connect live with your Amazon Redshift database.
In this method data will not be imported from Amazon Redshift and stored in Zoho Analytics. Instead for every report that you create, Zoho Analytics will generate appropriate queries to fetch the required data from Amazon Redshift to show you the report.
Note
- The live connect feature is available only in Zoho Analytics paid plans.
- The feature is currently available only for Amazon Redshift.
Dec 15, 2016
Subtle Changes in the Home page Interface
We have made the following changes in the Zoho Analytics home page.
1. The Create Workspace option has been renamed as Import Your Data to reflect the first step any user would perform upon logging into Zoho Analytics. You can continue importing your data from a wide variety of sources using this option as you used to with the create Workspace option.
2. The search bar in the Zoho Analytics homepage has been made much faster. The search now suggests the database names as you type in making it extremely responsive.
Nov
Nov 7, 2016
A simple approach to import data from Cloud Databases
We are introducing a very simple model to import data stored in your Cloud databases such as Amazon RDS, Amazon Redshift or Microsoft SQL Azure into Zoho Analytics for reporting & analytics. You can setup the import process using a simple setup wizard.
Till now, users had to download and configure the Upload tool to import data from the cloud databases. This new model does not require any software to be installed. You can completely setup and manage the import process from the Zoho Analytics web interface itself. You can also set up periodic schedules to have the latest data updated automatically into Zoho Analytics.
To import the data from the cloud databases, click the Import from Cloud Databases option in the Zoho Analytics homepage.
Click to learn more about importing data from cloud databases.
Important Note
- In case you are already using the Upload tool, we strongly recommend you to use this new simplified import process to fetch your data from the Cloud databases into Zoho Analytics. This model is so easy that it will hardly take a few minutes to import your data into Zoho Analytics.
New Revamped Subscription page
We have completely revamped the interface design of our subscription page. You can now completely manage your subscription including upgrades and downgrades from this page.
Incase you have purchased more than one Zoho Product, you can manage the subscription for all the products from this page.
Nov 18, 2016
Improved Drill Down Feature (Available only in New Charts)
Zoho Analytics now allows you to dynamically select the drill down path from the Zoho Analytics chart interface itself. Earlier, when you define a drill down path, you will be allowed to traverse only through the defined path. Now, the path that you define will be listed along with a wide list of connected columns that you can drill down with.
You can also configure the list of additional columns that are to be listed as a part of the drill down while sharing a chart.
In order to dynamically drill-down, click on the chart area and select Drill Down by.
Note
- This option is available only in the New Charts library which was released for public beta testing recently.
Week Settings at Database Level
You can now update the week settings such as start day of the week, week format and week mode at the database level. All the reports in the database will use this week setting subsequently.
To set this,
- Login to Zoho Analytics
- Open the corresponding Workspace
- Click Settings > General
Note
- This function will not be available if you have switched to the new charting library. We are working on it and will be released soon.
Oct
Oct 7, 2016
Enhancements in User Filters
In continuation with our updates on the user filter feature (Timeline Filter), we have once again come up with a list of enhancements to increase its usability.
In this update the following features have been supported:
1. Highlighting applied filters: This feature automatically highlights the user filter that has been applied on your report/dashboard with a subtle green color. This helps you quickly identify the filter that has been applied.
2. Filter Level Reset: You can now reset a particular user filter that has been applied. To reset individual filters, click the Reset link available on the top of the corresponding filter.
3. Excluding Dashboard Filters: You can now choose to exclude a particular report in a dashboard if you do not want the user filter to be applied on it.
To exclude a report,
- Click the Options icon of the report in the dashboard designer
- Select Exclude Dashboard Filters.
4. Default Value in Timeline Filter: You can now set a default value for the timeline filter too.
To set a value as default,
- Click the Edit icon on your timeline filter
- In the Selected Values list click the Star icon that appears on mouse over to mark the value as default.
5. Timeline Date Column mapping: You can now map a date column to be used for a timeline filter at a report level.
- Click the Options icon of the report in the dashboard designer
- Select the date column from the Mapping Timeline Filter drop-down.
Oct 17, 2016
Introducing the Google AdWords Advanced Analytics Add-on (Beta)
We at Zoho Analytics are extremely excited to present to you the Google AdWords advanced analytics add-on (Beta). This add-on enables you to import your Google AdWords campaign data into Zoho Analytics for powerful reporting and analysis. You can easily create reports to track your key ad campaign metrics such as best performing campaigns, conversion funnel, clicks vs conversion, ad analytics and much more...
Click to learn more about the Google AdWords Advanced Analytics Add-on.
Note
- The Google AdWords advanced analytics add-on is currently in public beta testing. Therefore, you may encounter certain functional bugs and limitations.
- This add-on is currently enabled only for customers in the paid plan (Standard and above).
Custom Fields support in ManageEngine SDP analytics add-on
If you are using the ManageEngine ServiceDesk Plus advanced analytics add-on, you can now import the custom fields available in ServiceDesk Plus account into Zoho Analytics. These custom fields will be automatically fetched upon updating your SDP pack to version 9229 or above.
Click to know more about the ManageEngine Advanced Analytics Add-on.
Sep
Sep 20, 2016
Introducing Variables Feature in Zoho Analytics
Zoho Analytics has introduced a new feature called Variables. Variables are placeholders that helps database administrators/owners to assign dynamic values for individual users of the database.
You can use these variables as a part of the Sharing filter criteria to filter reports dynamically based on the user who has logged in. You can currently use variables in Sharing Filter criteria. We plan to support variables in features such as user filters, formulas etc. very soon.
You can create and manage variables from the Variables tab in the Settings page. Click here to know more.
Support for Bubble Charts
We have introduced a new "Bubble Chart" type into Zoho Analytics charting library. Bubble charts can be really useful if you want to visualize your data highlighting the magnitude/weightage of a data point with sizing. You can use a bubble chart wherever a Scatter plot is used, with scatters points being replaced by bubbles. The size of the bubble will be determined by the data column dropped in the new Size shelf of the Chart designer.
Note:
This chart type is available only in the "New Charts" library which was released for public beta testing recently.
Sep 27, 2016
Beta Announcements
We are extremely happy to announce the Beta releases of two much-awaited integrations with Zoho Analytics.
Note
- As these integrations are currently in public beta testing you may encounter certain functional bugs and limitations.
- This add-on is currently enabled only for customers in the paid plan (Standard and above). We will come up with a pricing plan as a part of the general release.
MailChimp Advanced Analytics Add-on (Beta)
The beta version of Zoho Analytics Advanced Analytics Add-on for MailChimp enables you to easily analyze your email campaigns in MailChimp and derive great insights, with the in-depth reporting and analytical capabilities of Zoho Analytics. Product marketers and analysts can slice & dice their campaigns data, measure and track key campaign metrics and effectively execute their email campaigns.
This add-on comes bundled with over 40+ insightful reports such as campaign conversion funnel, active days of a campaign, customer domain specific analytics etc. that enables you to analyze your data deeper. You can also create your own reports using the easy to use drag and drop interface.
Xero Advanced Analytics Add-on (Beta)
Zoho Analytics provides financial analytical capabilities using its dynamic and robust integrations with Zoho Books and QuickBooks Online. Now, it's time for Xero to join the league.
Zoho Analytics advanced analytics add-on for Xero empowers your financial data and helps you derive great insights. You can create and analyze reports such as financial overview, bill trend, pending invoices and do much more. The Xero Analytics add-on comes with 45+ insightful reports and dashboards that are capable of giving you a greater visibility on your financial data.
Support to Set 'Column Width Ratio' while Exporting as PDF
Zoho Analytics now provides you with options to set the column width ratio while exporting any tabulated report (Pivots, Tabular View and Summary View) as a PDF. You can choose to either export the report with
- Equal width for all columns
- Proportionate width as in the report
Aug
Aug 24, 2016
Chart Chooser Dialog Revamped
In our continued efforts to provide visually rich and powerful chart engine, we recently revamped our entire charting library and announced its public beta. In continuation of that, we have now revamped our Chart Chooser dialog. Our new intuitive and smooth Chart Chooser dialog will help previewing the chart types available and switch between them real fast (with lesser clicks).
This dialog can be invoked using the Other Charts option in the toolbar. Try out and post your feedback!!
Enhanced Formula Editor with Suggestions
Zoho Analytics formula editor has been enhanced to support features such as keyword highlights, suggestions, error messages etc.
In this update the following features have been supported:
- Suggestion: Provides you the possible autofill suggestions as you type in the formula.
- Keyword Highlight: Highlights the keywords in the formula for better readability and understanding of the formulas.
- Warning/Error: Displays intuitive warning or error message in the case of any inaccuracy or error in the formulas.
Jul
Jul 07, 2016
FTP Import Support in Zoho Analytics
Zoho Analytics now supports data imports from your FTP and SFTP servers. This will be extremely beneficial for users who store their data on these servers. Zoho Analytics also allows you to periodically schedule importing of data from your local/remote servers. With this, you can have the latest data synced into Zoho Analytics.
Click here to learn about importing data from a FTP server into Zoho Analytics.
Jul 14, 2016
Announcement: Zoho Analytics Advanced Analytics for Zoho Books and QuickBooks Online
We are extremely happy to announce that Zoho Reports has now released Advanced Analytics Add-on for the two most popular accounting softwares - Zoho Books and QuickBooks Online.
Zoho Analytics offers seamless integration with these two softwares. This add-on empowers you with analytical capabilities over your Zoho Books/QuickBooks data. It also gives you a greater visibility on your financial data and helps you stay on top of the cashflow.
The add-on comes with a set of 75+ pre-packaged reports and dashboards, which you will find useful and valuable. Besides this, you can also create your own reports and dashboards for in depth financial analysis.
Refer to the below links to know more about this advanced analytics add-on
Zoho Books Advanced Analytics (help documentation) | Sample reports and dashboards
QuickBooks Advanced Analytics (help documentation) | Sample reports and dashboards
Jul 27, 2016
Beta Announcement
We are glad to announce the availability of two important features for public beta testing. As these features are in beta, we would love our users to try and share their valuable feedback. You can share your feedback by clicking the Feedback link inside Zoho Analytics.
Visually Beautiful Charts:
We have completely revamped our charting library. Our new charts have been built using the latest client technologies such as HTML 5, Javascript, CSS & SVG. It is visually appealing, fast, light and offers a wide range of customization options. Not to miss we are adding a whole variety of new chart types too...
You can try the new charts (beta) by clicking Try New Charts link present in the top right corner of Zoho Analytics.
Coming Soon in General Release: New chart types, New KPI widgets, New set of customization options and much more...
Zendesk Advanced Analytics Add-on:
The beta version of the Zendesk data connector enables you to view and analyze your helpdesk metrics in Zendesk. You can slice and dice your data and create insightful reports such as active tickets by agents, resolved tickets trend, escalations and do much more
Coming Soon in General Release: More than 50+ sample reports and dashboards.
Note
- Please do note that as these features are currently in beta testing and hence they are subject to behavioral change.
Jun
Jun 23, 2016
Timeline Filter for Dashboards
Zoho Analytics has introduced a new type of user filter named Timeline Filter. This feature allows you to create a common Date/Period user filters that can be applied on all reports in the dashboard. This user filter is different from the other filters, as it is not tightly bound to any (date) column in a table.
With this timeline filter you will be able to setup a common Date/Period user filter independent of the tables on which the reports have been created.When you use the timeline filter in a dashboard, Zoho Analytics will apply the criteria on all reports, matching it with the best possible date column associated with the report. By default, if the report has a date column, it will filter using it. The matching date columns can also be customized. Since this is a common period filter, you can setup only one timeline filter in a dashboard
May
May 5, 2016
Support to Auto Identify Look-up Columns
Zoho Analytics allows you to blend/join data across multiple tables using a special feature called Auto-Join. This feature is enabled when you associate tables through a common look-up column.
Zoho Analytics has now made the process of defining the look up easier. We now support auto identification of columns that can be linked (looked-up) with your existing tables in the same database at the time of import. It just needs a review and confirmation. Click here to know how.
Support for Email Schedules with Default User Filter
Zoho Analytics now allows you to set email schedules by applying the associated default user filters on the reports that are mailed. To apply this feature, select Apply Default User Filter in the Email: Settings dialog.
May 13, 2016
Zoho Analytics API - Client libraries for PHP & GO released
Zoho Reports has now included the API client libraries for the popular PHP and GO languages. This enables developers to easily build/integrate the powerful reporting and analytical capabilities of Zoho Analytics into their PHP or GO applications.
Zoho Analytics already provides client libraries in a variety of popular programming languages like Java, C# and Python. You can learn about Zoho Analytics API from our help documentation.
May 24, 2016
New Settings Page for Workspaces
Zoho Reports has now introduced a new settings page that is specific for each Workspace. You will be able to manage your database preferences from this settings page. With this option, you will be able to configure a wide range of features such as starting day of the week, starting of a financial year, data backup and so on.
To access the settings page, click the Settings button in the Explorer tab of the corresponding Workspace.
Refer to this help documentation to know about the available options.
Apr
Apr 05, 2016
Introducing API Usage Metrics and Pricing
Zoho Analytics now introduces a daily API usage limit in accordance with your pricing plan. Zoho Analytics API usage will be measured based on units consumed and the frequency of API calls. The API usage limit is capped to your pricing plan. You can refer to the below table to know the API usage limit for your plan.
Plan | API Units per Day |
Free | 1,000 units |
Standard | 10,000 units |
Professional | 25,000 units |
Professional Plus | 50,000 units |
Enterprise | 100,000 units |
You can also purchase API units as add-ons. To know more about the usage limit or how it is calculated, refer to this help documentation.
To purchase API units as add-ons:
- Log into Zoho Analytics.
- Click the Subscription link on the top right corner.
- Click Manage your Plan button under your Current Plan tab.
- You can select your API add-on plan from the drop-down menu.
- Click Proceed to make the payment.
Note
- This is applicable only for users who sign-up for Zoho Analytics, starting today. We will be gradually moving the existing users into this new API usage plan.
Apr 13, 2016
Use 'Look-up' Fields in Formula columns
Zoho Analytics now supports 'Look-up' fields in formula columns. Previously, it was not possible to use formulas on a lookup field. You can refer to the Defining lookup section in this help documentation to learn about creating a lookup.
Note
- This functionality will be applicable only if the lookup column has been created with the delete criteria set as No Action on this (child) table.
You can use the lookup field to create both custom and aggregate formulas. Refer to the topic 'Adding Formulas' to learn about creating a formula column.
Full Join Support for Query Tables
Zoho Analytics now supports full join for query tables. The FULL JOIN combines the results of both left and right outer joins.
The joined table will contain all records from both the tables and will fill in 'null' in the case of missing values. You can refer to this video on 'How to create a query table'.
Custom Field Support in Zoho Projects Advanced Analytics Add-on
You can now include the custom fields available in your Zoho Projects portal in the reports that you create in the advanced analytics add-on. These custom fields will be automatically fetched upon the next schedule. Refer Zoho Projects: Advanced Analytics add-on to know more.
Apr 26, 2016
Enhancements in Conditional Formatting
Conditional Formatting in Pivots and Summary Views offers enhanced features like adding/formatting text and icons to highlight your condition in addition to the earlier formatting capabilities. Click to know more.
Wrapping Column Headers in Pivots and Summary Views
Zoho Analytics now allows you wrap lengthy column headers in Pivots and Summary Views. You can use this feature by clicking the Settings button in the toolbar and selecting Wrap Text in Column Headers.
Mar
Mar 2, 2016
KPI Widget Enhancement
Customizing "Null Value" Display:
Zoho Analytics now provides an option to customize the display of unknown values in your widget. You can now customize both the label as well as the value for displaying null values.
Mar 14, 2016
10 Fold Increase in Rows Limit in Free Plan !!
Zoho Analytics now offers 100,000 rows limit to all Free plan users. This is 10x increase from the current limit of 10,000 rows. Existing free plan users can avail this by visiting the Subscription page and following the directions from there on to upgrade their account.
Microsoft Edge Browser Support
In addition to Google Chrome, Firefox, Safari and Internet Explorer, we now support Microsoft Edgebrowser.
Mar 24, 2016
Pivot Enhancements
Display Missing Value Option
Zoho Analytics now supports the Show Missing Values feature for Pivots too. Recently, this feature was introduced in charts. This allows you to view the in-between missing values in your data. This can be applied on a Date or a Category column.
So far when you create a pivot with a date or category column, if a particular category does not have any value, then the Pivot would skip displaying that data. With this new option you can choose to display the record which does not contain a value.
You can apply this function for the columns in both "Rows" and "Columns" shelves. You can also enforce hierarchy on the selected columns. Click to know more.
Mar 30, 2016
Campaign Module Support For Zoho CRM
Zoho Analytics now supports the following modules in Zoho CRM:
- Campaign
- Campaign Lead Status
Existing users can include these modules using the Edit Setup option.
Refer to "Zoho Analytics Advanced Analytics Add-on for Zoho CRM" help documentation to know more about the default fields and formulas that will get synchronized for these modules on setup.
Feb
Feb 25, 2016
Schedule E-mails in your own Time Zone
Zoho Analytics now offers support to schedule emails in your preferred time zone. Previously only Greenwich Mean Time(GMT) was supported.
To schedule an email :
- Open the report/dashboard and click Email>Email this View.
- In the Email as : Settings window that opens, you can set your schedule preferences.
Jan
Jan. 5, 2016
Support to Export/Email Multiple Reports in a HTML Format
Zoho Analytics now supports exporting/emailing multiple reports in a HTML file format. So far these features were only available for a single report.
Now you can export or email multiple views as a single zipped HTML file by clicking Export -> Export Multiple Views -> As HTML (ZIP).
So far this multiple export feature was supported for PDF file format.
Check out updates in: 2017 | 2016 | 2015 | 2014 | 2013 | 2012 | 2011 | 2010 | 2009 | 2008 | 2007
Jan. 8, 2016
Show Involved Columns Option in Reports Designer
Recently there was an update to filter, sort or expand the fields in the reports designer. We have now additionally implemented an option to Show Involved Columns. This will be useful to quickly list only the data fields used in creating a particular report.
Share your Feedback with a Screenshot
We now allow you to take a screenshot of the issue you are facing and attach it, while sharing your valuable feedback to the Zoho Analytics team. This will help us serve you better. To use this feature click on Feedback link in the top right corner and select Capture Screen.
You can click to capture the entire screen or drag to select a section of the screen. With this feature you will be able to
- Zoom-in or Zoom out
- Highlight a particular section
- Blackout a section
2015
Dec
Dec. 22, 2015 | |
Enhancements in DashboardZoho Analytics Dashboard has been enhanced with the following feature. ThemesZoho Analytics now allows you to apply a range of visually appealing themes over your dashboard. By default Zoho Analytics provides six theme layout, which can also be customized as needed. You can choose the required theme by clicking the Themes toolbar option in the Dashboard. You can customize any theme by clicking the Customize option displayed when you mouse over the themes listed. The new themes support will definitely make your dashboards look really appealing. You will find it more handy in case of embedding as you can customize the dashboard to suit your website or application look & feel. KPI Widget Color CustomizationNow Zoho Analytics allows you to customize the display color of the Primary value of the widget, when the value is lesser than zero or greater than or equal to zero. Handy Contextual Options for ReportsZoho Analytics now provides a set of handy contextual options for reports embedded in Dashboard. With these new options that appears on mouse over, you will be able to perform the following operations.
The options will appear to a dashboard viewer/user based on ther permissions granted by the author of the dashboard. Conditional Formatting for Pivot Table and Summary ViewZoho Analytics now provides Conditional Formatting support for Pivot Table and Summary View. This enables in visually highlight data points in your pivot & summary views, thereby enabling to do better and easy analysis. To know how to apply conditional formatting over your Pivot, refer here. |
Nov
Nov. 30, 2015 | |
Enhancements in Query Table Editor Interface:We are introducing a new feature rich query table editor in this update. The salient features of our new query table editor are as follows.
Add Description for Aggregate/Custom Formula:You can now add descriptions for your Aggregate or Custom formulae. These will be pretty useful to add contextual notes about the formula you create. Language Support for Zoho CRM Column NamesFrom now on, if you change the language in Zoho CRM, the column names in Zoho Analytics will automatically get updated after the next synchronization. Inventory Modules for Salesforce CRMWe now support Inventory modules like products, price books, quotes, orders and contracts in Salesforce CRM. |
Oct
Oct. 1, 2015 | |
Support to Auto Format Units of a Numeric ColumnNow Zoho Analytics provides an option to auto format the unit value as thousand (K), million (M) and billion (B) based on the data in the corresponding column. Recently , Zoho Analytics introduced formatting the numeric columns values with thousands (K) or millions (M) or billion (B) unit notations. Now with this 'Auto' option, Zoho Analytics auto detects the data in each record and formats the unit accordingly. This allows the flexiblity of setting the right unit based on the actual value in each row, instead of fixing only particular unit always. |
Oct. 30, 2015 | |
Enhancements in Advanced Analytics for Zoho CRMModule Rename HandlingFrom now on, if you rename a module name in Zoho CRM it will be automatically renamed in Zoho Analytics too. Previously, to get the renaming into Zoho Analytics you need to re-sync the setup. This step is not required anymore. Alert on fields removalNow Zoho Analytics will alert you when removing fields from the integration setup of Zoho CRM. The alert will also display the dependent views/reports that will get deleted on removing the fields. This will help you in deciding whether to delete the fields or to retain them. This alerting feature is also implemented in Salesforce Advanced Analytics add-on. Handy Options in Report DesignerNow Zoho Analytics provides options to expand, sort and filter the fields list in the reports designer. This will be really handy to choose the fields that you want to use while creating the reports. This menu appears when you mouse over the fields list on the left while you are creating the reports. With this new option you will be able to perform the following action.
These option will be available in reports designer. This will also be available in dashboard user filters and KPI widget filters. |
Sep
Sep. 9, 2015 | |
Multiple Groups Support for Sharing & CollaborationZoho Analytics now allows you to create multiple groups to share & collaborate easily in a Workspace. You can group a set of users based on functional roles/needs to create a group. Within this group you could easily share data, reports and dashboards to enable easy collaboration. Email Reports and Views as In-line MailZoho Analytics now allows you to E-mail reports as a in-line mail content. So far reports can be mailed only as an attachment. Now they can be sent as part of the mail content, which will be very easy for users to view them. Goal Module support in Google Analytics data connectorGoogle Analytics Advanced Reporting Add-on now supports syncing Goal data from Google Analytics into Zoho Analytics for reporting & analysis. Support for New FormulasWith this update the following formulas have been supported in Formula Columns.
|
Sep. 11, 2015 | |
Enhanced Upload Tool - Upto 4 times fasterThe new version of Upload Tool supports executing multiple database queries in parallel, thus enabling quicker data uploads from your local databases. This version of upload tool can handle data uploads up to 4 times faster than the previous versions. The previous versions of Upload Tool will execute the database queries configured in database_sql_queries.xml one at a time, pulling data from your local database and uploading the same into Zoho Analytics. In the new version the tool smartly identifies dependencies between the queries configured and looks at parallelizing the execution. The tool considers the following cases as dependent queries:
For the above mentioned cases, queries will be executed sequentially one after the other based on dependency . In all other cases, where there are no dependencies, query execution will be done in parallel, thus enabling faster data uploads. You can download the latest version of the Upload Tool from here. |
Sep. 23, 2015 | |
Charts EnhancementsDisplay Missing Values Now Zoho Analytics provides a new option to include the tick label for the data point, which does not have any value. This is available for both the date and the category columns. So far when you plot a chart with a date or category column, if a particular data point does not have any value, then the chart would skip this from the plotting it in the axis. With this new option you can choose to even display the point which does not contain a corresponding value in your chart. For example if you are plotting a chart for sales across years. If the year 2013 does not have any data, then it will be skipped in the previous version. Now you can choose to display this. This feature will be pretty useful to visualize the complete trend considering all data points. Charts Look and Feel Zoho Analytics has enhanced the Charts look and feel by fine tuning the color effects. Now it sports a more trendy and light look & feel. |
Aug
Aug. 6, 2015 | |
Chart specific Drill Down PathNow Zoho Analytics allows you to set a drill down path for your chart axis from within Charts settings. This enables you to define drill down paths a lot quicker for a chart. You can find this option in Settings section, which allows you to define the complete path in the same dialog. This path is specific to the chart where you are defining it. When you open the Drill down settings, any drill paths paths already defined at the table level will be displayed by default. If you want to define the path globally (i.e., for all charts), then you need to define that for the corresponding columns at the table level. To know more refer this documentation. Create Lookup Columns in Business Application Data ConnectorsIn the databases that you setup using any of the default Business Application Data connectors (like Zoho CRM, Salesforce etc.,) offered by Zoho Analytics, till now you cannot define Lookup columns in the data tables pulled (synchronized) from these applications. Now we support this too. With this option you can combine data sets (using the auto-join feature) across business applications (e.g., combine Zoho CRM Leads data with your Marketing Campaign information that you might have stored Google Drive etc.) and easily do cross functional analytics. |
Aug. 13, 2015 | |
Android App Support for Zoho AnalyticsWe are happy to announce the availability of the Zoho Analytics App for Android Tablets. With this app you can access & interact with all your reports & dashboards in your Zoho Analytics account on the go any time, any where. Groups & Clients Modules support in Zoho Projects and Zoho BugTracker Analytics Add-onThe Advanced Analytics Add-on for Zoho Projects and Zoho BugTracker now supports Groups and the Clients modules. From now on you can synchronize data from these two modules into Zoho Analytics and analyze the same. |
Aug. 24, 2015 | |
Enhancements in KPI WidgetsSupport to Customize the Comparison Indicator Now Zoho Analytics allows you to customize the comparison indicator. Till now the indicators will only be displayed based on the result of comparison between latest and previous value. From now on you will be able set the indicator by choosing what to compare with the given aggregate values. With this you can display the indicator based on various patterns such as comparison between maximum & minimum value and so on. You can also set the indicator by comparing it with a constant value. Support to Customize the Primary Value With this update Zoho Analytics allows you to display dynamic values in the Label & Value component of the KPI widgets. You can do this by specifying the values in a parametrized format. Follow the below given format to specify a parametrized format. ${ColumnName}.LABEL - Refers to the default label of the column used. ${ColumnName}.VALUE - Refers to the corresponding functional value of the column used. ${OPERATION} - Refers to the corresponding Show Value As operation. |
Jul
Jul. 24, 2015 | |
Report specific data formatting optionsZoho Analytics 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. Dashboard PDF Export EnhancementsZoho Analytics 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 RatioThis 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-onSalesforce Advanced Analytics Add-on now supports pulling data from custom modules setup in your Salesforce account into Zoho Analytics. You can add up to five custom modules from Salesforce into Zoho Analytics. Schedule Imports in your own Time ZoneSo far data imports can be scheduled only in GMT time zone. Now Zoho Analytics allows you to set these schedules in your own time zone of preference. New Functions in Query TableZoho Analytics Query Table has now been enhanced with the following new functions.
|
Jun
Jun. 5, 2015 | |
Trash and Restore SupportZoho Analytics now supports to the concept of trash and restore for better handling your deleted views in your Workspace. With this, you can easily restore views deleted accidentally from Trash. You can view all the deleted view list using the Trash option at the bottom left of your navigation tree. You can find the options to restore or delete the view permanently, when you mouse over the views listed under Trash. The views will be maintained in trash for 45 days from the date of deletion. Support to Format Numeric Columns in UnitsNow Zoho Analytics supports formatting the numeric columns in units such as thousands (K), millions (M) and billion (B). This helps to maintain your data more legible as the value increases. Dependency List of a Query TableZoho Analytics now provides an useful option to view the dependency list of any Query Table. With the "Dependency List" option you can view the parent tables ( & query tables) on which the selected Query Table has been created on. You can also view the list of child query tables which have been created over the selected Query Table. In the dependency list, you will also be able view the hierarchy level of each table (or query table) in the dependency list. Level indicates the proximity of the dependency. The lower the level the more direct is the dependency. Dependency list will be a pretty useful feature to facilitate easy management & maintenance of your query tables, especially if you are a power user of query tables. Importing MilliSecond dataFrom now on you will be also able to import millisecond data into your date column in a Zoho Analytics table. |
Jun. 23, 2015 | |
Custom Sorting in Pivot TablesZoho Analytics now allows you to sort the Pivot Table columns in a custom order that you define. Custom sorting was a feature that is already available in Charts, which has been extended to Pivot tables now. You can find the Custom Sort order item under the "Sort" menu in Pivot Tables. Invoking the same will allow you to customize the order in which the values of the columns are to be sorted. Setting the order and applying it will sort the column values accordingly. Support for Date and Time Difference functionZoho Analytics now supports data and time difference functions in both Formula Columns and Query Tables. With this function you will be able to calculate the date and time difference between two date columns based on the unit specified. The supported units are SECOND, MINUTE, HOUR, DAY, WEEK, MONTH, QUARTER, YEAR. For more details refer here. Enhancement to Auto Generated ReportsAuto generated reports in Zoho Analytics has now been enhanced. With the new update you will find new combination of analysis done and reports created automatically. That apart now the reports generated also covers some the valuable features that has been recently introduced into the product. Do give it a try... |
May
May 6, 2015 | |
Advanced Summary Functions support on Aggregate FormulaZoho Analytics now supports applying Advanced Summary Functions (Windowing functions) even over Aggregate Formula while creating reports. So far when you use an Aggregate formula in a report, you will not be able to apply other functions on the formulae. The function will always be selected as 'Actual' and cannot be modified. Now you can apply other windowing calculation such as Running Total, Difference form, Moving Calculation etc., |
May 26, 2015 | |
Support for Inventory Modules in Advanced Analytics for Zoho CRMAdvanced Analytics Add-on for Zoho CRM now supports analytics on inventory modules data. With this, you can configure to synchronize data from the following inventory modules into Zoho Analytics Workspace while setting up the add-on.
Existing users can synchronize the newly supported modules by editing & saving the setup again. You can edit the setup either from Zoho CRM or Zoho Analytics. You can choose to include or exclude the line items (for quotes, invoice, sales order and purchase order) using the Include (module name) Line Items Fields checkbox in. For more details on how to edit setup, refer here. Support to Edit Advanced Analytics for Zoho CRM Setup from within Zoho AnalyticsNow you can edit Advanced Analytics setup from within Zoho Analytics too. To edit setup click CRM Analytics > Edit CRM Setup from the Explorer tab of the Zoho CRM Advanced Analytics database. |
Mar
Mar. 26, 2015 | |
Configurable Join support for report creationZoho Analytics now allows you to choose between Left or Right type join while creating reports (Charts, Pivot Table and Summary View) over related (linked) tables. This option will provide much more flexibility in creating reports. You can find this option in the Table Relationship dialog.
Let's say you have joined Employees (parent table) and Tasks Completed (child) tables through a Lookup column Employee Name. If you want to create a report to show the tasks completed by each employee. Left join will return all employees who have 1 or more completed tasks in their name. Where as Right join will return all employees, including those with no completed tasks at all. |
Jan
Jan. 02, 2015 | |
Copying a TableWith this new feature from Zoho Analytics, you can now save a copy of a table in your database. This feature will be pretty useful for cases like Backup, Copying table design etc. Click 'Save as' menu in the toolbar to save a copy of that table. You can choose to copy the table with data and/or retain the look up columns of the original table. On copying, all formatting, formulas etc. will get retained in the new table. |
Check out updates in: 2017 | 2016 | 2015 | 2014 | 2013 | 2012 | 2011 | 2010 | 2009 | 2008 | 2007
Jan. 12, 2015 | |
Announcing Zoho Analytics 3.0The much awaited Zoho Analytics 3.0 is now here. Zoho Analytics 3.0 is sleek, responsive and feature-packed. The user interface has been completely revamped. Zoho Analytics 3.0 offers an enhanced user experience, designed for power users and beginners alike, to quickly and easily create fabulous reports. New data connectors for popular business applications including Salesforce, Google Analytics & ManageEngine ServiceDesk Plus have been added to the existing robust set of data connectors. Apart from the above, Zoho Analytics 3.0 comes with lot other interesting features like exploratory drill down, KPI Widgets in dashboards, organizing and sharing reports as Slideshows, visualizing and understanding your database models through Model diagrams etc. Watch the video below to find out what's new in Zoho Analytics 3.0. |
2014
Dec
Dec. 03, 2014 | |
Dashboards - Enhancement to View Underlying Data permission controlWhile sharing a dashboard for the permission "View Underlying Data" you could now handpick the columns specifically that you want to share. So far you could only show all the columns or the columns involved in the reports embedded in the dashboard. |
Dec. 08, 2014 | |
Conversion rate in Funnel Charts
Find the above features under 'settings' in chart view. | |
Chart Enhancements
|
Dec. 10, 2014 | |
Advanced Analytics Add-on for ServiceDesk PlusZoho Analytics now provides an advanced analytics add-on for ManageEngine ServiceDesk Plus. With this add-on, SDP customers can create fine-grained reports with easy drag-and-drop actions, without writing database queries. The add-on also comes pre-packed with 80+ useful reports and dashboards. With this add-on you get simplified KPI tracking and analytics for improved decision support in IT service desk operations. |
Nov
Nov. 10, 2014 | |
Multi table support in Aggregate FormulaSo far, aggregate formula could be created with columns only from a single table. But now, you can create an aggregate formula by combining columns from any number of related tables. This will further help you to derive more powerful business metrics in Zoho Analytics.
|
Nov. 20, 2014 | |
Editable User FilterSo far in User filters multiple values could be selected only from the drop-down box. But now, you can also enter the values separated by commas in the highlighted field. Values are case-sensitive and should exactly match the phrase. This feature is enabled only with 'Multi-select box component' in user filters. |
Oct
Oct. 14, 2014 | |
Setting on how to display Null/Empty values in reportsZoho Analytics now provides an option to specify how to display null/empty values in your reports.
|
Oct. 24, 2014 | |
Support to Select a Range of Filter ValuesNow Zoho Analytics allows you to select or unselect a range of filter values using the Shift and click. This will reduce the tedious work of selecting the individual filter values and allows you to select multiple values together. This option is available for Filters and User Filters with Actual Values.
|
Sep
Sept. 2, 2014 | |
Support to Auto Refresh Published and Embedded ViewsZoho Analytics now provides an auto refresh option for the view that you embed or share as Permalink. Now you can set your views to automatically refresh at every N seconds to show latest data. | |
Enhancement in Charts Custom Sort OptionNow Zoho Analytics provides delete option in Charts custom sort dialog to remove the values that are no longer available in the underlying data. |
Sept. 9, 2014 | |
Zoho Analytics Analytics Connector for Salesforce CRMZoho Analytics now provides a connector add-on for Salesforce CRM. Using this, Salesforce users can now 'slice and dice' their CRM data and take informed business decisions. | |
Importing DataSetting up this add-on will sync data from your Salesforce account into Zoho Analytics. Data from the following modules, for which you have read permission, will be imported and stored in tables in Zoho Analytics.
| |
100+ Useful Default ReportsAlong with the Connector Add-on you will get 100+ insightful reports & dashboards. You can always customize them to your needs. | |
Creating your own reportsYou could also create your own custom reports over the Salesforce CRM data easily using the drag & drop interface in Zoho Analytics. You can combine other dataset along with Salesforce CRM data for creating compelling & holistic reports by importing them into Zoho Analytics. For more details on Zoho Analytics Connector Add-on for Salesforce CRM, refer to Help link. |
Sept. 17, 2014 | |
Enhancement in User Filters Component OptionNow Zoho Analytics provides an option to choose between a single select or a multi select drop down list for displaying date related values. Until now date user filter values for Actual, Relative and Seasonal period can be listed only in a multi select drop down list. Now you have the option to choose between single or multi select list box as required. | |
Enhancement for Advanced Analytics Add-on for Zoho CRMAdvanced Analytics Add-on for Zoho CRM now supports analysing your Potential Stage History. You can avail this by selecting the Include Potential Stage History fields checkbox when you setup the Advanced Analytics Add-on. The Potential Stage History data will be added as a new table in Zoho Analytics Workspace. | |
Support to Import XML FormatZoho Analytics now supports importing data from one more important file format, the XML. You can do this by setting the File Type as XML and then upload the XML data in the Import Wizard. | |
Support to Set Parameters for Web URL while Importing Dataorts New 3.0 Interface (which is currently in beta) now provides an option to set Get or Post parameters for the Web URL from which you are importing data. You can set up to 20 parameters for your import URL. |
Aug
Aug. 25, 2014 | |||
Zoho Bugtracker Advanced Analytics Add-onThe Zoho Bugtracker Advanced Analytics Add-on is now available in the service. With this add-on, Zoho Bugtracker users can slice & dice their bugs data to effectively analyze & track their issue management projects. | |||
Importing DataSetting up this add-on will sync data from your Zoho Bugtracker portals into Zoho Analytics.
| |||
50+ Useful Default ReportsAlong with the Connector Add-on you will get 50+ insightful reports & dashboards. You can always customize them to your needs. | |||
Creating your own reportsYou could also create your own custom reports over the bugs information easily using the drag and drop interface in Zoho Analytics. |
Jun
Jun. 6, 2014 | |
Support to Publish with Filter CriteriaZoho Analytics now supports Filter Criteria option while publishing the views. With this feature, you can apply a filter criteria to display the filtered data in your embedded view or published Permalink as needed.
| |
Support to Share FolderNow Zoho Analytics provides an option to share the views in a folder. This will reduce the tedious work of selecting the views from the entire views list available in that database, when you share them.
|
May
May 14, 2014 | |
Enable Reporting for NoSQL DatabasesZoho Analytics now enables you to analyze your data stored in NoSQL databases. You can connect and upload data from the following databases using Upload Tool and apply advanced reporting options in Zoho Analytics over your data.
To know how to upload data from your NoSQL databases, refer to the help section here. We have also tested connecting the following relational databases using Upload Tool through JDBC driver to enable data upload for reporting.
To know how to upload data from your Relational databases, refer to the help section here. | |
Amazon RDSSimilarly, you can now connect to databases hosted in Amazon RDS and upload the same into Zoho Analytics to enable reporting over the same. To know how to upload data from your database in Amazon RDS, refer to the help section here. |
May 27, 2014 | |
Support for Cases Modules in Advanced Analytics Add-on for Zoho CRMAdvanced Analytics Add-on for Zoho CRM now allows you to synchronize data from the Cases modules. With this, you can configure to synchronize data from Cases modules into Zoho Analytics Workspace. This module will be synchronized for all new users setting up the Advanced Analytics Add-on. Existing users can synchronize the newly supported module into Zoho Analytics by saving the setup again. For more details, refer here. | |
Support to view Row Count in DatabasesZoho Analytics now displays the number of rows used in each of your Workspaces. You could view this from the Subscription page, in the Manage Users tab and View by Databases. This will be beneficial in managing your plan usage & upgrades proactively.
|
Apr
Apr. 10, 2014 | |
Enhanced Dashboard User FilterZoho Analytics Dashboard User Filter will now filters tabular data too. So far when you add a user filter for your dashboard, only data from Charts, Pivot Table and Summary View will be filtered. Now Tables, Query Tables and Tabular View included in the dashboard will also be filtered. | |
Query Table Function EnhancementQuery Table now provides Interval support for the following functions. With this you will be able to add or subtract required time interval to your data column.
|
Apr. 22, 2014 | |
Enhancement for Pie and Funnel chartsThe following enhancements are available in the Pie and the Funnel Charts. | |
Multi Y SupportZoho Analytics now offers Multi Y Axes support. With this you will be able to compare data from multiple columns in Pie and Funnel. | |
Customize Data LabelNow you will be able to set whether to display the percent or value as data label over the corresponding section. You could also choose to remove data label.This is available in the Settings option. |
Mar
Mar. 11, 2014 | |
Support for Custom Modules in Advanced Analytics Add-on for Zoho CRMAdvanced Analytics Add-on for Zoho CRM now allows you to synchronize data from your custom modules. With this, you can configure to synchronize data from custom modules into Zoho Analytics for analysis and reporting. | |
Support to Customize Pivot Table and Summary View LayoutZoho Analytics now offers an option to customize the Pivot and the Summary View layout. Now you could choose whether to display index number for the rows. Also you can resize all the columns to a uniform width by setting the default width to the columns. This option is available in the Settings dialog. | |
Support to Sort LegendZoho Analytics now provides option to sort the legend items of a single - Y Axis chart. With this you will be able to set the order to display your legend items. You can avail this from the Chart Sort menu and by clicking the Sort icon available near legend in the Edit Design. |
Mar. 25, 2014 | |
Changes in Advanced Analytics Add-on for Zoho ProjectsSupporting Bugs Module Advanced Analytics Add-on for Zoho Projects now allows you to synchronize data from your Bugs module. Users who have purchased the Bugs module in Zoho Projects, can choose to synchronize data from bugs module into Zoho Analytics for analysis and reporting. Also, we have added 20+ insightful reports & dashboards over Bugs module for your convenience. You can synchronize this by selecting the Bugs checkbox in the Import dialog. You could also choose to add this in the existing Workspace by editing the setup by clicking Zoho Projects Edit setup in the toolbar option. Timesheet Module Timesheet module is no longer a mandatory module to be synchronized. You could choose to include or exclude this from your Workspace as needed. |
Mar. 28, 2014 | |
Account Usage NotificationNow Zoho Analytics allows you to configure mail notifications to monitor your account usage. This will notify you when your account usage crosses the threshold limits you have set for rows and users. This will be beneficial in managing your plan usage & upgrades proactively. |
Feb
Feb. 21, 2014 | |
Support to Import from Cloud Storage/DriveZoho Analytics now allows you to import data from different Cloud Storage/Drive to start with your reports and analysis.
| |
Added Custom FormulaZoho Analytics now supports STR_TO_DATE function for creating custom formula to convert a text column with date into a date column. | |
Enhancement for White Label site Home DashboardThe White Label site home dashboard is been enhanced now. So far, views from a single database alone can be added in the home dashboard. Now you could configure to add views from multiple database as needed. Also, you could configure to display all the shared views of your users in their home dashboard. To get this configured for your White Label site write to us. We will get this done for you. |
Jan
Jan. 24, 2014 | |
Improvements in Lookup ColumnNow Zoho Analytics has enhanced the Lookup column feature by adding a new option to handle parent table data deletion. Setting this option will not delete (retain) the corresponding rows in the child table even when data is deleted in the parent table. Also enabling this option will provide much higher performance in data uploads into this table when compared to others options and hence its highly recommended. From now on this will be the default option. You could enable this option for the existing Lookup Columns using the Edit Lookup Setting option in column right-click menu. | |
Enhancements to Multi-view ExportsThe following convenience options have been added for selecting views in Multi-view Export:
| |
More API SupportsZoho Analytics now supports the following APIs.
|
Check out updates in: 2017 | 2016 | 2015 l 2014 l 2013 | 2012 | 2011 | 2010 | 2009 | 2008 | 2007