Removing null values
Hi I'm making a running total in pivot view usign zoho analytics with time as a field variable. The problem is, the time coloumn has multiple null values which I want to filter out. However, I can not filter Null values or unknown values from a coloumnHow to deal with accented characters
I am trying to import data into Zoho Analytics. Some of the words are in French using accented characters, such as Montréal, but when I import them, they import as Montr�al. Does anyone know what I need to do to import the data and support the accentedExecute Query working / View Mode shows different value
Hello, We have a snapshot setup and I'm trying to return the next to last snapshot id where the data column is set to 'good' The Table: Snapshot Id Data 3 Good 2 Bad 1 Good So 3 is the newest snapshot, and I'm trying to find 1 When I run the followingRunning total calculated in user filter
Hi I have a problem in zoho analytics with the running total. I want to have a running total each month of the users data. However, I want to be able to only show parts of the running total and still get the correct values. When applying a time user filterHow to divide values from two different tables to create a ratio in a dashboard
Hi there, My name is Carolina and I tried to search on the community and online how to do a simple division in a dashboard, but I couldn't find an answer for that. For example: What I need to do is divide the Total Installations (134) by Total AppointmentsMerging Cells
I wonder if someone could help me with this problem? I have looked through the forums and noticed that someone posted the same question as I'm about to last year, but it was not answered. OK....I have created a table with three columns and a number of rows. I would like to merge cells but can't seem to find a way to do it. Can anyone help with this?Access to what Products are associated with which accounts
Is there a table that can be accessed to report on Products associated with accounts in the CRM?"Temporary Error" in Zoho CRM Data Source sync
I edited my setup for the Zoho CRM to Zoho Analytics Data Source Import configuration to add some new fields. After I saved the changes, I clicked the (Sync Now) link. After a few minutes I got a Sync failure error. The only reason given is "A temporaryMerging Tickets in Desk => Bad Data in Analytics
Curious to know if anybody has experienced this issue when dealing with Desk to Analytics integration: 1. You have two duplicate tickets in Desk so you decide to merge them (in Desk). 2. The ticket that was deleted during the merge is obviously no longerUsing Zoho API to update IP addresses to control access to Zoho Analytics views/dashboards
We are using IP restrictions to control access to Zoho Analytics views and dashboards. It would be very helpful to be able to add/remove allowed IP addresses via API.Synchronization between Zoho Analytics and Zoho Desk not working anymore
Since last Friday, our synchronization between Zoho Analytics and Zoho Desk keeps on failing.. How can I solve this problem?Connecting Zoho Creator with Zoho Analytics
Hi Team, I am unable to import the data and forms I created in Zoho Creator to Zoho Analytics. However, another organization admin can import the data and forms they created but also cannot import mine. When I try to import from the Zoho Creator datasource,What does it mean the letter X in Zoho Analytics
I am translating a document about the use of dashboards in Zoho Analytics , and I found these sentences : Tap any where to select corresponding X entries Tap on X-axis label to select all entries for the X Swipe down to filter all data points for anyCreating a bar chart to compare positives for 2 different yes/no fields
Here's the goal: We have multiple fields that are simple Yes/No in our Deals. I want to produce a bar chart with the number of YES for 2 of those fields. As 2 bars. i.e. X=21 Y=7 Something simple like that I currently do them from a pivot table in ExcelAnalytics Down?
Is anyone else having problems with accessing analytics.zoho.com website?Email schedule on specific date
Hi How can I schedule an email report to be sent out at a specific date and time? I don't want to send using the intervals being offered (daily/weekly etc) but rather only once on a future date. ThanksDerived table in zoho analytics
Hi Is it possible to make a derived table also known as a subquery in the from clause. Because I keep getting an error?Day 10 of Sync failure between desk & analytics...
I'm going on day 10 of "temporary" sync failures between zoho desk & zoho analytics. I have deleted the integration (which deletes the table and makes all the reports and dashboards useless) and re-added it. Both times it works for the first sync thenCustomer connect: How Market Dojo drives business growth with 360° insights
According to McKinsey, businesses integrating diverse data sources make decisions five times more faster than competitors. In our upcoming webinar, we're excited to converse with Market Dojo, a UK-based SaaS company built for procurement professionals,Request for Assistance in Importing Full Data from Xero to Zoho Analytics
Hello Team, I hope this message finds you well. I am writing to seek assistance with an issue I am encountering while trying to import data from Xero into Zoho Analytics. Specifically, I need to import data spanning the last 5 to 10 years. However, ZohoDate Last Modified
How does one set up a field to automatically record the time and date that its row was last modified?How can I use DATEDIFF in ZohoAnalytics for query?
Hey, Which function do I need to use that Zoho SQL will understand? I have used DATEDIFF and I can see that Zoho can't understand it, then I tried this date_diff(), and also no changes. Best regards, VladimirMonthly Average in a Summary Report (exlcude weeks with zero count)
Hi, I am trying to figure out how to get a monthly average on my attendance of unique ids (pco_id) that have checked in. If you look at May, it says there are 2 weeks in May and our average is 30, but we did not meet one of the weeks, and the 30 is notZapier and Zoho Analytics API
I'm having a problem setting up a Zap using the Zoho API. I'm currently using the Zoho analyticz API to get data and write data into tables using Power Automate Desktop but for a certain task i need to connect it to Zapier to get the last row from a tableRequest for Zoho Analytics Query Version history
Hi Team, As and When I am working on the Huge SQL Queries, I feel insecure especially, when i am making changes to the working query. If there is any improvements needed in the Current running query. Is there any plans for Version history for the QueriesFind and Replace on filtered Table
Hello, am I missing something from the procedure? I filtered a table then I am trying to replace a text value, but it says no rows match. The column is unbound free text and I am using it as Status (want to replace "available" with "disabled" text). AnyReport of the Week - Packed Bubble Chart
Zoho Reports allows you to display large data points efficiently packed within a small space using the Packed Bubble Chart. Packed Bubble charts display the data as a cluster of bubbles. Data in the columns plotted define the size and color of the individual bubble. This provides an effective visualization in easily comparing the categories by looking at the size of the bubble. The below illustration shows how to create a packed bubble chart. The following are a few sample Packed Bubble Charts.Tooltip Customization
Hi Team, I have a bar chart that displays the dollar amount in proposals sent, won, and projected to close per month (a bar per metric per month). I have the count of proposals per metric included in the tooltip shelf. When I hover my mouse over the 'Sent'How can I generate a report on dormant Accounts in Zoho CRM and Zoho Analytics?
I can't imagine this is a unique ask, but can't find an answer in the community. We have lots of Clients (i.e. Accounts) with various levels of 'dormancy' i.e. they have not engaged with us for # months. This is based on the date of the most recent EnquiryWhat tools does Zoho Analytics have to connect well with Postgresql with Sync Condition?
I would like to know what tools Zoho Analytics has that can connect well with Postgresql. I want to sync data with Sync Condition to Postgresql. For example, I want to Sync when data matches a specific date range.Importar dados de API (JSON) usando método POST e passando outra tabela como parâmetro
Pessoal, Estou com uma dúvida se consigo passar um parâmetro como uma tabela de referência no Zoho Analytics Veja o exemplo abaixo: Preciso saber se existe alguma variável que possa fazer essa referência. Obrigado!Spilt Axis for stacked column and line graph
Each month around this time I prepare a business review deck. One of the biggest annoyances I have with Zoho, also happens to be something that most other platforms have provided for a long time now, and that is being able to create a chart with stackedInstant Sync of Zoho CRM Data?
With how valuable Zoho Analytics is to actually creating data driven dashboards/reports, we are surprised that there is no instant or near instant sync between Zoho CRM and Zoho Analytics. Waiting 3 hours is okay for most of our reports, but there areZoho Analytics - SalesIQ Conversation Tags
Good day, I cannot seem to locate the "tags" field for SalesIQ conversations in Zoho Analytics. Any idea where I can find that field or table because I need it for my reports. Thank you! AndreAnalytics SDK getOauth api is failing only in production
I am using ZohoAnalytics SDK and with it I am sycing data to Zoho analytics workspace. Things are working perfectly in local environment but when I pushed code in production (AWS ECS), getOauth function in SDK is failing. The reason for failure is, whenHistorical changes to data tables and reports
As in Microsoft Power bi, when you edit data in sources, you have a step for every modification. So you can rollback o undo something. In zoho Analytics it will be great to have an overview of all the modifications, for instance: Changed types, Added columns, transformations, etc.Zoho reports API: GETEMBEDURL
Hello guys, While trying to get an embed URL for a report through the reports API, i'm always getting the error: <error> <code>8023</code> <message> You do not have permission to perform this operation. </message> </error> </response> The format of the URL path i'm using is: https://reportsapi.zoho.com/api/adminaccount/DBname/Dashboard?ZOHO_ACTION=GETEMBEDURL&ZOHO_OUTPUT_FORMAT=XML&ZOHO_ERROR_FORMAT=XML&authtoken=*token*&ZOHO_API_VERSION=1.0&ZOHO_IS_SECURE=true Is there any configuration to beAnalytics export to excell
I am trying to get some data into another analysis program to do make use of some other functions. Would I be able to use the api to auto update into an excel file for example? If not are there any other options that I have?CRM/Reports Multi-select Lookup Fields
Hello, Is it possible that multi-select lookup fields (recently added to Zoho CRM) will become available within Zoho Reports? I have looked at adding them through Data Sources - Zoho CRM, but they do not show up under the modules in setup. This feature would be highly beneficial, as I need to create reports based on these fields and must currently export to a third service rather than doing all reporting within Zoho. Thanks! KaylaRetrieve comments on customer happiness in Zoho Analytics
Hello there, I would like to receive the customer satisfaction rating comment from the customer in the Zoho Analytics standalone app. How do I do this? Best regards, SvenNext Page
Access your files securely from anywhere
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
[Upcoming Webinar] Power up LinkedIn marketing with Advanced Analytics
Modern businesses are leveraging social media like never before to generate, retain, and expand their customer base while driving revenue. LinkedIn continues to be one of the most preferred marketing platforms for businesses. Based on our interactionsAnnouncing Zoho Analytics 6.0 - An AI Powered Self-Service BI & Analytics Platform!
At Zoho Analytics, our mission is to democratize analytics for everyone. We recognize that team members across an organization rely on data to make both simple and complex decisions every day. These tasks shouldn’t require ongoing support from IT and[Fireside Chat on 6.0] Experience the AI powered self-service BI & Analytics platform
Ballooning data volumes at breakneck speed, expanding data diversity, the increasing importance of data management and governance, and the emerging complexities in analytics—BI vendors and customers are turning to cutting-edge technologies to addressAnnouncing Zoho Analytics 6.0 Beta!
We are delighted to open up the next major version, Zoho Analytics 6.0 Beta! The new version comes packed with a wide range of functionalities for all persona, namely business users, data analysts, data engineers, and data scientists. Zoho Analytics teamWhat's New in Zoho Analytics - August 2024
Hello Users! We are back with the latest updates and enhancements made to Zoho Analytics. Keep reading to learn more about them. Connect to the data hosted in the cloud without allow-listing the IP addresses Utilize Zoho Databridge to connect to the data
Most Discussed Topics
How to create comparison time periods like these examples
In a Pivot Report I would like to be able to select any date range and show a set of metrics for that date range e.g. revenue, orders, units sold. I would then like to be able to compare to the previous period based on the amount of days on the selectedIs it possible to have an Aggregate or a formula data column that only sums subtotals?
So I am trying to make a data columns that would only sum the subtotal. let me explain, I want to sums the hours worked of employes. I also need to split the hours when they reach 40 hours into another column. I can make this work perfectly with formulaMake Widgets Clickable or Copiable
Hi, I created a KPI Widget in Zoho Analytics whose content I would like the users that see my dashboard could copy or click and be redirected elsewhere. Yes, I'm aware I can create a Text Box for that instead of a Widget, but the problem is that the linkSolution of the Week: Financial Reports with Impactful Visuals
Finance reporting is a critical part of understanding an organization’s financial health. With Zoho Analytics, you can easily create dynamic reports such as Balance Sheets, Budget Statements, and Profit and Loss Statements. Now, with the release of ZohoContextual Information when Apply Filters
Hello, Let's say I had a pivot report looking at an "Accounts" table, if I had a user filter to select a specific account. When a user hover overs an individual option in the "Accounts" user filter, is it possible to have a pop-up display with additional
Zoho Developer Community
Zoho DataPrep Resources
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
Zoho Campaigns 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
Announcing Zoho Analytics 6.0 Beta!
We are delighted to open up the next major version, Zoho Analytics 6.0 Beta! The new version comes packed with a wide range of functionalities for all persona, namely business users, data analysts, data engineers, and data scientists. Zoho Analytics teamWhat's New in Zoho Analytics - August 2024
Hello Users! We are back with the latest updates and enhancements made to Zoho Analytics. Keep reading to learn more about them. Connect to the data hosted in the cloud without allow-listing the IP addresses Utilize Zoho Databridge to connect to the dataWe are coming to your city! Zoho Analytics Community Meetup
Hello, business leaders and data enthusiasts! We are delighted to announce that registrations are now open for the ZUG meetups, and we can't wait for you to be a part of them. Our in-house analytics experts are geared up to lead discussions on constructingZoho Analytics: 2021 Look Back
As we start a new year in 2022, here's some of our top moments from 2021. Zoho Analytics in 2021[Customer Talk] PREMO Group's Analyst Interview at Zoho Day 2022
Premo Group, a 50 year old Spanish Manufacturing Company, has been our long-standing customer with #ZohoAnalytics. They've been using our platform for their end-to-end, unified business analytics solution. Hear more from Claudio Cabeza, Director at PREMO
Top Contributors
Naresh Kumar K K R
Arthur
Data Sailing
Charanya R
Anitha Rajesh Kumar