Zoho Reports v3 API
Hello I think I posted this question in the wrong forum!, so apologies for re-post. I see that Reports v3 has an enhanced API to allow column add/rename/delete. The questions I have are:- 1. The API documentation doesn't yet cover these new endpoints, when will the documentation be updated? It would be useful to see the details of these. 2. Having the ability to create a table would provide a more complete solution to table management, so that a data upload can be fully automated. Is that a likelyPDF Include Options and Formatting using API bulk export
Hi all, I am successfully calling to export a dashboard from our Analytics workspace using the Analytics API from within a CRM function, however I have come across the following issues that we want to address: Include either: a custom header which displaysCOMMON_INTERNAL_SERVER_ERROR
Hello, I am getting error one send post request via python( ) to Zoho analytics, the error is COMMON_INTERNAL_SERVER_ERROR. how to fix it? ***I don't want to use the SDK package** error: {"status":"failure","summary":"COMMON_INTERNAL_SERVER_ERROR","data":{"errorCode":7005,"errorMessage":"Sorry,Date format
Hello, I'm importing a CSV, and all works fine except that i cannot get the datetime format right! My datetime field values look like the following: 2012-03-28T00:00:00Z and 2012-03-28T16:11:36Z Could anyone advise what date format template I might be able to use to import that as a date field? I've tried yyyy-MM-ddThh:mm:ssZ and similar, and the preview looks good but on selecting "ok" i get the error "Invalid date format string found.". Any help would be appreciated. Thanks."Weird" date format: how to handle it?
I get data from a JSON feed that has a date format that I can't make it work with Zoho Analytics. 2018-11-28T14:34:07-02:00 I tried the format: yyyy-MM-ddTHH:mm:ssZ and it won't accept because of that "T". If I do not put the "T" it gives an error. yyyy-MM-ddHow can I delete my last data import on Zoho Analytics?
I recently uploaded the same excel file twice and need to delete the duplicate data. Is there an easy way to delete my last import?How to get the business days between today and target date
I have a table [Calendar], with columns Calendar Date and Business Day (1 represents a working day, 0 represents a holiday). Now, I have another table [aaa_file] with the column Target Date. How can I calculate the number of working days from today toDuplicates
Is there a way to highlight duplicates in a report duplicates? e.g., using conditional formatting. We do not do manual import. We auto-import data from Zoho Desk Thanks RudyWidget with text value
Hi! I have a list of names and I want a widget that will show me the name I filter with. Like logo, since the dashboard is dynamic, I want that each time I change the filter, the widget will show the relevant name. Is that possible?Question about Data Retention in Zoho Analytics after Importing
Hello everyone, I'm currently working with Zoho Analytics and encountered a query that I hope this community can help me with. When importing data into Zoho Analytics, there's an option for "Cleanup" which allows selection of the data's age. I have twoZoho Much Slower Than Usual
Hi Zoho Team Over the last 3-4 weeks I have noticed a major slowdown with Zoho's speed using dashboards, and also when trying to import data and edit graphs. Is this a problem other accounts are experiencing, or am I having a unique problem? I have performedZoom in on Maps
Hi Appreciate that the Maps are still on beta testing We're based in the UK and we have added the latitude and longitude to a trial report. We get the data we would expect back but the Zoom feature does not allow us to zoom far enough in to make use ofExport Zoho Analytics Chart with API in Deluge
Hello, Has anyone tried to export a Chart from Zoho Analytic with the API in Deluge? We were trying and we think we have to convert the response because we are getting a lot of characters instead of the image.Slideshow from Zoho Analytics no longer displaying on TV screens
Hello. I hope you can help. We use the Analytics module to general company dashboards that are displayed on smart Tv's throughout the company. We have found recently, that they are no longer displaying when the browser on the TV goes to the URL of theNew Features rolled out on April, 2024
Sunburst Chart We're thrilled to announce that Zoho Analytics now supports the Sunburst Chart. Explore the power of hierarchical data with our sleek and intuitive Sunburst Chart and uncover trends with precision. This dynamic chart visualization transformsSolution of the Week : Consolidated Balance Sheet for Multiple Organizations with different base currencies
In the previous solution, we discussed in detail about creating a Multiple Organizations Setup with the same base currency. In this solution, we will be addressing the process of creating consolidated financial reports, such as a Balance sheet, for multiplebusiness_hours() with holiday list
Hello there, I would like to calculate the time between two dates, taking into account working hours, public holidays and weekends. There is the function business_hours() in Analytics, but there is no option to pass a list of holidays. Does anyone haveChart showing the running total per Geography per month
I want to create a chart in Zoho Analytics that displays the running total of the growth of the leads per month in 2024, grouped by Geography. However, I only seem to be getting the number of leads per geography that were added per month, not the totalRemoving null values
Hi I'm making a running total in pivot view usign zoho analytics with time as a field variable. The problem is, the time coloumn has multiple null values which I want to filter out. However, I can not filter Null values or unknown values from a coloumnHow to deal with accented characters
I am trying to import data into Zoho Analytics. Some of the words are in French using accented characters, such as Montréal, but when I import them, they import as Montr�al. Does anyone know what I need to do to import the data and support the accentedExecute Query working / View Mode shows different value
Hello, We have a snapshot setup and I'm trying to return the next to last snapshot id where the data column is set to 'good' The Table: Snapshot Id Data 3 Good 2 Bad 1 Good So 3 is the newest snapshot, and I'm trying to find 1 When I run the followingRunning total calculated in user filter
Hi I have a problem in zoho analytics with the running total. I want to have a running total each month of the users data. However, I want to be able to only show parts of the running total and still get the correct values. When applying a time user filterHow to divide values from two different tables to create a ratio in a dashboard
Hi there, My name is Carolina and I tried to search on the community and online how to do a simple division in a dashboard, but I couldn't find an answer for that. For example: What I need to do is divide the Total Installations (134) by Total AppointmentsMerging Cells
I wonder if someone could help me with this problem? I have looked through the forums and noticed that someone posted the same question as I'm about to last year, but it was not answered. OK....I have created a table with three columns and a number of rows. I would like to merge cells but can't seem to find a way to do it. Can anyone help with this?"Temporary Error" in Zoho CRM Data Source sync
I edited my setup for the Zoho CRM to Zoho Analytics Data Source Import configuration to add some new fields. After I saved the changes, I clicked the (Sync Now) link. After a few minutes I got a Sync failure error. The only reason given is "A temporaryMerging Tickets in Desk => Bad Data in Analytics
Curious to know if anybody has experienced this issue when dealing with Desk to Analytics integration: 1. You have two duplicate tickets in Desk so you decide to merge them (in Desk). 2. The ticket that was deleted during the merge is obviously no longerUsing Zoho API to update IP addresses to control access to Zoho Analytics views/dashboards
We are using IP restrictions to control access to Zoho Analytics views and dashboards. It would be very helpful to be able to add/remove allowed IP addresses via API.Synchronization between Zoho Analytics and Zoho Desk not working anymore
Since last Friday, our synchronization between Zoho Analytics and Zoho Desk keeps on failing.. How can I solve this problem?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,What does it mean the letter X in Zoho Analytics
I am translating a document about the use of dashboards in Zoho Analytics , and I found these sentences : Tap any where to select corresponding X entries Tap on X-axis label to select all entries for the X Swipe down to filter all data points for anyCreating a bar chart to compare positives for 2 different yes/no fields
Here's the goal: We have multiple fields that are simple Yes/No in our Deals. I want to produce a bar chart with the number of YES for 2 of those fields. As 2 bars. i.e. X=21 Y=7 Something simple like that I currently do them from a pivot table in ExcelAnalytics Down?
Is anyone else having problems with accessing analytics.zoho.com website?Email schedule on specific date
Hi How can I schedule an email report to be sent out at a specific date and time? I don't want to send using the intervals being offered (daily/weekly etc) but rather only once on a future date. ThanksDerived table in zoho analytics
Hi Is it possible to make a derived table also known as a subquery in the from clause. Because I keep getting an error?Day 10 of Sync failure between desk & analytics...
I'm going on day 10 of "temporary" sync failures between zoho desk & zoho analytics. I have deleted the integration (which deletes the table and makes all the reports and dashboards useless) and re-added it. Both times it works for the first sync thenCustomer connect: How Market Dojo drives business growth with 360° insights
According to McKinsey, businesses integrating diverse data sources make decisions five times more faster than competitors. In our upcoming webinar, we're excited to converse with Market Dojo, a UK-based SaaS company built for procurement professionals,Request for Assistance in Importing Full Data from Xero to Zoho Analytics
Hello Team, I hope this message finds you well. I am writing to seek assistance with an issue I am encountering while trying to import data from Xero into Zoho Analytics. Specifically, I need to import data spanning the last 5 to 10 years. However, ZohoDate Last Modified
How does one set up a field to automatically record the time and date that its row was last modified?How can I use DATEDIFF in ZohoAnalytics for query?
Hey, Which function do I need to use that Zoho SQL will understand? I have used DATEDIFF and I can see that Zoho can't understand it, then I tried this date_diff(), and also no changes. Best regards, VladimirMonthly Average in a Summary Report (exlcude weeks with zero count)
Hi, I am trying to figure out how to get a monthly average on my attendance of unique ids (pco_id) that have checked in. If you look at May, it says there are 2 weeks in May and our average is 30, but we did not meet one of the weeks, and the 30 is notNext 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 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 "DataAdd Analytics function for Title case (capitalising each word in a string)
At present, you can only capitalise each word in a string in Analytics during data import. It would be really useful to be able to do this with a formula column, but there is no Title Case function.
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
Anitha Rajesh Kumar
Naresh Kumar K K R
Mikhail Koval
Jaivin Joy Eapen
Jamila