[UI Update] Mandating New UI for all Zoho Analytics Users
Dear Users, We’re pleased to share that the new and improved Zoho Analytics 6.0 user interface has already been embraced by many users, delivering a faster, cleaner, and more efficient experience. For the Zoho Analytics users who are still using the oldNew User Invite Changes Email Address
Hello, When inviting a new user, I noticed that after I keyed in the email address and sent the invite, that the invite had changed the email address. Is this because the address may have been an alias? This was a gmail based account with a company domain.Controlling Lookup Paths
When building pivot tables, Zoho automatically selects 'lookup paths' for you based on which columns are configured. Sometimes, I want zoho to not use a look-up at all between two tables.... but that doesn't seem to be an option, as long as any relationshipsHow to setup compare with same period last cycle ?
I can easily setup in CRM, but I dont know how to set it up in analytics.Expanded Data Preparation and Modeling Capabilities in Zoho Analytics
Since launch, the integration of Zoho DataPrep within Zoho Analytics, has significantly enhanced the ETL (Extract-Transform-Load) capabilities. This integration allows users to connect, clean, transform, and enrich their data effortlessly—all from withinAccess to what Products are associated with which accounts
Is there a table that can be accessed to report on Products associated with accounts in the CRM?Pivot Sql Query
This query isn't working and I can't understand why. It comes up with the error message "Unknown table or alias 'Source1' used in select query." when it is clearly defined in Line 12. If I remove "Source1." from in front of the columns in the select listCustomer Segmentation using RFM Analysis
How well do you know your customers? Whether you operate in a B2B or B2C space, chances are that 80% of your business comes from just 20% of your customers (Pareto's Principle). According to a study by Forbes, acquiring new customers costs five timesUnknown JSON attribute(s) found in the parameter CONFIG - Error Code 8542 - Facing this while try to update a row in analytics
temp.put("NeedAlyz",NeedAlyz); finalBody = Map(); finalBody.put("columns",temp); //info open+" "+closed+" "+answered+" "+awaitCusRes+" "+wfl+" "+solution+" "+onhold+" "+high+" "+medium + " view id : "+vid+" contact id : "+conid; //info overDue+" conidIt would be very helpful to be able to use variables in the formula columns
Currently, variables can be used only in aggregated formulas. It would be great to be able to use them in regular formulas as wellHow to filter by null values
Is there a way to filter a widget by null? I want to get a list of records that don't have a date filled in and can't seem to see how without going through a query. Is it possible to do it through the widget filters? Thanks.Edit Transformation
How do I edit the transformation of an existing data source? I am trying to Cluster/Merge a column of data. I can't find that option now that the data has been imported.Dynamic Date Filtering for KPI Widgets – Need Help with Query Table
Hello, I'm seeking help with setting up dynamic date filtering for my KPI widgets in Zoho Analytics. Below is an overview of my setup and the issues I'm facing: Why: I need my KPI widgets to update dynamically based on a date range selected via a dashboardConnect to Zoho Reports via MS-SQL Server
Hi there, I have a premises MS-SQL Server and we are trying to get all tables/fields information about our current subscription we have and I wondering how can I connect from my local DB to your ZOHO DB to begin extracting information and combining with different datasets to generate an internal analytic dashboard. What would be the best approach? Or is there any way that I can download report on a weekly basis, if so. How can I generate it? Thanks for your helpColumns language changed
Hello, As you can see in attachment in Zoho analytics some colums of field have change from language to french and some are still in English. We have no idea why but we would like it to be in English all again. how can we do that please ? ThanksAsk Zia to update a number
Hi, Quick question....... Is it possible to use Ask Zia to update a number in a table, for instance if I have a field with $1M and would like that updated to $10M can I do that via Ask Zia? Thanks in advanceDoes funnel chart in Zoho Analytics have an option of deciding the order of the stages of funnel in custom manner?
I want to build a funnel chart for my recruitment process. I have data from Zoho Recruit synced with Analytics. Upon creating the funnel chart with 'Stage' in X-axis and 'distinct count of candidate ID' in Y-axis, I can create a funnel chart. However,User filter in Analytics Report
We have connected Projects to Analytics so we can generate have a dashboard on task progress and completion. I've added a "User Name" user filter, with the intention that we will be able to quickly see tasks per task owner and what the statuses of thoseMissing Custom Fields in ZOHO Reports
Hi, I am currently attempting to generate some reports using the programme. However, I have met some obstacles in the form of missing custom fields from the field selection panel when creating charts etc. Please advise. There are plenty of custom fields which is rather important to creating these reports. Thank you.What's New in Zoho Analytics - March 2025
Hello Users, We're back with the latest set of enhancements and improvements aimed at improving your analytics experience. Common Query Table Expression (CTE) support in Query Tables We’ve added support for Common Table Expressions (CTE) in Query Tables,Conditional formatting - Making negative numbers red
Is it possible to make negative numbers red? Or even better, is it possible to add conditional formatting to cells or to the text?Zoho Analytics and Linked Workspaces
I have a main workspace that contains all of the data for my company. I have need to allow users to build dashboards and reports for their departments, BUT I can't give them access to the main workspace as it contains all the company financial and employeeConnexion Woo / Zoho Analytics . API
Hello, I'm trying to set up the Zoho Analytics and Woocommerce connector but when I enter the user key and the secret key, I get this error message: Error building/reading/writing data. we've changed the path to access the /wp-json/ API to /secu_api/Custom Field in Zoho Projects pulling into Analytics
We have a client that we have built our their new business process using Zoho Projects, and we have build a lot of custom fields with their their Projects where they are capturing specific data points that we want to be able to track and pull data, asHow to Calculate Trimmed Average
How can I calculate a trimmed average by using percentile ranks? I would like to eliminate the top and bottom 5% of my data in order to get a more accurate average. For example, if I have: 1, 2, 3, 4, 5, 6, 7, 8, 9, 10 in my data I want to exclude thePivot report with SUM for months and AVG across months
Hi I am looking to create what I think should be a simple report but I cannot seem to get it right. I have a table filled with Expenses spanning multiples months. I want to create a Pivot report (or something that works) where each month is displayedKPI Widget dashboard select periods
I have a problem with selecting periods as a user filter. In the beste scenario I would like to have to have a period filter like Google Analytics has of Datastudio (see attachment). In the KPI widget I "Group by "inquiry_date" on week&Year". It selectsData refreshed X mins ago
How can I permanently have the "Data refreshed X mins ago" in my dashboards? It would be nice to know how old the data is since the minimum refresh time is every 3 hours. So when you open the dashboard you can immediately see the data is X hours oldTip of the Week - Timeline User Filter for Dashboard
Does the Date User Filter in your Dashboard leave out a few reports from filtering? This happens when the reports are not created over the same table and the (time) column over which the user filter is created. To solve this, Zoho Reports has a Timeline User Filter. This filter applies the criteria on all reports, matching it with the best possible date column associated with a report. i.e., if your reports are based on a date column, then it will filter it for that data column. To know more onMap view - Zoho Analytics
In Zoho Analytics, the Overall Map is duplicating, with the global map appearing twice, which makes it hard to view clearly. Let me know what needs to be doneCombine Small Pie Slices in Pie Chart
Hello, I am trying to make a pie chart showing our sales in each of our product categories. The problem is that we have over 80 product categories, and not that much room from which to look at it. I am wondering if there is a way to combine the smallestMantener visible solamente el primer nivel de la vista dinámica.
Saludos. En esta ocasión ocupo su atención para preguntar de que forma puedo mantener solamente visible el primer nivel de la información colocada en el campo filas de la tabla dinámica y que se visualice únicamente esa etiqueta y su consiguiente sub total. En el caso del ejemplo que adjunto, allí quisiera ver los estados con el sub total de cada uno de ellos. Como siempre, Gracias por su atención. Saludos. Adel Bahsas El Maaz.User Filter for Dynamic Date Dimensions in Zoho Analytics
One challenge I frequently encounter is the need to create multiple versions of the same report—one for yearly data, another for quarterly data, another for monthly, and so on. While this works, it leads to unnecessary duplication, making maintenanceZoho Analytics - Only show certain data labels
How do I only show certain data labels on my charts? I have a combo chart with 3 data bars and 1 data line. I only want to show the data label for the data line, not the data bars. How can I do that?Zoho Analytics - Level on level queries
I am facing a limitation of having too many level on level queries however some of my queries are complex and rely on multiple joins to get my desired output. How can I bypass this limitation as this is hindering my report creation.Create/Update Query Tables through API
We need an API to edit the query tables. Currently if columns are added/removed from a normal table, we have to edit the query tables made on top of that table manually to reflect the changes. We want to automate this task to automatically update theCreate Dashboard with information pulled from multiple modules?
I am looking to create an overview dashboard for each account we have within the CRM. This will need to include information from Books, Bookings, Analytics (want to see the graphs). I am new to using Zoho but am trying to help streamline our processesNeed Marketing specialist for Zoho client
HI, I am looking for someone to help a client with their social media marketing. I have set up Zoho for them, but they want to start various social media campaigns and are looking for a referral. This is for a marketing person who is familiar with ZohoZOHO Reports - Filter Logic?
Hi, I need a way to apply filter logics such as ((1 AND 2) OR 3). All I can see as of now is a way to enter different AND filters in the respective filter column. But how can I add an OR filter? Any advice would be highly appreciated. MarkZoho Analytics - Values gets Duplicated
In Zoho Analytics, I have two tables: one for Country-wise Sales and another for Country-wise Budget with Region. I am attempting to create a stacked bar chart to compare the Region-wise Budget and Sales Revenue. I have set up a lookup between the twoNext Page
New to Zoho Recruit?
Zoho Campaigns Resources
Announcements
What’s New in Zoho Analytics – September 2025
Hello Users!! In this month’s update, we’re raising the bar across multiple touchpoints, from how you bring in data, plan and track projects to how you design and brand your dashboards. We’ve added the all-new Gantt chart for project visualization, expanded[Webinar] The Transformative Power of Gen BI
Traditional decision-making tools are no longer enough. The integration of generative AI into business intelligence (BI) is proving to be a true game changer—enabling businesses to make faster, smarter, and better informed decisions. Early adopters ofUpcoming Change: Snowflake Username/Password Authentication Deprecation – Action Required
Hello Users, Snowflake has officially announced that username and password-based authentication will be deprecated by November 2025. You can find the official announcement [here]. If you're using a Snowflake connection in Zoho Analytics to import data,Zoholics Europe 2025: Your Ultimate Data Analysis (Zoho Analytics) Workshop Experience
Why should you attend? This year, Zoholics Europe 2025 is putting data analysis centre stage. With a dedicated workshop designed to answer all your data-related questions, you’ll gain practical skills, real-time solutions, and expert insights that youAnnouncing Agentic AI - Ask Zia!
We are delighted to roll out the new agentic AI capabilities in Ask Zia, where every stage of the BI workflow is assisted by AI. With a human-in-the-loop approach, Ask Zia ensures that you’re in command of the decision, while AI handles the complexity.
Most Discussed Topics
Two Data Labels in Bar Chart
I need to create a bar chart that has both the SUM and COUNT. I've concatenated them into a formula but it converts it into a stacked bar / scattered chart. The bar chart is no longer accessible. Since i'm comparing YOY, it would be best to have it inA formula that capitalises the first letter of each word
Hi all, is there a zoho formula that can capitalise the first letter of each word in a string? INITCAP only capitalises the first letter of the first word.Aggregating the First Value in the Group By of a dataset
Hi I am trying to get the following Aggregate Formula to work in my chart, but cannot seem to get the right format. I have a series of data that I am running an include_groupby and want to SUM only a column in the first row of each group. So for example.How to Create a YTD vs Last YTD Comparison Report in Zoho Analytics?
Hi everyone, I'm trying to build a report that compares Year-to-Date (YTD) metrics from this year to last year. I’m struggling to get accurate results using custom formulas or aggregate functions. Has anyone successfully created a YTD vs LYTD comparisonHow to parse column having JSON data using SQL?
We have a daily sync from a PostgreSQL database that brings data into Zoho Analytics. Some of the columns store raw JSON data. We need to build SQL queries on top to parse data from JSON and store them in discrete columns. There is no option for "Data
Zoho Subscriptions Resources
Zoho CRM コンテンツ
-
オンラインヘルプ
-
Webセミナー
-
機能活用動画
-
よくある質問
-
Ebook
-
-
Zoho Campaigns
- Zoho サービスのWebセミナー
その他のサービス コンテンツ
ご検討中の方
Zoho Sprints Resources
Zoho Books Resources
Zoho Projects Resources
Zoho Orchestly Resources
Zoho CRM Plus Resources
Zoho WorkDrive Resources
Migrate to Show’s New Community
A place to share, discuss and stay updated about everything relating to Zoho Show presentations.
Get Started. Write Away!
Writer is a powerful online word processor, designed for collaborative work.
Zoho Creator Resources
Zoho CRM Resources
Sticky Posts
What’s New in Zoho Analytics – September 2025
Hello Users!! In this month’s update, we’re raising the bar across multiple touchpoints, from how you bring in data, plan and track projects to how you design and brand your dashboards. We’ve added the all-new Gantt chart for project visualization, expandedAnnouncing Agentic AI - Ask Zia!
We are delighted to roll out the new agentic AI capabilities in Ask Zia, where every stage of the BI workflow is assisted by AI. With a human-in-the-loop approach, Ask Zia ensures that you’re in command of the decision, while AI handles the complexity.Invitation-Based User Access in Zoho Analytics
Hello everyone, We’re rolling out an important update on how users are added to your Zoho Analytics Organization and Workspaces. Previously, when admins added users, they were automatically added to the organization. Moving forward, to improve securityZoholics Europe 2025: Your Ultimate Data Analysis (Zoho Analytics) Workshop Experience
Why should you attend? This year, Zoholics Europe 2025 is putting data analysis centre stage. With a dedicated workshop designed to answer all your data-related questions, you’ll gain practical skills, real-time solutions, and expert insights that you[Webinar] Evolving BI & Analytics in the Age of AI
Artificial intelligence is redefining how data is collected, analyzed, and leveraged across industries. As businesses strive to become more agile and insight-driven, traditional BI and analytics must transform to meet new demands. AI-first organizations
Top Contributors
Naresh Kumar K K R
Anitha Rajesh Kumar
Mikhail Koval
Jaivin Joy Eapen
Jamila