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
Zoho Reports API Error Codes Reference
Hi, Is there documentation online which lists all possible error codes returned by the Zoho REPORTS API when it is being used? I did see this list for the CRM API: https://zohocrmapi.wiki.zoho.com/API-Error-Messages.html We are implementing a new reports tab in our web-app and would like to "gracefully" handle all errors returned from Zoho. Thanks, Colin Mooney Avego http://www.avego.com
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?
Chart total amounts from start to end date
I have a created a table to track bonding by month. The table tracks the date a bond is issued, when it expires, the bond type, and bond amount. I wish to create a chart which displays the total amount of active bonds by type and month. In example if a bond was issued in the amount of $10,000 on 01/01/2010 and expires on 01/01/2011, I would like for the total to be reflected each month the bond is active (01/01/2010 – 01/01/2011) rather than the date it was issued.
Pricing Plan Question - few rows but lots of users
Hi, can someone help explain the plans. My database will have few rows, maybe around 5000. However I want to share the reports with potentially hundreds of different users. Do I really need to pay for every user to view their custom report? The reports will be tailored to show only the rows relevant to that user. I don't see an affordable way of doing this. If I had the standard plan ($35/month) and then had 100 users then the cost would be an extra $800/month for these users. Am I missing something
Create Dashboard
Do we create dashboard just by dragging and dropping charts and tables? I can't seem to be able to drag and drop any of the items?
Authenticated share
Hi, I have created a chart view in Zoho Reports, now I'd like to embed it in another webapp. I don't want to be accessible to anyone having the link, but I need to do authentication to allow it to be displayed. This authentication would be managed by this other webapp. Is it possible to share but forcing authentication (for example sending credential in a HTTP POST request)? If not directly, can be done using Zoho API? Regards Asier
Set default date range on embedded report
Hi Guys I feel this should be quite easy, however when i search google i get some odd results. We have some reports that we embed in documents for viewing. What i would like to do is set a default date range for those reports. Currently it is using over two years of data which is annoying as it must be changed every time. any help would be appreciated. andy
Custom formula returning "NaN" and doc won't save. Help!
I created a simple custom formula that operates like: column1 / column2. The data in column 2 is occasionally 0 (it's click data from a PPC campaign and some days there are zero click on a particular ad) but this prevents me from saving my report because it reads as an error. Can someone please help me solve this issue? How can I tell Zoho to discard 0s when using this formula?
Uploading data from MS Access
Hi, I have issue uploading data from Microsoft Access. I searched the forum and could not find a suitable answer. The MS Access database is located at: C:\temp\OperationalDatabase.accdb. I set the configuration file database_connection_params.conf: # $Id$ DBTYPE=msaccess HOSTNAME= PORT= USERNAME=root PASSWORD= DBNAME=SalesDB MDBFILENAME=C:\temp\OperationalDatabase.accdb And I receive the following error in the logs: 2011/10/07 17:31:51 NZDT:TESTRUN :: false 2011/10/07 17:31:51 NZDT:2011-10-07 17:31:51.851
Asistance with Zoho Reports, CRM, Recruit
Hello: We are looking for a resource with experience with Zoho Reports, CRM, Recruit. Proven experience and credentials a must. Thanks, Raúl González Bleumasters Consulting . Technology . Outsourcing t us + 1 (956) 329-4535 t mx + 52 (81) 1808-1687 n 62*12*76688 www.slideshare.net/bleumasters
Advanced IF for BUDGET vs ACTUAL charting
I have the following table: DATE VALUE TYPE 01-01-2012 10 ACTUAL 01-01-2012 12 BUDGET 01-04-2012 11 BUDGET I need to calculate: BUDGET (as of 01-04-2012) = 23 (12+11) ACTUAL (as of 01-04-2012) = 21 (10+11) and chart it (see attached image) BUDGET data is already in table ACTUAL data is added daily Can you give me any idea.. should I create a new column formula? But then how do I chart the
Newbie needs help
I am trying to create my first report. I created a database and imported about 650 records. I am trying to create a report and it is telling me that it only allows 100 distinct values. My reports usually contain 300 records. How do I get around this or am I not understanding it correctly! Thanks. Also is there people on here who will create my basic database and reports like I want them for a reasonable rate? Thanks, Rena www.thepricematchreport.com
Query Table: Case sensitivity
Hi, I try to do a SQL query table where I match two strings: SELECT * form DBA, DBB, WHERE DBA.A = DBB.A The matching is case in-senstive, I'd need case sensitive matchin however. What can I do? best, Zoltan
Next Page