Customization of charts
I have embedded a number of charts within a website, but the default chart background does not match the website color/aesthetic. When I attempt to change the chart background, only the inside of the chart is shaded with the background color (not the axis or legend areas). Is there a way to shade the Entire char, so that I can make it blend with the website that it is embedded into? Is there a way to add a background image to a chart? Thanks,
API Import
I am trying to get Zoho Reports to retrieve data from my cloud based scheduling tool. The cloud based tool has a REST API and Authentication key but cannot get the data to import into a Table or database. I am trying to create scheduled reports to send to clients
vertical cell height in reports
Hello, I have come across an issue recently. In the reports that my company uses, the height of cells would automatically be adjusted so that all the text in the cell could be seen across multiple lines. This was always just how Zoho reports worked. Recently, it seems that the height of cells has stopped automatically adjusting and is showing at just 1 line. This causes us to only be able to see what fits in 1 line of text, which is insufficient in many cases. If I modify the width of a column,
How to get support for reports?
Is this the only way to get support? I have a problem specific to my database and would like to be able to email someone directly instead of going through a public forum. I have created a "feedback" request, but it's not clear to me that is actually a support ticket.
how to make same diagrams in reports?
how to make diagram with floating pointer from red to green zones? see screenshot
Zoho Reports - New feature rolled out on Jan 02, 2015
Copying a Table With this new feature from Zoho Reports, you can now save a copy of a table in your database. This feature will be pretty useful for cases like Backup, Copying table design etc. Click 'Save as' menu in the toolbar to save a copy of that table. You can choose to copy the table with data and/or retain the lookup columns of the original table. On copying, all formatting, formulas etc. will get retained in the new table.
How can I select rows without a date ?
dear all, In a data sheet I have rows of which in one particular date column there is a date filled in or no date.(blank). The date is a proof of delivery date. I would like to build a pivot table only filled with the rows that in the particular column has not a date ( = blank) . so all rows should be reflecting those who have no proof of delivery date in it ( = not delivered) How can i obtain this. If I selct the column and try to put a filter it does not let me to select blank or emty or...
How can I get a report to display empty cells?
I created a dashboard that has two reports within it. The first report shows all 12 months in the year because each field has a value greater than 0. The second report (filtered slightly differently) only show 5 months because 7 of the cells are empty. This doesn't look good, how do I get it to show all values even if they are null/empty.
Zoho Potential - Sales Report
I have closed won potential with revenue amount of $48,000 which is divided into 12 months projects. Each month is actually $4,800. So, 1) How to divide the revenue to 12 months and 2) How to generate a sales person's report for specific month?
firewall configuration
Hi team, We would like to evaluate SD+ with ZOHO Reports, but our SD+ server by default doesn't have access to the internet to upload the data. So, in order to open the traffic on firewalls from our SD+ server only to ZOHO Reports we need to know your IP range, can you share? Mar
Is anyone online?
I have some (basic) questions regarding Zoho Reports and am wondering if I can chat or screenshare with someone. 1) I have a field called "Event Type" and values such as "A", "B", "C", "D", "E". Let's say I wanted to report on a rollup or group these into regions where Event Types A, B, C = region 1 and Event Types D and E = Region 2. How can I add this column to a database? 2) When I want to refresh the database, how do I do that? I would want to wipe out all of the original data and put new data
Today I started getting an API_ACCESS_REQUEST_BLOCKED error when the CSV upload program tries to log in
It doesn't happen all the time, but enough that I can't get all my data uploaded. Nothing on my side changed. What is wrong? Here is what I get in the log file: 2014/12/19 16:07:26 MST:Logging in 2014/12/19 16:07:26 MST:logging into https://accounts.zoho.com 2014/12/19 16:07:27 MST:IAM Error: Response status: 200 IAM Response: # #Fri Dec 19 15:07:27 PST 2014 CAUSE=API_ACCESS_REQUEST_BLOCKED RESULT=FALSE 2014/12/19 16:07:27 MST:Error!!! Could not login. Could be because of API_ACCESS_REQUEST_BLOCKED
Zoho Reports: any timeframe for iPad / iPhone browsers support?
hi, Zoho Reports is great but when I try to access one of my published reports from my iPad, the graphs keep on refreshing. They seem to be displaying well other than the constant reloading. Do you have any plans to make it compatible? If so, any date? Thanks in advance! Fabien
Feature Request: Add area shading to axis (background) or as minimum Add "Threshold" to Scatter chart
HI Zoho Folks, I have request for a new feature. I have a scatter chart of min vs max as my two axis. One set of our customers get a certain configuration if their MIN value is ABOVE a certain threshold. One set of our customers get a certain configuration if their MAX value is BELOW a certain threshold. My "Max" value is charted on the Y-Axis, my "Min" value is charted on the X-Axis. So I'd like to be able to shade from Min Threshold and greater, that is the area to the right of a threshold value
Query table not updated automatically after adding formula columns
Hi, if I create and save a query table of this type: SELECT * FROM TABLE1, TABLE2, … WHERE (any condition) And later modify the source tables (TABLE1, …) adding formula columns, these new columns will not be added to the original query table result. I hope this can be improved on the future, since now apparently it is required to generate a new query table for any change (adding new columns, etc.) that is done on the source tables.
prior month formula
Hello, Does anyone know how to create a formula to get the prior month sale?
Issue in ZOHO_CRITERIA
I want to filter the report (Pivot chart) based on user login. I created a report in ZOHO Report and i want to embed that into my creator app. iframe code is <iframe frameborder=0 width='400' height='300' src='https://reports.zoho.com/ZDBDataSheetView.cc?OBJID=###### &STANDALONE=true&LP=RIGHT&ZDB_THEME_NAME=grey&INTERVAL=-1&REMTOOLBAR=true&INCLUDETITLE=true&INCLUDEDESC=true&ZOHO_CRITERIA='Company Email='zoho.loginuserid'></iframe> But the filter is not working. Thanks Gowsalya.B
Feature Request: Add "Best Fit Line" (R-Squared) to data set on Scatter Plot
HI Zoho Reports Folks, Please add the ability to chart a "Best Fit Line" (i.e. R-Squared) to a scatter plot graph. It would also be nice if you could include a 'error line' around this best fit...so that you can visually see all of the data points that fall in inside the Best Fit Line +/- 20% (or some other threshold value mechanism) Cheers, Tyler
How to create a field in a table that is the sum of 2 other numeric fields in the same table row
I have a table of time spent on a task in a project. Each row of the table is a task and has a billable minutes column and a non billable minutes column. So the table would look like this: Task Billable Minutes Non Billable Minutes Task Name 1 25 10 Task Name 2 12 60 Task Name 3 6 15 I want to create a column in the table that has the billable minutes and non
Zoho Reports - New feature rolled out on Dec 08, 2014
Conversion rate in Funnel Charts With the latest enhancements, you can now show the conversion rate in your funnel charts as data label. The conversion rate can either be from the previous value or from the original value. Also, two new funnel designs, 'weighted height' and 'weighted width' have been added to the existing 'uniform height' design. You can find the above features under 'Settings' in chart view. Other Chart Enhancements 'Sorting' option has been added to both pie charts and web
Zoho Reports - New feature rolled out on Dec 03, 2014
Dashboards - Enhancement to View Underlying Data permission control While sharing a dashboard for the permission "View Underlying Data" you could now handpick the columns specifically that you want to share. So far you could only show all the columns or the columns involved in the reports embedded in the dashboard.
Zoho Reports - New feature rolled out on Nov 20, 2014
Editable User Filter So far, in 'User Filters', multiple values could be selected only from the drop-down box. But now, you can also enter the values separated by commas in the highlighted field. Values are case-sensitive and should exactly match the phrase. This feature is enabled only with 'Multi-select box component' in user filters.
Zoho Reports - New feature rolled out on Nov 10, 2014
Multi table support in Aggregate Formula So far, aggregate formula could be created with columns only from a single table. But now, you can create an aggregate formula by combining columns from any number of related tables. This will further help you to derive more powerful business metrics in Zoho Reports.
Stacked Bar Chart - data not stacking
When I try to create an stacked bar chart, the two data sets don't stack, but go side-by-side. How do I correct this/
Single Number Reports
Saludos. Soy nuevo en el uso de Zoho Report y estoy estructurando los reportes necesarios para introducir en toda nuestra organización este modelo de reporte. Es por ello que surgen algunas dudas cuyas respuestas no son evidentes en el area de trabajo. Quisiera me orientaran en relación a lo siguiente: 1) Single Number Reports 2) Dar formato (color, tamaño, negrillas,etc,) al Dato que aparece en las "Vistas de Resumen" 3) He elaborado un filtro con el 20% de las empresas que mas facturan en la "Vista
How can I recreate this report? -- Number of Potentials in each stage by month
I found this on the Zoho blog but can't find out how to create the first report listed. Specifically, I need to know dollar amount (instead of number of Potentials), and I need it by week rather than by month. Can anyone help? Thanks, Monica
SDP on Demand reports linked to requester with Zoho report account
Hi, How can I send predefined SDP on Demand reports to any Zoho requester account ? Thanks
Pending Requests by site
Please can you tell me how I can make a report for a dashboard that shows the Number of Pending Requests by site? This is for ManageEngine SDP
How can I do a ROW_NUMBER(), OVER and PARTITION in Zoho Reports?
'm trying to do the following, in Zoho .. but I can't figure out how to do ROW_COUNT(), OVER and PARTITION(..).. User | Class | Age Foo | "A" | 10 Bah | "A" | 12 Fred | "B" | 11 Jane | "A" | 11 and I'm after the eldest child, in each class. Results Class "A": Bah (12 years old) Class "B": Fred (11 years old). This can be done quite simply with a ROW_NUMBER, OVER PARTITION Can this be done in ZOHO?
Report Client returning empty rows, on exportDataUsingSQL call
Hello, A program just started failing last night at 1:28am EST, which for the past several weeks worked successfully. The issue using the report client actual call rc.exportDataUsingSQL(self.uri, "JSON", stream, sql, None) where the sql is a simple "select column from query-table" However, the query-table is currently empty. The report client, however, seems to be creating an empty row [u'', u'', u'', u'', u''] I am expecting no results to create a "rows" JSON array, with zero elements. Not a single
Unable to launch java - UploadTool error
Can you help me? When I ran the UploadTool to connect to a relational database, I get the following error message: Unable to launch "jre/bin/java" (8) Please, help me....
URGENTLY - The image at embeded page is showing a bad character
Dear Support, Could you verify what's happen? The page with embed image is showing bad characters.
Backslash characters removed on import
It sounds like backslash "\" characters are removed on CSV import. We have an input CSV containing the value Electric-PC\Electric, we import the CSV using the API, and in the table we see Electric-PCElectric. Any idea what the problem is ? Thanks !
Google import not working
Hello, I am having issues importing from google drive. I am unable to create a new database from google drive, the only explanation given is Sorry, Zoho Reports was unable to import this file. I have created a database from an identical google spreadsheet in the past, so am unclear why this isn't working. Please advise.
Need to make a formula field which gives total number points which is due till particular date
Hi Team, I need to make a formula field which returns total number of open points till particular due date. Please help me.. Thanks Kapil
How to copy/query a table from one reporting database to other one?
I have two reporting databses. I want to combine data from specific tables in each databse at one report. What is the best approach?
Single Number Reports
I would love the ability to create a single number report. Something that shows just the pertinent single number. For example. Sales for last month: $14,365. This is a very popular trend now with reporting services. See what they do here? http://www.geckoboard.com/statusboard-features/ I would love for this to be added to zoho reports. Thanks!
Problems running the Upload Tool - remote SQL database
Can someone please help me? I am getting the error message after I run the UploadTool (Mac) -bash: syntax error near unexpected token 'newline' Could not find this mentioned anywhere near the Reports topics...
Zoho Update Tool Error java.sql.SQLException
I'm with an error using Zoho update tool. Please, see below the log. Could you help me finding out how to solve it, please? Thanks in advance. 2014/11/23 18:00:27 BRST: OS : Windows NT (unknown) 6.2 x86 2014/11/23 18:00:27 BRST: JVM Version : 1.6.0_16 2014/11/23 18:00:27 BRST:TESTRUN :: false 2014/11/23 18:00:27 BRST:2014-11-23 18:00:27.121 :: Connection Props are : 2014/11/23 18:00:27 BRST:DBTYPE :: msaccess 2014/11/23 18:00:27 BRST:HOSTNAME :: BRASBHNOT021 2014/11/23 18:00:27 BRST:USERNAME :: 2014/11/23
Legend filters on dashboard
I created a dashboard of charts which are set to NOT show the legend but they are showing it within my dashboard. I have no filters on my dashboard. How do I get rid of this?
Next Page