Getting Error : Report Cannot Be Joined
Looking for some advice. I am getting the following error when trying to join reports in a table view I am trying to Add "DueDate" from the Table "Eagle _Network_DueDates" to a pivot table primarily built on a table titled "Eagle_All_Hours_Report" byZoho Analytics Seems to Forget Zoho Projects Data Structure
I am in a proof of concept with Zoho Projects and Zoho Analytics. Management wants to see how long tasks are with specific users in specific stages of a project. I came up with a query to give us a pseudotable (a view) which would neatly provide thatZIA auf Deutsch?
Wann können wir mit ZIA auf Deutsch rechnen?[Integration Enhancement Update] Supporting Debit Notes data in Zoho Books - Zoho Analytics integration
Dear Customers, We are glad to share that the debit notes data will be supported in Zoho Books - Zoho Analytics integration from 16-January-2023. As debit note is an integral part of invoice module, we will be importing the debit notes data in the Invoice[Product Update] Business apps integration settings edit access to account and organization administrators in Zoho Analytics
Dear Customers, We are glad to share this private beta update! Users with account administrator and organization administrator roles can edit an existing business app integration setting irrespective of the integration owner who configured it in theirDynamic or calculated date ranges
Is it possible to use a calculated or relative date range in Zoho Desk reports? i.e. say "Current time" - 28 days. I'm attempting to report on tickets that have had no activity for a defined period e.g. Dormant tickets would be any active ticker (i.e.Pagination Causing Duplicates
I am using Analytics to pull in data from an API. When I use the pagination protocol provided by the API (offset & limit), it is causing duplicates instead of paginated results (so, as an example, I'd be expecting records 1,2,3,4,5,6,7,8,9,10, but getting[Integration Update] New Authentication Model in Shopify - Zoho Analytics Integration
Dear Shopify integration users, This is an important update from Zoho Analytics. Due to some technical and policy limitations in Shopify - Zoho Analytics integration, we are discontinuing the OAuth based authentication model. From now, Zoho Analyticshow to make separator for thousands?
hi made widget in reports how to make separator for thousands? for example - 1,000 - 1'000 - 1 000Where with a boolean NOT !=
Hi, I have a SELECT which does a SUM() on some column FROM a table, WHERE another column in the table does not equal to a specific string. The NOT is not working and it is still being summed up. I'm trying to SUM up all the payments of invoices that were[Webinar] 2022 - The state of business intelligence
In hyper-competitive markets, modern businesses need to stay dynamic and evolving. That's why many organizations have embraced data-driven decision-making as the fulcrum for accelerated business growth. And this trend is here to stay. Given the rapidProblem with data type
I have a problem with changing a data type from Plain text to number. I need to have a sum of hours spent but because when the database was built Hours Spent column was put as Plain Text instead of as Number. I've tried it in query but I can't convertAggregate formula to get previous months data
Hello, I was wondering if there is a way to write formula to get the data from the previous month? So I would want to get the sum of sales from previous month to use it in the current month. thank you[Blog] Project analytics: 360° insights for successful project delivery
Project management is a key enabler for efficiently managing the volume and velocity of business efforts and delivering ambitious growth rates. With growing data volumes, more project managers are adopting data analytics to make better business decisions.Please add the option to be able to share the Folder with filter creterium
Please add the option to be able to share the folder with filter creterium funktion.Collapse Columns should be added as option
Dear Zoho Team, I miss the option to collapse columns ( see picture). Could you please integrate this option? Ana JevaPicklist History in Reports or Zoho Analytics
Hi there, I am trying to track our Lead-Funnel Stages with a Picklist. While I see the history through the stages I cannot find a way to access the history in reports or Zoho Analytics. is there a way to do this? Thanks, Hannessend Alert to User Groups and not only per Email Id
Dear Team, How can I create an ALER message that will be sent to the specific User Group? We have 40 users who should receive alerts. It's really time consuming to add each email separately for each alert setting. Thank You , Ana JevaReport of the Week - Top N Items in Each Category
This week, let us see how to create a report that lists top 5 in each category. You can apply this in various scenarios such as top selling product in each category, top performing agents in each department, top customers in each region, etc., Let usUser filter contains
Hello, Is it possible to have custom made user filters ? We would like to have a user filter that combines Accounts which are containing a same piece of text in the Account Name. Example of some Account Names: Warehouse 1 Warehouse X Mini Warehouse Westshare folder to user group with filter criteria
Dear Zoho team, Could you include an option to share the folder with filter criteria? Problem: I have many reports in one folder, to save time and use the same filter criteria it would be much more efficient to share the complete folder directly ratherControlling external sharing of zoho analytics data
We face an issue where User A and User B, where both user A and user B are both present in workspace C are not able to share their own reports with each other to collaborate. Zoho support told me today that to allow user A and user B to share data, thenHistorical data - to remain unchanged
Hi I have created comparison funnle charts to show different stages of my B2B sales pipeline. Th charts are based onAdd more values to database variable
Hi, Is there way to add multiple values, perhaps separated by comma in the variable value that is associated to an email address. I understand the work around would be to create a new map value pointing to the same email address. But that would be a bit tedious. Say we have John Doe who can view reports for West and East region. I am assuming currently we have to add two map values. This is not too hard if you just had two map values. What happens if you had 100 product categories and need to mayCollapse groups in a summary view?
How do you collapse group rows in a summary view? Or to collapse a section in a pivot view? Is there anything like a tree control? This would seem like basic functionality for display of grouped data. For example, suppose I have a pivot view with a summaryDate filter
Hello, Our fiscal year is starting in september. I created a chart with filter to start in Y2023 and that it should be possible during the year to see chart results per Month in the new fiscal year. However when I create a dashboard with that chart, itZoho Desk integration - information about time entries whether they have already been invoiced
Hello, we use zoho desk with the zoho books add-on. Thus, the time entries that are marked as billable ("isBillable": true) can be charged with zoho books. Using the Desk API, I can access the information of the time entry I need, so it's definitelyACCOUNTID being "Truncated"
I am using ZOHO Reports in conjunction with ZOHO CRM. When I export the Events table to either and Excel or CSV file, the ACCOUNTID number gets truncated, or rather the last three digits get replaced by 0s in the Excel or CSV. I have attached an example with screen shots. In ZOHO, ACCOUNTID is an 18-digit field (e.g., 917037000000222130). When you exporting it either to Excel or CSV, you see 9.17037E+17 in the Excel/CSV column; when you look at the actual number in the field it is 917037000000222000.Join Tables
Hello Dear Zoho Team, When I want to join two tables from the same source, I get this error that I uploaded in the attachment. It is very important that we join these two tables. How can we fix this problem ? Thank you in advance for your help. KindZoho Desk - Analytics Sync failure
Hello, The synchro between our Desk and Analytics Apps does not work anymore. The error message says: Reason for Sync Failure: The plan for your Zoho Desk account does not support Zoho Analytics integration. Solution: Please upgrade your plan if you wantLinking two tables by value
Hello, I am new with Zoho Analytics and would like to know how could I link two separate report tables/pivot tables? I have pivot views: sales and detailed sales These views has filter OrderNo In sales viewI have OrderNo, totals sale price In detailedDate Field not Populating
Hello when uploading data, the Date columns return with no data at all, the data table has about 6 million rows. I am not sure how to fix this?Date setting
I have my dates all set to USA format (mm/dd/yyyy) for my data imports, but after import Zoho still flips the format to dd/mm/yyyy in my raw data after its imported. How can i stop this from happening?Analytics IP WhiteList
Hello, please, tell my whitelist IP addresses for data center analytics.zoho.jp Thanks[Upcoming Webinar] Retail analytics: Identifying revenue hotspots and optimizing retail operations
Hi there! With the number of individual moving parts involved in the retail value chain, advanced retail analytics has become an integral part of decision making for retailers of all sizes. By transforming raw data into actionable insights, retailersNew Features rolled out on September 15, 2022
Enhancements for Advanced Analytics Connector Advanced Analytics for Zoho Commerce Advanced Analytics for Zoho Finance suites now supports Zoho Commerce too. This helps you to manage your online store effectively and market it with ease. You can also📢 [Blog]: Boost your online store sales with Shopify sales reports
For businesses of all sizes, it’s imperative to keep an eye out for particular sales metrics. Specifically for an online store run on Shopify. What’ll be your Shopify store’s average order value for the next 3 months (or the next 2 quarters? or the nextWeb chart - change fill colour?
Hi I have a web chart which is perfect for what I want to show but I can't see any way to change the colour of the fill from default blue. Am I missing something?Cumulative stacked bar grouped by status
Hello, I did that chart: Its almost what I want, but when I try yo color by status, I got that: So, I'm having trouble to group my status and get a cumulative stackedbar, like that: Any idea how to manage that? Thanks in advance!Alternative to Decomposition Tree in Zoho Analytics
Does Zoho Analytics provide a view/chart that has the ability to drill down across multiple dimensions at once, similar to Power BI's Decomposition Tree? Any suggestions/tips would be appreciated. Thanks!Next 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
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! ExtremeZoho 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 theCRM Related list table in Zoho analytics
In Zoho Analytics, where can I view the tables created from zoho crm related lists? For example, in my Zoho CRM setup, I have added the Product module as a related list in the Lead module, and also the Lead module as a related list in the Product module.Is 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?
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
Naresh Kumar K K R
Sudhakar
Mikhail Koval