summary view
I want to know the SQL that is used to display the summary view,because I want to use Zoho CloudSQL.How to convert Seconds into Hrs:Min:Sec format in Zoho Reports
We have two date/time stamp field in one of our data tables. We want to create a formula column to calculate the difference between these two dates. What format will the resulting column be in -in am hoping it will be in a numberic format and the result will be in seconds. Can someone confirm?Average Processing Time
Is it possible to show Avg Processing time in Hrs:Min:Sec format???Zoho report API
I'd like to use zoho report in zoho crm. I get zoho report. Can I use ZohoReportPHPLib.zip?? Please teach me how to ZohoReportPHPLibTransitioning to a new Zoho Community platform
Dear Zoho Reports Users, Our users forum here is being transitioned to a new Zoho Community platform. More details are available in the below URL. https://help.zoho.com/portal/community/topic/zoho-community-is-transitioning-to-a-new-platform We are excited about this and we believe you will like it too, as the new Zoho Community platform will result in more user engagement. Happy participating in the new forum!Greater Than symbol not being accepted as valid.
Hi, I'm working on a table to determine when an Organization first enrolled for any of our services. This could be for a Portal service which there is a Training Record for or a Data connection for which there is Interface Record. I've been able to pull back the earliest date from each table to determine when the first service was. Here is the expression I'm using: Case When Min(Trn."Training Date - End Users") >= Min(InterS."Go Live Date") >= Min(InterD."Go Live Date") ThenNew Features rolled out on Jan 17, 2018
HubSpot CRM Advanced Analytics We are happy to announce the general availability of HubSpot CRM Advanced Analytics powered by Zoho Reports. This integration empowers you with deep sales analytical capabilities and helps you keep track of your Key Sales Performance metrics. HubSpot CRM Advanced Analytics comes with over 60+ handpicked sales analytics reports and dashboards that you will find of great value. You can also create your own insightful reports to track your sales pipeline, visualize yourmongodb connection problem
I am trying to import the data from mongodb database. I am facing an issue that it is giving an error saying that "Database is not found, Please check whether the database exists or not" Actually, I have a database in my mongodb called test. Can anyone help me? Please check the below link for my configurations. logs and conf filesGetting an error when trying to use a date filter as a user filter
Hi there. Can someone help me with this error that I am getting when trying to use the Expense Date as a user input filter on a summary report being built from a query table Numerical Criteria format is illegal() If I take out the user filter, it works fine. ThanksCrear grafico apilado con el total sumarizado de los valores que lo componen.
Saludos. Quiero agradecer el interés que siempre han puesto en todas mis solicitudes. En la medida en la que profundizo en el uso de la herramienta van surgiendo nuevas necesidades. Acá planteo una mas. Al crear un "Gráfico Apilado" en el se pueden observar los valores individuales de cada uno de los elementos que lo componen identificados con un color diferente cada uno de ellos. No obstante la barra no posee un valor del total de los elementos que la componen. Podría ser esto posible? Para ejemplificarloNew Features rolled out on Jan 05, 2018
Import Data from Multiple Excel Sheets in a Single Click Zoho Reports now allows you to import all the data from your Excel workbook in one go. Earlier, users were allowed to select only one sheet at a time while importing data from an Excel workbook. From now on, when importing an Excel workbook, you can select multiple sheets at a time to be imported into Zoho Reports (in Step 2 of the Import Wizard). Each sheet will be stored as an individual table in the reporting database. Click to learn more.Report for Leads to won conversion ratio
Hi Team, We are running a trial version of zoho reports to find out suitability to our needs. We have created couple of reports as well as referred to few default reports which are fine. However, we are facing issues in creating a report for leads to won conversion ratio for a particular time period. For example, we want a report to show number of leads created in 2017 and the percentage of these leads won in 2017. We tried to tweak some of the existing reports to get the results but not getting7005 Error on ZohoQuery
We are experiencing some api issues since 27th Decemeber 2017 and wondered if you have changed the api requirements? Adding and updating rows works fine using ZOHO_IMPORT_TYPE, but query commands like ZOHO_SQLQUERY have stopped working completely We make the api calls are made via php (using sample code originally taken from your forum) and have been unchanged for a few years. The code example of one of the calls is as follows: $url = "https://reportsapi.zoho.com/api/yyyyyyyy/tttttttt?ZOHO_ACTION=EXPORT&ZOHO_API_VERSION=1.0&authtoken=xxxxxxxxx&ZOHO_OUTPUT_FORMAT=CSV";Advanced Analytics configuration
I get this error when trying to connect to Manageengien / Zohorepports in the cloud ERROR: Could not update configuration settings due to an exception while saving the Advanced Analytics configuration details. Report the problem to the system administrator. The support file will get the error tracking to analyze the problem and can be created under Support -> Create Support File. Any suggestions ?How to make a widget for progress % in zoho reports?
Similar to this one: Is there a way to do this in zoho reports. The available widget only shows the inc/dec from a previous time. Hoping for your response. Many Thanks,Can we add html link in the Reports
We have the need to hand off the user to another application based on the row value. Can we create a HTML code and have it render a link in the report?"Magic SalesMap" para ZOHO Y SALESFORCE
Saludos. Podria Darme informacion detallada acerca del asunto del correo. Gracias.New to Zoho and wish to create a database
Hi, I'm new to Zoho and I wish to create a database of raw data client contacts. My existing data is on a multitude of excel spreadsheets some of which are duplicated. What is the easiest way for me to create this I will be looking to have four fields which would be name, home phone number, mobile phone number and product. I am presuming I need to make sure that all of my excel spreadsheets have their columns in this order? Am I able to upload all my spreadsheets then dup check by phone numberNew Map Charts for Zoho Reports
Hi. Can you send mr a private Beta version of Map Charts for Zoho Reports feature. Thank You.Dashboard 3+ Columns
Is it me or one doesn't seem to be able to create a new Dashboard of 3 or more columns ? I can see the pre built Dashboards, some include 4 widgets side by side, but when I keep trying to recreate that arrangement, the boxes auto resize and I cannot replicate the same. This is counter intuitive and really, the only issue I've found with Zoho reports. Hopefully there is a trick to make this work. DanielZoho Reports
Hi ,I have a query regarding Importing data, as I'm importing data from local database(sql server). I'm able to import the tables but I'm not able to import my view table which I have in DB , So let me know how can I import my view data or else how can I import my view query to zoho reports ? If I try to copy the view on query table on zoho report it says only select is allowed. So anyone please guide .Drill down on Bar chart not working
Hi We have noticed an issue on most of our reports where if you use the filter to select specific products and then click on the filtered bar within the bar chart, we seem to be getting all the data through rather then just the data for that period. Is there a setting that needs to be changed? If you can help me with this it would be greatly appreciated ThanksNew Features rolled out on Sep 28, 2017
Analytics on the Go: Introducing New Mobile Apps for iPhone and Android phones We at Zoho Reports are extremely happy to announce the availability of Zoho Reports Mobile Apps for both iPhone and Android phones. This is in addition to the already existing apps for iPad and Android tablets. With the Zoho Reports Mobile BI app, you can access the reports and dashboards that you create in Zoho Reports service, on the go. The Zoho Reports Mobile BI application provides you with the following capabilities:Export email doesn't use filter
I've created a Tabular view report which I need to send to different email addresses based on the Project "Group ID". Regular export keeps whatever filter is current but export to xls scheduled email doesn't always keep the filter. Usually, it doesn't but I've run the same scheduled export email more than once by just changing the send time and have gotten an export that has the filter and others that don't use a filter. I've created separate reports so I only have one filter in place on each reportWhat's New Monthly Digest: November 2017
New Connectors Released We have extended the Advanced Analytics connectors for the following popular business applications. Google AdWords Zoho Survey SurveyMonkey Pivot Tables - Customizing 'Show Total As' Show Total As In Pivot Tables, by default, the summary function used to display the subtotals will be the same as that of the summary function applied on the corresponding data column. With this update you can customize this and apply anyDatabase not found
Hello, I'm trying to connect to Sql Server 2008 in Zoho Reports using the upload tool but this is showing the error below. I already checked the information and it is correct. How can I solve this problem? database_connection_params.conf DBTYPE=sqlserver HOSTNAME=VIX-DB-001 PORT=1433 USERNAME=sa PASSWORD=samaster DBNAME=MMDB #MDBFILENAME= #SQLITEFILENAME= #FIREBIRDFILENAME= Follow the logs. 2017/11/08 18:02:36 BRST: OS : Windows NT (unknown) 6.2 x86 2017/11/08 18:02:36 BRST: JVM Version : 1.6.0_16How can I remove a sort on a pivot table
I have created a project pivot view that includes "last update" and "start date". I can't get the sort on the "Start date" to go away. I just want to sort by last update. How do I remove the sort on Start Date but keep the column in the view?We are unable to get TXT record for DKIM right now. If you have added the TXT record just now, please wait for 30-45 mins for the changes to propagate and try again.
We are unable to get TXT record for DKIM right now. If you have added the TXT record just now, please wait for 30-45 mins for the changes to propagate and try again.how to return multiple counts using countif?
I have a column with the results of a survey "very interested", "interested", "moderate interest", and "Not interested". I am trying to use Countif in an aggregate formula to return the count of each of those in a summary report. I can get one category to show a count but can not work out how to extend the formula to show a count for each result. Are you able to use a multiple countif in an aggregate formula. If not then what is another way to achieve the result.Need help with reporting this data
Hey All! Hope I'm posting this in the right place! Quick question regarding comparative data. Example below for what I'd like to show: Date A (12/1)- new process F was put into place Date B (12/6)- overall satisfaction was at 80%, with 100 people saying they were satisfied -------------------------------------------------------------------------------------------------------------------------------------------------------------------- I have my columns in excel divided this way: Date (process change)Tabular View Export adding Project ID column
When I've setup scheduled .xls export emails of tabular reports for Projects, sometimes the export is adding the Project ID. This field is not visible in the tabular report. What is causing this?Custom Fields mapped from Zoho Finance Suite Added
Thanks for enabling Custom Field integration in Reports with Zoho Finance Suite. This is a major step for one of my clients and allows in-depth reporting on Sales Orders at Item level. Well done Team Reports! Craig Davies Target Cloud Authorised Zoho One Partner (UK) info@targetcloud.co.ukschedule batched reports
Hello, How do I have CRM email me a set of all reports I need in one email every morning? the system allows for one email per report but I'd rather not have 10 emails to go through every morning. ThanksEdit rights issue in a table of a shared database
Hello all, I am having an issue with the Edit Rights for the shared data in ZohoReports. I’m not able to edit the tables on the shared database A. I cannot find the “Edit Design” option on any tables of the Shared database. But, I do have those options on the database B that I have created by myself. Please find the attached images, they will give more better understanding on this issue. There are four images two for shared Database A and two for the Database B (created by myself). OR, is it thatShare data between databases?
Is it possible to share / link data from one Reports Database into another? Use case: my team is effectively an "agency" with multiple clients. We have data coming from a variety of internal systems into one main database we use for internal reporting. Those feeds are combined with each other, aggregated, etc. to form more useful data views than the individual feeds provide on their own. We would like to use some of those new views to feed client-specific databases for client-facing reporting. IIn ZohoReports Chart, it has a dynamic y-axis, Is it possible same for x-axis also?
Hello all, I'm new on ZohoReports and am creating a scatter plot with Date of Start on Y-axis and Date of Due on X-axis. So, there is a Priority check box based upon which I can see the selected data on the chart. Priority has 4 options:- High, Low, Medium and None. Firstly, I unchecked None, which changed the Y-axis minimum from 2 Jan 2017 to 19 Jun 2017. Similarly, on unchecking Medium changed the Y-axis minimum to 10 Jul 2017. But, the same is unattainable on the X-axis. If this could be done,Changes to columns in main table not reflecting in existing Tabular reports
Hi I created a new table and from that several tabular reports which show only certain columns in each. I have since added an additional column into the main table but this column does not appear for me to select in the existing tabular reports. Please tell me I don't have to recreate each tabular report... Thanks, ClairePercent Data conversion error
I have a dashboard setup that pulls data on schedule from a Zoho Docs spreadsheet. Three of the columns are formatted as % in the spreadsheet. Those same data points are imported into corresponding % fields in the Zoho Reports table. This works fine for existing data in the spreadsheet, however when NEW data is added to the Spreadsheet, all data are changed to 1/100 of the actual value. The only workaround I have discovered is to manually reapply the % format to the columns in Zoho Docs. I thinkBest way to to merge pivots into one report
Hi, I am evaluating zoho reports and can't work out if the following is possible. I would like to merge two pivot tables together to form a sales history and current inventory report. I think this can be hopefully be accomplished with query tables. Table one contains the sales data and the second table contains the inventory. The sales data needs to be pivotted to create a monthly total sales report. I then want to tack on the end of the table the inventory for each product. An example is shown inExist import with 'Add and Replace' option
I've been trying to do an exist import with Add-Replace option but not able to after so many attempts. See the error below. The existing table (Company Master-YE) has ~51k rows and the intended import file has ~35K. I'm trying to add and replace based upon two matching fields. While I understand that this operation is somewhat resource-intensive and could take a while, I'm disappointed because I'm not able to do it at all.Next 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