What's New in Zoho Analytics - August 2024

What's New in Zoho Analytics - August 2024

Hello Users!

We are back with the latest updates and enhancements made to Zoho Analytics. Keep reading to learn more about them.

Connect to the data hosted in the cloud without allow-listing the IP addresses

Utilize Zoho Databridge to connect to the data hosted in the cloud. This method is useful for accessing the data in the private network without the need to allowlist the IP addresses. We have also revamped the user interface of the Databases and Datalakes page to establish a connection with the preferred data source seamlessly.

New in-built function for JSON

Extract data from JSON columns from within Zoho Analytics using the new built-in function extract_json().



String data type in report formulas

Zoho Analytics now supports plain text data types in report formulas. This feature is useful for categorizing numeric data values based on conditions, such as performance tracking and segmenting data.


Conditional formatting based on other columns

With the recent update, you can now apply conditional formatting based on other columns used in the pivot table. This enhancement provides more flexibility and makes comparison between the related columns easier.

Dashboards

The following are the enhancements made to the dashboard functionality

Static images and custom icons in KPI widgets

Add custom icons to provide visual cues about the type of information contained in the widget without the need for lengthy descriptions. Using icons in the dashboard enhances visual appeal and grabs the attention of the users.

Copy and paste reports in dashboards

Zoho Analytics allows you to reuse reports and KPI widgets by copying and pasting reports to other tabs in the dashboards. This cuts down the redundant work and saves time recreating similar reports.



Sharing views created by users with admin

Users can share the reports created by them with Administrators. (Until now, this wasn't possible). The views shared by the users will be listed under the Shared Views folder for the administrator, with the name of the user who shared the report.



Add-ons for Zoho CRM and Zoho Books ultimate plans

Users in the Ultimate plan of Zoho CRM, Zoho Books, and Zoho Inventory can purchase additional rows and users from the online store. 

    • Sticky Posts

    • Zoho Analytics in 2024: A look back

      Happy new year to everyone in the Zoho Analytics community! As we welcome 2025, here's a look back of important happenings in 2024.

    • Announcing Zoho Analytics 6.0 Beta!

      We are delighted to open up the next major version, Zoho Analytics 6.0 Beta! The new version comes packed with a wide range of functionalities for all persona, namely business users, data analysts, data engineers, and data scientists. Zoho Analytics team

    • What's New in Zoho Analytics - August 2024

      Hello Users! We are back with the latest updates and enhancements made to Zoho Analytics. Keep reading to learn more about them. Connect to the data hosted in the cloud without allow-listing the IP addresses Utilize Zoho Databridge to connect to the data

    • We are coming to your city! Zoho Analytics Community Meetup

      Hello, business leaders and data enthusiasts! We are delighted to announce that registrations are now open for the ZUG meetups, and we can't wait for you to be a part of them. Our in-house analytics experts are geared up to lead discussions on constructing

    • Zoho Analytics: 2021 Look Back

      As we start a new year in 2022, here's some of our top moments from 2021. Zoho Analytics in 2021

    • Recent Topics

    • Problem with leave API

      Hi, we are unable to add a leave through "Add a Leave API" , we are receiving unauthorized and page doesn't exist. we generated the access token which is working for the other endpoints like "Cancel a leave" and "Get Leave Records", the same access token

    • When Email is sent, automatically have information be stored inside.

      Hi there, I just wanted to know if it was feasible to make it so that when i receive an email to a specific email, all of the information or contents would be filled up inside of leads. This will help me with another side of the process that im working

    • Shopify to Zoho Books Integration

      I have had to go ahead and disable my Shopify integration entirely.  When a Sales Order comes in from Shopify, it lists the shipping charge as a line item with no SKU attached to it.  As you are not able to edit a Sales Orders that comes in from a Marketplace,

    • Enhancing Answer Bot's Capabilities

      Wouldn't it be amazing if the answer bot could directly search for answers in our database, FAQs, articles, etc., without needing to display the entire article? without relying on external tools like ChatGPT This way, it could provide concise and relevant

    • Comment gérer un logo d'entreprise par webinaire ?

      J'organise une série de webinaires avec plusieurs partenaires. Je voudrais que chaque landing page présente le logo de mon entreprise et celui du partenaire avec lequel j'organise ce webinaire. Or je n'ai vu que la possibilité de définir le logo de l'entreprise.

    • Audit Log Export via API

      Hello, Based on the documentation here https://www.zoho.com/crm/developer/docs/api/v7/create-export-audit-log.html I need to specify the scope ZohoCRM.settings.audit_logs.CREATE to create a log export. I've created a Self Client app but when I specify

    • Create custom rollup summary fields in Zoho CRM

      Hello everyone, In Zoho CRM, rollup summary fields have been essential tools for summarizing data across related records and enabling users to gain quick insights without having to jump across modules. Previously, only predefined summary functions were

    • Useful enhancements to Mail Merge in Zoho CRM

      Dear Customers, We hope you're well! We're here with a set of highly anticipated enhancements to the Mail Merge feature in Zoho CRM. Let's go! Mail Merge in Zoho CRM integrates with Zoho Writer to simplify the process of customizing and sharing documents

    • Sandbox for consultants who are helping me develop a report

      Hi. I occasionally need to hire someone who has a Zoho skill I don't have and I need to give them access to my account so they can work. It makes me a bit nervous, but I need them to get a work product done. I set their access as "User" and it turns out

    • Prevent carriage returns / line breaks in multi line fields

      I'm trying to connect Zoho Sheets with Zoho Creator however because some people are using carriage returns in multi-line fields the rows are not being created correctly : The values in A4 and A6 are part of a multi line field that looks to have been split

    • Function went from fine to nonfunctioning without change

      url = "https://www.zohoapis.com/crm/v7/Accounts/" + id + "/Attachments/" + attach_id; file_engage = invokeurl [ url :url type :GET connection:"zoho_attachments" ]; The attach id is grabbed from a file upload field account = zoho.crm.getRecordById("Accounts",id);

    • How to get NSE/BSE Stock Prices in Zoho sheets?

      I've been looking for a function that provides me with the NSE/BSE listed stocks price in Zoho Sheets like GOOGLEFINANCE in Google sheets, but I found none. Please help if there is any way to het stock prices?

    • Setting Up Direct Mail Campaigns

      If I need to set up a 5 step direct mail campaign is that possible? Basically every week I upload names from a CSV to Zoho and then would need to mail them every 45 days for about 6 months. I would want to be able to take names off the list when they say their house is sold or that they don't want to be contacted. I don't necessarily need to have it integrated with click2mail or anything but would at least need to be able to export the file in a CSV/excel for each mailing.  Does anyone know if that's

    • Add and Remove Agents from Departments and Groups in Zoho One

      Hi Zoho Flow Team, We hope you're doing well. Currently, Zoho Flow provides an action to add an agent to a group in zoho one, but there is no action to remove an agent from a group or a department. Another action that we find missing is the option to

    • Zoho Creator HTML Snippet - Can't get list to iterate

      Hi! I'm trying to create an HTML Snippet on a page in Zoho Creator and would like to create an HTML table pulled from a list of time entries that I have in a form. I have successfully pulled the collection of time entries, but the code that I have built

    • How can I create individual records from a subform

      Hi, I am collecting subform data into a Lead record and I need to create individual records for each row associated to the account when it is converted. How can I do this?

    • Custom Extension, create a trigger button in custom module to launch the app, or any workaround

      Hello Have created a custom extension , publish as private, all working But I'm facing an issue For my test I create a button in accounts or Contacts module to launch the app. But how I can handle to create same button in a custom module (not created

    • How do I filter contacts by account parameters?

      Need to filter a contact view according to account parameter, eg account type. Without this filter users are overwhelmed with irrelevant contacts. Workaround is to create a custom 'Contact Type' field but this unbearable duplicity as the information already

    • Connecting Zoho Inventory to ShipStation

      we are looking for someone to help connect via API shipStation with Zoho inventory. Any ideas? Thanks. Uri

    • Moving contacts from one folder to different folder

      I set up two folders. Uploaded CSVs and build my fields according to what I needed. My boss wanted more fields and changed the categories wants different fields added and contacts in one folder moved to the other due to reclassification. How can I do

    • Zoho Projects Currency fields in Deluge script

      I have several functions I've written in Zoho Projects that take one or more currency fields as input parameters (arguments). These functions have been working just fine for months, and I made no changes to any of them. Today (Jan 21, 2025) I noticed

    • How do you handle existing customers/contacts?

      Hi, We just integrated MA 2.0 with our CRM and we chose to only import our existing customers contacts. In MA they are all "Raw leads" by default and we would like to mass update these to a stage called "already customers" but the last default stage "Sales

    • Quick Create popup for Lookup fields, Mailchimp related list and User lookup field!

      Hello everyone,   We have recently introduced some most-requested enhancements. Here are the details: Quick Create popup for Lookup fields When we create a new deal in Bigin, there is an option to create a contact/company right from the Create Deal page.

    • Webinar - Getting Started with Landing Page Marketing | Zoho LandingPage

      Ready to build your first landing page that actually converts? Landing pages are a powerful marketing tool—but only if you know how to use them correctly. In this webinar we’ll dive into everything you need to know about creating landing pages that capture

    • Making the Resolution Tab Mandatory

      Hello Everyone! This edition is here to show you how to make the Resolution mandatory when closing a ticket. The Ticket Resolution tab helps keep a record of the solution provided for the ticket query. The resolution can serve as a quick reference to

    • Automation #6 - Prevent Re-opening of Closed Tickets

      This is a monthly series where we pick some common use cases that have been either discussed or most asked about in our community and explain how they can be achieved using one of the automation capabilities in Zoho Desk. Typically when a customer submits

    • 🔍 How to effectively organize data in a CRM? – My approach and questions for you

      Dear ZOHOssians! While working on organizing data in a CRM, I decided to use the native modules: Leads, Deals, Contacts, and Accounts as a solid foundation for managing processes. However, I’m now exploring the next steps and considering various options

    • Gravity Forms, JSON, Webhooks and Zoho Flow

      I have form that I use to populate a Module in Zoho CRM. When the data is sent back from Gravity Forms, it's sent back in this format (I've cleansed the data for privacy): { 4 : "email@email.com", 5 : "+61999999999", 6 : "emai2l@email.com",

    • Introducing Bot Filtering for Accurate Email Campaign Analytics

      Dear Marketers, We're excited to announce a new feature designed to enhance the accuracy of your email campaign analytics: bot filtering. This feature helps you filter out bot-generated opens and clicks, ensuring your campaign reports reflect genuine

    • Report to see committed stock vs quantities on order with suppliers

      Hello Zoho Community, I am looking for a report in Zoho Books / Inventory that will show the committed stock from sales orders, and show what quantities of the same part are on order from purchase orders. I have found the committed stock details report,

    • Account

      I need to know how the maximum contact records available in my subscription. Also pleas advise the process to increase Contact Records. Also I need someone to contact me, I may need to add users, but need to workout a package that would fit my budge

    • Getter error message Number of statement execution limit exceed Line:(216)

      Hi, this script is giving me error message "Number of statement execution limit exceed Line:(216)". Please advise htmlpage Pay_Period_Details(PayPeriodID,AgentID,ShowPrint,start_range,end_range) displayname = "Pay Period Details" content <%{ /* Get The current Pay Period Record */ Int_Pay_Period_ID = PayPeriodID.toLong(); Current_Pay_Period_Record = Pay_Period[ID == Int_Pay_Period_ID]; Previous_Pay_Period_ID = thisapp.Application.GetPreviousPayPeriodID(Current_Pay_Period_Record.ID); /* Checking Agent

    • API Casing needs consistency in names

      The JSON for an account record looks like this: {"Name": "Name of the Account", "id": "id of the account", "Address": "address of the account" "Owner":{ "name": "Name of Owner", "id": "id of owner", } } It makes no sense that "name" is capitalized in

    • How Can I Easily Access and Manage My GEPCO Online Bill Using Zoho Sheets?

      Hello everyone, I'm looking for an efficient way to access and manage my GEPCO online bills. I've heard that Zoho Sheets can be a powerful tool for organizing and tracking bills, but I'm not sure how to set it up for this specific purpose. Does anyone

    • Newspaper template

      Is there a template that looks like a newspaper or magazine?

    • New in Writer: Enhanced Content Generation and Formatting features

      We are excited to unveil these features that can enhance your content creation and formatting experience. These additions are carefully tailored to boost your productivity and unlock your full content creation potential. Get the scoop on all the fresh

    • Webhook when estimate is refused is not firing

      Hello, I use a workflow through make that sends estimate with zoho books (I paid books and sign). -Those estimates when accepted are firing the webhook that I create in zoho sign (photo 1) -However when refused they are not firing the webhook that I created

    • Transfer contact to a lead.

      Is there a way to transfer a contact from CRM to a lead without having to re enter everything.

    • Form to update a CRM contact field

      Hello I need an help as I am going crazy. I need to create a form where there is a dropdown field with the contacts of Zoho crm (if possible filtered on the base of a field) and where other fields will be be automatically fetched with zoho crm data as

    • Zoho Recruit - Blueprint and ZIA

      If I activate the Blueprint for Jobs in Zoho Recruit, Zia disappears for matching canddiates, why is that?

    • Next Page