Error in a Custom Formula Column
I have an error in a custom formula column. I have a VERY simple formula in a custom column. Here is the formula: "Column Name"* .15 All I am tryting to accomplish is to multiply in order to get a % of another column. But it only works on some of the entries like in the image below: You can see that for some of the rows are blank and for no apparent reason. I was told when I contacted support about the issue that all I have to do is add a ZERO before the decimal in the formula. So I did that.
Query table with multi line field
Very pleased with ZOHO. However I cannot get this query to work. SELECT "Email", "Name", "Interests", "Classes Attended Title" FROM "Group Table" WHERE "Title" = 'Teacher'AND "Interests" = 'Icing' Title is Plain Text field, Interests is a Multi-Line field. Please help a 75 year old database newbie
Average of an average!
I have created a simple logging application, where I log the number of successful events and the time taken. In a form field I store the number of events (Number) In a form field I store the time in hours (Decimal) In a calculated Form field I store Events / Hour – giving the Events per hour for each record In a Pivot report I then sum all of the records (Filtered list), it all works well except calculating the total events per hour for the report. Am I able to calculate the total average? (Sum
Add filter to toolbar in static link!
It would be awesome to see a Filter option added to the static link toolbar. That way, I have a whole pile of information ready for multiple users (teachers) to view, and they can differentiate the data according to their own classes.
IF Statement
I'm creating a column with a formula field and am able to do the following: if("column 1"='abc', 'Correct', "Not Correct"). In column 1 I have cells that contain the following: abc abc 76 xyz qrs I'd like to be able to write a formula that does the following: If column 1 contains abc, then return 'correct' or if column 1 contains xyz then return 'maybe correct' or if column 1 contains qrs then return 'not correct'. Basically I need the formula to A. search for text rather than an exact match B allow
Custom range in x-axe
I'm setting up a graph to view age distribution for a number of registered persons. I would like x-axes to be age grouped by 5 years. (15-19 years, 20-24 years, 25-29 etc) Is this possible?
Percent Line Chart
Hi, I need to create a line chart of percentage. On my table there is four columns: Month, Territory , Total Contacts, Total Sales My objective is to make a line chart by month (X axis) with percentage of sucess on contacts (Y axis is [Total Sales] / [Total Contacts] ). This same chart have to show a Territory Filter, and the user will be able to view the perfomance by territory. How Can I do this, without create one view for each territory ? regards, Delio Tomaz
Stacked Bar Graph not displaying correctly
When I choose a stacked bar graph the data is not displayed correctly. Have I selected something that is causing this issue, or is it a bug in the reports application? Its almost as if the data was inverted for some reason. Jason Rapp
Zoho Reports - New features rolled out in December 05, 2011 update
Export/Email Dashboard as PDF file Zoho Reports now has the ability to export and email dashboards as PDF. To export or email a dashboard as a PDF file, follow the below steps: Open the required dashboard and select the Export option from the toolbar. Select one of the following options: Export as PDF - To export the dashboard in Portable Document Format (PDF). Email as PDF - To email the dashboard as an attachment (PDF) to the email address specified. Provide the required Format options and click
Share View To User | Filter Criteria | So What Am I Doing Wrong?
In ZOHO Reports from I am selecting a Query Table named "Master Commission Report". I then select "Share View To User" and enter the following in the "Filter Criteria" field: "MASTER COMMISSION REPORT"."Agent" = 'travelstore' I then click on "Preview" and the filter criteria works fine by displaying only the information pertaining to "Agent" = 'travelstore'. Now the problem appears when I send the "link" to the "Shared User". The link is not appling the "Filter Criteria". The link is simply
Schedule CSV files updates from behind a firewall ( https)
I'm trying to import a CSV file and schedule periodic updates, but are not able to import the CSV file from behind my firewall (which off course makes sence as reports.zoho.com is on the outside). It is not possible, from a company intelligence perspective, to share the CSV files in the public domain. How can this be solved? Regards
Pie Chart Can't display totals? (Only percent shown...)
Is there any way for a pie chart to display the totals within the category, as opposed to the percent of total?
URGENT! Zoho Report cuts a digit from a number
I'm repeating the problem here, sorry. ===================== Dear Zoho Reports Team, We've just found a big problem: 1. We have a query which is created as SELECTs from many other queries and tables. 2. It has the first column 'code' which has Positive number format There are, for example, two codes: 1242357 1242359 3. I have another query over this query, where i do: SELECT concat('810',code) as "code" where 'code' is the column 'code' from the first query. 4. In the second query i get CUT version
More than 5 Columns in CRM Reports
Hi I'm having a problem when adding more than 5 columns when creating a Zoho report? The thing that happens is that site goes blank, and stops loading. So I wanted to know if I'm doing anything wrong?
CRM Reports
Is it possible to change/customize the x, y axis within a report?
Iframe code using parameter creteria
Hi, I can not find the write code to embed my selection criteria report on a google site. Can someone compose this code. global database. Link works in browser. You see all the data https://reports.zoho.com/ZDBDataSheetView.cc?OBJID=71310000000763410&STANDALONE=true&privatelink=7571234dbcfd66a81611a1425e2873ea&ZDB_THEME_NAME=blue&DATATYPESYMBOL=false&REMTOOLBAR=false&SEARCHBOX=false This I want in a iframe Link works in browser and selection on Royal cl Chien pol Tournai column --> Wedstrijd clubnaam
Query Error Message When Using "Order By" Clause
Everything works fine with the Query until I put in the "Order By" clause. I receive the following Error Detail: "Kindly ensure that the table name you have specified is in the query scope.". ======= 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 "Travel Date" ======= So, what am I doing wrong??? Any
How to write the BBCode to embedd a Zoho spreadsheet in phpbb
Does anyoone know how to embed a Zoho spreadshet into a phpbb post? What is the BBCode that needs to be included in the post?
How Do I Update a Tabular View base on Query table ?
Hi, I have one Tabular View based on Query Table. I have changed the Query Table, adding columns, but this changing was not applied onm Tabular View. I Have already tried to find the columns on Hide / Show Columns but it no appear. How Can I do it ? Regards, Delio Tomaz
Zoho Reports: Fetch data from Zoho Sheet
Hello, I would like to use Zoho Reports to fetch data from an online spreadsheet. Currently I see Zoho Reports does support Google Docs Spreasheets. Ironically I cannot find out how to insert a Zoho Sheet range into a Zoho Report table. Why does Zoho play nice with Google Docs but not with it's own apps? Am I missing something? Thanks in advance, LG
Printing Filter Criteria on Reports
I've set up several reports that allow the user to select a date range. My issue is that when the report is exported to PDF there is no way to show the date range selected in the report. Can filters be included in the report export?
Create a chart from a Pivot Table
It it possible to create a chart from a pivot table. I am trying to chart the percentage of records by date and status. This is easy in pivot tables. I have 3 different statuses represented by percentage of total for records of each day. I can not figure out how to do this with charts. Being that i have it in a pivot table can I somehow create a chart of that? Thanks
Upload Tool - Problem
Hi, I am trying to upload some data to my Zoho Database, but when I execute upload tool, some columns has strange values (net.sourceforge.jtds.jdbc.ClobImpl@e61a35). When I execute the query direct on SQL, every run OK. I found the temp file generated by Zoho on \temp Folder. The same problem occurs, so, this issue is on the query that Upload Tool did on my SQL; Atached a printscreen.
Zoho reports api for creat a new database or a new table
Hello,I want to know do you have the Zoho reports api for creat a new database or a new table with java?
Deduplicate Records
I have a mySQL table that will have duplicate records show up occasionally. Is there an easy way to merge these records according to a specific criteria (some duplicates are actually desired in certain columns but not in others) so a chart report won't show the duplicates? Thanks!
Exclude Statement for Query
I have a database that contains data by session: Fall I 2010 Fall II 2010 Spring I 2010 Spring II 2011 Summer 2011 Fall I 2011 I have no trouble writing a query in order to collect all of the data by session and then of course grouping it by say website or market and I even know how to write a query to create a formula such as "clicks/impressions" = CTR. It's all great. EXCEPT....I want to be able to group the first five listed above to give myself totals and to give myself an accurate CTR. I
My Accounts Report
Can I make a report that only shows my accounts and not all of the users' accounts?
Identifying dependent objects
Hi, I tired to delete a table in Z Reports and I received a caution saying that one or more dependent views exist for this table. However, there is no option to list the child views so I can delete the the dependent objects to ensure there are no orphan objects in my repository. Is there way to find out or list the dependency/parent-child object relationships from base tables to queries to reports and views? It would be useful for data lineage as well. Cheers Sunil
URGENT: restore back up (Why support is not answering?)
Hello, on October 16 I have contacted support to get my back up restored. Unfortunately I did not yet get any response. Could you please restore my back up for the following dB only: ApplicantReport 16-Oct-2011.zip Moreover, is there a procedure for user to restore the DB from a back up? As you can immagine these problems can be quite urgent for a user running his business on Zoho!!! Thanks, F
Restore Zoho Reports database backup
How to restore Zoho Reports databse backup from one account to another
Pivot table metric functions not mirrored in charts
Hi, I noticed in the pivot table report, there are a plethora of functions such as % of total, % difference and so on that is available for reporting. However, the very same metric functions are not available in charts. I have attached a screenshot of a pivot table showing % of region sales out of total sales. It would be great to use graph, other than PIE charts, visualize the breakdown. For instance stacked bar graphs. The use of % functions or even sales by a dimension such as region over total
User Filters: embed in website
Hello, when I publish a chart report in our intranet don't show the user filters. How can I do to show it? We would use the multi select box in our intranet. Thank you
Averages
I have data in my table that is by date. I've got Seven columns: Day Absolute Month Brand Campaign Ad Group Clicks Impressions The formula for calculating "click through rate" is "clicks / impressions". No problem to add in a formula column to do that by date. However, what I'm really wanting to do is this: 1. I want to provide ascending user filters - Day (or I'm okay even with Month), Brand, Campaign, Ad Group 2. I want the user to be able to see clicks by date range 3. I want the user to
Cross-referencing two data tables
I hav two sheets that I am going to want to cross-reference (hopefully by using an SQL chart)... Sheet 1: Already, I have a sheet that I built with User ID #s and some resulting scores data. Sheet 2: I have a .csv coming from an outside provider that will have matching User ID #s in a column, but the data categories are different. I watched the video on how I can use the SQL interface to make a display sheet, but I want to cross-reference the two sheets I mentioned above (Sheet 1 & 2) so that I can
Nested SELECTs aren't supported. Query over Query aren't allowed more then 3 times. What shall we do?
Dear Zoho Reports Team, Thank you for the great product! Unfortunately, your SQL dialect lacks one of the most important things: nested SELECTs. When i realized that i was disappointed. Then i found a workaround: make a SELECT and save it as query table, then make a new query table and select from the first query table. Everything was going correct until i got an error: "The above query cannot be saved, a maximum of 3 levels of Query over Query tables only allowed." That's a pity. That's frustrating.
User Filter Glitch
I am developing a chart where I need the user to be able to filter by month. No problem, I've added that filter, BUT unfortunately when the user selects "All" the filter only grabs the data that is similar in each month, rather than pulling all of the data than filtering. For example. I have my chart build to show impressions by keyword. Then I have user filter's placed for Brand, Campaign, Ad Group, Impressions (Top 5, Top 10, Top 25). This works great when only one month is pulled at a time
Table and Query tables usage and performance
Hi, First off Zoho Reports (and Zoho in general) is great concept and has quite rich features. I can think of number of improvements that can be added to make it more competitive to some of the other cloud services available which I will propose over time. My background is in business intelligence, data warehousing, data integration and data quality automation. In such I have worked on a number of tier 1 and tier 2 tools but I see a big gap in SMEs adopting these tools due to cost - and more over
Disable automatic X-Axis sorting on graph
Hi, I created a simple area chart using the name of months along the X-axis and the min, max and average sales figures along the Y-axis. I entered the data in the underlying table as so: Month Min Max Average Aug 10 20 15 Sep 8 15 11 and so on..... Jul 22 27 24 I would like the graph to maintain the order of the month entered. Unfortunately the graph seems to apply a default sort on the X-axis where I get the
Percent Change
I know, I have a lot of questions! I'm learning SQL as I go here and I've kinda hit my learning limit!. I have a table: Brand Keyword Rank (number) Rank Type (three types) Month I want to be able to calculate Month over Month percent change in rank. How do I do that? Thanks in advance. Jamie
Charts
Essentially what I'd like to do is create one chart that then allows the user to specify the y-axis without having to put all the fileds in the y-axis for myself and then requiring them to check and uncheck the legend filters. Ideally I'd like to let the user do the following: 9 columns" Date Absolute Month Brand Campaign Ad Group Keyword Clicks (number) Impressions (number) Click through Rate (percent) I want to create one chart, then allow the user to select from three different numbers to display
Next Page