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.
How to JOIN 2 Tables
Hello, I Have Put Several Tables in a Custom Folder (all tables Have same Headers) . I want to Create a MASTER TABLE and Merge all Tables in it. I Tried Query Table But it is returning Crazy Results, Can anyone please help. Best Regards, Atul Jain
Currency Standardization for Proper Analysis
Hello, My Data Has Separate RATE and CURRENCY columns, RATE mentions price of the Product and CURRENCY Mentions Which Currency price is (mentioned in Standard 3 Digit USD, EUR, INR etc) Can anyone let me know how to Standardize all Price to USD for Correct Analysis. Best Regards, Atul Jain
Embeding Zoho Reports Dashboards into Help Desk Portal -
Hi, Is there a way to embed a Zoho Reports Dashboard into the Help Desk Client Portal and have it filtered by the User's Organization in the CRM?
Colocar Valores del Eje Y en una posicion determinada
Saludos. Quisiera saber si existe la via para colocar el "valor del eje Y" del menu "Parámetros" en una posición seleccionada por nosotros "arriba", "abajo", "Medio". Gracias.
UploadFromDB.bat failing to run on Scheduled Task
Hey guys, Hoping i could get some help with this. I am trying to use a scheduled task to run the UploadFromDB.bat file on the Reports Tool. However, when i try to run it, it wont even show the cmd prompt showing up and times out after the hour i set it to. If i run the batch file manually, all works fine. I have tried to multiple ways to get this to work Set Add Arguments: UploadFromDB.bat Email Password UploadFromDB.bat Email -A authtoekn <Blank>
User Filter Does not Reset on initial load of Dashboard
I have several Dashboards with a single user filter on them. I have the filter set to Select Box List All Values I have set the "default filter value" to a valid field value Filter Behavior is set to "Always list all values" When the Dashboard is first loaded (by a user) the filter does not have a starting value and the reports are not filtered. It is really ugly for my users, as the query it is pulling from has all sorts of information that I don't want my users to see when the page loads. If
Does the Zoho report API support the GET action?
I'm trying to GET data from Zoho Reports using the Skuid REST API connector. And I wanted to ask if the Zoho Reports API supports the GET action? I do not see this anywhere in the documentation....I would like to GET data from my Zoho reports database and into my Skuid application....Thanks for any help or advice Skuid APP REST Connection https://docs.skuid.com/latest/en/data/rest/index.html?highlight=rest
Beta charts - Stacked Area Chart, colors faded
Hello! On the Beta charts, the Stacked Area Chart colors are too faded relative to the background, so my users cannot read them very well. Is there a way to deepen the colors?
creating a simple report
In a Pivot Table, how can I filter an individual field but not filter all of the incoming data? What I want is a simple report listing the following, using the data imported from Zoho Desk - Agent Tickets Assigned Tickets Resolved John Doe 1,200 1,100 Tickets Assigned will be the total number of tickets assigned in the given period [Filter all records by date range] Tickets Resolved will be the total number of 'Resolved' tickets in the time
Calculate percentage of total sales
Hi, I am kind of new in Zoho reports, so I will need your support... I would like to know for each client what is the percentage of sales. I am familiar with formulas and aggregated formulas but i didn't manage to make it works. Tnx L Client Jul 2012 Oct 2012 Nov 2012 Total by client Percentage of total sales Client 1 $ 4.00 $ 4.00 4/52 = 7.69% Client 2 $ 4.00 $ 21.00 $ 23.00 $ 48.00 48/52= 92.31% Total $ 52.00 100.00%
FTP Feed Schedules
Good Day I am currently working with a database that has tables that need be updated from an FTP server three different times a day, everyday. My current solution has been to update the tables in my database every hour. My question/suggestion is, can it not be made possible for one to set multiple specific times one can update a table in a day?
Date Difference to today's date
I am looking to write a formula that calculates the difference (in number of days) from a date in the past (entered in a column) to todays date e.g. Date 10th April to todays' date (in this case 1st May) answer = 21 Thanks, Tom
I need help in sorting a Pivot Table, can some help me?
Is there any where I can go to get some direction in sorting a pivot table? I would appreciate any help I can get. Thanks in advance!!
Response to a HTTP POST request that cannot be processed
Hello everybody: I am making an app for Android that sends many HTTP POST requests to my Zoho Reports account and I would like to know if there is any special or diferent response to those HTTP POST requests that cannot be processed because there are not more API units available. I want my app to be aware of this for the user to be notified about this in order he is able to make proper decision. Thanks in advance!
Calculating Working Days in a Month
Hi there, I need to be able to calculate the number of working/business days in any given month. I have found existing functions for SQL such as the below: (DATEDIFF(dd, "Month", DATE_SUB(ADDMONTH("Month",1),1)) + 1) -(DATEDIFF(wk, "Month", DATE_SUB(ADDMONTH("Month",1),1)) * 2) -(CASE WHEN DATENAME(dw, "Month") = 'Sunday' THEN 1 ELSE 0 END) -(CASE WHEN DATENAME(dw, DATE_SUB(ADDMONTH("Month",1),1)) = 'Saturday' THEN 1 ELSE 0 END) However it seems that Zoho does not recognise the "dd" or "wk"
New Features rolled out on April 19, 2017
Beta Release: Teamwork Projects Advanced Analytics Add-on We at Zoho Reports are very happy to announce the release of Zoho Reports Advanced Analytics Add-on for Teamwork Projects (Beta). This add-on empowers the users of teamwork app with advanced analytical capabilities thereby giving a greater visibility & control on their project execution. The Teamwork Advanced Analytics connector comes bundled with over 50+ default reports and dashboards that will help you keep track of your Key Project Metrics.
Widget - Choose source table/query list not alphabetized
In a Dashboard, if you select "Add Widget", the drop down list of potential table/query sources is not ordered in any way that makes sense. For users like myself that have 100+ tables and queries in a database, it is incredibly annoying to have to scroll through one by one to find the correct source. I would think it would be in alphabetical order like other lists. Thanks.
Duplicate Values when using Look-Up columns to generate reports
Hi All, I have 2 Tables [Employee Data Leave and Tasks]. I have done Look-up using common Field [Employee Name] I then created report based on below values: X-Axis - Date Y-Axis - Total Allocated Hours [From TASKS table] - Total Daily Working Hours [From Employee Data Leave Table] The actual value of Total Daily Working Hours is = 8 Hours for January 2017. The Report is showing Total Daily Working Hours = 16 Hours . [This is Incorrect] The reason it is showing as 16 hours is because it
Problem with old/new Charts
Dear Zoho guys. I'm concerned about the following issues I'm facing in a Combination Stacked Chart: Issue 1: When I use the OLD Graphs in a combination stacked chart, the bars are shown stacked but the line are shown in the same scale. Whet I turn into the new Graphs the bars are still shown stacked and the lines are ALSO shown stacked (here is my problem, I need to show both lines under the same scale): Issue 2: When I try to show numeric values in a chart, everytime i Try to show values with 0
Next Page