Urgent / Converted from Lead remove form potencials? / Synchronization stops
Hi Team I need support ASAP, I've just recived an email with the following message: Zoho CRM data synchronization with Zoho Analytics has stopped on 20 Sep 2023 10:49:12 AM GMT due to some columns being deleted in Zoho CRM which will be deleted in the
'Undefined' instead of a number in a chart
Hello, I have a table in one workspace (Workspace 1), which I imported in a second workspace (Workspace 2). I have created a chart from this table, however in Workspace 2, instead of numbers in the tooltip, it just shows 'undefined'. There are also no
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
Delete rows
Hi, I have in my tables 4 records which are duplicated by some reason.... I need to delete those 4 manually. I go to DATA, search the rows, select the header but I cannot find the option "DELETE ROW". I can only DELETE COLUMNS. Please help. Thank y
Logical Operators in Zoho Analytics Query
if_case ( "Customer Address"."Item Wise Weight" > 100, ("Quantity Ordered" * "Weight") * 30) as "Zone Cost" Hello All, Requirement is to check the weight of the item and add a custom rate as a different column, but the above query is resulting in the
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
Analytics Dashboard Logged in user
Hello, I created a dashboard so our salespeople can keep track of their own KPI's. We want every salesperson to have that same dashboard BUT that the data of the charts/tables/... is updated to the the salesperson that's logged in. Also, the salesperson
People - Leave Tracker
I need to create a report that contains the leave tracker of the people in Zoho Analytics, but when integrating People I do not see the table with the information.
I can't change the currency format in zoho reports' zoho book extension
I use zoho books and zoho report. My currency is NOT $ in zoho books. But in zoho reports all the financial tables are in USD and it does not allow me to change the currency format.
No practical examples of how survey data is analyzed
There are no examples of analysis with analytics of zoho survey data. Only survey meta data is analyzed, such as number of completes, not actual analysis of responses, such as the % in each gender, cross-tabulations of survey responses. One strange characteristic
Analytics Dashboard User Filters Default Value
User Filters on Dashboard do not allow Unknown to be set as a default filter value. I have to include NULL values in my dashboard among other values but I can't include NULL/Unknown by default in Dashboard User Filters.
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
Problem when Exporting data through API without a ticket
Hello, I usuccesfully followed instructions to export through API without a ticket given in topic (https://help.zoho.com/portal/en/community/topic/remove-quot;ticket-quot;-from-mandatory-parameters-on-export-api-calls) The result I get is this message: { "response":{ "uri":"[...]", "action":"EXPORT", "error":{ "code":7309, "message":"You need to (re)login to export. Incase you have logged in already,then please refresh the whole page(browser) and try again." } } } Thanks for the help!
Error: View is not present in the workspace
When saving a dashboard, user receives a popup with the following error. "View is not present in the workspace" What does this mean or refer to? There is no further insight given.
Zoho Analytics with Facebook API
I connected my business's facebook account to Zoho Analytics. I am trying to make sense of the data, but I need someone to provide an assist. Looking at the premade "Page Insights" dashboard - The first column presents "Impressions" and "Post Impressions".
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
Underlying data columns
Is it possible to change the columns (make visible/invisible/reorder) when clicking "view underlying data" on a chart? See attachment Thanks
ZOHO Reports is not Working !
This error is coming up: Please fix it ASAP. Sorry!! Unable to display this page Sorry, an unexpected error occured when performing this operation. The error has been logged and will be looked into. It would be of great help if you could provide us with additional information using the ''Feedback'' link at the top of this page. 1. The error has been logged and will be looked into. 2. It would be of great help if you could provide us with additional information using the feedback link.
Unable to Export - Prompting for Login When Link Created using Access Without Login
When creating an export URL, I am selecting Access without Login however it is returning an error message "you need to relogin to do this operation" when attempting to export.
Report: Export as PDF
Hello, I created filters in the report builder. It works with the report view but not working when I export it as pdf. I was expecting WYSIWYG (What you see is what you get) in the exported pdf. Please advise if I did something wrong. Thanks, Edith
Solved: Zoho Databridge JDBC driver problem with European time zones and MySQL
If you are running in problems with following configuration: - Zoho Analytics and Zoho Databridge - MySQL on Windows server - default timeZone configuration just run following commands in mysql: SET GLOBAL time_zone = '+1:00'; or SET GLOBAL time_zone
API Export Dashboard as PDF with Filter Criteria from Multiple Tables
When exporting a PDF of a Dashboard using the API, it accepts ZOHO_CRITERIA which comes from a single table, but won't export when the criteria contains more than one table. For example, imagine a simple dashboard with two charts, one showing sales by
Inactive links when you export a query in Excel
After you export the table query in Excel all the links, even if the data type "Link" are displayed in the form of text, which is extremely inconvenient for work
Invalid numeric expression found
I am getting this error on several canned reports that Zoho provided with Analytics and on several reports I have created. I have not changed any of these reports and I have not altered any of the aggregate formulas that they use. Something has changed recently to cause this error. Alert Message Invalid numeric expression found. The numeric expression contains a String column/value which cannot be converted to numeric.
How do you join tables?
I am trying to join tables to create a report combining them, but any documentation explaining it or instructional videos are showing "Edit Design" button which needs to be clicked in order to create lookup columns. However, I simply don't have that button on any of my tables. What am I missing?
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?
Graphs with 'Full Date' no longer work
I have a number of graphs that are showing "no data available" . All of these graphs have data in the graph by "full date" - I also get the error circled below when I try to create a new graph "by full date" This has never happened before and suddenly
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
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
Automatic updates of lookup column data between tables
Hi, I'm having some trouble with Reports. I have 2 tables, one with seller names and information about each seller ("Seller Table") and a second table that tracks sales ("Sales Table"). The two tables are linked together through a lookup column, with the Sales Table "looking up" the seller's name for each sale from the Seller Table. The problem that I'm running into is that when I update the name of a seller in the Seller Table, that information is not automatically updating in the Sales Table. I
Another import is in progess in UploadTool. No other imports.
Suddenly started getting an error message when running UploadTool: Another import is in progess in this table started by the user 'yourstruly' at '24 Sep 2014 04:33:23(GMT)'. Please try again after some time or contact the Reporting Database ("mydb") Administrator. There are no other imports in progress. Uploading multiple tables. The failure is NOT on the first one. The setup was working fine for quite some time. No changes were made. - Best Regards
Can someone please "resend" my Confirmation link?
I seem to have lost it, and don't want to lose my account here. Thank you.
"Invalid column used" when using column aliases SQL
The following query runs and saves fine: SELECT TOP 10 "Country Code" AS Country, sum("Units") AS Sales FROM "Sold Units" GROUP BY "Country Code" However, this isn't that useful because it's not ordered. So, if I just do the final step: SELECT TOP 10 "Country Code" AS Country, sum("Units") AS Sales FROM "Sold Units" GROUP BY "Country Code" ORDER BY Sales DESC The query executes and displays what I expect. However, if I click "Save", I then see an error message: "Invalid column used". I'm convinced
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
Lost Data in entire table in Reports
Hello Please help. For some reason I can no longer see any data in one of my tables in Reports. It is called ALL_AUTO. We use Zoho as a place to store our info and if it is gone it will take weeks to recreate. Please help me if you can! Jeremiah
Desparate help please - reporter and creator
Dear Zoho Creator and Reporter Teams, Many thanks for your help – your apps have huge potential. I have a number of problems with using your programmes. I am attempting to use Zoho Creator/Reports to run a live audit tool, which will real-time produce reports regarding the data stored - this is potentially to be implemented into large business scale. In Zoho creator I have encountered the following problems: CHECKBOX DATA CANNOT BE PRESENTED IN A GRAPH. This needs to be fixed. It should
Geo Mapping update/use
Hi, I had request to use the beta geo mapping tool in Report. We had it on our account at one time. I see it no longer there. is there a way to use it when creating a SQL Query table to define geo coded information?
TO_INTEGER + TO_INTEGER generate a String not a Number
In a Query Table I put a formula like TO_INTEGER(IFNULL(MAX(xxx), 0)) + TO_INTEGER(IFNULL(MAX(yyy), 0)) AS "xxx + yyy". xxx and yyy are numeric columns with empty values. And the problem is that that formula output value like "014" or "080" instead of 14 or 80. Any idea ?
Zoho Reports Database
Hi! I have a database in zoho reports but when you migrate to zoho analytics I cant view my database, Can you help me to solve my issue? Cordially Edgar MOntoya
Analytics isn't syncing all of the CRM data I need...
Hi, I have a module in CRM that I am trying to get to sync and link with my CRM accounts for reporting in Analytics, but it's not pulling the data. The module is called "Negative Reviews" which is associated with each individual account in the CRM. I've attached screenshots of my Sync settings and of the data I am getting
Next Page