Número de registros en las Tablas Cargadas
Saludos. En ocasiones necesito conocer cuantas Bases de datos (tablas) tengo registradas y cuantos registros existen en cada una pero de manera practica. Existe la forma de saberlo en una presentacion (informe) tabular en algunas de las opciones del menu de suscripcion u otro? Gracias.
New Features rolled out on September. 27, 2016
Beta Announcements We are extremely happy to announce the Beta releases of two much-awaited integrations with Zoho Reports. Note As these integrations are currently in public beta testing you may encounter certain functional bugs and limitations. This add-on is currently enabled only for customers in the paid plan (Standard and above). We will come up with a pricing plan as a part of the general release. MailChimp Advanced Analytics Add-on (Beta) The beta version of Zoho Reports Advanced Analytics
Add an Edit Report Option to the Actions Menu
Hello Zoho Community, Currently, in order to edit a Query Table you are required to wait for the report to fully load. I'm a SQL Developer by trade and write some fairly complex reports... which have a tendency to timeout before I start optimizing the code (insert tears and lamentations here). Now, I know there is a "work around" where you open a faster table so that you have the edit button available and can jump in while the report is loading (probably a bug, but I see it as a feature :D). May
Export Information when Embedded on a Website
Currently, when you embed a report - perhaps a view or a table on an external site, you can run filters or sort the data, however there is no way of exporting this data (into XL or CSV or PDF etc) This simple feature would allow users to really start to syndicate reports with maximum control. Can you confirm whether this is on the Roadmap or if it is likely to be? Thx Cloud-Workforce.com
New Features rolled out on November 18, 2016
Improved Drill Down Feature (Available only in New Charts) Zoho Reports now allows you to dynamically select the drill down path from the Zoho Reports chart interface itself. Earlier, when you define a drill down path, you will be allowed to traverse only through the defined path. Now, the path that you define will be listed along with a wide list of connected columns that you can drill down with. You can also configure the list of additional columns that are to be listed as a part of the drill down
Unable to edit aggregate formulas
I don't know if something is wrong on the Zoho end, or mine, but I suddenly mid day today am unable to edit aggregate formulas. It will open the edit window and let me type, but won't let me save my changes, I also don't see the function names in the lower left anymore. Any idea what the problem might be?
5.1.8 Error
Hi, My account is blocked. I get an 5.1.8: Sender address blocked. Can you unblock my account please?
Report Column Width
Is there a way to adjust the column width of reports? I have 9 different columns which would fit fine on a standard 8 1/2 X 11 page in landscape view, but many of the columns are over sized so the document is autofit making it hard to read.
How to find rows used
Hi! Now that the Subscriptions page has been rebuilt, how do I find my current usage statistics for Zoho Reports?
Zoho Reports
Hi, I am new to using Zoho reports and was wondering if there is a way of changing the Customer ID field and Sales Person ID from number to text? I need it to show the name of the company and the sales contact's name. Thanks Katie
New Features rolled out on November 9, 2016
A simple approach to import data from Cloud Databases We are introducing a very simple model to import data stored in your Cloud databases such as Amazon RDS, Amazon Redshift or Microsoft SQL Azure into Zoho Reports for reporting & analytics. You can setup the import process using a simple setup wizard. Till now, users had to download and configure the Upload tool to import data from the cloud databases. This new model does not require any software to be installed. You can completely setup
Pie charts from Check boxes
Hi there, I have a form that integrates with Zoho reports. One of the fields are called interested. The user can select Car, bikes etc When I person choose Multiple choices it includes in the row in one column eg Car, Bikes The problem is that when I generate a pie report it output multiple choices eg Cars, Bikes 50% and Bikes 20% How can I separate these choices?
mixing databases for creating one single dashboard
hi, Please is there a simple way to create one single unique dashboard but from many databases without coding ? Thanks
Bulk Import via API failing, HTTP Status 500, Error code 7005
HI Zoho reports... I am trying to copy from one database into another. I select a query from database 1, table A and insert into database 2, table A. This works fine for "Table A"...but is failing for "Table B"... However, when I iterate through the list and call "addRow" on a record by record basis the data can be loaded. Here are my API parameters for the IMPORT: bulk_params={'ZOHO_ACTION':'IMPORT', 'ZOHO_API_VERSION':'1.0', 'ZOHO_OUTPUT_FORMAT':'JSON', "authtoken": Config.AUTHTOKEN, 'ZOHO_ERROR_FORMAT':'JSON',
Bulk Import with "String" (instead of File) / Add Multiple Rows
I would like the ability to add multiple rows in a single API call. My API code runs in a cloud task worker environment and I have a list of JSON objects in memory, that I can easily marshall / convert into a string ... I would like to be able to pass that String (list of rows to be added) to the API. Due to the restrictions of my virtual cloud file, I am not even allowed to create a temp file, to dump this list ot a file and then IMPORT the file. I am currently iterating the list calling the ReportClient
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.
Avg Packages per day
Hi, How to get average packages per day/month in a widget with the given data?
How to view more than 5 names
Hi I'm trying to figure how to view more than last 5 names on each list in the reports. Can you please advise? photo attached. You can explain the flow in English. Ill translate to Hebrew :) https://www.dropbox.com/s/gyztkefohdazjhp/Screenshot%202016-10-27%2016.31.49.png?dl=0
data connector to CRM Vtiger
Saludos. Quisiera saber si existe un conector para las bases de datos de vtiger o PHP y poder obtener información directa desde la Data. Gracias.
Unable to sort report columns
I have createda report, however I cant sort any of the columns (Asc,Desc). I have tried using the arrow in the column header and also tried the Sort menu at the top of the report window. Neither work. Does anyone know what the issue might be?
Creating Zoho Reports using data in Zoho Recruit
Hi, I am managing a group of my recruiters whom are using Zoho Recruits, therefore I would like to generate reports that will enable me to track the following aspects and etc. : 1) Recruiters Productivity - No. of Job Postings, Candidates and Clients 2) Progression of Stages of Job Postings 3) Sales Pipeline I want to create these reports based on the data present in Zoho Recruit using Zoho Reports. I am available for an online meeting anytime from 11am to 4pm tomorrow (14/10/16) My contact details
New Features rolled out on October 17, 2016
Introducing the Google AdWords Advanced Analytics Add-on (Beta) We at Zoho Reports are extremely excited to present to you the Google AdWords advanced analytics add-on (Beta). This add-on enables you to import your Google AdWords campaign data into Zoho Reports for powerful reporting and analysis. You can easily create reports to track your key ad campaign metrics such as best performing campaigns, conversion funnel, clicks vs conversion, ad analytics and much more... Click to learn more about
ODBC Driver?
Any word on when the ODBC driver for the DB and Reports will be released? Thanks...
Dashboard View: URL link
Hi, Is URL /Permalink accessing user can have the view by option? We'd like to see the Dashboard by Folders, Related views or Types. Which helps us to see multiple category/function Dashboard by one URL Link
Where are the new charts?
When I click on 'Try New Charts' and create a chart view, I see the same old set of charts both in the toolbar as well as after clicking 'Other Charts' link. Where are the new charts?
unable to send message;Reason:554 5.1.8 Sender Address Blocked
Why our Email account "support@luxepick.com" has been Blocked without intimation and reason. We have to send email's to the Client more than 50 -70 per day. Can you make it Active ASAP. Thank you in Adavance. Cyril A
Problem with importing Google Docs Spreadsheet formula field values into Zoho Report
The value in a Google Docs Spreadsheet field that is calculated by a formula, will not be imported into Zoho Reports. Any solutions for this? Thank you in advance. Jeroen
calculate new field over invoice module
How can I calculate a new field (numeric) that I create in Zoho CRM??? Zoho Reports does not show me the new field :(
Calculate Index
I need to use an index at several levels within my data: Market level, Station level, Daypart level, etc. I've tried a custom formula, which accepts "(Actual Impressions/Estimated Impressions)*100" but is not a value that is useable in charts, pivot tables, and doesn't show up in the data set underneath the column. How do I get this to show up so I can use it?
Creating Zoho Reports using data in Zoho Recruit
Hi, I am managing a group of my recruiters whom are using Zoho Recruits, therefore I would like to generate reports that will enable me to track the following aspects and etc. : 1) Recruiters Productivity - No. of Job Postings, Candidates and Clients 2) Progression of Stages of Job Postings 3) Sales Pipeline I want to create these reports based on the data present in Zoho Recruit using Zoho Reports. I am available for an online meeting anytime from 11am to 4pm tomorrow (14/10/16) My contact details
Google analytics data
Hi everybody I have some problem with google analytics: If I see for example the data on google analytics page of my web site, I see for the 3 of october, 37 sessions and 31 users. If I look at the tab imported in zoho report, "USERS", for the same day, I count in the tab in the column users 35, and in the column session 37... why??? Date Landing Page User Type Users Sessions 2016-10-03 / New Visitor 14 14 2016-10-03 / Returning Visitor 3 3 2016-10-03 /chirurgo-plastico/ New Visitor 4 4 2016-10-03
Connecting three sources of data
I have three sources of data in three separate tables, and I would like to be able to report across all three. I'd like suggestions for the best practice for connecting them: Table 1 is a query table based on Zoho CRM sync that joins Accounts with Potentials to show total sales by client. Each Account has a unique Client ID that we assign it. Table 2 is an uploaded table of Invoices from our accounting system. Unique Client IDs are attached. Table 3 is an uploaded table of receipts from our accounting
New Features rolled out on October 7, 2016
Enhancements in User Filters In continuation with our updates on the user filter feature ( Timeline Filter ), we have once again come up with a list of enhancements to increase its usability. In this update the following features have been supported: 1. Highlighting applied filters: This feature automatically highlights the user filter that has been applied on your report/dashboard with a subtle green color. This helps you quickly identify the filter that has been applied. 2. Filter Level
Not showing calculation options
I use a lot of charts that show the monthly count and then a running average over time. Sometimes, I'm not getting the option to do the calculation over time. What is the data table requirement to allow calculations over time? Here is the table and the chart I'm trying to create. I'm attempting a combo chart, the bars showing the Total Count for that month and then a line for the running average. When I attempt to use the average running total, the option is not showing on the drop down list.
Aggregate Formula with mixed values
Hi, I want to make a Formula where I can obtain the following data: It is a Pivot Table, I want a fixed value the (sum of "1VENTAS" / the sum of each one of the lines)*100 and I´ve tried with many combinations with no success, it is possible to have this result even with other type of table? Thanks in advance
Report 'number of potential in each stage by month' not working
In the report 'number of potential in each stage by month', within Zoho Reports, there is a severe logical error. The X axis is based on last stage modification date. This means that the report shows status changes within the month, not potentials in each stage by month. For instance, at the 1st day of the month, the report shows no potentials in the new months. In fact, we still have the same number of potential in each stage as the day before (last day of previous month). Also, when looking
Ordenar dias de la semana.
Saludos. Tengo una columna con los dias de la semana o los dias del ano escritos en la modalidad texto. Necesito poder ordenar los dias de la semana o los meses del ano en las tablas dinamicas o graficos. Gracias.
Widget: Latest Date in the table
Dear Sir, I'd like to have a widget which shows latest sales date which is in the table(data).
Configuring the graphic for comparing the sales % per month
I would like to have a graphic that would give me te eight of some product on the period in analises. Example: Global sale Jan: 10.000 Global sale Fev: 10.000 Global sale Mar: 10.000 Product A sales Jan: 1.000 (10% of global sales) Product A sales Fev: 3.000 (30% of global sales) Product A sales Mar: 2.000 (20% of global sales) I would like a graphic with x-axis with month and y-axis the % of product A sales and that the bar would give me 10% em January, 30% in February and 20% in March... Currently
GIS Visualization of Data
Do you guys planing to have GIS Visualization as feature in the reporting platform? if yes when? Thanks
Next Page