Percentage of a sale value to overall sales
Hi, I am trying to calculate the % of a sale to overall sales as a row formula. In the following blog entry: https://www.zoho.com/reports/blog/explore-zoho-reports-series-part-i-formula-column.html it provides the following instructions: Or say you want to calculate the percentage of a sale value to overall sales. The formula will be (“Sales”/Sum(“Sales”))*100 However, If I try to add this formula as a custom formula it throws an error "Please use aggregate formula option to create aggregate formula.
Zoho - ManageEngine Integration. (Create a Time spent / Subcategory)
Hi all, Is it possible to create a report outlining the time spent per Sub Category per month. When I look at the table imported from ManageEngine to Zoho reports, there is no Sub Category field/column. Am I able to add this Sub Category column? Regards, Craig.
See account name in underlying data
Is there a way to display the account name in underlying data? For example, in a sales funnel I'd like to be able to see the Account Name along with the Opportunity Name. But the Account name does not display. Thank you.
Zoho and Crystal reports IX
I am new to ZOHO and have the most expensive version. Crystal Reports IX is my favorite Reporting Program,so I wonder if I can make a connection from CR to Zoho Not familiar with Zoho reports, and wonder if calculation on fields are possible ? Thnaks for reply. William
How to set up filtering based on user to show only their data?
In my example, let's say we have a report called Weekly Sales Report. This report needs to be shared with 50 sales people and each person can only view their own sales. When I share, I know I can share with one user and apply the filter criteria of "Sales"."SalesRep"='user1@mycompany.com'. However, I would have to do this 50 times while making sure I set the filter properly for each share. Is there a more generic or global method to share once with all 50 sales people while making the filter apply
Querys from diferent Zoho Reports Data Bases
I have one data base from Zoho Projects and another one from Zoho CRM, and I need to perform Querys between tables on both Data Bases, how I do that?
Reports not loading in Internet Explorer - Published URL
Hi Zoho, We often use the Publish -> URL/Permalink to export our Zoho Reports to our Intranet. Some users have alerted us that they are unable to view these reports correctly: some appear only partially and others not at all. We have determined that this is most likely due to a fault with Internet Explorer. Even with the Security Settings set to 'Low', we are unable to pull through the whole report to an IE browser. We do not have this issue with Chrome. Can you please advise as to whether this
Zoho Reports - New feature rolled out on March 26, 2015
Configurable Join support for report creation Zoho Reports now allows you to choose between Left or Right type join while creating reports (Charts, Pivot Table and Summary View) over related (linked) tables. This option will provide much more flexibility in creating reports. You can find this option in the Table Relationship dialog. Left Join - Report will be computed with all the rows from the child table (left) and only the matching rows from the parent table (right). Matching is done based
INNER Join With Concatenation
SELECT 'Task' as "Type","A"."Project Name","A"."Task Name","A"."Actual time Taken","B"."Work" FROM "Tasks" as "A" INNER JOIN "Task Estimated Hours" as "B" on CONCAT("A"."Project Name",' - ',"A"."Task Name") = "B"."CK" Above Query not returning even single row, need help in resolving the same. Thanks, GAURAV ARYA
Duplicate entries in my reports
I have a very basic report where I want to show entries for a specific date. I have created a date field and that is the only criteria that I use. I get a display of all client records with that specific date, which is exactly what I want. However, I get from 1 to 4 lines (records) for CRM record. Why do I not just see the client one time. If I am doing something wrong, then please tell me. Thanks David
Use Lookup Column in Formula
How can I use a lookup column as a part of a formula or what would be an alternative to this? What I am trying to do: - I have products and product prices stored in DB1 - In a sales DB I am using a lookup column to get product prices from DB1 Now I want to automatically calculate product prices (lookup column) * amount of products sold in the sales DB but for some reason I cannot use any lookup columns as a part of formulas. Any help would be much appreciated... Thanks in advance!
Upload Tool suddenly stopped working
I don't get any errors log, the only thing I get is the last line of the shell script: ./UploadFromDB.sh: línea 37: 26153 Terminado (killed) $JAVABIN $JAVA_OPTS com.adventnet.zoho.client.report.tool.ZohoReportUploadDataFromDB $1 $2 $3 $4 $5 The file has all permissions and I'm running it directly from console.
Security issue rogue employee
hi, I have a situation where we suspect an employee is using our data at a rivals office. Is there a way to check the IP address which a user logs in from? We would like to capture the data over a period of a few days if possible, and get a report on it.
Create a Date Column
Hi, I have two columns, both with number format, one with year and in the other month. I want to create a new column combining both that has Date format. I appreciate your help.
how to make graph as on example?
hi use klipfolio with zoho creator (json) think use zoho reports please explain how to make this type of graph - as on screenshot example? 1) current state of data (16.4%) 2) milestone data (19%) 3) 3 different colors for other pieces of graph
"number of rows" not properly counted
Hello, We're currently using the reports standard plan which allows us to upload up to 500,000 rows. According to the suscrption/usage page we are currently using 497,213 and that's not correct at all. We have 3 databases with less than 70,000 rows among all of them, so we are pretty sure the counting process on your side is not working right. We apreciate your help and thank you in advance. PS: the login email address of our account is:mobicotic@gmail.com
Adding data using Java API - Only Time column in a table
How to store only time like HH:mm:ss in zoho reports. I have changed my column type to Date and given the format as "HH:mm:ss" on dashboard, but I try to insert data, it gives me error.
Multiple filters same value
I have different tables, with different charts and I would like to have just one user-filter to filter the values of all tables (there is a column "primary key" in every table). Is it possibile?
Problem using the upload tool with mssql database
I'm trying to use your upload tool with our inhouse mssql db. I downloaded it and followed the configuration instructions. I keep getting this error. We have discontinued ticket support for Zoho APIs. We recommend you to replace the program with Authentication Token. For details, please refer our API guide available in https\://apihelp.wiki.zoho.com RESULT=FALSE 2015/03/09 16:42:14 EDT:ServerException (HttpStatusCode 200 Error Code: 407 , URI: https://accounts.zoho.com , Action: ZOHO_LOGIN,
Reports not generating
Hi None of my reports will generate - they open and load and then get stuck "generating" and then time out. I didn't have a problem with these reports before. I am able to create a new report, but it also gets stuck generating. Please assist urgently. Thanks Davina
How to enter data via iPad App?
Hello, We are wanting to enter field data via the iPad app. Does anyone know if this can be done? I have tried with no success. Thank you for the help.
CSV feed available to integrate Creator and Reports with free account?
With a "free" account in Zoho Report and Zoho Builder.. can you integrate them using a CSV feed or is this only available with a paid account?
Export option in graph
Hi, 1. How to give a export option in embedded graph (Public view without access). 2. How to create a graph based on conditional formatting data. for example to want to show only current quarters report . Date should be in X axis. Kindly assist me in this problem. Thanks Satya NHM
Import from zoho creator into zoho reports
I am having difficulty importing from zoho creator into zoho reports. Normally I would just copy the permalink, with publish enabled, and paste that link into the Data Location, selecting Web. For some reason this has stopped working, it only imports, a single cell with the entire document in it, rather then splitting it up, and displaying the rows normally. I have tried changing the view from List to Spreadsheet, and I have also tried to create a custom url, for CSV, but it's just not importing.
Reach support portal and reports from the same view?
Hello, We are trying to create a portal for customers. They should have the Support Portal and also be able to reach a database in "Zoho Reports". Is there any page for this? Where they can choose their apps? They should only be "Customer" in the support. Kind Regards, Marcus
how to make Bullet graph?
hi need to use Bullet graph how to make it?
new zoho reports interface data feed not working
Your new Zoho Reports interface is not working for me: please review this feed: https://creatorexport.zoho.com/lifengwu/2015client2/csv/Copy_of_BUFEED/NSsjOdkwa8S9JExGwayRbRbhuWsrtvs0WAbGHmCtAma12E93jFTHuKGXDfAyyksq1T2C8mDhMqdxTM5N1uO7awM8nZmEkX2hhzw3 When I fetch it from within Zoho Reports, I got all columns crammed into one column:
Zoho Reports - New feature rolled out on Dec 10, 2014
Advanced Analytics Add-on for ServiceDesk Plus Zoho Reports now provides an advanced analytics add-on for ManageEngine ServiceDesk Plus. With this add-on, SDP customers can create fine-grained reports with easy drag-and-drop actions, without writing database queries. The add-on also comes pre-packed with 80+ usefull reports and dashboards. With this add-on you get simplified KPI tracking and analytics for improved decision support in IT service desk operations.
Help query
Hi, i need help , how I could do this. for example, I have this table Fecha Plano Perdida etc etc etc etc etc 01-03-2014 20 10 02-03-2014 40 60 03-03-2014 50 40 04-03-2014 10 25 05-03-2014 15 32 06-03-2014 25 18 07-03-2014 86 22 08-03-2014 12 45 09-03-2014 14 60 10-03-2014 25 21 11-03-2014 34 44 12-03-2014 22 24 13-03-2014 12 18 I need to create a new table containing the following Fecha, Proporcion where fecha between 01-03-2014 and 07-03-2014 proporcion = Plano , when fecha
Time Tracking Reporting
Hi Guys, This is probably very simple but I cannot seem to be able to report on a project and the logged hours. Can anyone point me in the right direction as I am wanting to compare projects to ascertain which projects are taking longer than others.
please unblock my block my account.
my id is blocked because of exceeding bounce mail.my id is mohan@axinosys.com. thank you
API v3.0 has a feature to add/rename/remove columns
Two questions:- 1. When will the API docs be updated to see the details of these new API endpoints? 2. Is there an API call to create a new table, so that columns can then be added to it? If not that would provide a way to automate data upload including table management. Many thanks. Best regards Keith
Calculating difference between two dates with format "dd/mm/yyyy hh24:mi:ss" in seconds
good Morning I need to calculate the difference between two dates in seconds. Has "Zoho Report" some way to do this?
Time wrong in export report to pdf
Hi, When exporting a report to PDF the time mark on top is wrong date OK My properties are set to Europe Athene -2 GMT The reports shows 16:07 and it must be 09:14 Thanks
Auto Delete Rows in Table
Has anyone found a way to auto delete rows in a table from a schedule? Due to the nature of our imports its best to clear all data from the table and completely refresh it with a new import. Looking to schedule this vs manually opening each table and deleting all rows.
Manipulating Drill Down
Hi, I was wondering how one might be able to change the drill down options for the user when you create a new report. For example let's say we have a bar chart with dates (no time incl.) on the x axis and units sold on the y axis. How do we go about doing the following: If user presses any bar and selects the drill down option, the user will be shown a bar chart with time (grouped by hour) on the x axis and units sold on the y axis for the particular date selected. And if the user again selects any
Import Data to Google Sheets from Zoho Reports
Is there a way data can be imported from Zoho Reports to Google Sheets
3rd party cookie
I embed reports in a webpage using iframes. A client of mine has made changes to the security settings on their system to block third party cookies which is causing problems for viewing reports - The reports won't load. IS there anyway to get around this from your end? My client is reluctant to make the required changes to their settings (an over-cautious IT dept). Regards Jjoe
First Zoholics conference for Zoho Reports users
Hello Everyone, Save the dates for the first Zoholics conference for Zoho Reports users. This year's first Zoholics conference is to be held from February 25-26, 2015 at Pleasanton, CA, USA. This is an exclusive event for Zoho Reports (and Zoho Creator) customers, partners and developers to come together and share their experiences. Come join us for the event and get a chance to meet the users and experts from our user community, and the Zoho Reports team. We also have dedicated one-on-one sessions
Zoho Reports 3.0 is Here
Zoho Reports 3.0 has been released. More details about the release here - https://www.zoho.com/reports/blog/zoho-reports-3.html
Next Page