Understanding trend line coefficients
I have a graph where i need to understand the trend. The graph is fairly simple, and the trend analysis should be linear, so y = ax + b. So for the below graph i would expect something like y = 16x + 5 (approximately) When I look at the details for the
How to use values of two widget in the third widget
Basically I want to use values of two widget in the 3rd widget. I have two widget with different values, I want the ratio of these two values in the 3rd widget. Help is really need. Thanks Ravindra
New Features rolled out on May 23, 2023
ChatGPT Integration We're excited to bring you the ChatGPT Integration, designed to simplify complex tasks like writing queries and formulas. You can also find public datasets right within Zoho Analytics without switching tabs, get help in creating formulas
Map-Pie chart / Slice Sizes all equal
Hello I am using the Map-Pie chart with a custom image. The image is below, and is a blueprint of my manufacturing floor for my machine shop. Each Box represents a different machine. Inside each box I have mapped out pie's charting the hours worked by
Integrating Page Speed into Reports
Does anyone know how to integrate Page Speed Insights into Zoho Analytics reports?
Is there any table or field to find out which projects are associated with a recurring invoice in Zoho Finance?
Is there any table or field to find out which projects are associated with a recurring invoice in Zoho Finance?
how to get median to work?
i can't seem to get the median custom formula to do anything. when i add it as an aggregate function, i get an error saying: "Sorry, cannot create a Aggregate Formula. You need to have an Aggregate function used in the formula. For other types of formula, use "Custom Formula" option." which is odd because median certainly feels like a function that would only apply in aggregate. when i create it as a custom formula field, it never gets any value.
Matching dates of 2 columns (fields)
Hello, I want to make a table with the number of visit reports created per person (counted number of visit reports created in a custom module in CRM) and a second column with the target visits (this is filled in a field on a report on each month created
ZOHO URL criteria on two tables
I'm trying to publish a dashboard for several companies by scheduling an email and giving them a URL for the dashboard per company. I have one dashboard with a user filter by company drop down on the whole dashboard. The dashboard consists of reports
Add Vertical Threshold
I would lik to suggest adding a vertical threshold so that a line can be drawn vertically and not just horizontally. This would be great to denote a certain event it time when time is the X axis. Can you please add this to the feature list? Makes the charts much more descriptive.
Quick response appreciated - Vertical line on line graph
Hi, I need to present a line graph showing historical and future data points. What I'd like to do is add a vertical line to denote the current date - to clearly show what is past and what is future. How can I achieve this please? Thank you Marc
Trying to partition data from Zoho Desk into Analytics when a Contact is associated with multiple accounts
I have an interesting use case wherein a contact is associated with multiple accounts in Desk. I created Desk tickets for each account associated with that contact. I then went to Zoho Analytics to look at dashboards. I added an account filter but all
Regarding Top 10 customers sales Manager wise
Hello, How to show top 10 customers Manager wise . I have row wise data customer and manager wise. But whenever i try to filter by top 10 rows , it shows only top 10 customers instead of Manager wise. I want to show data as below if suppose we have Manager A and Manager B : Manager Name- Customer Name -Row Total ----------------------------------------------------------------- Manager A -> customer 1 - > 10 Manager A -> customer 2 -> 30 . . . Manager A -> customer 10 -> 100 -------------------------------------------------
Fetch Record From Second Table in Aggregate Function
Hi, I need an Aggregate Function that counts the number of records in the Calls table that: 1 - Are associated to a Deal; AND 2 - The Deal associated to that Call is in a stage called "6 - Proposal Presented to Client". I am using the following function,
What's wrong with this formula column?
Was wondering if someone could possible look over this and tell me what is wrong with it. Please note that my aim is to have the bonus item, followed by its quantity in brackets, each on a new line, but only if there is a bonus item on that level, sort see what i mean? if("Bonus Item 5"='',if("Bonus Item 4"='',if("Bonus Item 3"='',if("Bonus Item 2"='',concat("Bonus Item 1 (Home-bred animal)",' (',"Bonus Item 1 Quantity",')')),concat("Bonus Item 1 (Home-bred animal)",' (',"Bonus Item 1 Quantity",')',CHAR(10),"Bonus
Continuous Failed Import
I have an import that continues to fail. It used to have a data prep step, but I deleted the data prep. Since I deleted the data prep (because it was failing), now the whole report continuously fails to import. I REALLY don't want to have to delete the
Reports Deleted
Hi Team, I login this morning and saw my Leads Dahsboard showing "View Deleted" on each report. I logged in and checked, Except three reports, each report under "Leads" folder of "Experitest CRM Reports" is deleted. I have like around 15 reports in there. Can you please quickly check what just happened and how can I recover those ? Thanks, Hasan
[Upcoming Webinar] 5 common data & analytics pitfalls businesses should avoid
Hi there! A study by Forbes revealed that 87% of organizations believe that data is their most underutilized asset. In order to bring down that percentage, BI vendors, analytics users, and other stakeholders are exploring many ways to enable businesses
Need help on reports (Actuals vs Plan)
Hey guys, I need some assistance on a problem im facing. Currently we have our actual numbers for our billable hours and revenue that we generate. We wanna compare this to our planned revenue and billable hours accross 2023. We have added a new dataset
Schedule a report at the end of the month
Hi I would like to schedule a report to be sent at the end of each month. If I set this to be sent on the 31st of each month what would happen for months that only have 30 days? Would this send on day 30 instead? Dan
Multiple IF calculation
I'm trying to write an if statement that is fairly complex. In Excel, the formula looks like this: +IF(E2<0.2,(F2*0.05)*0.7,IF(E2<0.4,(F2*0.15)*0.7,IF(E2>0.39,(F2*0.2)*0.7))) Using the value of a specific cell (depending upon if it is lower, between or above a certain value) I am applying one of 3 mathematical operations to a different cell for the result. When trying to "map" this style over to the "IF" statements in Analytics, I am receiving errors. Here is an example of the data I'm trying
Won / Lost Amount not showing
Hi there, No figures show up for won amount / lost amount even though there is data in the won / lost swimlanes in the CRM. We have an auto sync every 3 hours. Regards, Sarah
Using "NOT IN" in WHERE clause
I'm trying to exclude records from a query by using a "NOT IN" clause, but it's not giving me what I want. I even tried "NOT LIKE" I need to exclude the string 'Dev or internal testing' from a column with a mixture of blank cells, but when I run the query
Change Report/Dashboard Owner in Zoho Analytics
Need a way to change the ownership of a single report and a dashboard from one user to another.
Unable to view any reports, tables or dashboards
Hi everyone, I'm getting this error: Sorry, refresh operation of the underlying query table was aborted, as processing time exceeded the allowed time limit. Please try after some time. Contact support, if the issue persists It looks like it is happening
IF LIKE '%%' FORMULA COLUMN
I'm trying to create a formula column to search for a piece of text in a field using an IF statement, and return a value. Normally in SQL I would do something like IF("column" like '%abc%', 1, 0) but that doesn't seem to work. From what I can tell it's
Looking for a way to create custom date filter
Hello! I'm looking to create a custom date filter for some entries. I have a lot of transactions for multiple loans and I'm looking to create a custom date filter for the following case: Let's say that we start to receive our monthly amounts back. At
New Google Sheets
I have a Old Google Sheets file that I have migrated to the the New Google Sheets. When I try to import the new sheets file it will not import it. A box pops up asking to "Please authenticate with your Goggle account". I have had no luck getting past this and it does not happen when I import from an old sheet. Thank You,
Chart from Zoho Survey
Hi Zoho Team I have integrated Zoho Survey with Zoho Analytics, some of the surveys have scoring enabled I need to get that information from Zoho Analytics, I have checked individual responses an I found the information how ever I need to create a chart and some KPI's eventually Regards,
How to get Stage history in zoho report
I am trying to create a report in zoho advance analytical that fetches all the potentials which had a change in Stage during the past year but we can’t find any formula to get potentials whose Stage were changed past Year. Could you please help me to find formula available in the Reports section in Zoho CRM?
Error en los filtros
Saludos. Al intentar ingresar en los filtro de los gráficos que he realizado, y con los que he trabajado sin problemas hasta el presente, me aparece de manera intempestiva el siguiente mensaje: "El parámetro COLPARENTVIEWID no es apropiado (no se ha enviado o es menor que el recuento necesario)" Impidiendome continuar trabajando en los referidos graficos. Agradeceria su apoyo para solucionar la presente situación. Gracias.
Countif contains a certain text string
I'm trying to create an aggregate formula that counts all the rows in a column if it contains a certain text string. I can easily create the formula if it equals a certain test string, see below. countif("Table"."Column"='xyz') The formula above will count the row if the cell only contains "xyz". it will not count the row if the cell contains "xyz pdq". How do I change the formula to count the rows in a column if it a cell contains a "xyz" along with any other string?
New Features rolled out on Apr 28, 2023
New Business Application Connectors We are excited to announce the availability of two new business application connectors. Google Analytics 4 (GA4) Advanced Reporting Zoho Analytics empowers your Google Analytics 4 (GA4) data with sophisticated reporting
Not able to edit a schedule in Analytics
Hello, I am trying to edit a schedule report in Zoho Analytics, but for some reason when I click on the Send button or when I try to Send, or edit the schedule, nothing is working. We've tried the org emails and the even sending with Zoho notification
ZoHo Reports / ZoHo CRM Realtime Data
ZoHo CRM is always being updated with data required by a remote sales team, this data is real-time in ZoHo CRM. Whilst the dashboards in ZoHo CRM meet basic requirements, ZoHo Reports add that additional layer of information representation. It baffles me why ZoHo Reports doesn't have real-time integration with ZoHo CRM. This would be a huge advantage for our business and I'm sure others. I'm forever being asked by our sales team, "why is the data out of date?" in this dashboard. Is realtime reporting
How can I use the Reports to show Products attached to Accounts & Potentials in the CRM?
I'd like to be able to report on the Accounts and Potentials in our system and show what Products are attached to each. When the 'Products' sync to the Reports module, it is just a table of the products entered, non-relational. The Accounts and Potentials tables also have no relational field to Products.
Adding Amazon S3 Data Source
I'm trying to add an Amazon S3 data source but I'm getting an error "Failed to fetch the buckets. Reason: Access Denied" Our dev team only granted me access to a certain path and not the entire bucket, so could that be the reason why I'm failing to add
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
Zoho Analytics
Hi Guys, seems Zoho Analytics is down Super slow loading times
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,
Next Page