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 to
Analytics 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 message
Sync 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 time
Is 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 planning
Row 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 calendar
The 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 required
Embedding 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 these
Controlling 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, then
Scheduled 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 is
Pivot 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 screen
Underlying 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 Data
Open 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 select
Formula Column 'aaa' cannot be removed.
how do i remove a Formula Column? this product is frustrating... Table report
Exclude 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. Can
Analytics-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_id
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,
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 in
Drill 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 project
How 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 the
Report 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 the
Time 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.75
Dates 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