API problem request
I'm Brazilian and I don't speak English, I'm sorry if the grammar is incorrect. I'm trying to consume Zoho Analytics API to send data to a table. The idea is to make a routine that will be executed every day to send the updated data. But when I try to
Private Links Available In Basic & Standard Package
Hi Everyone, I would like to know how many private links are available in the Basic & Standard package.
Missing fields in Zoho Analytics for Overdue Tickets
I'm looking for two fields in Zoho Analytics namely Is Overdue Is Response Overdue These fields exist in Zoho Desk but not in Zoho Analytics, and I require them in order to replicate a report in Zoho Analytics that I built in Zoho Desk. Any idea where
B2b Sales timeline filter issue
Hello Team, We are into b2b our sales cycle if minimum 3 month, I am trying to create report to get the conversion ratio as follows Deal Created Date Deal Close Date Conversion Ratio 10 deals ceated 2 deals closed xxx Now the challenge is when I apply
Changed Lead Source in Zoho CRM not syncing to Zoho Analytics
Hi, I've setup Zoho CRM. I've setup Zoho Analytics. I've added Zoho CRM as a data source for Zoho Analytics. The information has synced across. I have now had several days of automatic updates between Zoho CRM and Zoho Analytics. Most data seems to be
[Upcoming Webinar] Win with Analytics: Overcoming 5 critical sales challenges
According to a Harvard Business Review study, companies that excel in sales pipeline management witness a remarkable 28% increase in revenue growth. To clock such accelerated growth rates, sales teams must adopt a comprehensive approach that enables them
Sort a pie chart legend by the count
Is it possible to change the sort order on a pie chart to list the values in order by the count vs. alphabetically by the name?
Pause All Imports
Is there a way to easily pause all imports into a workspace? Like a toggle off switch? Thanks
Analytics : Highlighting a single bar in a bar chart
I have a bar chart showing values across a year by week. I have a user filter to change the selected week, however the year graph will remain as showing the full year. Is there anyway to conditionally format or construct the year graph to highlight the selected week ?
Aggregate function to count current month leads.
count_if(date(("Join Leads & Opportunity"."Leads.Time")) = 'current month')
How to get data based on current month using queries
My time field has date and time both. SELECT count("Id") FROM "Leads" where "Time" = month(now())
New Features rolled out on Jun 15, 2023
Advanced Analytics for ShipStation We are happy to announce the release of Advanced Analytics connector for ShipStation. The connector comes with 50+ hand-picked reports and dashboards that provide deep insight into your order and shipping management
How would you create a report that shows last week's Deal Stages to Now Deal Stages?
This is not achievable with CRM Reports. It might be possible in Analytics. It looks like it might require hand-coded SQL. I welcome your input and ideas.
ZOHO analytics 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
Data Validation - Date Range
I have a table in Zoho Analytics that I manually add records to: UserName - StartDate - EndDate ExampleData: JoeSmith - 1/1/20 - 6/1/20 JoeSmith - 6/1/20 - 1/2/22 JoeSmith - 7/1/20 - 1/2/22 Is there a way to prevent the last entry from being entered/saved
Zoho Analytics Pivot Table
We are trying to generate a sale analysis reports for all the customers in Zoho Analytics Format of Report: <Customer Name><Invoice Numbers><Items> But when we are generating the report, we are taking base table as invoices. We can see only customer ID
Graph Data Load Time
Has anyone else noticed a timing lag between updating a data set and that updated info visually changing in graphs? It used to be nearly instantaneous when you updated a table of data and the visual sets updating correspondingly. But the last day or two
Zoho Analytics Sync Status "In Queue" for so long that import Fails
Currently Zoho Analytics is failing to sync from an AWS source as the process is placed in the status 'In Queue' and remains in that status for so long that the sync fails due to "Taking Too Long". This seems to happen every 7 to 10 days and can last
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
Issue with Zoho Analytics API when adding rows using Postman
Dear Zoho Support, I have been encountering an issue while attempting to add rows to a table using the Zoho Analytics API through Postman. My goal is to iterate over all Postman global variables that end with '_Managed_Devices' or '_Managed_Computers',
Sort Y Axis
Is there a way to sort the Y axis descending like for a ranking chart? This seems like an easy feature to make happen if not. See below chart for an example.
Zoho Analytics Dashboard - Export to PDF
Hi, I have previously created a number of dashboards that are shared via email as PDF attachments. The PDFs are all exported using the Layout as Dashboard option, generally this has been reliable. The latest dashboard isn't behaving correctly on export,
Looking for someone good with Zoho Analytics
Looking for someone good with Zoho Analytics, can organize tables, create relationships and ensure database is up to standard.
White dashboards
Hello, Since a few days I cannot see the dashbaords anymore. Only white screens Can you help me please ? Thanks
Dashboards not loading
Anyone else been having an issue lately with dashboards not loading? Below is an example image. For a month now it has been getting increasingly worse, what happens is the dashboard will load the boundaries of the graphs, but no data will appear. After
Creating accounts map
Hello, I have a database of companies (accounts) in ZOHO CRM linked with ZOHO ANALYTICS. I have several informations on them, including Zip Code, adress, etc. I really need to plot them on an interactive map, but i have a problem using Map Charts in analytics
Dashboard widget for same day last week
Hi, Just wondering if it was possible to have a dashboard widget that would get the data of a sales amount from yesterday, say Wednesday in this case, and compare it to the same day, Wednesday, from the previous week only? 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 get a Daily Average for the Total Sum of Each Group in my data table
I am working with a rather large data set (aprox 50k data points per day), where each row is a record that has a VOLUME and a GROUP identified within each record. Approximately 10 groups in total, and the dataset is 90 days of info. I am needing to display
Aggregate Formula for rolling 12 months
Hi I'm trying to change this YTD formula to be for the last rolling 12 months. I though that I could use a calculation on the Fiscal Month Number parameter but I can't find the right formula: YTD(count_if("Tasks (Zoho Projects)"."Status" = 'Closed' AND
Enhancement Suggestion: Tabular View Report Adj Header Row Height, Text Wrapping
The Tabular View Report is incredibly useful. However, even if you adjust a query to display a shorter version of the field name at the top of the column using the "As" statement, often the width of the field name is much wider than the data in the column. So it would be really helpful if you could have either adjustable row height for the top row or text wrapping with an automatic top row height adjustment that would allow for the field name to be displayed at any column width. This way you
Query That Is NOT A CASE SENSITIVE QUERY
Hi, How do you create a query that is not a case sensitive and will show all data that has the same value from the first word? For Example ================= | ID | Account Name | --------------------------- | 1 | Mike Studio | | 2
Limiting Access to Specific Tables in Analytics
I have multiple lead resources that need to create/maintain reports/dashboards for their areas. I want to limit the data tables they have access to, they should not see sensitive data, etc. from other areas. I don't want to manage multiple workspaces.
Migrating Zoho Analytics Integration from Google Universal Analytics (UA) to Google Analytics 4 (GA4)
Dear Customers, As Google announced, the deadline for migrating from Universal Analytics (UA) to Google Analytics 4 (GA4) is approaching. In light of this, we would like to provide you with updated instructions on how to handle the migration of reports
[Upcoming Webinar] 5 key practices for building informative analytics dashboards
Hi there! In today's data-driven world, the ability to deliver and consume insights in a concise yet effective way is crucial for businesses. A well-defined dashboard serves this need by facilitating a central hub of data insights that provide an at-a-glance
Zoho Analytics report alerts - support emailing a CSV file
In Zoho Analytics report alerts, there is ability to send an automated email with an attachment but the system does not give you an option for what file type to use for the report. It defaults to an HTML attachment. Instead, can you provide capability
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
Report of the Week - Pareto Chart
A Pareto Chart helps identify the frequency of a factor (count) and its cumulative impact. The chart is a combination of a bar and a line chart. The bar represents the count of the components being analyzed and the line represents the cumulative impact
Next Page