Problem with scheduled report sending in Zoho Analytics
Problem with scheduled report sending in Zoho Analytics. Reports are not sent due to size. How can I increase it?
Data Discrepancy Between Zoho Books and Zoho Analytics
We have connected our Zoho Books account to Zoho Analytics, but we are noticing that the data being imported is not accurate or consistent between the two platforms. Despite the integration, there are discrepancies in the data values. Could you please
Data Discrepancy Between Zoho Books and Zoho Analytics
We have connected our Zoho Books account to Zoho Analytics, but we are noticing that the data being imported is not accurate or consistent between the two platforms. Despite the integration, there are discrepancies in the data values. Could you please
Zoho Projects Work Hours into Analytics
Since the most recent update, my Analytics reports that were comparing Zoho Projects Work Hours (estimate) against Timesheet Hours are gone. They were actually deleted. When I try to recreate them in Analytics there is no "Work Hours" field. Where
Dynamic Date Filtering for KPI Widgets – Need Help with Query Table
Hello, I'm seeking help with setting up dynamic date filtering for my KPI widgets in Zoho Analytics. Below is an overview of my setup and the issues I'm facing: Why: I need my KPI widgets to update dynamically based on a date range selected via a dashboard
Zoho Analytics - CRM Sync Failure
We have experienced consistent sync failures between our Zoho CRM and Analytics apps, but there aren't any details provided as to why this failure might be occuring. Please advise on troubleshooting steps so we can figure out how to restore the sync.
A/R Aging Details shows wrong aging days
In the A/R Summary Report all of the invoices are in the right aging buckets. When I run the A/R Aging Details report I get aged dates of +300 days when they should be in the 0-90 day range.
Chart with Filtered Data vs Unfiltered Data
I am looking to create a chart view that displays the full data set vs a subset of the data filtered by user filter. However I do not seem to find any method by which to exclude a plot from the applied filter or any other method by which to display the
How to create comparison time periods like these examples
In a Pivot Report I would like to be able to select any date range and show a set of metrics for that date range e.g. revenue, orders, units sold. I would then like to be able to compare to the previous period based on the amount of days on the selected
Bar chart from Deal Stage Snapshot table not showing right amounts
Hi, since we needed to track the changes of our deal pipeline over time, I added a new data source and selected 'Snapshots' to start the sync. At first I thought it was working just fine, after a few days I realized that something was wrong with the amounts
Unable to parse JSON field in New Query Table
I have a multiple level JSON field which I am unable to parse. "Complete Blocks"."EVENT_SCORES_JSON":"OverallScore" as Score The above line returns the full "Complete Blocks"."EVENT_SCORES_JSON" field as a Text type field i.e { "OverallScore" : XX, ect...
Facing Sync Failure Issue
Hello, I am using Zoho Analytics with Zoho Books integration. Recently, we have been facing a data sync failure issue and the reason for this is a temporary error. Do you have any idea about this? Do you know how we can solve this? I would appreciate
Pivot table has the maximum data points
When I make the pivot table that I need, he says: Data points exceed the maximum rows limit allowed in Pivot tables. 'Show Missing Values' option applied partially to show the pivot. But I only have 5 columns and maybe 80 rows. How is this possible? (I
ZIP Codes not Available on Zoho Analytics
Hi, I'm currently trying to create a Chart Map in Zoho Analytics, but I'm struggling to get all my data points displayed because not all ZIP codes from my database are available in Zoho, even though they are valid sequences. I can't provide a specific
Error Authentication type 10 is not supported
Al conectar Zoho Databridge con Postgresql mostro el error : Authentication type 10 is not supported 2. I get this message "Authentication type 10 is not supported". How do I resolve this? Zoho Analytics uses the MD-5 password authentication method. If
Reports and Dashboard required on targets vs achieved -
We have a CRM module that has information about the targets and another module that stores information about the achievements. The target table has the target set for an entire year and has a field called target start date as 1st of April that year. There
Everything is gone!
I set up Zoho Analytics over a year ago to pull data from Excel spreadsheets that are saved to my onedrive. I created reports that calculated scores based on the data and then dashboards to display these results. It took a long time to set up. I run these
Report Data Table in Microsoft Excel or Zoho Sheet
we are built automatically generate po order as per our item qty reorder level etc... in excel sheet prepared for po import in zoho book. I create item-related report in zoho analyst. i was daily report download excel sheet in my folder and this excel
Frequent Zoho Analytics Sync Failures
Analytics sync is continuing to frequently fail - every 2 or 3 days we'll have a sync failure with unhelpful messages like this: When you try a manual sync on the failed table it typically says "sync already in process" even though it's clearly errored
Zoho Analytics Error
Hi Team, I have been facing this issue with my dashboard. Kindly provide me a solution for this.
How can I delete my last data import on Zoho Analytics?
I recently uploaded the same excel file twice and need to delete the duplicate data. Is there an easy way to delete my last import?
Zoho Much Slower Than Usual
Hi Zoho Team Over the last 3-4 weeks I have noticed a major slowdown with Zoho's speed using dashboards, and also when trying to import data and edit graphs. Is this a problem other accounts are experiencing, or am I having a unique problem? I have performed
Merging Tickets in Desk => Bad Data in Analytics
Curious to know if anybody has experienced this issue when dealing with Desk to Analytics integration: 1. You have two duplicate tickets in Desk so you decide to merge them (in Desk). 2. The ticket that was deleted during the merge is obviously no longer
Synchronization between Zoho Analytics and Zoho Desk not working anymore
Since last Friday, our synchronization between Zoho Analytics and Zoho Desk keeps on failing.. How can I solve this problem?
Request for Assistance in Importing Full Data from Xero to Zoho Analytics
Hello Team, I hope this message finds you well. I am writing to seek assistance with an issue I am encountering while trying to import data from Xero into Zoho Analytics. Specifically, I need to import data spanning the last 5 to 10 years. However, Zoho
Zapier and Zoho Analytics API
I'm having a problem setting up a Zap using the Zoho API. I'm currently using the Zoho analyticz API to get data and write data into tables using Power Automate Desktop but for a certain task i need to connect it to Zapier to get the last row from a table
Find and Replace on filtered Table
Hello, am I missing something from the procedure? I filtered a table then I am trying to replace a text value, but it says no rows match. The column is unbound free text and I am using it as Status (want to replace "available" with "disabled" text). Any
Data imported through URL data sources will show HTML codes instead of special characters.
We have a data source configured to import information from a URL. Some of the data contains apostrophes that will not be displayed as the actual characters but as HTML code. Example: let's go will be displayed as let's go Is there an option in the
Trial: Project Status Overview Report Not Showing All Projects
We use Zoho Projects to track our teams IT projects. I'm currently evaluating Analytics to get better reporting capabilities of our projects. Unfortunately, when I run the "Project Status Overview" report, only 2 projects of the 8 projects currently open
Zoho report aggregate function issue
Hi, I wanted to write a formula connecting 2 tables. But currently im facing this error Alert Message Sorry, you cannot create a formula column involving columns from multiple tables. This is my formula. Can you help me with a workaround. Infact, i have
Mapping Date Columns in Filters
Hi Team, I created a chart where I am tracking USD in proposals per month by their sent date, won date, and projected close date. Those dates are all fields in the proposal record. On the x axis I am using sent date. On the y axis I have a sum_if formula
How to retain Currency formatting in the concatenated the column
Hi Support Team, I would like to keep the Thousand Separator for the " Refund Amt" column. This " Refund Amt" column has been concatenated with the "Bill no" Column. The Table is generated via SQL Query. SELECT DISTINCT (VC."Vendor Credit Number") as
Automatic Left Aligment for Formulated Column in Pivot Table
HI, From last 3 days, all the pivot table where we created a column with formula is automatically setting left alignment and very hard to change to right aligment. some time it take morethan 10 attement to change the format in setting option to but fail
Compare data between two data
I have a problem that I would like to create a chart that can compare data with the following date ranges. This previous week (meaning last 7 days ) vs the data before last week days (meaning data before 7 days ).
Zoho Analytics -
This might be a complex question, but I it's in high need in Zoho Analytics. I would like a chart that can compare data with the following date ranges. This last week (meaning data of last 7 days ) vs. data before last week ( means data range before previous
Grouping of Dates in Zoho reports needs option for monthly, quarterly, and Yearly
When trying to group records by dates in Zoho Reports, there is no way to group by month, date, or yearly, Any Ideas of how to do a work around?
Zoho Analytics - Charts are not updating for Dashboard
I have created a dashboard linking my Website Google Analytics, Zoho Campaigns and LinkedIn. Whenever I choose the date range - One Week, One Month, 3 Months etc. it does not change the Data. Am I missing something here?
Total Data Widget
I`m writing to request your collaboration because when I use a Widget to count IDs the total data recorded in the database, but the total is not being reported. For example, if I have 30k id´s in the database, the Widget just report 28k. I have been waiting
Error: Sorry!! Unable to display this page
Is Zoho Analytics down?
Cannot change data type from multi line text to plain text
Hey team, I have a column of data that has values which are no longer than 12 characters in length. There are no blanks. But I cannot change the data type of this from multi line text to plain text. Any ideas how I can force this? Thanks Carl
Next Page