Beta Announcement: Zoho Creator Advanced Analytics (Beta)

We at Zoho Analytics are extremely thrilled to announce the beta availability of the much awaited Zoho Creator Advanced Analytics Add-on. 

Zoho Analytics Advanced Analytics Add-on for Zoho Creator enables you to easily slice & dice your application data and create insightful reports & dashboards.  Empower your creator applications with deeper analytical capabilities with this analytics add-on from Zoho Analytics.

Click to learn more.

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.
Refer: Color Palettes | Pivot Themes

#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. 

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.

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.

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.

You can quickly review the default reports and dashboards from the Zoho Desk Sample Reporting database.

Click to learn more.

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.

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.

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.

Click to learn more.

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.

Click here to learn more.

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.

Click to learn more.

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.

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.

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

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.

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.

Click here to know more.

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.

Click here to know more. 

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.

Click here to learn more about using Flatly to import data.

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.

Click to know more.

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.