Date Pattern not recognized when importing data
Hi, I'm trying to import a data set which send a Date column in the format below: 2016-07-19T17:35:25-03:00 (it comes with a "T" between day and Hour) When I set the Date field in the import process to: yyyy-MM-dd'T'HH:mm:ssZ (which is standard in the list of date formats available in Zoho Reports) IT won't import the column, saying the format is not like the imported data. The alternative is to choose the column, Find and Replace the "T" for a "space", and then change the format to the one below:Using Contains as a filter
We are using Zoho Reports, ServiceDesk Plus analytics. I do not see how to create a report filter using Contains comparison of a string values, is one string contained in another. For example, Task Title contains the word Monitor. Is this possible in Zoho Reports? This reporting feature is available in SDP reporting. Thanks in advance, Craig RiceCustom Reporting Periods
If I want to do a report to show time spent on a client, how do I set a report to show from 17th of the month to 17th month rather than 'last month'Zoho UploadTool connect Heroku database issue
Hi. I have an issue with connection to Heroku PostgreSQL database from UploadTool. I'm getting an error: no pg_hba.conf entry for host ... Looks like an additional parameter should be passed in with connection string sslmode=require as stated in Heroku docs. But I cannot find how can I set this configuration in ZohoUpload Tool. Does any one know how to deal with it? https://devcenter.heroku.com/articles/connecting-to-relational-databases-on-heroku-with-java#connecting-to-a-database-remotely https://devcenter.heroku.com/articles/heroku-postgresql#external-connections-ingressData API via curl
Dears, I have a very strange problem with Zoho data API via curl. I have a database called Monitoring which contains a Table called Test with two columns (ID, Value). If I try to add an element via curl with the command curl -d "ZOHO_ACTION=ADDROW&ZOHO_OUTPUT_FORMAT=JSON&ZOHO_ERROR_FORMAT=JSON&ZOHO_API_VERSION=1.0&authtoken=<my token>&ID=2&Value=3" https://reportsapi.zoho.eu/api/<my e-mail>/Monitoring/Test I always obtain the answer { "response":{ "action":"ADDROW", "error":{ "code":8518,Daily web traffic report
Hi I used to get a daily report of visitors to our website at www.eon-media.com, we relaunched our site recently (with the same URL) and the reports have ceased, any suggestions on what I need to do to re-instate?MS Access 2010 Config file settings
I've just updated an MS Access database from MDE to 2010 format ACCDE. It's now stopped uploading to ZOHO. Can anyone advise on the settings I need in the database_connection_params.conf. I think I need to change the DBName and DriverClassName but can only find instructions for MDB files in the help docs. ThanksNew Features rolled out on Oct 12, 2017
Introducing Dynamic Threshold feature for Charts We at Zoho Reports are happy to announce the Dynamic Threshold feature. Until now, users could only set a static (constant) value as threshold. With this update, users can apply dynamic functions (value) such as Sum, Avg, Minimum, Maximum over the column in the reference axis or over a different column. Users can now set the Scope of the threshold to the entire chart or set the threshold value for each data point (cell). Apart from this, we haveWeek starting on Monday in Reports
Hi, I have a Line Chart with "Week and Year" in X axis. Everything is ok, but I need an ability to change week span to Monday-Sunday instead of Sunday-Saturday. Basically I need the week to start on Monday. Is there a way I can do it?Problems with filters dashboard
Hi, In lasted days, I have a problem with the filters dashboard, when i try select a second filter show me this bug: Sorry, an unexpected error occurred 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. Why happens this? how do for solved? in where i can see more informations of this bug? Note: I try do the same with view and works without problems, for example:Report on archived information
Morning, This is the first time I am using or rather looking into Zoho reports, I have been asked if I can create a report on archived opportunities invoices, is it possible to report on archived information? DTime in Hours
Hi, I have a formula column calculating duration of a service call. It currently looks at two columns formatted as DD-MMM-YYYY HH:MM and subtracts one from the other to show the difference. Is it possible to have this shown in hours and minutes, rather than just minutes? The above would then show as 01:15:00. In excel the format would be [h]:mm:ss, but this doesn't appear to work in Zoho reports as it results in the following error: "The parameter DATEFORMAT does not match the accepted input pattern".First Response Overdue Status
Hi, I have sync the Service Desk On demand to Zoho Reports and i would like to manage the First Response Overdue Status but i don't find it. Someone know how i can add? Best regards.Customize Threshold
Hi On a report I have 2 Thresholds that appear very close together (I will be doing many reports where this occurs). I have attached an example of how the report looks if I just use the standard setup. Is there some way I can customize this so that the appearance is better. (e.g. have the test for the lower threshold appear below the threshold line) I am happy to use coding is needed. Thank you GillCreate Report from ZOHO CRM Report
So we have three reports in Zoho CRM that I am trying to duplicate in Zoho Reports so we can than add each report to a Dashboard in Zoho Reports. As it appears so far I can get the exact report I need in CRM but not the Dashboard view we hope for, and in Zoho Reports I can get the exact Dashboard view we want but having trouble setting up the report.... So all data comes from Zoho CRM. We have set-up the Advanced CRM Analytics. So in Zoho Reports > Zoho CRM Analytics > Potentilas > Create NewNew Features rolled out on Oct 4, 2017
Beta: Zoho Campaigns Advanced Analytics We at Zoho Reports are very happy to announce the Beta release of Zoho Campaigns Advanced Analytics connector. The Zoho Campaigns advanced analytics integration powered by Zoho Reports enables you to easily analyze your email campaigns and derive great insights. Product marketers and analysts can slice and dice their campaign data and derive key campaign metrics such as campaigns trend, conversion rate, click rate, open rate, unsubscription trend and do muchIs it possible to copy a specific filter on individual values in another report?
I use a filter on individual values with about 60 of 200 values for a report. Is it possible to use this filter on other reports, too - l besides selecting those 60 values for every single report?How to combine two databanks (e.g. Zoho CRM & Zoho Desk) for reports?
We use Zoho CRM, Zoho Desk and Google Analytics as sources for Zoho Reports. How is it possible to combine them like in this demo? https://reports.zoho.com/ZDBDataSheetView.cc?DBID=779360000007798294&OBJID=779360000007813459Database structure advice please
Currently I add new monthly data to the bottom of a spreadsheet when updating monthly. So my spreadsheet gets longer each month and I work with one table in Reports. Would it be more efficient to have seperate spreadsheets and tables for each month and join them in Reports? Can some knowledgeable person advise me as to the best approach and explain why one is better than the other. Regards MarkWhat does Refresh do?
My data is in an Excel sheet on my hard drive. When I make changes to this file I would expect Refresh to show the changes but it doesn't. How do I update files in Report that have been changed in the original file on my machine? Feeling foolish - what am I missing here? What does refresh do? MarkChange Calendar
With addition of the change module to the ServiceDesk Plus Analytics, has anyone had any success in creating a change management calendar with Zoho Reports? Any suggestions on how one might accomplish with Zoho Reports? Thanks, Craig RiceADD Column API call with DEFAULT , MANDATORY values
Is it possible to set a default value and columns mandatory when using the ADDCOLUMN zoho action in the REST API ? I could not figure it out based on the documentation: https://www.zoho.com/reports/api/?shell#add-column THanks.Invoice ID not unique?
Hi, using Zoho Reports I pulled a report from the table "Invoices" and exported it as Excel. The outcome is that in the Excel file the invoice ID does no longer match what is inside Zoho database. Please see screenshot attached and notice how the information differs. Please advise! Thanks, MarkInbox Bloqueada novamente
Por favor ajudem-me! Meu email havia sido desbloqueado e aí quando comecei a receber as mensagens de meus alunos depois de umas 40 mensagens voltou a bloquear-se a inbox e necessito manter contacto com eles porque lhes estou guiando através de um processo muito importante. Por favor alguem me pode explicar porquê isto está acontecendo porque não estou a entender. a mesma mensagem quando tento desbloquear. "You have reached the maximum self unblock limit within the past 24 hours." Por favor algumAggregate formula sumIF,AverageIF problem for sales calculation more than 10000
Dear Sir, I am working on Aggregate sumIf formula for sales report But unable to make it . There is a error coming specific formula is invalid .Please check my formula and find the problem . I think syntax of formula is not correct thats why its showing error .Please give me a demo example for same .Below is my formula sumif(( "Ford details"."amount" >10000)) ford detials is sales report amount is Ford details Column I have to calculate Amount greater than 10000. I have also attached the screenshotcrosstab report
Can get more than 2 factors in crosstab report ? or have any way to do itThe required action param is missing
I have passed data using node and every time i got the error "The required action param is missing". Reference URL : https://www.zoho.com/reports/api/?php#import-data API URL : https://reportsapi.zoho.com/api/xyz@gmail.com/testDB/Accounts POST PERAMETER : 'ZOHO_ACTION' : 'IMPORT', 'ZOHO_OUTPUT_FORMAT' : 'JSON', 'ZOHO_ERROR_FORMAT' : 'JSON', 'authtoken' : '38f207ac4a8a5b73ce427***********', 'ZOHO_API_VERSION' : '1.0', 'ZOHO_FILE' : 'Accounts.csv', 'ZOHO_IMPORT_FILETYPE'Tick box in reports
Hi I have an table that includes entries from a list of tick boxes in 1 cell with each item separated by a pipe. . See example This makes adding the total number of any item difficult. Is there any way i can return the individual entries in the end column (advice given) into a filter where i could choose the individual item rather than the entire column of many individual items - which is what i can do just now. Thanks Joe"Age in Days" calculation in Advanced Analytics
Hi Can someone advise how this is calculated? I am getting values on this report which I cannot understand. Thank youCombine Date Column and Time Column in Query Table
Hello, I have created the below sql query to combine a date field and a time field. The query works in Sql Management Studio, but, I receive an error when I attempt to run the same query in a Zoho query table. Query: SELECT PREP_START_DT = convert(varchar, Prep_Start_Date, 103) + ' ' + convert(varchar, Prep_Start_Time, 108) FROM "HQProductionPerformance" WHERE Prep_Start_Date >= '2017-08-27' Zoho Query Error: Length of the display column name 'CAST(PREP_START_DT as CHAR) CAST(CONVERT(varchar, Prep_Start_Date,Sales vs target
Hi, I would like to create a combined chart, with target in line and sales in bars, like this : The target for each sales reps is different from month to month. So I create a table of target : (example of Q3 2017 below) The problem is I can't join this with the data "won amount" from opportunities table. How can I do this ? Thank for your help Opportunity owner date Target A Jul-17 5,000.00 A Aug-17 0.00 A Sep-17 4,000.00 B Jul-17 1,200.00 B Aug-17 0.00 B Sep-17 2,000.00 C Jul-17 0.00 C Aug-17 0.00List reports that reference a table
Hello, Is there a way to list what reports are referencing a specified table? I want to know which reports are referencing it so I can see how a change I want to make would affect reports that are using it.Account Inactive
Hi, Please Urgent help needed! when I tried to login into my account info@workapay.com it returns "account inactive"'. please how do I get my account reactivated?Is there way to check the usage of the shared dashboards?
Is there way to check/track the usage of the shared dashboards in Reports? I like to track the things like whom has accessed to it at when. Any idea? ThanksConnecting to MySQL database on a hosted server - need incoming server IP/domain
We have a hosted MySQL database siting on our website hosting service (Dreamhost). I've created a MySQL connection in reports with the credentials for the database, but the connection fails with "Access denied for user zohoreports. Login failed.". I know the credentials are correct, because when I connect to the database using the 'MySQLWorkbench' off my laptop, it connects just fine (I Whitelisted my laptop's IP address). The Dreamhost service restricts access based on the inbound IP address orAverage Sales per Day Formula Over Selected From To Dates
Hi I have a Sales table wherein I have Invoice Dates, Item Description, Qty per Invoice, Invoice value. I have made a pivot for sales data with different user filters. One of them is Sale Invoice From Date and To Date. I want a formula to calculate average sale qty per day with respect to the number of days selected in the date filter including the selected dates.New Features rolled out on Sep 7, 2017
Public Release: Microsoft Dynamics CRM Advanced Analytics We at Zoho Reports are extremely excited to announce the public release of the Microsoft Dynamics CRM Advanced Analytics connector. This integration empowers you with deep sales analytic capabilities over your data in Microsoft Dynamics CRM. Thereby enabling you to keep track of your Key Sales Performance metrics and optimize your sales execution. It comes with over 100+ handpicked reports and dashboards that you will find of great value.Keep the filters floated at the top of the page
One suggestion, could we have the option to keep the filters floated at the top, or side, of the page? This option would be useful especially when the dashboard page is long. With the filters always on the page, users could easily check what filters have been set and easily toggle the setting wherever they are on the page.Why is my project not showing up in my reports
Hi - my projects from Zoho Project Mgmt used to automatically integrate to reports. Then, for some reason, I had to go through and choose the projects I wanted to integrate. Now, I can't even choose a project. So - Im adding projects into Zoho Project Manager but, they don't show up on reports. Any ideas why?Lookup Column
Hi I have created lookup column in one of my tables. However, values in that are not populated automatically in the table. How do we achieve this? Regards. VaibhavNext Page
Access your files securely from anywhere
New to Zoho LandingPage?
Zoho LandingPage Resources
New to Zoho Survey?
New to Zoho Marketing Plus?
Everything you need to run your marketing
New to Zoho Marketing Plus?
Everything you need to run your marketing
New to Zoho CRM Plus?
Deliver unforgettable customer experiences
New to Zoho CRM Plus?
Deliver unforgettable customer experiences
New to Bigin?
Announcements
[Upcoming Webinar] Power up LinkedIn marketing with Advanced Analytics
Modern businesses are leveraging social media like never before to generate, retain, and expand their customer base while driving revenue. LinkedIn continues to be one of the most preferred marketing platforms for businesses. Based on our interactionsAnnouncing Zoho Analytics 6.0 - An AI Powered Self-Service BI & Analytics Platform!
At Zoho Analytics, our mission is to democratize analytics for everyone. We recognize that team members across an organization rely on data to make both simple and complex decisions every day. These tasks shouldn’t require ongoing support from IT and[Fireside Chat on 6.0] Experience the AI powered self-service BI & Analytics platform
Ballooning data volumes at breakneck speed, expanding data diversity, the increasing importance of data management and governance, and the emerging complexities in analytics—BI vendors and customers are turning to cutting-edge technologies to addressAnnouncing Zoho Analytics 6.0 Beta!
We are delighted to open up the next major version, Zoho Analytics 6.0 Beta! The new version comes packed with a wide range of functionalities for all persona, namely business users, data analysts, data engineers, and data scientists. Zoho Analytics teamWhat's New in Zoho Analytics - August 2024
Hello Users! We are back with the latest updates and enhancements made to Zoho Analytics. Keep reading to learn more about them. Connect to the data hosted in the cloud without allow-listing the IP addresses Utilize Zoho Databridge to connect to the data
Most Discussed Topics
Make Widgets Clickable or Copiable
Hi, I created a KPI Widget in Zoho Analytics whose content I would like the users that see my dashboard could copy or click and be redirected elsewhere. Yes, I'm aware I can create a Text Box for that instead of a Widget, but the problem is that the linkHow 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 selectedIs it possible to have an Aggregate or a formula data column that only sums subtotals?
So I am trying to make a data columns that would only sum the subtotal. let me explain, I want to sums the hours worked of employes. I also need to split the hours when they reach 40 hours into another column. I can make this work perfectly with formulaContextual Information when Apply Filters
Hello, Let's say I had a pivot report looking at an "Accounts" table, if I had a user filter to select a specific account. When a user hover overs an individual option in the "Accounts" user filter, is it possible to have a pop-up display with additionalHow can I find invisible characters in my Deals table?
Hi, I'm using Zoho Analytics to investigate some formatting issues we've come across in our Deals from Zoho CRM and it seems that something's wrong with some of our records. Although we defined a global set to pick from in our "Lead Channel" picklist,
Zoho Developer Community
Zoho DataPrep Resources
Zoho Subscriptions Resources
Zoho CRM コンテンツ
-
オンラインヘルプ
-
Webセミナー
-
機能活用動画
-
よくある質問
-
Ebook
-
-
Zoho Campaigns
- Zoho サービスのWebセミナー
その他のサービス コンテンツ
ご検討中の方
Zoho Sprints Resources
New to Zoho TeamInbox?
Zoho TeamInbox Resources
Zoho Books Resources
Zoho Projects Resources
Qntrl Resources
Zoho CRM Plus Resources
Zoho Campaigns Resources
Migrate to Show’s New Community
A place to share, discuss and stay updated about everything relating to Zoho Show presentations.
Get Started. Write Away!
Writer is a powerful online word processor, designed for collaborative work.
Design. Discuss. Deliver.
Zoho Show Resources
Zoho Creator Resources
Nederlandse Hulpbronnen
Zoho Inventory Resources
Zoho CRM Resources
Sticky Posts
Announcing Zoho Analytics 6.0 Beta!
We are delighted to open up the next major version, Zoho Analytics 6.0 Beta! The new version comes packed with a wide range of functionalities for all persona, namely business users, data analysts, data engineers, and data scientists. Zoho Analytics teamWhat's New in Zoho Analytics - August 2024
Hello Users! We are back with the latest updates and enhancements made to Zoho Analytics. Keep reading to learn more about them. Connect to the data hosted in the cloud without allow-listing the IP addresses Utilize Zoho Databridge to connect to the dataWe are coming to your city! Zoho Analytics Community Meetup
Hello, business leaders and data enthusiasts! We are delighted to announce that registrations are now open for the ZUG meetups, and we can't wait for you to be a part of them. Our in-house analytics experts are geared up to lead discussions on constructingZoho Analytics: 2021 Look Back
As we start a new year in 2022, here's some of our top moments from 2021. Zoho Analytics in 2021[Customer Talk] PREMO Group's Analyst Interview at Zoho Day 2022
Premo Group, a 50 year old Spanish Manufacturing Company, has been our long-standing customer with #ZohoAnalytics. They've been using our platform for their end-to-end, unified business analytics solution. Hear more from Claudio Cabeza, Director at PREMO
Top Contributors
Naresh Kumar K K R
Arthur
Data Sailing
Anitha Rajesh Kumar
Blake