Timesheet Entries Have no Project Group
I have a Pivot View Report that I'm using for a weekly report, our Projects in Zoho projects are split into different groups, this report is summarising the total number of hours that have been booked against Project Groups. I have identified that thereNew Features rolled out on December 21, 2023
Advanced Analytics for Typeform Zoho Analytics provides you with sophisticated reporting and analytical capabilities, over the data you collect using Typeform. Zoho Analytics provides comprehensive insights, allowing you to analyze survey responses, customerZoho Analytics - Crossed report from « potential » CRM module and Zoho Books (Estimate)
Hey everyone ! I would like to generate a report on Zoho Analytics including Potential module informations and books informations. Actually, i had made an integration with books and CRM (via Zoho Finance) So, i only create estimates in potential module.Zoho Analytics Jotform Data Integration
Hi, I find this newly released tool to be a little bit frustrating. I have a multi option answer field in Jotform. It allows users to pick multiple answers (up to 40) to the question. When this goes into Jotform, they are semi-colon separated (as expected)Monitoring the Customer Satisfaction of an E-commerce Platform
Ensuring customer satisfaction is the cornerstone of a thriving E-commerce platform. Effective strategies and tools for monitoring the customer experience on an E-commerce platform has become very crucial in today's businesses. Watch this video to knowReport of the Week - Warehouse wise Inventory Aging Report over Finance Data
Slow moving stocks may lead to issues like expiry (in case of food items), obsolescence, and high holding costs. That's why you need the Inventory Aging Report. It helps you maintain a healthy business by tracking how quickly your inventory moves. ItOriginal 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 can I allow my users to choose a currency for a dashboard?
We have created a revenue dashboard with many charts for displaying various looks at historical revenue. The dataset hosts 3 different currency fields reflecting our global footprint. Typically, revenue is used as the y-axis in the collection of charts.Sum - Running Total
I am having trouble creating a nice "Running Total" graph in Zoho Analytics. The problem is the source data doesn't necessarily have an entry for each month. The code below is how I create a Query Table which I use for the Graph. But for example theyNeed Help with Generating a Report
I have 3 fields in the table. Field 1 is "product type" , Field 2 is "purchase value", Field 3 is "Purchase Date". Example Values Product Type Purchase Value Purchase Date Fruits 300 10/12/23 toys 200 10/12/23 fruits 50 11/12/23 toys 100 11/12/23 fruitsWeek to Date Reporting
Hi, Just a quick one, was wondering if there was any way in which you could do week to date reporting but also use past weeks data the same, What we're looking for is basically something along the lines of a report that on a Thursday would should theMerging multiple data tables
Hello, I have 2 data tables that I need to merge and present a unique table or report. Problem is that tables don't have the same number of columns, and some column are common to both table. I don't see how I can achieve that. I thought about using UNION,Monitoring the Marketing Performance of an E-commerce Platform
In the fast-paced realm of E-commerce, tracking and enhancing marketing performance is crucial for achieving competitive advantage. Watch this video to know about critical aspects of monitoring marketing strategies.Count_if doest not work properly if there is a quote in string
I am trying to count certain strings in a column but the formula breaks if the string has quotes. here is the code I used. count_if("column"."table" like '%I don't live here%') the single quote in the string is breaking the code and the formula doesn'tHow can I remove duplicate entries in my Zoho Report?
I have a large database (of 80,000 records) and one of the columns contains duplicate values. How can I identify and remove these duplicate values? It's important that duplicates are identified in column "A" only. Thanks in advance.2023 rundown: 40 key features in 40 minutes
2023 brought with it a range of game-changing trends in data and analytics—encompassing transformative capabilities in generative AI, advanced visualization, automated data preparation, and more. Heading into next year, our team at Zoho Analytics remainsGet the User Filter value in the Dashboard
Hi team, I have a dashboard with different reports, tables, and widgets in it. The dashboard has one user filter and it's a date filter. I need to be able to get the date value in the user filter. Please let me know how I can do that whether I shouldZoho Analytics - Charts are not updating for Dashboard
I have created a dashboard linking my Website Google Analytics, Zoho Campaigns and LinkedIn. Whenever I choose the date range - One Week, One Month, 3 Months etc. it does not change the Data. Am I missing something here?Monitoring the product sales of an E-commerce Platform
Effective monitoring of product sales is paramount for sustained success. This requires a comprehensive analysis of sales data, customer trends, and market dynamics. Watch this video to know about optimising product sales on an E-commerce platform, ensuringHow 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 showNew Features rolled out on November 24, 2023
Hello users! We have a host of features and enhancements in store for you this month, ranging from new business application connectivity to robust security enhancements. Let's take a look at the latest updates to Zoho Analytics. Advanced Analytics forZoho Analytics: 2021 Look Back
As we start a new year in 2022, here's some of our top moments from 2021. Zoho Analytics in 2021Getting a join error on a query table that has always worked before
Hello, I am getting a join error "Sorry, query execution failed as the columns used in the JOIN conditions might contain too many duplicate values. Please ensure that at-least one of the column used in JOIN condition contains unique values." This is aZoho Analytics Sync Interval
Hello Zoho team, I hope you're well. I'm wondering if it's possible to change the sync interval for specific data sources in Zoho Analytics from 3 hours to 1 hour. I need to sync certain data sources hourly to achieve real-time analytics on our wallboard.Show date of a record on dashboard
Hello. I want to add widget/text which will show me the date when last deal was signed as well as how many days passed since the last deal signed. Is there any way I can do this? Date is defined in CRM under the DEAL field named "Date of order". ThankMonitoring the Website Performance of an E-commerce Platform
In the realm of e-commerce, effective monitoring of website performance is crucial for sustained success. Seamless functionality of your e-commerce platform is imperative for maximizing business growth. Watch this video to know about the comprehensiveNeed advice on project
Hello, this request is rather generic and could resemble many of the previous ones and I apologize if this is the case. I'm currently doing a work-study programme in my 1st year of a Master's degree in IT and I've just been given a new project and I'dFiltering based on Text Blocks
Hi I want to be able to create a number of text blocks within Zoho Analytics, whereby when a user chooses a fitler for a report X text block will show - is this possible?No data is showing when importing GA4 to Zoho Analytics
I'm new in using Zoho Analytics and I already have several GA4 properties with lots of data. I tried to import the GA4 to my Zoho Analytics, but after the setup and check the dashboard it doesn't show any data at all. Tried it with the older UA and itTotal Data Widget
I`m writing to request your collaboration because when I use a Widget to count IDs the total data recorded in the database, but the total is not being reported. For example, if I have 30k id´s in the database, the Widget just report 28k. I have been waiting[Databridge] Spawn EC2 machine with Databridge every 3 hours to run DataSource Syncronization job
Hi, currently I have a Databridge installed onpremise in a Mac machine that is always on. The syncronization between local DB and Zoho is configured to happen every 3 hours. I'm going to migrate DB to AWS and use an EC2 instance as the databridge. In5 focus areas of online businesses using e-commerce analytics
As the digital realm evolves, it has become imperative for businesses to have a digital storefront. To thrive in the dynamic realm of the online business, keen understanding of the operations and optimising them is crucial. Watch this video to learn about[Upcoming Webinar] Embedded Analytics: A faster route to modern, data-driven applications
Today's most innovative software takes advantage of next-gen embedded analytics offerings that speed development and power data-driven insights. Next-gen platforms are API-rich, enabling you to deliver concise and contextual analytics at decision pointsWhat metrics do you track in your sales dashboard?
We need your help creating the ultimate sales dashboard. As you know, having the right metrics at your fingertips is critical for sales success. But with so much data to choose from, how do you decide what to track? That's where you come in! In the commentsAPI Export Dashboard as PDF with Filter Criteria from Multiple Tables
When exporting a PDF of a Dashboard using the API, it accepts ZOHO_CRITERIA which comes from a single table, but won't export when the criteria contains more than one table. For example, imagine a simple dashboard with two charts, one showing sales byTrying to get Zoho Marketing Automation to sync data into Zoho Analytics
Hey friends! I'm trying to use the beta data source of Zoho Marketing Automation of Zoho Analytics. Every time I click on the Zoho Marketing Automation box, I get a pop up that says, "Unexpected Error." Any ideas?Google spreadsheet =importdata or =importhtml
I'm trying to import data into a google spreadsheet from a published URL / Permalink of a table from Zoho Reports. I'm attempting to use the Google spreadsheet =importdata or the =importhtml functions. I can't get either to work. Is what I'm attempting possible?Full screen mode on a tablet
Hello! I created a dashboard Id like to permanently show on a tablet. I noticed you have two android apps to view dashboards on the phone/tablet. Zoho Dashboards shows dashboards properly but doesn't maintain colors and doesn't show a lot of importantIssue creating a YTD report with last years numbers
I am looking to create a widget to compare the YTD leads we have in 2023 to the YTD leads we had in 2022. I'm having issues with the aggregate formula creation to gain access to the 2022 Leads YTD data point. Feeling like this is a common view of dataError: Sorry!! Unable to display this page
Is Zoho Analytics down?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 – 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
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 les
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
Tip 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 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
Top Contributors
Jaivin Joy Eapen
Roy Vargis
Mikhail Koval
Jack Stolkin
Pradeepkumar R