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
Multiple Color combination for Text Field in Charts
Hi All, I have a Report that has a "Text" Field [In Edit Design] values as "Billable" and "Non-Billable". My other fields such as X-Axis, Y-Axis, Color, and Size is already filled. My problem is I am getting the below Chart with both "Billable" and Non-Billable" in the same color demarked by only a LINE as given below: Does ZOHO has the ability to apply multiple colors for the same "Text" Field? I want different colors for "Billable" and "Non-Billable" demarked by a LINE. Please see the attachment
Custom Module connecting Potentials and Leads
I created a custom module called Partners. I put a lookup field on the Potentials and Leads module linked to my custom module (Partners). I want to make a report that lists Potentials and Leads for each Partner. However I go to create a report with Partners, and do not see Leads nor Potentials listed. How do I do this?
Using Zoho Reports python API, database not found when uploading to shared database of which I am not the owner
Hi, I get this "'Database not found!" error with the python Zoho reports API when adding a row to a shared database, one where I have write access but I am not the owner. Could someone recommend how to fix this? Thanks Rick Full message: Traceback (most recent call last): File "ZohoAccessor.py", line 102, in <module> ZohoAccessor().test() File "ZohoAccessor.py", line 29, in test self.addSingleRow(rc,uri) File "ZohoAccessor.py", line 65, in addSingleRow result = rc.addRow(uri, rowData,
Edit report scheduling
Hi - I am trying edit the emails within reports that are already scheduling and I've reviewed the Zoho documentation and other questions on here however I can't find anywhere on our system which shows the email schedules or anywhere within the report itself to amend the emails. Please help. Thanks
Activity RELATEDTOID, SEMODULE
Currently, the CRM to Reports integration does not appear to provide the ability to pull over SEMODULE or RELATEDTOID fields. This prevents any sort of robust reporting on activity vs revenue. Is this on the radar, did I miss a checkbox somewhere?
Next Page