Limits on Import Number
I'm attempting to import all of the records from a Knack.com database. Knack only allows calling 1000 records at a time. The object has over 1000 records so I need to request the records until it has them all. I'm not very good at coding or java. I've attached what I've got so far. Anyone able to help?
Resizing KPI widgets
Hi, I'm having an issue where some KPI widgets have resized and are not displaying the information. I attempt to resize them larger to show the information but it's not working. In the attached image you can see the original size of the widgets I had on the dashboard. I'm still not sure why they resized. I can hover the cursor over them and the blue line appears but won't let me resize it.
Limits on Import Number
Hi, I'm importing data from a knack database. Knack's API only allows pulling out 1000 records at a time. I'm a little stuck on how to get zoho to continue asking for records until it has all of them. Any suggestions?
Aggregate formula
Hello I am trying to write a Aggregate formula however I am running into problems. Is there a forum that helps define the operators as well as the syntax for the tables, columns, and rows. IE "Table"."Column". 'Row'
Import from zoho reports table
Hi, I need to make a scheduled import from one table from zoho reports to make a new table with the historical value. How I can to import from a zoho reports table? Thanks, Oriol
GET XML via API to Bubble only getting 1 column
Good Afternoon, I'm trying to GET data from Zoho Reports using the Bubble development API. The results I'm getting are getting stuck at the first column Here's how I've set up the Bubble API connector to Zoho Reports: The rest of the parameters are: ZOHO_ACTION = EXPORT ZOHO_OUTPUT_FORMAT = JSON ZOHO_ERROR_FORMAT = XML ZOHO_API_VERSION = 1.0 ZOHO_DELIMITER = 2 (this sets the delimiter to a semicolon) And finally, the Bubble results when I initialize the call: You can see that columns 0, 1, 2, 3...
Endless "Sync In Progress" Status
My Zoho Reports trial recently ended and I purchased a subscription to continue working on the reports. The data was imported from Zoho CRM and was set to sync automatically every day. However, I noticed Zoho CRM's database is now stuck in 'Sync In Progress' mode and I can't access its setup nor manually sync the database. It's been in this state for the last 2 days. If someone has been experiencing the same issue and found a solution I'd appreciate your sharing that information. Thank you!
Absolute and relative variation / Variación absoluta y relativa
Thank you. I have several years' information on a table called Financial Transactions. In some of its columns I have "Date" and "Value of Sales" among others. I require absolute and relative values for the last two months. Could you please tell me how? Thank you ******************************** Gracias. Tengo información de varios años en una tabla llamada "Operaciones Financieras". En algunas de sus columnas tengo "Fecha" y "Valor de Ventas" entre otras. Requiero obtener los valores absolutos y
Zoho Reports & Zoho Books Automatic Sync not adding records to zoho reports
We've been using zoho reports and zoho books sync for about a year with no problems. About a week ago, we noticed that new zoho books records are not being added automatically. The sync says it has run, but there aren't new records. If you manually trigger the sync, new records appear. Very inconvenient, since many of our report consumers cannot trigger a manual sync.
Zoho reports query table problem
Hi, I wanted to ask you a question regarding one query that I am trying to build so I can make a report out of it. I had 2 requirements: 1. Get the potentials that have reached the red zone, and the red zone is a percentage of probability for that potential. 2. Get the potentials that have reached the red zone and ended up being won. The red zone will also be chosen in the report slider. For the first one I solved the problem by using this query : SELECT potential."POTENTIALID" AS "Potential Id",
Giving an access to Zoho Reports
Hi, could you advise on how to give an access to Zoho Reports to the person from my organisation? This is what is despaled after accesing ZOHO Reports: You've got the right process, but is it followed through? Read more. Top of Form Bottom of Form FeedsProjectsHomeLeadsAccountsContactsPotentialsCampaignsReports Top of Form Bottom of Form 1 Setup General Users and Control Customization Automation Extensions & APIs Zoho Google Social Marketplace Others APIs Webforms Data Administration Advanced
Directly push form date from Zoho Creator into Zoho Reports
Hi I found this link on the subject but it is no longer working. https://reports.wiki.zoho.com/-Creating-Data-Entry-Forms-for-Zoho-Reports-using-Zoho-Creator.html Any guidance on how this can be achieved would be greatly appreciated. Thank You.
Running Average of Scores
Hi, I've created a graph that has the date on the x-axis and scores on the y-axis. I would like to graph the average of those scores over time, such that the last point should be the current overall average. I've tried all the options, including "moving calculations" and while that one gets the closest to the current average with the last point, it is off by a few points. Any suggestions for building the graph that I want so that each bullet point includes the average of the scores to that point?
report comparison on time with gaps
Hi, Is there any way to see reports with time frame as - this year quarter1 vs last year quarter1 - this year month1 vs last year month2 .. I can see options like this week/month/year vs last week/month/year but not this year current week vs last year same week I'm expecting a dashboard in which I have 2 reports side by side showing same kind of data say "number of leads on weekly basis". It has a user filter on top in which there are options like "this month/quarter/week". When user selects say
First Trx Date in SQL
I am trying to get the first trx date by joining Zoho CRM Accounts, Zoho Books Contacts, and Zoho Books Invoices. I can get my expected results, but the first trx date column is no longer a date field, I believe its a string, which is not ideal for reporting filters. I am updating my SQL to CONVERT the field to a date field: SELECT "Account id", "Account Name", "Account Type", CONVERT(DATE,MAX("Invoice Date"),23) AS lasttrx, MIN("Invoice Date") As first_trx, COUNT("Invoices
Filter not being applied
Hi Everyone, I have a report that i have applied a filter on. When i run the report, I have to constantly select the filter. Is there a way to have the filter permanently applied? Thanks Dan
Zoho Reports App for iPhone
Why isn't there an iPhone app for Zoho Reports? There is one for iPad, but not iPhone.
Aggregate Formula: Calculate Conversion Rate based on Orders and Sessions: Parameter EXPR not correct
Dear Zoho Reports Community, I have following table: Date | Type | Value with Order and Sessions information, e.g.: Date Type Value 30 Nov 2017 Orders 10 30 Nov 2017 Sessions 100 31 Nov 2017 Orders 5 31 Nov 2017 Sessions 100 ... ... ... Now I want to calculate the conversion rate for each day, based on Orders/Sessions. This would lead to a conversionrate of 10% for 30 Nov 2017 and 5% for 31 Nov 2017 At the end, I want to have a chart, showing the conversion per day. So I added a Aggregate formula
Announcing New Charts Visualizations.
Announcing New Charts Visualizations. #MoreVariety - #MoreColors - #MoreImmersive - #MoreModern We at Zoho Reports are extremely happy to announce the general availability of the brand new version of our charts visualizations. Our new charts brings in more variety, more pleasing & cool color schemes, offers more immersive experience and is built on a more modern technology stack. #MoreVariety: We have now added several new chart types such as Bubble, Packed Bubble, Dial and Bullet to our library,
Force decimal numbers type when creating tables trhough API's bulk import
I'm importing data trough API's bulk import, automaticaly creating tables. I've ran into serious problem: when table is created and incoming data has some integer values (say, "total": 500), the type of a column will be set as 'Positive Number'. But if in later imports to this already exising tables "total" becomes decimal ("total": 550.6), request fails with "Bad request" error, because decimal value in being inserted into integer column. I don't see a way to force Zoho to create numeric columns
Invalid JSON in API response
Every API action that returns field "criteria" (EXPORT, FETCH), returns it like this: "(\"Id\"=\'id_2\')", which is invalid. Here's a full response that fails JSON validation: { "response": { "uri":"....", "action":"EXPORT", "criteria":"(\"Id\"=\'id_2\')", "result": { "column_order":["Id","table1field1","table1field2","table1field3"], "rows":[
Zoho Reports (User Filter)
Hello, User Filter has "Select all" Button. But that disappears once a Query is Typed in User Filter Search Box I want to "Select all" results of My Query. I Have already discussed this with Mr. Sarvanaprakash from Zoho Reports and he understood the problem. Development team please insight from him. Best Regards, Atul Jain. 9550590673
Zoho Reports Sync failure with Zoho Projects and Incorrect data displayed
Hello, We have created a report for Zoho Projects in Zoho Reports to give us results for the users Overdue, Today and upcoming Tasks. We have a total of 5 users. Selecting each user in the User Filter allows us to see the tasks and take a print accordingly for each user.. Since today morning, the user filter shows only 2 users. Also it only shows the Upcoming tasks. We need help. As the system is broken suddenly. Nothing has been changed at our end. We also noticed a Sync failure. (Attaching screenshots
Sales Report by Customers and by Item quantity
HI I want to know how many quantity of each items each customers bought during the month How can I do this Am not seeing any ways in Zoho reports. and its used to be
Razão:554 5.1.8 Email Outgoing Blocked. Learn more.
Good afternoon I can not even send emails, says it's blocked.(554 5.1.8 Email Outgoing Blocked.) Can check Thank you
Format of Numbers
Hi, I can't change the number format from the one with two digits after the decimal. Changing Settings - Range and Interval - Set Format does not work. So instead of having 123456 I have 123456,00. Please advise how to get rid of ,00. Thanks in advance!
COLUMNAS DE BUSQUEDA DESAPARECIERON
En las columnas en donde tenian la opción de BUSQUEDA DE COLUMNA, han desaparecido. Y si edito la tabla en la columna de tipo de datos no aparece la opción LOOKUP COLUM. Por favor necesito ayuda urgente. muchas gracias. DANIEL ARRIETA de Mendoza - Argentina mail: postvtamendoza@gmail.com
New Features rolled out on May 24, 2017
Improvements in the Lookup Column Feature We are rolling out a few enhancements to the lookup column feature to further enhance its usability. Specify data type for look up column: Users can now change the datatype of the lookup column. Until now, the child column will share the data type of the parent column. With this update, you can set a specific data type for the child column. You can change the data type of the lookup column using the Edit Design option in the table. Support for Default
Mixing of Aggregate functions (like SUM, MAX, ...) with non aggregate columns is not allowed
The formula below is not working and I cannot find a workaround. Could you please help me? if("source indicator"='Total Opex', "Steering_Database_EUR"."Diff. Actual vs Target (EUR)"*-1, "Steering_Database_EUR"."Diff. Actual vs Target (EUR)") Thanks
Storing historical data for potential probability
Hi all, Currently we are using Zoho DB as the main source of data for the reports. I would like to know if we can have the following data store in Zoho reporting database: - max probability that was ever reached for potentials (since the potential record was created)? Basically, we would like to measure how many potentials reached final stages of negotiation (where probability for winning was very high), but were not won for some reason. Do you have some ideas/formulas for that? Regards Vera
SQL Query: COUNT value in Column, ignoring Group By - Found solutions not supported in Zoho
Hey everyone, I have the following database Order # | SKU | Other info | Other info2 - always first when grouped 1 SKU1 Name |abc 1 SKU1 Name |xyz 1 SKU2 Name |xyz 1 SKU2 Name |xyz 2 SKU 2 Name |abc 2 SKU 2 Name |xyz 3 SKU3 Name |xyz 3 SKU3
Median Aggregate Formula - Percentile Workaround
Hello, This is a very specific example, but I'm hoping to find a workaround for calculating Median. See below request: I've tried the Percentile workaround for Median in Zoho, but for some reason my aggregate formula is not calculating the Median. For instance: Aggregate formula used: Percentile("ODC Dec2015-Apr2016"."GROSS_REVENUE",50) On the graph, the only number appearing is the highest value vs. the actual media. Is there something off with my formula? Please advise. Thank
Is this possible?
We have a custom module (Value Visit) that contains many different checkboxes that our end users check when they complete a task for a client. The end users aren't required to do all tasks at once, but as long as they complete all tasks (check all boxes) within a fiscal quarter all is well. The end users do not continuously update 1 Value Visit record for the entire quarter, but instead make a new record each time they visit a client (account). What we need is a report that will look in a given time
Gauge Graphics
Dear Support, It'll be great if we have some Gauge Graphics at Zoho Reports. Could you tell us if is possible? Thanks. Paulo Miguel.
Python Library for Zoho Reports
Hi, I use the Python Client Library (https://zohoreportsapi.wiki.zoho.com/Python-Client-Library.html) to run Zoho Reports API at home. It works great. However, when I try to run it my office it throws an error. I believe this is because my work place uses a proxy server that authenticates with my windows login account. Can you confirm if the Python Client Library can support API calls via a proxy server? If yes, how do I do this? Do I need to change the ReportClient.py file to support this? Thanks
New Features rolled out on May 17, 2017
Homepage - Import Options in a Single Page The new Zoho Reports homepage layout will allow you to easily spot all the import options in a single page. Until now, users had to navigate across pages to check out the available import options. We request you to check out our new layout and share your feedback. Send Email - Option to Append Email Sent Time You can now choose to display the exact time when the report was generated in the subject line of the email while emailing reports and dashboards.
Free trial has hijacked my access
I have access to a number of Zoho services on a corporate license. Today, I was granted a license to use Reports, but when I navigate to Reports, it claims I am in a Free Trial (I also received an email to this effect). Please remove the free trial and verify my access to my company reports.
Report using Related Lists
Hi, I am a user of CRM Plus, which I have integrated with Zoho Reports. In the CRM, there is a section within the modules for related lists, and I can run reports on this relationship in CRM. However, the same relationship is not available in Zoho Reports (the two modules in the model diagram are completely disconnected). Please consider integrating related lists into your reporting tool along with the module data! This is the only way I have found to reasonably create a many-to-many relationship
Table vs. rows in UploadTool command prompt
Can someone explain me, where is the difference in my configuration, that I get on one site table in UploadTool's command prompt and on the other site the status is reported in rows? Thanks! vs
Widget - Grafico Dial y Grafico Comparativo -
Saludos! He descubierto con grata sorpresa que los widget incluidos en el Dashboard poseen dos nuevas funcionalidades, GRAFICO DIAL y GRAFICO COMPARATIVO. Podrían enviarme tutoriales sobre como usarlos. si poseen manuales completo de uso de la herramienta widgwt con todas sus posible utilidades, seria aún mejor. Gracias.
Next Page