Need help with date conversion - extract Month()
Need help with date conversion/math. Here's my code. The "Predicted Receive" is a simple CRM date field in a custom module. current_date() must be return a date-time and extracting "month" from "Predicted Receive" is incorrect...I think. SELECT Vendors."VendorIf I want to schedule data into Analytics from Workdrive, do I need to keep the file the same?
I'm trying to draw in data from my Workdrive from a file that is updated once a day. However the file is larger than 10MB so the only way I can see to update the file is to delete the old file and replace it with a new one in the same place, with theSending scheduled reports multiple times a day
We are sending scheduled reports of tables. However, I can only send the report once a day if I choose the daily option. Since the data changes during the say, I want to send the report twice a day. Is that possible?Error syncing data with Zoho Desk
Hello I am getting data synchronization error and I get the following error message. Currently the owner of Zoho analytics is the same as Zoho Desk and we are still having this issue. I need a quick fix as the issue directly affects the metrics we track.Can you see custom fields created in Quickbooks in Zoho Analytics?
I have custom fields I've created in the invoice in Quickbooks Online that I'd like to use in Zoho Analytics but I can't seem to sync these fields in the Quickbooks/Zoho Analytics integration. Is this not possible?Your Zoho Finance account does not have the required access.
I'm trying to create sales reports using Analytics, synced with our Book. However, the sync keeps failing. When I try to edit the connection I get the following error message "Your Zoho Finance account does not have the required access.".Invoice Item and Description Field In Zoho Reports
In Zoho books, we populate item & description fields for our invoices. See screen shot attached. We do not use invoice items, we simply write in the details of the products (we make custom products). In Zoho reports, it doesn't appear that this information is available. Ideally, these would be available as columns within the Invoice Item table. Right now "item name" exists, but it is only populated if it is linked to an invoice item. I'd love to know where these values are made available in ZohoWarning [400] Bad Request: POST https://analytics.zoho.com/connwebhook?ZOHO_ACTION=WOOCOMMERCENOTIFY&CONNDBINFOID=
hello i am trying to integrate my woocommerce store to zoho analytics. for months now every time i tried, we are gettings thosands of: Warning [400] Bad Request: POST https://analytics.zoho.com/connwebhook?ZOHO_ACTION=WOOCOMMERCENOTIFY&CONNDBINFOID=XXXXXXXXXXXXXXXXXXHow to embed the same chart multiple times in a dashboard but with different filters
I have 6 machines... and a chart that shows multiple temperatures for each. I want a dashboard that shows the same chart 6 times, once for each machine. Seems like the only way is to create 6 copies of the same chart with a hard-coded filter in each.Zoho Analytics not update for Google Analytics V4
Many zoho analytics users are on google analytics for our web sites and now internal applications. We learned that Zoho analytics has not updated their api for Google Analytics V4. Its so much more powerful and we need the Zoho analytics team to upgrade[Blog] Powering order-management for online sellers with Analytics
Quarantines and lockdowns around the world have driven an unprecedented number of consumers to ecommerce for buying goods. Though this mass digital exodus appears to be a boon for online sales, experts have predicted a deceleration in the industry’s growth.Does Zoho analytics work with some kind of cryptography ?
If I have some information in database, which are with some kind of cryptography. Is it possible to zoho use them ?Click through to CRM from Reports
Hi, Is it possible to click through analytics to custom urls, i.e the zoho crm records? Thanks ScottConvert Seconds to Hours, Minutes and Seconds
I have a column that has total seconds for a phone call. I need to convert the total seconds to Hours.Minutes.Seconds on the call. Example: Call lasted 4,277 seconds. Need to convert it to 1 hour, 11 minutes, 17 seconds.Field Layout or Pagelayout from Desk in Analytics
I can't find the field Layout from Desk in Analytics. I need that field to create a filter, 'cause I have different layouts on my tickets. Anyone can help me? Please.Chart legend color change not working - one value is stuck on dark gray
Color change is working as expected for all but one value. When I click the colored box to open the custom color screen, nothing happens.Report based on Week Starting
I have a list of Milestones that auto-calculate when a date is entered. I want to produce a report like the one below that shows a gantt type chart, with the Week Starting along the top and the jobs down the side. The auto-calc dates should fit into theNew Features rolled out on June 29, 2022
HIPAA compliance Now we provide specific features in Zoho Analytics to help you use Zoho Analytics in a HIPAA compliant manner. Click here to learn more. Enhancements in Advanced Analytics for Google Ads Advanced Analytics for Google Ads now supportsprimary key option for any column
I need to be able to designate any column in my database as a primary key. The built-in primary key doesn't help. I want to create a database of new vocabulary words, and I need to ensure that I never enter the same word twice. If there's any way other than a primary key to do this, please let me know. Thanks.Running Total
Hello, is it possible to have a running total in a pivot table in %?Underlying data columns
Is it possible to change the columns (make visible/invisible/reorder) when clicking "view underlying data" on a chart? See attachment ThanksURL data type seems to have size limit
I have created a custom formula against the Zoho Projects "Tasks" table in Zoho Reports. The custom formula concatenates the following. <zoho projects portal url>#taskdetail/<Project ID>/<TaskList ID>/<Task ID> The goal of this concatenation is to createZoho Analytic-hyperlink from value in the grid/column
I’m trying to create a hyperlink from the data-grid result whereby the hyperlink will open Zoho CRM records. Appreciate if anyone can advice if this is possible or any alternate ways to handle this. TellTims SurveyTip of the Week - Customize KPI Widget with Label Parameter
A KPI widget is not just for calculating a single metric. You can add more details to a KPI widget like 'Top salesperson', 'Region with the lowest sales', 'Percentage achieved against target' etc., using the label parameter. When you type $ in the KPI value field in the Settings tab, the supported label parameters will be listed. The following are the available parameters to customize the KPI widget. ${Metric-Column-Name}.VALUE ${Metric-Column-Name}.LABEL ${OPERATION} ${Grouping-Column-Name}.LABELSync data from Zoho Analytics to Zoho Campaigns
I use the integration between Zoho CRM and Zoho Analytics to sync specific modules, but I want to sync specific tables from Zoho Analytics to Zoho Campaigns. At the moment you can't sync data from Analytics to Campaigns. Could there be an integrationIntegration between Zoho Campaigns and Zoho Analytics
Hello. Is there an integration between Zoho Campaigns and Zoho Analytics? I use the integration with Zoho CRM to sync specific modules, but can I sync specific tables from Analytics to Campaigns?Remove specific Text from a String
I want to remove specific text from all Job Numbers in a specific column. In my specific case, I want to REMOVE the letter T from the "JobNumber" column I get an error when I use the code below. Any suggestions what I am doing wrong, how to fix this?Conditional format linked to fields
Will be great if you add and option to link the conditional format value to a field, so the user can do it manually or linked on a table. The X on the image should be able to linked to a field in another table.Hide first column of summary table
Dear Sir. Is there any way to hide or eliminate the first column of summary tables: Thanks for your support.Error in IF Formula while adding Column Formula
Hello, I am trying to clean my column which has responses like '2.Self-employed/Business स्वरोजगार' , '3. Labor श्रमिक'. My objective is to add a formula column so that it returns values like 'Self-Employed', 'Labor'. Basically, want to get rid ofZoho Finance - Missing Relationship in Native Integration
I'm just getting started using Zoho Analytics, so it's possible that I am missing something here. However, it appears to me that a natural relationship in the data synced from the Zoho Finance suite is missing. In the Bundle table, the Composite ItemAnnouncing Zoho Analytics 5.0 -- A Modern Self-service BI & Analytics Platform
We are extremely delighted to unveil Zoho Analytics 5.0 - A Modern Self-service BI and Analytics platform to the public. Experience analytics like never before with the following new capabilities and enhancements: Comprehensive AI-Powered Data PreparationEmail Scheduled Tab Or Button required on Front
Dear Team, Please add Button Left side panel for Email Schedule to add edit or delete & etc. Regards, Subhash KPath visualization from Departure to Arrival airport
Hi Zoho team, Is there any way to map or show the routing activity of airlines from source to destination? Thank you! SwathiIntroduce "3 axis" / "3 dimensional" chart reports
"3 axis" or "3 dimensional" (bar) charts are extremely useful to visualize complex data with (at least) 3 different data points. We keep 3 levels of "problem" and "solution" classification data in our Zoho Desk tickets (for example main/sub/sub-sub problemOverlapping Reports in Dashboards
It's rare, but occasionally it would be a good feature if I were able to overlap reports, either fully or partially in the Dashboards. Also, then having the ability to move objects to the front or rear, or make them transparent/translucent would be goodReport of the Week - Customer Balance Report
How much do your customers owe you? How about customers with payments long overdue? How much advance payments do you have in hand? For all these questions, the Customer Balance Report provides you with the answer. This week we'll see how to create a customerAnalyze Semrush data with Zoho Analytics
How #ZohoAnalytics can help in analyzing your Semrush data Perform detailed competitive analysis across domains Track the performance of keyword-driven content marketing Measure effectiveness of organic & paid search campaigns Find out more about ourQuery Assistance
Hi, Wonder if I could get a bit of help, I want to create a new column within a query table and am going round in circles, I want a new column to be that of "Acquisition Type" and if a Lead Source is Facebook it goes down as Social, if Adwords its PPC.Minutes between creation of a lead and the first call
Hello. I want to measure the (business) minutes between the creation of a lead and the first call. I have two seperate modules: Leads and Calls. When I combine them into one pivot table, I am not able to substract from each other. So, I created a queryNext 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
Jack Nellist
Naresh Kumar K K R
Mikhail Koval