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-doCorrelated 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 "BillGoogle 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 isError: 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.User Filter not selecting All Items
We are encountering 2 issues when using the user filter. When users are trying to search using the filter option, the OK button is grayed out. Users have to unselect or make a change before it filters properly. 2. When filtering and the OK button works,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 visualZoho 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 everyDashboard 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? JamieZOHO 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.Showing ALL missing data
Hi, When I create a chart, I noticed that even when enabling the "show missing values" option, if, let's say, the current time period will not show as "0" on the chart if there's no data (rows) in the table. For example, I have this data: Week 1: 0 rowsIssues with Dashboard Filter and KPI in Zoho Analytics (CAGR)
Hi everyone, I'm trying to build a CAGR (Compound Annual Growth Rate) KPI in Zoho Analytics, but I'm running into some issues with filter synchronization. Here's the scenario: I created two test reports: One that filters results from 2021 to 2025. AnotherUnknown 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+" conidImport 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 thisCalls 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 toPeople - 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 areError 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 requestedDate 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 screenUrgent: 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 consistentlyOriginal 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 showProblem 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 responseAlert 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 saidCant 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 happensColumn '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 thisZoho 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 analyticsQuery 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 | | 2Matching 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 createdDashboard 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?Reports Deleted
Hi Team, I login this morning and saw my Leads Dahsboard showing "View Deleted" on each report. I logged in and checked, Except three reports, each report under "Leads" folder of "Experitest CRM Reports" is deleted. I have like around 15 reports in there. Can you please quickly check what just happened and how can I recover those ? Thanks, HasanChange Report/Dashboard Owner in Zoho Analytics
Need a way to change the ownership of a single report and a dashboard from one user to another.Problema com a API do Analytics Zoho
Estou tentando consumir a API do Analytics Zoho para enviar dados para uma tabela. A ideia é fazer uma rotina que será executada todo os dias para enviar os dados atualizados. Porém quando vou tentar fazer a requisição dentro da minha API, ele retornaNext Page
Access your files securely from anywhere
New to Zoho Recruit?
New to Zoho LandingPage?
Zoho LandingPage Resources
New to Zoho Survey?
New to Zoho Marketing Plus?
Everything you need to run your marketing
New to Zoho Marketing Plus?
Everything you need to run your marketing
New to Zoho CRM Plus?
Deliver unforgettable customer experiences
New to Zoho CRM Plus?
Deliver unforgettable customer experiences
New to Bigin?
Announcements
What's New in Zoho Analytics - November 2025
We're thrilled to announce a significant update focused on expanding your data connectivity, enhancing visualization capabilities, and delivering a more powerful, intuitive, and performant analytics experience. Here’s a look at what’s new. Explore What'sWhat's New in Zoho Analytics - October 2025
Hello Users! We're are back with a fresh set of updates and enhancements to make data analysis faster and more insightful. Take a quick look at what’s new and see how these updates can power up your reports and dashboards. Explore What's New! ExtremeWhat’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,
Most Discussed Topics
Can I use a Standalone CRM Function as the Callback URL For Async Export Data API?
I am creating an export job using this API https://www.zoho.com/analytics/api/v2/bulk-api/export-data-async/create-export/view-id.html There is a "callbackUrl" key in the CONFIG object. I tried copying the URL for a standalone function in CRM which canIs it possible to sync data every 5–10 minutes in Zoho Analytics (CRM or Excel imports)?
Hello Team, I want to know if Zoho Analytics supports near real-time syncing of data from different sources. My requirements: I am importing data from Zoho CRM → Zoho Analytics I also have some datasets maintained in Excel/CSV I want both data sourcesHow to Rank Tables by Row Count in Descending Order
I am trying to understand the consume of lines that grow up so fast in the last week. Is there any way to create a pivot table or query to get TABLE NAME LINES in descending order?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 isPrinting Multi-Page Reports (PDF Export)
Hi, I am moving a report from Google's Looker Studio to Zoho Analytics and trying to reproduce the Looker page by page dashboard editing experience. With Google, what you see is what you get when you print to PDF. But I can't seem to create the same experience
Zoho Developer Community
Zoho Subscriptions Resources
Zoho CRM コンテンツ
-
オンラインヘルプ
-
Webセミナー
-
機能活用動画
-
よくある質問
-
Ebook
-
-
Zoho Campaigns
- Zoho サービスのWebセミナー
その他のサービス コンテンツ
ご検討中の方
Zoho Sprints Resources
New to Zoho TeamInbox?
Zoho TeamInbox Resources
Zoho Books Resources
Zoho Projects Resources
Qntrl Resources
Zoho CRM Plus 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.
Design. Discuss. Deliver.
Zoho Show Resources
Zoho Creator Resources
Nederlandse Hulpbronnen
Zoho Inventory Resources
Zoho CRM Resources
Sticky Posts
What's New in Zoho Analytics - November 2025
We're thrilled to announce a significant update focused on expanding your data connectivity, enhancing visualization capabilities, and delivering a more powerful, intuitive, and performant analytics experience. Here’s a look at what’s new. Explore What'sWhat's New in Zoho Analytics - October 2025
Hello Users! We're are back with a fresh set of updates and enhancements to make data analysis faster and more insightful. Take a quick look at what’s new and see how these updates can power up your reports and dashboards. Explore What's New! ExtremeTip of the Week - Spot Risky Sales with Conditional Formatting
In Zoho Analytics, small tweaks can lead to big insights. One such feature is Conditional formatting based on other columns, your key to instantly spotting where sales success is overshadowed by product returns. Our tip this week shows you how to applyWhat’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.
Top Contributors
Jaivin Joy Eapen
Bhoomi Joshi
Naresh Kumar K K R
Shiva Pranav S
Mikhail Koval