Formatting Time Elapsed
How can I format time elapsed (ex. 00:02:34) without date information and without converting to text? It won't accept [hh]:mm:ss. Thanks.
Can we customize logo?
can we customize logo in the zoho reports software??
Export and import options disabled
I just joined zoho community and would like to export IPL table for processing in R. But the export option is disabled. I have a free account, is that the problem?
Name of Chart indicators change depending on the function used
Hi, I have an issue with the charts that I hope somebody can help me with. Whenever I use SUM in creating a bar chart with my indicators, I get the word TOTAL added to the beginning of my indicators which changes the meaning altogether. Is there a way to remove or disable this? Thank you!
Using Bar Charts: Selecting SUM adds the word "Total" to the beginning of an indicator
This happens whenever I use bar charts and there doesn't appear to be a way to remove this if I use bar charts and SUM. This changes the meaning of the indicator completely and we'd like to know if there's a way to remove it. Thanks!
Source table of a report
Hi Zoho Reports forum, I'd like to know if there is a way to know which table(s) is (are) used by a report. Is it possible ? Thanks ! Cimballi
Calculated fields: Initial Data or Let ZOHO do it?
Hello Guys, I'm new to report writing and I'm looking for some advice on where the responsibility lay for calculating data. Should calculated fields be handled by the initial app/database server pre-import, or by ZOHO from the raw data once imported? Let's use a simple example. I have two tables, related to one another. Customers and orders, each order has a customer, each customer could have many orders. Say I want a field that gives me a count of the number of orders each customer has, and others
Column formula for "greater than" and "less than"...
Question: "Is this the correct formula for the example below?" The reason I ask is when I try to place it into the "Add Custom Formula" screen, this error message appears "Specified formula is invalid". =IF("Total Commission"<=10,"Total Commission", IF("Total Commission">10,"Total Commission"*0.80)) Total Commission Agent Commission ---------------------------------------------------------------------- 1 $3.00 $3.00
Microsoft Access upload to Zoho Reports
I've been attempting to configure the upload tool to import some MS Access tables into Zoho Reports. However, when I click on the "UploadFromDB.bat" file, it immediately quits. No log file is created. I've gone through the wiki article on how to set it up but am having no luck. Does anybody have an example of the configuration file setups? This really shouldn't be that hard. Thanks in advance.
Java: command not found when running uploadfromdb.sh for reports
Hi, I'm trying to execute the shell script to upload my database to Zoho, but I'm running into this error when I run it: /ZohoReports/UploadTool/bin/UploadFromDB.sh: line 17: java: command not found Any ideas? Thanks, -James
Zoho Report Number of Rows Shown (wasted "screen estate" )
Hi When Viewing a report Zoho only shows a 16 or so rows and at least a Quarter of my screen is being unused wasted "screen estate" Just makes it hard to look at a report with many rows and yes i end up having to scroll (does zoho own shares in a scrolling company ??) Any way to make reports more view efficient and friendly Thanks
Bar graph
I have a chart and one bar has a total of 300. When I create the graph the total goes on increments of 20 which is great so the chart is not so big. But when I go to view the graph within the application it goes in increments of 2 and then makes the graph to big to view. Now i have to scroll down so much. How can I keep it at the amount of increments I choose. Thank you.
Change the default range?
Is there anyway to change the default range? When I select a column, like "Cost", I can show the range, but it automatically chooses the range. I know that I can filter by range, but I want to know if I can change the default values?
Downloaded excel file report - dates not working
When I export a report the date fields aren't working (see attached file). Only a handful of the dates are recognised by excel as dates, the rest are recognised as text. No matter what I try in excel I can't get the Zoho date fields to show as dates. This stops sorting ability as well as creating charts and formulas. This only happens with Zoho reports that are extracted. It's made even worse in that only "half the fields" have this problem. See the attachment. Really need a fix!
Querying for a date range
Hi, I did the following query table SELECT "Email", "First Name", "Added Time" FROM "GGIT Applicants" where "Added Time" between '07 Apr 2012 00:00:00' and '15 Apr 2012 11:59:59' and it is returning results that include March. Please help! I have attached the returned results. Note there are many more records in the database but it only seems to get confused with March. Thanks for the help!
Unable to refresh pivot report
I am unable to refresh several pivot reports. The request is timing out. I know the reports are quite large but I don't know how to improve performance in order to see updated information in my reports.
Calculated fields:Initial data import, or let ZOHO do the work?
Hello Guys, I'm new to writing reports, and I'm looking for some advice on where the responsibility lay for generating calculated fields. Whether it should be done by the app/database server pre-import or by ZOHO once the raw data has been imported. Let's look at a simple example. I have two tables, Customers and Orders, each order is assigned a customer, each customer may have many orders. Say I want to know how many orders each customer has placed, or that customers total spend, or their average
Error when creating report for related table.
Hello All, I've got a couple of tables that are related by a lookup column: Orders: OrderNumber Value Deliveries: OrderNumber DeliveredDate I'm trying to generate a report that gives me a count of deliveries and a sum of their value for a given month of delivery dates. i.e. Deliveries in January: 5, totaling £12,000 However, whenever I try and do this I get the following error: Sorry, you cannot have numeric column(s) ('Column,Column4'), from the parent table ('Untitled-1')", when text/date columns
Upload Utility - Import Type = Add. replace if already exists
I am using the Upload Utility to try to upload data. I have successfully uploaded several CSV files using the import type of "Delete Existing and Add" and "Add at the end", But when I try to upload a CSV file using the "Add, replace if already exists" import type, it seems like the upload is getting hung up. The status on the bottom of the GUI interface says "Logged in Successfully, Uploading data", but it has been stuck on that for several hours. I have entered the name of a single column in
Problem With a Bar Chart
Hi, I am new to ZOHO, so please help me out in this one I have 5 columns for which I have to create a bar Chart just like in excel. They dont have a year column but still i can create a chart in excel using the same data but here in ZOHO the bar chart icon is grayed out, can somebody help me in this one?
Ability to pass Fields to ZOHO Reports via URL
Is it possible to pass fields via url which will be added to the report dynamically, i.e. http://zoho..../Column=[NEW_COLUMN from database]
Generating random keys for reports in client site
Hi, i wonder if you can help me, i have a site where i have different customers, i generate with zoho reports, reports so they can see their status, when i generate a reports with random key and embed in my site it´s ok, but the url stays static, is there anyway i can make a code to geturl from zoho reports to put in my website and my website update the links with new key, so i can generate random keys everyweek?
User filter by column
I Have a table that is a golf score card. Each column is a different hole. I am looking to do a pie chart that shows the percentages of strokes you have taken on that hole. This works great for one hole. The issue is that I don't want 18 of these pie charts in my dashboard, I would like it so that there is one pie chart that you can choose what hole to get your stats on. Is there a way that I could set a user filter to switch between holes/column's?
Urgent ! Attention Required "Query Issues"
Hi I have two tables Testing101 and testing102 . testing101 has to columns A and B while testing102 has two columns A-1 and B-1, each has got two rows Now I want to sum up Columns A from testing101 and column A-1 from testing102, how can I do that? I am a novice and new to zoho, help me out ASAP !
QUERY issues
hi, i am using the sum query and using it to sum different columns from two tables but it is returning double the value than expected. can u plz urgently explain me why is it happening here's the query: SELECT SUM("A")+ SUM ("A-1") FROM "Testing101" ,"Testing102"
Combine values from multiple columns.
I am not sure about the best way to go about this so let me explain what it is that I am trying to do. I have essentially a golf score card with each hole as a column and each player score in the row's. I would like to create a pie chart that shows their percentage of 1' 2' 3' 4' and so on. I can easily do this for one hole by creating a pie chart. How could I do this for a whole game 18 holes not just the one? I was looking to do an aggregate formula and try to combine all columns but I am unable
User filtered dashboard
Is there a way to apply a user filter to a whole dashboard? I have a dashboard with 4 charts on it. I want all charts to be user filtered by the same criteria. I don't like the idea of making the user select a filter for each chart. Is this possible?
Desparate help please - reporter and creator
Dear Zoho Creator and Reporter Teams, Many thanks for your help – your apps have huge potential. I have a number of problems with using your programmes. I am attempting to use Zoho Creator/Reports to run a live audit tool, which will real-time produce reports regarding the data stored - this is potentially to be implemented into large business scale. In Zoho creator I have encountered the following problems: CHECKBOX DATA CANNOT BE PRESENTED IN A GRAPH. This needs to be fixed. It should
Strategies for transferring a Zoho Reports database to a customer
Hello, We are in the process of devloping a Zoho Reports database with al dashboards and import tables that go with that, and after implmentation we would like to transfer full ownership and admin to one or more persons within the customer organization. What would be the best strategy for transferring admin ownership of the database, including sharing of import tables, dashboards etc.? How would we best work with sharing/making public, and the necessary Zoho accounts that our customer will need?
Drilling down into details from Charts
Let me illustrate with an example of the situation that I am hoping to solve. The DB in question is Super Store Sales. Let us say that I have a bar chart which shows me the data for the SUM(Sales),SUM(COST) [Y - Axis] against Date in terms of quarters [X - Axis] with User Filters for Product Category and Product. Image shown below: Now if I click on any of the bars I will be displayed the underlying data for the selected parameters corresponding to the bar. But what I want is to be able to do is
Combining data from two colums into one column...
In ZOHO Reports, is it possible to combine data from two columns "Last Name" and "First Name" into a third column "Passenger" using the "Custom Formula Feature"? EXAMPLE: ----------------------------------------------------------------------------------------- Last Name First Name Passenger ----------------------------------------------------------------------------------------- SMITH JOHN JOHN
String into Numeric Argument
Collaboration Forum, Need some help! How do i convert a string into a numeric calculation so i can avg, sum, count etc... in edit Aggregate Formulas(Zoho Reports)? String is: Cradle to Grave (mm:ss) Desired outcome: I want to be able to Aggregate this field in a report. Thanks Arron Blue Pumpkin Hosting www.bluepumkinhosting.com
Query Table to Split Comma-delimited values into multiple records
I have a table that stores Labels (aka "tags") in one column, comma separated for each row. Here is an example: Id, Labels, .... <- These are the column headers --------------------------------------------------------------------------- "123", "usability, subscriptions", ... "325", "usability, membership, reports", ... I would like to report on the Labels column but it's impossible to build a pie chart breaking down the Labels usage in the current format, so I went searching online for some solutions.
Adding SELECT UCASE( ) to a Query Report.
Everything works fine with the Query, however, I would like to know how to add SELECT UCASE( ) to the SELECT "Agent" and "Passenger" fields? Any help would be greatly appreciated. Thanks! ======= SELECT "Catagory", "Agent", "Passenger", "Booking Number", "Travel Date" FROM "August 2011" WHERE "Agent" = 'JOHN' UNION SELECT "Catagory", "Agent", "Passenger", "Booking Number", "Travel Date" FROM "September 2011" WHERE "Agent" = 'JOHN' ORDER BY "5" =======
Sql statement for cumulative sum.
Hello guys, how are you doing? Thanks for the time answering this. I want to make a cumulative sum using a sql statement. Can you help me telling whats the error in this formula: select t."data da operação",t."Cliente", (select sum(x."saldo inicial") + IF(x."TIPO"='SALDO INICIAL',0,if(sum(x."Quantidade")=0,sum(x."profit"),0)) as teste from "Futura Completo" x where x."DATA DA OPERAÇÃO"<= t."DATA DA OPERAÇÃO") as "Patrimônio" from "Futura Completo" t order by t."DATA DA OPERAÇÃO" ? Tks Guys Leonardo
Is truncating dollars on the Y-Axis data labels possible?
I have total dollars on my Y-axis and the numbers are extremely large. This is creating an extremely jumbled and illegible axis. Can I put the numbers on the axis in millions so people can read the report. Image is attached. Thanks!
Report that list's most recent date.
I have a table that lists "tags". Users trade these tags with one another. I check what users have what tags every so often. Not all tags are checked at the same time. I want a report that shows what user has what tag and the last time the tag was checked. I seem to be having a hard time getting a report to show me this. I am also not sure if my table is formatted correctly to do this. Idealy i would want somthing like: tag 1 - user1 - oct 5 tag 2 - user2 - oct 10 tag 3 - user5 - feb 6 Currently
Reporting on All Projects
HI, We are currently using ZOHO Projects for maintaining our projects. However, we are looking for a reporting tool that can list all the projects, tasks and milestones and the status for a specific period of time. I am wondering if that kind of reporting is possible through ZOHO reports. If yes, how do we integrate ZOHO reports with ZOHO projects? Appreciate your time Ramesh
Is possible reach tables from two differents Zoho Reports Database?
Dear Support, Can we access tables from 2 ou more different Zoho Reports DB? Sample : I've one DB called DB1 with 1 table called Tablexxx I've another DB called DB2 wiith another table called Tableyyy I'd like to reach the Tableyyy inside DB1. Is that possible? Thanks Paulo Miguel.
Applying formulas to totals in summary view?
I'm trying to run formulas on my data totals in summary view. Is there a way to do this? Or another way to calculate totals and do the same? Seems like a simple feature to not provide. Anyone analyzing large amounts of data would benefit. The last post I saw about this was over 4 years ago and the rep claimed you were working on it?
Next Page