Correlated subqueries not supported in Zoho Analytics. This creates huge limitations
Running into a major limitation in Zoho Analytics: correlated subqueries simply don’t work, even in completely standard SQL patterns inside a JOIN. Example: LEFT JOIN "Bills" b
ON d."Id" = b."Deal ID"
AND EXISTS (
SELECT 1
FROM "Bill
Updating Analytical Fields Data
Dear Zoho team, I'm having an issue with the recently added fields in both Analytical Desk and Analytical. How can I generate the data in Analytical when new fields are added? https://analytics.zoho.com/workspace/2436819000000007005/edit/24368190000
OAuth2 Scope Error - Incorrectly defaulting to CRM instead of Analytics.
Hello Zoho Team, I am trying to connect n8n to Zoho Analytics API V2 for a simple automation project. Despite using the correct Analytics-specific scopes, my OAuth handshake is failing with a CRM-related error. The Problem: The authorization screen shows:
local file csv import problem
The issue occurs when I upload a CSV file via Databridge. In the preview, everything looks correct — the values are in the proper columns. However, after clicking Import, the first column becomes empty, and the values from that column appear in a new
Formatting Problem | Export to Zoho Sheet View
When I export data to Zoho Sheet View, ID columns are automatically formatted as scientific notation. Reformatting them to text changes the actual ID values. For example, 6557000335603071 becomes 6557000335603070. I have attached screenshots showing this
FOLDER DISAPPEARED
Hello Zoho Community. I recently found a problem with no explanation: a folder in Zoho Analytics just disappeared, but the tables and SQL sentences still existed, the folder was not deleted. The solution for me in this case was to create a new folder,
sync views to sheet
Im looking to sync my views aka reports in analytics to zoho sheets, when data is updated in analytics it also should be updated in sheets, till now zoho sheets only offer raw data connection and it is not enough as these reports are difficult to re-do
SQL Table slowed to a crawl
Hi all - I seem to have noticed an update. Now whenever I am typing in the script field for the SQL tables there is a huge delay and it is all very slow. This has never been the case for me in over 5 years of using Analytics - I really hope it's fixed
Google Analytics import data inaccurate (as of October 11, 2025)
We have Zoho Analytics connected to GA4 to import daily event data. This has been running without issue for a couple of years. However, a month ago we started noticing discrepancies. All data until October 10 lines up perfectly - October 11 onward is
Error: View is not present in the workspace
When saving a dashboard, user receives a popup with the following error. "View is not present in the workspace" What does this mean or refer to? There is no further insight given.
Cannot Invert Axis for Rankings
Hi there I want to be able to create a ranking graph in Analytics/BI, with 1 at the top of the Y axis, but I am unable to invert the axis. Super simple example in Excel below. Higher rankings need to be higher up on the graph to give the correct visual
Zoho Analytics Automatically Deletes Queries and Reports When a Synced CRM Field Is Removed
We’ve encountered a serious and recurring issue that poses a massive data integrity risk for any Zoho Analytics customer using Zoho CRM integration. When a field is deleted in Zoho CRM — even an unused one — Zoho Analytics automatically deletes every
Dashboard won't save, nor allow me to do a "save as"
For some reason, one of my dashboards won't let me make any modifications to it and save? I get the "do you want to save before closing?' and I say yes and the dialogue box just stays there. I try to do a "save as" right after I open that dashboard and I get the dialogue box that seems to let me name the new dashboard, but it won't let me save. The dialogue box just stays there unless I hit cancel or no. Can you please help? Jamie
ZOHO Reports is not Working !
This error is coming up: Please fix it ASAP. Sorry!! Unable to display this page Sorry, an unexpected error occured when performing this operation. The error has been logged and will be looked into. It would be of great help if you could provide us with additional information using the ''Feedback'' link at the top of this page. 1. The error has been logged and will be looked into. 2. It would be of great help if you could provide us with additional information using the feedback link.
Unknown 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+" conid
Import Hidden Excel Worksheets
Hi All, Seems a bit of a simple one however I have ran into some difficulty, we are wanting to automate the import of our sales data from our Point of Sale system into Zoho Analytics. Due to other complexities the only method that we can achieve this
Calls module deleted on CRM, Sync Failures on Zoho Analytics
Recently the calls and meetings module was removed on crm side. Since it was removed, our zoho analytics sync is resulting in failures. I tried removing calls and meetings from the data sources edit setup menu but neither of them show up. Do I need to
People - Leave Tracker
I need to create a report that contains the leave tracker of the people in Zoho Analytics, but when integrating People I do not see the table with the information.
Connecting Zoho Creator with Zoho Analytics
Hi Team, I am unable to import the data and forms I created in Zoho Creator to Zoho Analytics. However, another organization admin can import the data and forms they created but also cannot import mine. When I try to import from the Zoho Creator datasource,
Tooltip Customization
Hi Team, I have a bar chart that displays the dollar amount in proposals sent, won, and projected to close per month (a bar per metric per month). I have the count of proposals per metric included in the tooltip shelf. When I hover my mouse over the 'Sent'
Zoho Books to Zoho Analytics sync fails consistently every other time
Different values between Google Ads and data in Zoho Analytics
Hi. We've actived the Google Ads integration to Zoho Analytics. However, we see that there are different values in Zoho Analytics if we compare the same data to Google Ads. How is this possible? Is it possible that values are rounded off after they are
Error while importing an excel sheet to Zoho Analyitcs using PHP Library API
We are facing issue when we are trying to upload a csv file to zoho via the api integration (version: "2.1.0"). Organisation ID: 679207784 Workspace ID: 1861560000007540051 View ID: 1861560000020340002 We have already contacted your support and they requested
Date Column Import Failed from MySQL DB
I am trying to import some tables and they all seem to have the same issue with the date format. It is a MySQL 8 DB in DigitalOcean and in the database the date is stored in this format YYYY-MM-DD, However when attempting to import the preview screen
Urgent: Continued Issues with WooCommerce Sync - Need Assistance
I am writing to bring to your attention an ongoing issue I have been facing with the WooCommerce Sync feature in Zoho Analytics. Initially, the integration worked seamlessly during the first import; however, subsequent autosync attempts have consistently
Original transactions Description in Accrual Transaction Data in Analytics
In Accrual Transaction report, in description column, fourmula is transaction no in that line item, instead we need actual description as per that particular transaction like invoice/CN/Payment etc. Can you create a query table for the same ?
How to Hide Previous year months
HI Team I Have created a Line chart for AR balance & Collection for FY 2023-24 monthly basis, but AR amount to be consider as Running total in order to get the closing balance for the month. If i put date filter and restricted only FY 23-24, AR will show
Problem with local database connection to Zoho Analytics On Premise
For days now I have been trying to connect my local database to Zoho Analytics On Premise, but it won't let me. No one from Zoho support has been able to help me, in fact I did connection tests with the cloud version and it allowed me to make the connection,
Issue when running this SQL query in Analytics
Trying to solve for the issue in this query when creating a query table in Analytics. Getting an error message "Encountered AS" in Line 2. SELECT "Completed Jobs - Structure".* WITH RankedData AS ( SELECT "JOB#", "BDM Total Commission Earned", ROW_NUMBER()
Can not open any of the previously created dashboards / charts
Any attempt to access previously created dashboards or even stand alone charts results in Alert Message: "Sorry, an unexpected error occurred when performing this operation. The error has been logged and will be looked into. It would be of great help if you could provide us with additional information using the ''Feedback'' link at the top of this page." Tried to create a new chart - the same result. Access to Tables appears to be unaffected.
Sync with Zoho CRM Not Working
For over 5 hours now the sync with Zoho CRM has not been work - it just remains stuck in 'Sync in Progress'. There is no way to stop or restart the sync. Have verified this is an issue in multiple accounts. Reported the problem hours ago but no response
Alert Message problem on Reports
I see this message when I try to: Filter with the range or dropdown items Enter a value in the search query Try to press reset button on the right Is zoho analytics facing any problems at the moment?
Row exceed limit in Zoho Analytics
Hi, I am generating the reports in Zoho Analytics by syncing the data from the Zoho desk. As soon as I moved to the live plan, the limit was about to be exceeded, though I specifically asked whether I'd face any issue with this, and the presales rep said
Cant export a panel from a public view
Hi! Since yesterday users that access through a public view cant export a panel as a PDF. The option is enable but it loads and loads but nothing happens
Column 'Goal category' missing in data connector between Bing Ads and Zoho Analytics
Hi, I've set up the data connection between Bing Ads and Zoho Analytics. All kind of tables and columns are synchronizing at the moment. However, I am missing the column 'Goal category' to determine what kind of conversion it is. Where can I find this
Zoho Analytics Dashboard - Export to PDF
Hi, I have previously created a number of dashboards that are shared via email as PDF attachments. The PDFs are all exported using the Layout as Dashboard option, generally this has been reliable. The latest dashboard isn't behaving correctly on export,
Creating accounts map
Hello, I have a database of companies (accounts) in ZOHO CRM linked with ZOHO ANALYTICS. I have several informations on them, including Zip Code, adress, etc. I really need to plot them on an interactive map, but i have a problem using Map Charts in analytics
Query That Is NOT A CASE SENSITIVE QUERY
Hi, How do you create a query that is not a case sensitive and will show all data that has the same value from the first word? For Example ================= | ID | Account Name | --------------------------- | 1 | Mike Studio | | 2
Matching dates of 2 columns (fields)
Hello, I want to make a table with the number of visit reports created per person (counted number of visit reports created in a custom module in CRM) and a second column with the target visits (this is filled in a field on a report on each month created
Dashboard Filters Disappeared! -- Resolved
I have Dashboards embedded in several websites via the Embed API. Just today, the filter boxes are no longer showing up. I contact ZoHo support with no answers as of yet. Anyone else?
Next Page