Error: Sorry!! Unable to display this page
Is Zoho Analytics down?SELECT with UNION ALL and LIMITS
Hi, I have a query I'm trying to run that has a UNION ALL but I need different limits on each SELECT. See below: (SELECT "Users"."User ID" as "User ID", "Users"."Employee ID" as "Employee ID", "Users"."Role" as "Role", "Users"."First Name" as "First Name", "Users"."Last Name" as "Last Name", "UserProduct"."Product ID" as "Product ID" FROM "Users", "UserProduct" WHERE ("Users"."User ID" = "UserProduct"."User ID" AND "Users"."Role" = 'Child') LIMIT 1 OFFSET 2) UNION ALL (SELECT "Users"."UserSKU Run rate in zoho analytics
How do i create a run ratePlain text column loses leading zero when exported to csv
I have opened using notepad as per this old post https://help.zoho.com/portal/en/community/topic/leading-zero-for-zip-code-disappears and the leading zero is still there. However I cannot access the recommended solution (I guess because the post is soHow to add a Zoho CRM custom upload field as a data source
How do I add a field to Zoho Analytics that displays the uploaded file names? Or it can simply be a true or false if there are files uploaded to that field.Cannot change data type from multi line text to plain text
Hey team, I have a column of data that has values which are no longer than 12 characters in length. There are no blanks. But I cannot change the data type of this from multi line text to plain text. Any ideas how I can force this? Thanks CarlWhich network ports need to be allowerd for Analytics API (Export and Import Data)
Good afternoon, I would like to kindly ask you which ports I need to allow for Auth API and Analytics API (Export and Import Data) Thank you in advance, PetrReport using business_hours function in a query combined with User Filter in pivot table
Hello, I am wanting to create past utilization reports on users based on available hours vs hours logged in timesheets for the same period. I know that I can "hard code" a few queries that will provide specific periods, i.e. 1. Query for Year-To-DatePass value in business_minutes()
Hello there, I would like to use the function business_minutes() and pass data for the start and end of the working time. The times may be different for each data record, so I cannot use a fixed value. How can I do this? Something like this: business_minutes('2023-01-01How to merge two columns into one to create universal user filter on dashboard?
Hello, In Zoho CRM, our Leads and Deals modules are separate (as is normal). In the Leads module there is a field called "Lead Owner", and in the Deals module there is a field called "Deal Owner". For our company, the lead owner and deal owner for theData not flowing properly from Deals (CRM) into Analytics Table
I am trying to sync data from Zoho CRM Deals Module into Zoho Analytics and am having some issues Below is a Test Deal. Under finance information you can see that I have three lines of finance data (3 lines that would go to a customer PO). When this dataQuestions about printing a Summary report to PDF
We have two questions about printing a summary report to a PDF file. Firstly, I see that I can adjust all columns to be a specific width. Are there any options to make one column larger than others? For example, we have a weekly notes report. We printUsing CASE in a Query Table
Hi, I'm trying to use a CASE in a Query table, but I'm unable to do it. It should be as simple as: SELECT "FIELD 1", "FIELD 2" CASE WHEN "FIELD 2" = "CASE1" THEN "ABCD" ELSE "WXYZ" END FROM "Potentials" What am I doing wrong or how could i do it? Thank you very much (I'm new at both sql and zoho reports).Creating custom date ranges in Zoho Analytics report
We want to track our aging inventory based on receipt date. We would like to use a date range not available in the options of Zoho Analytics. We would like to see aged inventory based on receipt date for 3 months or less / 3-6 months / 6-9 months / 9-12Calculate time on the basis of manipulated/custom time values
Hello there, I have the following requirement: I need to set a start time and an end time based on a condition and calculate the duration in between. Example: If condition A is met ---> Start time = <date> 08:00:00 If condition B is met ---> Start timeCompare two tables over time
I would like to know a proper way to compare two tables over a period of time. In the most basic example: I want a bar chart in the following way: In Y-Axis, the count of distinct records from table 1 Also in Y-Axis, I want the same for table 2. In X-AxisTip of the Week: Forecasting with what-if analysis
You make challenging decisions in your business everyday. These decisions, good or bad, determine the future of your business. Good decision-making often involves guess work—you guess the outcome of your actions against various external factors. Wouldn'tHow do I delete some tables from an integrated data source?
Is it possible to delete some tables that I don't need from a particular data source or do I have to delete the entire data source? I do not want to do the latter as I need some tables from it but some are not required.map a key
email = zoho.encryption.urlEncode("email "); workspaceName = zoho.encryption.urlEncode("Book"); viewName = zoho.encryption.urlEncode("Stock_Sum"); paramsMap = Map(); paramsMap.put("ZOHO_ACTION","EXPORT"); paramsMap.put("ZOHO_OUTPUT_FORMAT","JSON"); paramsMap.put("ZOHO_ERROR_FORMAT","JSON");Zohoanalytics : formula to calculate the number of months between two dates
Hi everybody, I have a report on ZohoAnalytics : In the Column "SOCIAL Ancienneté", I want the number of months between two dates (column B and C) Thanks for your helpCan't set the type to Date / Datetime
Why can't I set the type to Date or Datetime?New Features rolled out on October 20, 2023
New Chart Type - Tree Map We're thrilled to announce that Zoho Analytics now supports Tree Map visualization. Tree Map helps you to explore your data hierarchically with ease and uncover trends with precision. Click here to learn more. Chart Styling EnhancementsZOHO API Analytics: Add new record if it not exist, else update row existing
Is possible to add a new record if it does not exist in my table, otherwise update existing record. I'm using ZOHO API Analytics V1. Thanks.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,Filtering table data
Filtering table data enhances data analysis and allows users to focus more on the relevant information for their specific needs and objectives. Watch this video to learn how to filter data.How create a report showing what tasks are scheduled to be done but are not started in a specific duration?
Suppose I have a table with following data: Sample task history table We need a pivot report which shows what are the tasks which were scheduled to be done but are not started in a specific duration. For example, if max allowed delay to start a task is[Blog] Democratize decision-making with powerful data storytelling
Decision makers at all levels, especially C-level executives, mandate hard data before they make their moves—and it’s in this context that data storytelling finds its place and utility. Today, data-driven decision-making isn’t just a buzzword. Rather,[Upcoming Webinar] The blueprint for setting up a data-first organization
In today's data-dominated business landscape, analytics has acquired a critical position across industries—yet the global BI and data analytics adoption rate remains at 26%. This may be because the journey to becoming a fully data-driven organizationGoogle Analytics GA4 - Historical Data?
I am trying to build reports after integration with GA4. The setup seemed simple enough, but event tracking is only going back a couple days per property (30-40 rows each). Has anyone else encountered this, and if so how did you get older data? We'vePossibility of adding "Total" column to Analytics Bar Chart
Look at the image below. What our executive team is looking for is a total count of the certain columns added up. Is this even a possibility? I am aware that a stacked bar chart accomplishes this, however, that is not the format that the executive teamHow use aggregate formula form two table or use IF in Pivot view
I want use in aggregate formula from 2 table But I have this info Modified formula can be associated only to the table "Otwarte z filtrem - Support" and not to the existing table "Agents (Zoho Desk)". Changing associated table is not allowed when editingCalculate different values based on today's date (last 30 days sales, last 60 days sales, lifetime sales...etc)
Hi everyone, I'm looking to obtain something simple like "last 30 days sales", "last 60 days sales" as a value to use it on my pivot table. I'm trying to get the following aggregate values : - Last 30 days sales - Last 60 days sales - Last 90 days salesGet Zoho Analytics Data from the Table by Analytics API
Hello If you are looking for a solution to get the data of Zoho Analytics Data by the API, Please have a look below email = Zoho Analytics Owner Email workspaceName = Zoho Analytics Work Space Name viewName = Table / Report Name Scope will be use:- ZohoAnalytics.data/Trendlines
Trend Lines are used to identify the trend present in your data. Zoho Analytics can plot the past & future trends in your time series or number series data. There are five such models to derive the trend line.Possibility to create pivot view like in excel. KPI
I would like to calculate KPI for employees. I have several goals, each with a different importance, but I would like an example of at least 1. Is it possible to get something like this at Zoho analytics? I have Data Sources form Zoho Desk. I would likeData sources not pulling dates
Recently several data sources pulled from Google Sheets have not been syncing properly and leaving the date column empty. I have tried fixing the formatting for the column to make the format of the date the same between the data in Zoho and the formatCFK file
We tried everything as you said but in our case these files are not supportedAnalytics Sync Stuck In Queue Again
The sync into Zoho Analytics from our AWS tables has been showing as 'In Queue' for a long time again. Last time they had to do something on the backend to get it to work againZoho Analytics access is down or very slow
We've tried various browsers and incognito etc but the Analytics instance we are on clearly has a big problem. Simple reports are taking multiple minutes to open and be viewable in a browser. Other reports and activities like sync are failing entirely.Error sync
Hi, I have an error syncronization. Can I help me? ThanksNext 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 - 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,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 you
Most Discussed Topics
Zoho Analytics - Make text clickable in underlying data
Hi Community, I have a simple sales report based on a Invoice query table. I have included a link on to each invoice on the table and sent the Invoice number URL to the link. This works find in the query table, but when I click underlying data on theIs it possible to create a word cloud chart in ZoHo Analystics?
Hi there, I have a volume of transaction text that I would like to analyse using word cloud (or other approcah to detect and present word frequency in a dataset). For example, I have 50,000 records describing menu items in restaurants. I want to be ableIs it possible to pull the Zoho desk data into Zoho analytics in real time
Hi - I am looking to add more dashboards and reports of Zoho Desk in analytics. I see there is a schedule to pull the data into analytics, but I'm wondering if there is an option to pull the data in real time instead of a specific interval?Missing information data Zoho inventory
there some missing data in Zoho inventory connection. pick list stock counts bin location we have requested it via mail and the support team doesn’t gove feedback. has anyone achieve to get these info or to ask other ya lesZoho 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
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 - 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.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 security
Top Contributors
Jaivin Joy Eapen
Roy Vargis
François Ehret
Mikhail Koval
Jack Stolkin