Can this report be done without SQL? How?
Notes in integration with Zoho Analytics
Will the "Notes" field in CRM be available to upload into Zoho Reports so we can add notes as a feild in the reports?Tip of the Week - Conditional Formatting Chart
Conditional formatting allows you to highlight your data series based on a pattern or a trend in your data. This makes it easy for you to identify when your data reaches certain values or when it deviates from the trend. Zoho Analytics allows you toAnalytics Bulk API - Export Data (Asynchronous) JSON_PARSE_ERROR only on first try
Hello, inside a custom function in Zoho Flow I want to create an export job, but I get an error when I send the request. However, this error only occurs the first time, if I call the same custom function again in the flow I don't get an error messageSync Not Working
Zoho Analytics Sync appears to be down again. Have multiple accounts and when attempting syncs with various sources like Zoho CRM, Desk and Google Analytics the Status remains in 'Sync in Progress' without completing. This is at least the second timeIs there a way concatenate text from multiple rows into single cell?
I've build a delivery reporting system for a customer and they are looking to link the rounds data with route planning software, however as there are multiple lines generated for the same location (products to be delivered) and as such the route planningRow counts by workspace?
Does anyone know how to get a row count by workspace?Weekend ticket reports
I want to create a table report that show tickets for Saturday & Sunday afternoon(lets say from 18:00), is there an option to do this in Zoho Analytic without selecting specific dates? is there a way to filter by day(sunday) and time and not by calendarThe Books Delivery Challan Module is Not in Analytics to Sync this Module
I have attached screenshot where you can see my modules under sales. I want to make a analytics report so wanted to sync this module data in analytics. But in analytics data sync option there is no module named Delivery Callan.Need help with Join function in Zoho reports
Team, I have 2 tables - and I need to get ALL matching results in one cell.. Ex: Table 1 contains a Pin code Table 2 contains many addresses corresponding to that Pin code How do i get a query result where for each unique pin code I can get all addresses in one cell.Sharepoint Excel synchronization with Zoho Analytics
Hello, Is there any possibility to synchronize an Excel File on Sharepoint via Zoho Analytics? OneDrive is user-dependent and therefore problematic. Best,Zoho Analytics "Bulk API - Import Data". MORE_THAN_MAX_LENGTH
I have encountered a problem with "Bulk API - Import Data", it return { "status": "failure", "summary": "MORE_THAN_MAX_LENGTH", "data": { "errorCode": 8507, "errorMessage": "The length of the parameter FILE is more than requiredEmbedding dashboard for mobile browsing
Hello folks, i successfully embedded my dashboard in my website via iframe, and works fine from desktop but is stuck from mobile. We cannot scroll the iframe and the reports are very heavy for the browser. Does anyone have a workaround that doesn't involve using the Zoho mobile app?New Features rolled out on July 26, 2022
Advanced Analytics for Teamwork CRM Advanced Analytics for Teamwork CRM empowers you by providing deep sales analytics over your CRM data. This integration helps you to keep track of your key sales performance metrics and optimize your sales team's execution.Formatting and conditional formatting for multiple columns
Dear Zoho, we're building user retention views where large tables have data where we need to color code the background depending on value in a field. We also have to change the data format (to percentage), and set the digits shown (to 1), and then create[Webinar] What's New in Zoho Analytics: H1 2022
Hi there! 2022 has been an eventful year so far on the Zoho Analytics front, and we've brought in lots of exciting new features and updates to enhance your experience! With our well-rounded approach to development over the years, we've got you fully[BLOG] 4 Shopify sales analytics reports to grow your online store
There are many benefits to selling on Shopify—a full-fledged website builder, easy set up, a customized online store, and an extensive marketplace to cater to any Shopify store needs. The question, however, is how can merchants better translate theseControlling external sharing of zoho analytics data
We face an issue where User A and User B, where both user A and user B are both present in workspace C are not able to share their own reports with each other to collaborate. Zoho support told me today that to allow user A and user B to share data, thenScheduled import using local database option (file location) and htm files
I am having an issue with the import feature available for scheduled file imports Background: My quality team uses a system called Gagepack. Gagepack will automate scheduled reporting and save them to our network as htm files. Unfortunately there isPivot Table color is grayed out
Pivot Table color is grayed out on dashboards for some reason. Even though they were created with different 'theme' color in the report view See images provided below First image is view on dashboard, second image is view from the report screenUnderlying Data
Hi, When I made a Chart or a View I used to click on the data I want to consult, and it brought back the information detailed and ALL the columns that were on the report or view data base, I just found out that now the same reports are just showing the columns that are in the view...is this a bug? o how can I add columns to those underlying consults.Change Default Currency in Zoho Reports
Is it possible to default all currency fields in my Reports and Tables to my local currency without having to reformat them every time?Change Currency in reports
New to Zoho and starting to get my head round everything, so far I am very impressed and can't wait to get fluent. I apologise if I am being stupid but is it possible to change the currency in a report. In my main forms it shows as GBP (£) but in the reports I generate showing client spend etc it is all shown in USD ($) if someone could point me in the right direction I would appreciate it.Transfer Data Source ownership in Zoho Analytics
Hi, I am an "Organization Admin" in Zoho Analytics, and I'm managing the whole thing on my own. Eventually, I'm gonna be an "Account Admin" so that I have no further issues or restrictions, but for now, I'm not. My problem is that I'm working on a DataOpen tickets per day
Hi, Day 1 of working with Zoho Analytics for me. I'm want to create a dashboard with multiple widgets and bar sets on it. One of them is a Line chart with the following info: X-axis = first day of the month untill the last day of the month (so if i selectFormula Column 'aaa' cannot be removed.
how do i remove a Formula Column? this product is frustrating... Table reportExclude alpha numeric characters
I have fields with both numbers and letters in them. The length of both numbers and letters can vary. I am looking for a way to return the information as two columns - one for numbers, one for letters. Can anyone help please?Create Report of Zoho Project Tasks with a certain tag
In Zoho Projects we use the tag field. I am trying to create a report in Zoho Analytics that will list out the tasks across all projects that have a specific tag but I am having trouble figuring out how the tags are linked to the tasks in projects. CanAnalytics-Update row; criteria
Hello Trying to update row in Analytics from Desk: headersMap = Map(); headersMap.put("ZANALYTICS-ORGID",orgId); config = Map(); config.put("columns",columnsMap); criteria = "(\"salesorder_id\"=" + creteria_salesorder_id + " and \"package_id\"=" + creteria_package_idZoho Books - Payments Made does not Connect to Invoices table?
Hello Zoho team, We have set up a sync from Zoho Books for most modules including Invoices and Customer Payments. All our payments are always applied to an invoice. Using API we can always find the invoices that a payment has been applied to. However,Displaying total seconds as HH:MM:SS in widgets
Hello, I have a table that contains all of our call data including call length in seconds. I've used the sec_to_time function to convert the seconds to HH:MM:SS format within the table but I would like to be able to aggregate call length and display inDrill Down - Pivot Table
Is there anyway to have drill down options in pivot tables like in the chart function?How to add a Zoho CRM custom upload field as a data source
How do I add a field to Zoho Analytics that displays the uploaded file names? Or it can simply be a true or false if there are files uploaded to that field.Zoho Projects Integration - Project Completion %
Hi everyone I've connected our Zoho Projects to Zoho Analytics to pull specific types of reporting. One area I am battling with is finding the field data that shows completion % of specific projects. In Zoho Projects I can see the complete % per projectHow to filter by null values
Is there a way to filter a widget by null? I want to get a list of records that don't have a date filled in and can't seem to see how without going through a query. Is it possible to do it through the widget filters? Thanks.HTML links in column
I am importing this date from a Zoho Creator view via a CSV feed. The Link column is from a field in the Creator view that is of "URL" type. How do I get the column to display the link as a HTML clickable link? I do not see an option to set a column to 'Link' type.How to find ZohoAnalytics OrgID?
Hi reader, I hope you are doing well. I've been trying to work with the Zoho Analytics API library and have has no problems with the auth and token refresh steps, very clear to use! However, for actually interacting with ZohoAnalytics itself through theReport of the Week: Top Tags in Zoho Projects
Advanced Analytics for Zoho Projects now supports the "Tags" module. This enables you to create reports over the Tags in Tasks, Bugs, Milestone, Projects and Timesheet modules. This week let's see how to create a report over your Tags data. Follow theTime Format from Decimal Number to Hours and Minutes (hh:mm)
I have been using Zoho Analytics for some time now, and I have a query table that combines data from three datasheets (Calls, Desk and Projects data coming from different Zoho moduels). One of the columns contains Hours, as a decimal number, eg. 0.75Dates Missing when filtering data
I am having an issue with the charts and dates disappearing. In the image below you can see bar charts. They are set to be on a rolling 13 month display, using the relative filter to include the last 13 months of data. When the data set is unfiltered,Next Page
Announcements
New Features rolled out on July 26, 2022
Advanced Analytics for Teamwork CRM Advanced Analytics for Teamwork CRM empowers you by providing deep sales analytics over your CRM data. This integration helps you to keep track of your key sales performance metrics and optimize your sales team's execution.[Webinar] What's New in Zoho Analytics: H1 2022
Hi there! 2022 has been an eventful year so far on the Zoho Analytics front, and we've brought in lots of exciting new features and updates to enhance your experience! With our well-rounded approach to development over the years, we've got you fully[WEBINAR] KPI dashboards—an indispensable business enabler
Here’s an interesting piece of trivia. IBM once reported that 2.5 quintillion bytes of data are created everyday, worldwide. However, nearly 90% of that structured data goes unanalyzed. This data is known as dark data. Now let’s switch gears to your business.[Webinar] Project analytics: 360° insights for successful project delivery
Hi there! Project management is a key enabler for efficiently managing the volume and velocity of business efforts and delivering ambitious growth rates. By adding a layer of 360° analytical insights, project managers are better empowered to successfullyNew 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 supports
Zoho Pagesense Resources
Zoho DataPrep Resources
Zoho CRM Resources
Zoho Subscriptions Resources
ご検討中の方
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
Zoho Desk Resources
Zoho WorkDrive 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
Most Discussed Topics
Zoho Books - Payments Made does not Connect to Invoices table?
Hello Zoho team, We have set up a sync from Zoho Books for most modules including Invoices and Customer Payments. All our payments are always applied to an invoice. Using API we can always find the invoices that a payment has been applied to. However,Transfer Data Source ownership in Zoho Analytics
Hi, I am an "Organization Admin" in Zoho Analytics, and I'm managing the whole thing on my own. Eventually, I'm gonna be an "Account Admin" so that I have no further issues or restrictions, but for now, I'm not. My problem is that I'm working on a DataOpen tickets per day
Hi, Day 1 of working with Zoho Analytics for me. I'm want to create a dashboard with multiple widgets and bar sets on it. One of them is a Line chart with the following info: X-axis = first day of the month untill the last day of the month (so if i selectHow to find ZohoAnalytics OrgID?
Hi reader, I hope you are doing well. I've been trying to work with the Zoho Analytics API library and have has no problems with the auth and token refresh steps, very clear to use! However, for actually interacting with ZohoAnalytics itself through theChange over Time Graph (or Trend Line Graph) of Daily Average of Staging Duration
I'm not sure if my question title does explain my issue but I will try to explain it in detail. We are creating dashboards which include staging reports created with data from Zoho Desk. The main report on these dashboards has a bar chart which shows
Sticky Posts
Announcing 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 PreparationZoho Analytics | Quarterly Newsletter | Q2 2022
Hello Everyone! I hope all of you are safe and well! Zoho Analytics - Q2 Quarterly Newsletter is out now! Check out the newsletter (attachment) to know all about our new features, recognitions, webinars, blogs, and many more exciting things. Do let usZoho Analytics: 2021 Look Back
As we start a new year in 2022, here's some of our top moments from 2021. Zoho Analytics in 2021Update on the recent Apache Log4j2 vulnerabilities - Impact on Zoho Analytics On Premise Deployments
Dear Users, Three high severity vulnerabilities (CVE- 2021-44228, CVE-2021-45105 and CVE-2021-45046), impacting multiple versions of Apache Log4j utility, was disclosed publicly on December 9, 2021. We have found no evidence of any successful exploitationAsk the Experts #19: Five hours live Q&A session with Zoho Analytics product experts
Hello all, We are excited to host the next online community event in 2021 - Ask the Experts #19 on 25 November 2021 between 05:00 AM - 10:00 AM PT. If you've had any questions about the Zoho Analytics features or prefer to learn more, join the discussion
Top Contributors
Charanya R
Vaijayanthi V
Ashton Jensen
Mikhail Koval
Ryan