Applying dashboard filters to KPI widgets
Hi, Is there an option to apply the Dashboard User Filters to the KPI widgets on the dashboard. They work for charts but don't apply to KPI widgets.Joining Two Tables on Multiple Ids
Hello all, I'm guessing there is an obvious solution for this, but definitely not an expert in sql. On our Deals module, we have two user lookup fields. In Analytics, those fields have the user's ids in those table rows, and I'm trying to create a queryWebsite Alarm Monitoring
Watch this video to learn about the importance of aligning the alarms metric with your business goals, and how it can be achieved using Zoho Analytics and Site 24X7 integrationGet the User Filter value in the Dashboard (Zoho Analytics)
I built a dashboard in Zoho Analytics with different reports, tables, and widgets in it for my personal website https://apkzity.com. The dashboard has one user filter and it's a date filter. I'm happy to try Deluge script, SQL, or any other way to achieveShowing total number of records on a stacked bar graph
Zoho Desk always displays the total number of records in the title of its stacked bar graphs. Is something similar also possible to achieve in Analytics?Pagination in Zoho Analytics V2 bulk API
Dear Zoho Analytics developers! I am trying to get Zoho Analytics reports asynchronously using the Zoo Analytics V2 Bulk API I am creating a job, then I use the link "https://<ZohoAnalytics_Server_URI>/restapi/v2/bulk/workspaces/<workspace-id>/exportjobs/<job-id>/data"What's New in Zoho Analytics - January 2024
Hello users! With the onset of a new year, we're delighted to bring you new feature updates and enhancements to improve your experience. Read on to learn more about what's new in Zoho Analytics. HyperSQL - Live Connect We have enabled Live Connect forHow do I create a formula that gives me a ratio of Lead Conversions per Week over Calls made per week?
So using the two system-generated tables from CRM, Leads and Calls, I want to create a custom field for a report that will show me Leads converted by week, divided by the calls made per week. In the Leads table I have the field "Date Converted", and theIntegrating with the Google Play Store Console & Apple App Store
Has anyone integrated their Zoho Analytics Workspace with the app stores? We have a mobile app and I would like to be able to display the number of downloads, updates, and other statistics from the two app stores next to each other in Zoho Analytics.Zoho Project - Total Forecasted Hours
Does anyone know an easy way to get a total of all the forecasted hours across the portfolio? I'm aware trying to create a custom report that can generate this figure for each task and the total up but the completion percentage doesn't seem to come backHelp creating inventory volume report.
I've been working with Zoho support for a few months now trying to develop a inventory volume report. Though they have been helpful, it never seems to generate exactly what we're looking for. I thought I'd turn to the community for further help. We'veUrgent: 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 consistentlyCommenting report records
Hello, I have a request I don't exactly know how to answer it, and may be not with analytics. I'm getting daily 3 emails with excel sheets attached and inserted in tables. I built a new SQL table aggregating all 3 tables (3 SELECT). Then a report is buildCSV Exported data includes $ symbol for currency column
Hi, When I export a table or view (query) to a CSV file and the table contains a column that is of currency type, the "$" symbol is included in the export. Can this be removed? The CSV file feeds into a database and short of writing a script to removeGrouping of Dates in Zoho reports needs option for monthly, quarterly, and Yearly
When trying to group records by dates in Zoho Reports, there is no way to group by month, date, or yearly, Any Ideas of how to do a work around?[Upcoming Webinar] 7 BI trends to watch in 2024
BI and analytics is increasingly taking center stage, as we generate and interpret business data like never before. And with the recent breakthroughs in AI, the BI space is witnessing a stream of futuristic capabilites that are transforming data intoQuestions about ZOHO Reporting
I am looking into integrating reporting into an existing site for reporting. Have a couple questions about zoho reports. 1) Can zoho reports create a paragraph of template text that has embedded data from the database. For example, the following text would be a template but the numerical data would be plugged in from the generated report data: The percentage of international widgets increased from 59.4% in the 2005/6 Survey to 60.1% in the 2012/13 Survey. Average domestic widgets increased fromHow to publish and share portals?
Portals are an advanced way of data storytelling. In this video, you will learn about how to publish and share portals on Zoho Analytics.Linking tables across workspaces
I am new to Zoho Analytics and I am trying to link a table across workspaces so that I don't have to import it each time I make a change in the original table. Can someone tell me the most efficient way of doing this? Thanks.How to access department data for each project and job from Zoho People
Using Zoho Analytics how can I see the departments that belong to each job and project from Zoho People? I don't see the related fields in Zoho Analytics.Anchor Links in Dashboards
Hello, Our dashboards frequently have multiple sections that would be more easily skipped between using anchor links. Please consider adding an anchor link feature to the text widget? This could be done by adding an anchor link option to the text widget next to the "remove" option (see screenshot). The option would assign an ID to the <div> containing the text widget in the live dashboard. Then, the chosen ID could be linked using a traditional <a href="#link_id"> in the html section of the textMonitoring the Operational Health of an E-commerce Platform
In the dynamic landscape of e-commerce, ensuring the seamless operation of an online platform is paramount for sustained success. Watch this video to know about critical aspects of Operational Health.Table "wrapping" to show large number of columns
Is there any way to render a list where the table columns can wrap around? I need to output upwards of 20 columns and scrolling sideways across a table is not really desirable. Any other tips/suggestions/hacks for outputting a lot of columnar data? I'mDashboard From Multiple Reports Databases
I have a number of Databases within Zoho Reports that each have a couple of KPI reports. So that management don't have to log into each Database and find the KPI reports, is there some way I can integrate. My preference would be a new Database that can import the relavent data from the different Databases. However I believe this isn't supported. Is this being considered in the future? Alternate method would be to have some sort of Dashboard that links off to each report. This would however need toCRM subforms data in zoho analytics ?
Hi, it seems the subforms data inside a zoho crm module (as in deals for example) is not importing in Zoho analytics. is that correct ? and if so , any roadmap on that feature ?How to Group Records and Sum Unique Values
Hey all, I was hoping someone would be able to help me on something that I cannot seem to get right. Let me show you an example of what I am trying to do. Here is an example of the structure of my data, note the multiple records for a single company.Analytics Cleanup
We would like to clean up our Analytics reports. Is there a way in Analytics to determine where a report is used and/or the last time it was opened?report formula column can't show the total of value
Hallo Guys, I try to make two formula with name kriteria and total supreme with if function the function has running well but it's run with problem, the problem is function column can't shown total value, any one can help me ?Books to / from Analytics Creator
Hello, I understand the "sync" from Zoho Books to Analytics is a one-way data migration. Are Deluge or a connector (zapier, integrately, etc.) the only ways to push data from Analytics (or Creator) to Books? Is there no pre-built Zoho tool to push data[Product Update] Zoho Projects and BugTracker Data Model Changes in Zoho Analytics Integration
Dear Zoho Projects and BugTracker integration users, As a continuous effort of enhancing our product with latest API versions, we are updating Zoho Projects and BugTracker APIs in the Zoho Analytics integration framework. As a part of this upgrade, the📢 : Rewind with us – Zoho Analytics in 2023🗓️
As we wrap up 2023 and step into 2024, we at Zoho Analytics are grateful for all the customers who journeyed with us this year. While we look forward to continuously evolving and enriching your analytics experience, here's a glimpse back at some of oursub-reports
I would love to have a full sub-reporting fetaure that allows me to join two reports in one and have headers and footer for sections. For example: - master header with document number, client, date - details with products, quantity - master footer with document totalDate and time of Sync on X axis
I need a simple graph that will show me on certain values on Y axis for each day of the year. That could be for instance total amount of deals having a certain stage. Calculating that amount is not a problem. The problem is to have it show for every singleCumulative total in a query table
Hello there, I would like to calculate a cumulative total of the column "elmCount" per customer in order to check when the total of the elmCount exceeds the limit. There is one limit per customer. In a normal SQL environment I would do it as follows:Custom formula column in pivot report
hello I have a pivot table report in zoho reports (data source : Zoho crm). I need a column in this pivot report that can perform a calculation "column x - column y", column y being a total of several columns in the same report. I can see that adding a custom formula column is not available in a pivot report- or at least I have not been able to figure out how to do so. Is there a solution, please? Thank youReal time data in dashboard
Hello. I would like to trace and display real time events. I will have a datamart (SQL) and I would like to acquire data in near real time from my SQL datamart. The best I can do in term of time interval is with every 'N' minutes where the lowest N isSort X-axis in web chart
Hi, I want to sort the categories that are in my X-axis for my web chart in a custom manner. That is, that I can self decide where the words are assigned to in the web-chart. Can someone tell me how to do so? Kind regards,Expanding on Data Storytelling in ZAnalytics with an Executive Summary (with text based description and numbers)
Is it possible to create a template of some kind for use in a slide associated with data storytelling that will automatically capture and insert some key numbers (where XXX are shown) from a financial report like a Balance Sheet or an Income StatemenCreate Report from multiple databases
I have read through the Forums and it looks like the ability to create reports from multiple database was on the roadmap a year ago. Has there been any progress towards this end? I have 2 large (# of tables/relationships) Creator databases that are downloadedDatawarehouse schema design for Zoho Reporting
Hi, Was trying to create star schema in Zoho Database and create dashboards on it. My Question is : 1)Do we have index option for faster data retrieval? 2)Any way we can create complex(more than one column) keys-Primary key?. ThnksNext 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