Collapse Columns should be added as option
Dear Zoho Team, I miss the option to collapse columns ( see picture). Could you please integrate this option? Ana Jeva
Picklist History in Reports or Zoho Analytics
Hi there, I am trying to track our Lead-Funnel Stages with a Picklist. While I see the history through the stages I cannot find a way to access the history in reports or Zoho Analytics. is there a way to do this? Thanks, Hannes
send Alert to User Groups and not only per Email Id
Dear Team, How can I create an ALER message that will be sent to the specific User Group? We have 40 users who should receive alerts. It's really time consuming to add each email separately for each alert setting. Thank You , Ana Jeva
User filter contains
Hello, Is it possible to have custom made user filters ? We would like to have a user filter that combines Accounts which are containing a same piece of text in the Account Name. Example of some Account Names: Warehouse 1 Warehouse X Mini Warehouse West
share folder to user group with filter criteria
Dear Zoho team, Could you include an option to share the folder with filter criteria? Problem: I have many reports in one folder, to save time and use the same filter criteria it would be much more efficient to share the complete folder directly rather
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
Historical data - to remain unchanged
Hi I have created comparison funnle charts to show different stages of my B2B sales pipeline. Th charts are based on
Add more values to database variable
Hi, Is there way to add multiple values, perhaps separated by comma in the variable value that is associated to an email address. I understand the work around would be to create a new map value pointing to the same email address. But that would be a bit tedious. Say we have John Doe who can view reports for West and East region. I am assuming currently we have to add two map values. This is not too hard if you just had two map values. What happens if you had 100 product categories and need to may
Collapse groups in a summary view?
How do you collapse group rows in a summary view? Or to collapse a section in a pivot view? Is there anything like a tree control? This would seem like basic functionality for display of grouped data. For example, suppose I have a pivot view with a summary
Date filter
Hello, Our fiscal year is starting in september. I created a chart with filter to start in Y2023 and that it should be possible during the year to see chart results per Month in the new fiscal year. However when I create a dashboard with that chart, it
Zoho Desk integration - information about time entries whether they have already been invoiced
Hello, we use zoho desk with the zoho books add-on. Thus, the time entries that are marked as billable ("isBillable": true) can be charged with zoho books. Using the Desk API, I can access the information of the time entry I need, so it's definitely
ACCOUNTID being "Truncated"
I am using ZOHO Reports in conjunction with ZOHO CRM. When I export the Events table to either and Excel or CSV file, the ACCOUNTID number gets truncated, or rather the last three digits get replaced by 0s in the Excel or CSV. I have attached an example with screen shots. In ZOHO, ACCOUNTID is an 18-digit field (e.g., 917037000000222130). When you exporting it either to Excel or CSV, you see 9.17037E+17 in the Excel/CSV column; when you look at the actual number in the field it is 917037000000222000.
Join Tables
Hello Dear Zoho Team, When I want to join two tables from the same source, I get this error that I uploaded in the attachment. It is very important that we join these two tables. How can we fix this problem ? Thank you in advance for your help. Kind
Zoho Desk - Analytics Sync failure
Hello, The synchro between our Desk and Analytics Apps does not work anymore. The error message says: Reason for Sync Failure: The plan for your Zoho Desk account does not support Zoho Analytics integration. Solution: Please upgrade your plan if you want
Linking two tables by value
Hello, I am new with Zoho Analytics and would like to know how could I link two separate report tables/pivot tables? I have pivot views: sales and detailed sales These views has filter OrderNo In sales viewI have OrderNo, totals sale price In detailed
Date Field not Populating
Hello when uploading data, the Date columns return with no data at all, the data table has about 6 million rows. I am not sure how to fix this?
Date setting
I have my dates all set to USA format (mm/dd/yyyy) for my data imports, but after import Zoho still flips the format to dd/mm/yyyy in my raw data after its imported. How can i stop this from happening?
Analytics IP WhiteList
Hello, please, tell my whitelist IP addresses for data center analytics.zoho.jp Thanks
[Upcoming Webinar] Retail analytics: Identifying revenue hotspots and optimizing retail operations
Hi there! With the number of individual moving parts involved in the retail value chain, advanced retail analytics has become an integral part of decision making for retailers of all sizes. By transforming raw data into actionable insights, retailers
New Features rolled out on September 15, 2022
Enhancements for Advanced Analytics Connector Advanced Analytics for Zoho Commerce Advanced Analytics for Zoho Finance suites now supports Zoho Commerce too. This helps you to manage your online store effectively and market it with ease. You can also
📢 [Blog]: Boost your online store sales with Shopify sales reports
For businesses of all sizes, it’s imperative to keep an eye out for particular sales metrics. Specifically for an online store run on Shopify. What’ll be your Shopify store’s average order value for the next 3 months (or the next 2 quarters? or the next
Web chart - change fill colour?
Hi I have a web chart which is perfect for what I want to show but I can't see any way to change the colour of the fill from default blue. Am I missing something?
Cumulative stacked bar grouped by status
Hello, I did that chart: Its almost what I want, but when I try yo color by status, I got that: So, I'm having trouble to group my status and get a cumulative stackedbar, like that: Any idea how to manage that? Thanks in advance!
Remove limitation to import only up to 100 fields from a single Zoho CRM module
Zoho CRM supports creating of over 300 fields per module. Zoho Analytics supports import of only 100 fields per Zoho CRM module. Please consider removing this limitation. Best regards, Mladen Svraka Zoho Consultant and Authorized Partner www.mladen-
Help with the creation of a report
Hello, We need a report "Hours by projects" with a way to reduce the hours by 20% if the employee is a junior. I would like to see the last column with the adjustments and the previous one with the real hours. I've tried with a customizes field in Staff
Query with WHERE function not working
Below is my query code SELECT DISTINCT "Network", "DepartmentName", "ActStartDate", "ActEndDate", "Actual Days to Complete", "EstStartDate", "EstEndDate", "Estimated Days to Complete", "On Time vs Late" AS 'Aero Build OTD' FROM "Eagle_AllHoursReport"
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
Count with Multiple Conditions
Hi Everyone, I have simple DAX formulae which I have been trying to implement as an aggregate formula in Zoho Analytics. If anyone could give some inputs for the same. Attaching the DAX which I created in excel: 1. Formula I: 2. Formula II : Any help
Custom Query Editor: Selected text is automatically removed when clicked on
Hello, in the Query Table Editor the selected text is automatically removed when clicked on. Repro Steps: 1. select text 2. click on the selected section (somewhere on the purple highlighted area) 3. the selected text gets deleted This is very critical
Major Issue with Data Import using 'Prepare Data'
The end goal for my project is to schedule booked capacity in my business by importing from my Project Manager database. The imported data will include the department, the job number, the estimated and actual hours for that job, and the projected start
Page Break
How do I add a page break to a Dashboard for printing?
Zoho Reports - Invert Axis
I have a simple bar chart that shows the average number of people achieving a certain score (between 0 - 8). The chart shows the value 8 as the highest on the 'y' axis. This is fully understandable. However I need to display the results with 0 being the highest and 8 the lowest (i.e. invert the 'y' axis values with 8 at the base and 0 at the top). Is there any way I can do this with Zoho Reports?
📢 : Zoho Analytics is a winner🏆 in 2022 Industry Excellence Awards
Dresner Advisory Services has recently named its 2022 Industry Excellence Award winners. The annual Industry Excellence Awards acknowledge vendors who have achieved leadership position in the company’s 2022 Wisdom of Crowds Analytical Data Infrastructure
CountIf formula for multiple stringtypes
I am trying to calculate the amount of times I made contact with someone. The results require counting multiple string values. This is what I am trying. count(if("status"=('stringvale1,stringvalue2,stringvalue3'),1,Null)) Normally I would do a COUNT(FIND_IN_SET(status, 'stringvale1,stringvalue2,stringvalue3')) What should i try? Sincerely, Josh
How to use COUNTIF with a NOT IN operator
countif("Tickets"."Status"!= 'Completed' or"Tickets"."Status"!='Closed' OR"Tickets"."Status"!='Service Call Completed'') countif(NOT("Tickets"."Status Group" IN ('Completed','Closed','Service Call Completed') I have tried this in multiple ways including
Engagement Rate Discrepancies between Zoho & native data
While pulling data for a monthly report, our team noticed some pretty big discrepancies between engagement rates reported through native data, versus Zoho. For example, the top LinkedIn posts in November yielded engagement rates below 1% in Zoho, while
Filter Table by Values which don't appear in Join table
I am trying to filter a table to the values which are not in a joined table. I have tried many versions but none seem to work, not sure what I am missing. SELECT "Site Details with Display Unit"."Account_ID" as 'Site Account ID', "Site Details with Display
subquery not working
Hi! I'm trying to make a subquery and the system will not let me, I've tried several ways with no result, Annex consultation to see if I can help SELECT DISTINCT "A"."Semanas", (SELECT SUM(CASE WHEN "Código"='SI' THEN "Saldo inicial del banco" ELSE 0 END ) FROM "Juan sql" WHERE "Semana anterior"= "A"."Semana anterior") AS "Saldo inicial del banco", "A"."Semana anterior" FROM "Juan sql" as 'A' GROUP BY "A"."Semanas","A"."Semana anterior" tells me that does not identify the alias thanks....
Use Zoho Analyitcs instead of Data Studio (Google)
I use DATA STUDIO to GENERATE DASHBOARDS for my DIGITAL MARKETING clients (Google tool), but I would like to know IF I CAN USE ZOHO ANALYTICS instead: - I need to send my customers a LINK for them to ACCESS THEIR DASHBOARD (no need to login), LIKE I DO
Issue with adding people to email distribution list
I have restrictions setup so that only accounts with specific email domains may be added to exports for emails, etc. As you can see in the image below, two domains have been added I am having problems adding a colleague to an email distributions list,
Next Page