ServiceDesk Plus Region
Are there plans to incorporate the ServiceDesk organizational details into Zoho Reports? We have our organization mapped out the regional level and it would be nice to produce rankings and drill down reports by region. Craig Rice
Parameter in a Query
Hi, I have a query that includes the typical FROM a date TO a date. I change this FROM / TO value all the time and I have to change it manually in the query all the time in several sentences. Does someone know how can I make to select the FROM date and TO date just one time, maybe in a kind of form previous to run the query? Thks for your help! Enrico
Bad request when calling ADD_ROW api
I have a web application that uses Spring client to send data do Zoho reports tables, when I run the development server with the same data and same code, all the commands are called correctly and I get 200 response. However, on production server, I am receiving 400 error (bad request), and I'm not understanding what is wrong with the data I send: This is the url I send the data: https://reportsapi.zoho.com/api/xxx@xxx.com.br/cervaki-app/Engajamento?ZOHO_ACTION=ADDROW&ZOHO_OUTPUT_FORMAT=JSON&ZOHO_ERROR_FORMAT=JSON&authtoken=xxxxxxxxxx&ZOHO_API_VERSION=1.0
Filtered tabular view in Zoho Report Dashboard
Hi, is thera a workaround to put in a dashbaord a filtered tabular view. Here is the example that I have: I have in a query table all information about deals. I would like to provide in a dashboard tree tabular views that give info about renting, paymemt of commissions, direct sales. I do not want to provide the data in a single tabular view because e.g. the payment of commission report consist of 6 fields but direct sales tabular view of 15 fields.
Query table creation option to shared users
Is it possible to give a shared user option to create Query tables?
How to Rename a Column in Tabular View
Hi. I have found the instructions for renaming a column, but it appears to be different in Tabular view. There is no "Edit Design" button. I have tried all available menus and contextual menus, but I cannot see how to do this. Is it possible?
Does anybody dealer with ORA-01861 error with date?
I'm trying to export data to a table in Zoho Reports using Zoho Upload Tool. I can successfully run the query and get the results in Oracle (using TO_DATE conversion for text fields with date value), but using the exactly same query in database_sql_queries.xml gives me the following error when I run the UploadFromDB.bat: java.sql.SQLException: ORA-01861: o literal não corresponde à string de formato at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:125) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:305)
Inserting a carriage return or new line in SQL code of a Query Table for readability
My queries are working correctly, this is a formatting question to make it easier for me to see the structure of my queries when I am editing them. In a SQL Query Table, the SELECT commands easily allow me to put each field on a new line by using the carriage return after the comma: SELECT "Table 1"."Field Name 1" As "Alias Name 1", "Table 1"."Field Name 2" As "Alias Name 2", "Table 1"."Field Name 3" As "Alias Name 3", etc. all I had to do was hit "Enter" after the comma. When I hit
Records being truncated by 10,000 rows exactly
I have been using the UploadfromDB.sh tool for a few months now and it has never given me a problem. However, when i'm trying to load a new report it truncates the data exactly by 10,000 records no matter how large the data set. The database that I am pulling records from grows daily so the records uploaded grows daily. Yesterday the number of records the tool says were written was 24367 (which is the correct number) but the report on zoho.com showed 14367. Then when I tried it today the upload tool
New Column Is Not Calculating
Created a new calculated column in our request table but it is not calculating all records. The calculation is: datediff(curdate(),"Completed Time") and the column name is Days Since Closed, numeric. What am I missing to get this new field to calculate correctly? Thanks - Craig Rice
Zoho Reports
Hello, Is there a way to pull reports for individual users?. Example: We have a small sales team and need to track progress of individual users ideally with out running independent reports for each, or at least filter. Thanks, -Wyatt
Shared report with variable filter not opening
The user with whom I've shared a report using a variable filter is not able to view the same. He encounters the time-out error. Report name is 'Dashboard-Micro-YE'. What could be the reason? I've shared the DB with support to look into this.
Filter using row numbers in pivot table
In a pivot chart, is there a way to filter the chart using the row numbers that are provided by Zoho? My use case is that I am using the pivot view to display individual rows of data from my table (without showing all of the data columns using a summary or tabular view). I want to filter so that the report does not display any data if there are less than 5 rows of data. I've tried building an aggregate formula to count on a field, but the field counts are unique to each data row since I'm displaying
Filter using row numbers in pivot table
When creating a pivot view of data, is there a way to build a filter using the row count that Zoho Reports automatically creates? The use case is that I am using a pivot view to show individual rows of data. I want to limit the pivot report so that it does not display if there are fewer than 5 rows of data. I've tried building count aggregate formulas and use the aggregate formulas to filter the data, but this does not work because I'm trying to show individual rows, so the count is always 1.
Query Sorting Records First Entry By Group
SELECT "IORef", "PaymentDate", SUM("FCIRecognition") FROM "Dave Live - Income Details" GROUP BY "IORef", "PaymentDate" I wrote the above simple select query - I would like the result to be that for the 'IORef' the earliest date for each 'IORef' is only displayed. So for example, using the results below only row 1 and 11 would appear IOB00000004 - 2016-01-28 35.32 IOB00000009 - 2016-01-22 0.51 I have 1000's of rows that I would like the earliest instance of the 'IORef' to only appear in the
the report brings an incorrect result
Hi, I'm doing a report. But the result seems wrong. I want the users to see only the lastlogindate in the report of 1900. the users that a value is true I want to see. The Result Seems Wrong. MY TABLE SAMPLE MY REPORT FİLTER : As a result of the report from: when I questioned the data, I see that people in that position who do not meet this criterion affects reports, and report the result seems wrong. Please help
Reports Status
Is there a service that displays the status of Zoho servers? At times, we notice a performance drop in the reports and would like to know if the problem is on the servers where Zoho reports is hosted.
Zoho Offline
Hola. Saludos. Existe la Posibilidad de Trabajar con ZOHO "Offline"? Local? Gracias
Formatting not working within tooltips
None of the formatting, whether for Y-axis or Tooltip columns, are working within the tooltip message area of New Charts.
How do I trim and replace in a formula?
Hello, Apologies in advance for the length of this post, but it requires background information. I am trying to do something in Zoho Reports that I have no problems with in Excel (or Access). Background: We make tooling used in sheet metal fabrication. Our part numbers are either fixed or variable. The variable part numbers have always caused headaches for sales analysis. Here are a couple of examples of variable part numbers: PAAA0A025 PAAB2A0250X1000 The fifth character always indicates the shape,
Lookup not supported
Hi, I am trying to join two charts using lookup function following the instruction from the video demo and I'm receiving information: 'Sorry, currently lookup on another lookup column is not supported'. I'm on trail version. Could it be the reason...? Thanks in advance!
Terminating Report Execution Threads
Greetings Everyone, When loading a report, there is an execution timeout. I'm often working on reports/dashboards that are processing very large amounts of data and sometimes wish to terminate the executions rather than wait for the report to load (especially when I know it's going to timeout). Is there a way to manually kill the process execution? Closing the report or dashboard doesn't seem to do the trick and neither does refreshing the page. If that's not feasible, would it be possible to add
Custom Formula Using Data from Related Tables
I'm testing our Zoho Reports and have a question.. I'm looking to calculate ratios using fields from related tables. I have three tables as follows: Table A: Clients Table B: Annual financial data for each client, joined to Table A by a client ID, for a series of years. Table C: Additional annual financial data for each client, joined to Table by a client ID, for a series of years. I want to use the data in Table B and C to calculate specific ratios for each client in Table A for each year. For example,
Sort Values in descending Order Pie Chart
Hi Team, Can you help how to sort values in Ascending/Descending Order in Pie chart. Regards, Anil
How to turn off (NOT MINIMIZE) chat?
Of late, I've been seeing these chat icons which are more annoying than helpful because they hide important elements like rows count in a table view and X-axis settings in chart view (see below example). How do I get rid of them? Need help urgently. Clicking on close button on top right only opens chat window.
Table disappear
Hello, I have a problem. I create a graph with data from Table Customers. Once I save the graph, the Table Customer disappear and I cannot use it anymore to update the graph. The Table Customer is still in my file but I just can't access it from my graph anymore. Any idea why ? Thank you :)
Report grouping by elements in a multiselect list
Hello, I have created 2 forms: Phases (ex. P1, P2, P3) Initiatives, containing initiatives and a multiselect lookup with phases that the initiatives belong to (ex I1 ->P1, P2 and I2 -> P2, P3) Now I want to create a report that displays: Individual phases (as grouping category) InitiativesAnd which should show me: P1 -> I1 P2 -> I1, I2 P3 -> I2 My report produces a grouping category that includes all phases: P1,P2 ->I1 P2,P3 ->I2 Can you please help me ? Norman
Counting Rows
Hello, I was wondering what exactly odes a "row" means when importing data. Like if I have a CSV file, does that count as one row ? If a row has 2 columns and it is treated as one row. Does that mean that if I have a row with 25 columns, it will still be streated as one row ? Thank you very much
Stacked bars graph
Hi Zoho, I've created a simple graph what have negative and positive values, each one comes from different tables. Using a Stacked bars graph, it overpose negative and positive values, but when there are only negative values, for exemple, it didn't shows. shows only the columns which have both of this values (positive and negative). When I take the positive column away, the single negative values show up. OBS.: The tables are connected by lookup columns. Can you help me ?
Is it possible to set a minimum amount of records
Is it possible to require a certain amount of responses before showing the data? Let's say I put a minimum limit on 10 and make my report. If the database only has 9 records, the charts in the report must be empty.
New Features rolled out on February 23, 2017
Zendesk and Mailchimp Analytics - Public Release We at Zoho Reports are extremely happy to announce the general release of advanced analytics connectors for Zendesk and Mailchimp. Until now the beta version of these connectors were only available for the paid users of Zoho Reports. With this general release it is made available for all Zoho Reports users. The add-ons are available Free in all paid plans of Zoho Reports. It is priced at $15 per add-on/month in free edition. Zendesk Advanced Analytics
Using zoho reports properly to create ZOHO CRM commission reports
Hi, I am really stuck how to realise the following report to my partners: I would like to provide to our partners info about the commissions that we have to pay them and the commissions that they have to pay us for the Deals that we have made with their reference. As general the partner has to have access to table that provide data from the DEALS MODUL CONTACT MODUL Here is what kind of colums the table has to have: DEAL NAME DEAL TYPE CONTACT ( this is lookup filed and provide the name of the
my id is blocked
Hi There, please remove the block on our mail account. We are not able to send a single mail right now, can you please explain the reason for this ? rubina@reacherp.sg
Using Constants within a Query Table
Hello, I'v started creating a new query table but have found myself using a lot of constants within my queries. These constants or "magic number" may need to change globally. I was wondering what the best way to handle constants/magic numbers withing qiery tables. One option is to create a table call "My_Report_Variables" with two columns "Constants Name" and "Constants Data". I could then lookup the "Constants Name" to get the data. In the future, if the values of these global constats change, I
Email This View - Export Option Missing
HI, Can you please tell me how I switch on the " Email This View" export option. I can export a file when viewing a report, but the email option isn't present. Any tips appreciated. Screen shot of my file , with the support info below it. Thanks Paul
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.
Group By error
HI can you explain why the following doesn't work as a zoho query but works using raw SQL. Thanks Joe clientID, sid, `Activity Type : L1`, min(`Date of activity`) FROM opf_act WHERE `Activity Type : L1` IN('Pathway referral', 'Other informal learning') GROUP BY clientID; It generates the following error If I add any of the other fields to the Group By ,, then the table is no long a summary table.
CarPro Systems
Hi, I am new to CarPro. I am using excel ODBC for analysis. I would like to extract for all cars in my fleet, the disposal date, the date it was marked for sale, the date it was unmarked for sale. what is the source table to use on excel odbc? Thanks. Ash
Legend Filters stop working during drill down
Hi - I have some charts with Legend Filters. These work fine initially, but if I drill down, they no longer work and all Legend entries are shown. Is this expected behaviour or a bug? Thanks.
Zoho Reports - trouble importing decimals
Hi Someone can help me on troubleshooting this problem, please? I'm importing a CSV file (separated by semicolon) from OneDrive to a Zoho Reports Table. Everything runs smoothly but I have a problem with currency and decimal columns. I have a decimal value in the CSV that is 2,5 (comma for decimal) Scenarios: 1 - I've defined the taget column as Decimal, with two decimal places, and a comma as a decimal separator. The importing result are: for 2,6 in the source the result is 26,00 for 1 in the
Next Page