Desk FAQ Article views in Analytics
Hi, I am trying to report on the success of various FAQ (Knowledge Base) articles we have created in Zoho Desk. One of the metrics we wanted to track was the view count for each article. I can't see view count as a default option in the FAQ table in theHaving Trouble with usign Alias with one Table
Hello, Recently I have started having trouble using Alias with a table. Even when using the most basic of Alias, I still get an errorReport to Switch Columns and Rows
Hi, I am struggling to figure out how to put my data into a specific layout as I would like one row per question. So for example my data comes through per entry: Date Added Qu1 Qu2 Qu3 etc 14/01/23 3 5 7 15/01/23 1 2 4 16/01/23 4 5 7 etc I would likeIs it possible to make certain axis on charts ignore filters?
Greetings I was wondering if there was a way to make certain columns on axis ignore filter? i'm looking for something that is similar to the aggregate function "ignore filter" but it would be applied to column inserted on the chart, is there such a thing?Nested if
Hello, I'm trying to use a nested if as an agregate formula with an existing agregate formula, however I´m getting a message the specified formula is invalid if("SETTLEMENTS_ENC"."Testing" >= 600,1500,if("SETTLEMENTS_ENC"."Testing">=525,1000,500))SQL retrieving different data
case 1 - https://analytics.zoho.eu/workspace/143206000000002008/edit/143206000021753342 when I use text in the CASE statement, it retrieves only part of the data (being 90 the max. no. of lic.) case 2 - https://analytics.zoho.eu/workspace/143206000000002008/edit/143206000021753342New Features rolled out on Feb 21, 2023
Overview Effect for Charts To visualize reports with large data sets, Zoho Analytics has enhanced charts with new interactive options: the overview and scroll bar effects. These enable you to plot large data on a chart to get a clear picture of the peaks[Webinar] Humanizing insight delivery with modern BI & analytics platforms
Hi there! BI and analytics today extends beyond crunching numbers to deliver business insights, covering every aspect of a user's analytics experience. In that context, users are now looking for more consumerized experiences when interacting with dataCreating dashboard in zoho creator
Hi Folks, How to create a dashboard in zoho creator app using zoho analytics?Exporting Query Table into Regular Table
Hello, I am trying to export a Query Table into a regular table, when I utilize the Zoho Analytics Workspace Button when creating a table and select the query table, I get an error and no data is exported. It then shows up as exporting from a local fileBulk email delivery for dashboard with filter criteria
Is it possible to share the dashboard via weekly scheduled email to a long list of non-users, where each would receive a dashboard pdf version that is filtered by their email address, considered the dataset having a column that have these non-users' emailNew Features rolled out on April 26, 2016
Enhancements in Conditional Formatting Conditional Formatting in Pivots and Summary Views offers enhanced features like adding/formatting text and icons to highlight your condition in addition to the earlier formatting capabilities. Click to know more. Wrapping Column Headers in Pivots and Summary Views Zoho Reports now allows you wrap lengthy column headers in Pivots and Summary Views. You can use this feature by clicking the Settings button in the toolbar and selecting Wrap Text in Column Headers.[Blog] Driving Insights & Decision Making with Augmented Analytics
In today’s highly competitive market, the case for augmented analytics arises from the need to obtain business intelligence in real time. From an operational point of view, it enables automation of manual workflows that were highly tedious and error-prone.Scatter vs Bubble Visualisation (Text Labels)
Hi everyone Is there a way to add text labels to bubble plots? It seems there is a character limitation on bubble plots, but not so on scatter plots? I'm trying to create a bubble plot graph that uses the size function but still allows me add the textDuplicate dashboard OR dynamic datasource
Dear Zoho Team, I want to offer the same dashboard to different companies, and in my architechture each company data resides in a dedicated MySQL database. So I would like to be able to embed the same dashboard and pass as embedding parameter the proper databsource related to the db of the specific company. Is it doable? I think not. So I thought to a different solution: I duplicate the dashboard for each company. But surprise: I neither cannot fond a Duplicate/copy button for my dashboard! ThisCreating Custom Thresholds
I created a bar chart showing the number of leads created each month of 2022 to compare to the number of leads created so far each month of 2023. I would like to create a threshold that is weighted for each month. If we created 100 leads in January 2022Zoho Analytics - Sample Projects
Dear All, Where can I find some sample projects which I can use on Zoho Analytics for increasing my practical knowledge on the same. Thanks and regards,Report of the Week - Leads to Deals Conversion Cohort
The goal of any business is to sell more. For this to happen, you try to convert more valid leads into potential customers. Lead Conversion Cohort helps you identify how effective your company is at converting leads into customers. It also tells you howUpdating Table Using API Python Library
Hi there, I am attempting to add rows to an existing table using the analytics V2 BULK API and the associated python library. My python code is as follows: from __future__ import with_statement from AnalyticsClient import AnalyticsClient import sys importZoho Analytics integration with new Google Analytics 4
Hi, We recently migrated our website to a new ecommerce platform and started using the new Google Analytics 4 service (the new ID is G-xxx instead of UA-xxx). When we tried to add the data source of Google Analytics, it is only displaying our old UA-xxxAllow for Layered Data in Geo Maps
Our organization is trying to display two layers of data as a map, with such layers as: A map of US states, with states we have a presence in colored according to the size of our presence (chart type "Map - Filled") A map of US states, with proportionallyLegend colour change after filtering
Hey I have recently started using zoho reports and I made a dashboard that uses user filters to change the values for all the charts within it (very cool by the way). My problem is that when I filter using the user filters the colours of the legends change. I really need some help with this since I need the colours to remain the same even after filtering. Is this possible and how can i implement this? Thanks in advanceSharing dashboard permissions filter criteria
Hi, I have a question on how to apply filter criteria while sharing dashboard with multiple pages and filters on those pages should be based on different tables and columns? For example, on the first page, the viewer should see and be able to select from[Product Update] Change in Teamwork Projects and Desk - Zoho Analytics Integration Authentication Method
Dear Customers, To simplify the authentication process, we have changed the authentication method of Teamwork Projects and Teamwork Desk - Zoho Analytics integration from API key to OAuth model. For all new integration setup, the new authentication modelDeal Activities Query
I found this Deal Activities query in analytic. Apparently, it ran a long time ago, but now does not find a table called "Activities." This would be a highly useful query table for me. Can it be revised to work with however CRM stores the underlying "activities"Aggregate function to get all days in certain month?
Greetings I need a way or an aggregate function that would return all days in a certain month to show them in my report, is there such a way/function? i tried searching through date functions but couldn't find what i'm looking for. ThanksNeed new API to get dependency details of all views in workspace
I want to request a new API to get source tables and query tables for all the views in a workspace. Feature Request Details: There needs to be an API which gives the following details for all views in the workspace in a single request: Dashboards WhatZoho analytics mobile export
Zoho analytics mobile app does not export user filtered data like the desktop. The mobile exports the entire table.Zoho projects analytics, how to show a report of documents and files attached to a task?
Greetings As the title states i'm trying to fetch info of files/documents attached to tasks in zoho projects and include them in reports where i show details about them. is such a thing possible? if not, is there another way (like using APIs) to achieveScale in radar graph
hi, We currently use the feature radar graph in Zoho report, even if this feature presents real limits. In this model of graph in Zoho report, it seems not possible to see the scale on the axes of the graph. Is it possible to improve this kind of graph please ?Analytics reports- Format of time duration in RESOLUTION TIME IN BUSINESS HOURS not in total hours
We are in the pocess of compiling reports and the format of the time duration is not formated in total hours. There are entries that are formated: 1mon 2w 4d ... 1y 2mon ... 2w 2d ... 5d 4h ... We need the report to pull these values in total number ofTemplates in Analytics
Hi, I have set up a Query Table in Analytics which shows exactly the data I need from an API based import. According to the KB, I can export that template and import into another Workspace, but how can I use it in the SAMER Workspace but for a differentJoin tables using date column
Hi, I understand lookups using the date column is not currently supported. The reason for my request is to join a Transaction fact table to a Time dimension table using the date column. The work around I can think of would be to use a Time Key which is an integer made up of the date (e.g. 13 December 2012 would be 20121213) and ensure that the dates in the Transaction fact have the Time Key value rather than the actual date value. However, this is additional work which could be overcome by providingConverting Lead per Type
Hello, We have an issue in Zoho analytics. it looks like the data is not imported correctly When we convert a lead => Account we then Edit the new created Account to update a custom field "Account Type" to 1 of 3 options: - active - non active -prospectHow to see Zoho Project Task List Table in Analytics
I have connected Z Project to Z Anlytics, but am not able to view the task list table"maximum of 3 levels of Query over Query tables only allowed" when saving 3rd level query
I am getting the mentioned error when trying to save a Query Table that's 3 levels deep. My setup: Table A is an actual table, created importing CSV data Table B is created with: select extract( YEAR_MONTH FROM "date") AS "ym",site_id, count(1) as t from page_views group by extract( YEAR_MONTH FROM "date"), site_id Table C (the one that breaks when saving) is: select * from "Table C" where t >= 3Actually the only reason I have Table B is because I can't use the "t" column in the WHERE clause.[Product Update] Discontinuing some fields support in Xero - Zoho Analytics integration
Dear Customers, An update in the Xero - Zoho Analytics integration. The following fields will be discontinued from 31-January 2023 due to some technical limitations in Xero and Zoho Analytics. 1. 'Quantity On Hand' field in the Items module. 2. FieldModules Missing
I am not sure if I maybe deleted the "starter" modules when I first activated ZOHO CRM thinking I would not need them, or if they are hidden, or what. But the Sales Order Module, and the Products Module seem to be missing from my Account. Is there a wayQuery to bring back last business day
Hi all, Wondering if anyone has written one, or can point me in the right direction, or an Analytics query to return rows of the last business day? I currently have the following (which may be wrong..) SELECT "Time Entry (Zoho Desk)"."Request" AS 'TicketQuery table - filter 'All Store sales' table to view 'Store 2 sales' table
Hi, I have a query table that is built from the 'union' of 5 other tables. Store 1 sales Store 2 sales Store 3 sales Store 4 sales Store 5 sales Each of these tables is the sales data from a store, made into a 'big' table that has all of the data. HowNext 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 – December 2025
December is a special time of the year to celebrate progress, reflect on what we have achieved, and prepare for what’s ahead! As we wrap up the year, this month’s updates focus on refining experiences, strengthening analytics workflows, and setting theWhat's New in Zoho Analytics - November 2025
We're thrilled to announce a significant update focused on expanding your data connectivity, enhancing visualization capabilities, and delivering a more powerful, intuitive, and performant analytics experience. Here’s a look at what’s new. Explore What'sWhat'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 of
Most Discussed Topics
Creating a Chart from a Report
In Zoho Analytics, is it possible to create a chart from a Pivot View report? We are looking to use Zoho Analytics to replace Excel for Sales reports and would like to be able to show both the table and the chart together.SQL Table slowed to a crawl
Hi all - I seem to have noticed an update. Now whenever I am typing in the script field for the SQL tables there is a huge delay and it is all very slow. This has never been the case for me in over 5 years of using Analytics - I really hope it's fixedHow to Rank Tables by Row Count in Descending Order
I am trying to understand the consume of lines that grow up so fast in the last week. Is there any way to create a pivot table or query to get TABLE NAME LINES in descending order?Report sorting not working
I make extensive use of Summary reports and Pivot Tables. Most of these reports are structured such that I have several columns of "information" data that I want displayed, followed by one or more "Data" summarizations. For example, I have the following
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 - November 2025
We're thrilled to announce a significant update focused on expanding your data connectivity, enhancing visualization capabilities, and delivering a more powerful, intuitive, and performant analytics experience. Here’s a look at what’s new. Explore What'sWhat'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.
Top Contributors
Jaivin Joy Eapen
Naresh Kumar K K R
1_Tharun V
Gowtham Subramaniam C K
Daren