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
ZOHO_CRITERIA STOPPED WORKING ON DASHBOARDS
Hi, The link below was working perfectly until some hours ago, when it started to show the following message: The view cannot be displayed since the associated criteria is not valid https://reports.zoho.com/ZDBDataSheetView.cc?OBJID=272046000000797758&STANDALONE=true&privatelink=697a90cebec169368d0aa6ad2b9672e9&WIDTH=400&HEIGHT=300&ZDB_THEME_NAME=blue&ZOHO_CRITERIA=(COORDENADOR='REGIS ARTUR DE CASTRO AMARAL' OR SUPERVISOR='REGIS ARTUR DE CASTRO AMARAL' OR PROMOTOR='REGIS ARTUR DE CASTRO AMARAL')
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
Zoho Reports
Hi How to get Click Rate or List Growth data from MailChimp into Zoho Reports Thanks
Scorecard
Hi all, I want to create a dashboard, that includes several metrics and then compare the average value of those metrics against predefined targets. Im not so much interested in having charts in the scorecard, want i want is to structure a set of metrics around our strategic objectives, and then compare the actual values against the target. It is possible to do this with Zoho Reports? Thanks, Juan
Zoho .pdf Reports - very wide and the text too small to read..... Help????
Been going on the past couple of days....can anyone help??
Adding Javascript to Dashboards
I have hit a brick wall and I seem to need Javascript, but can't see how I can get it to work. I want to try and overcome the limitation of the dashboard feature that you can't filter all reports in a dashboard from a single filter option. I need this function. I looked at adding a form on my HTML page which adds in the appropriate CRITERIA code into a URL like so ... &ZOHO_CRITERIA="YearMonth"='201005' But this won't work as the Dashboard is inside an IFRAME. I realised I could add my form into
Linked Dashboards
I want to create a multi level dashboard for my users. Right now I can create a kind of two level dashboard - as optionally - its possible to go from a chart to its underlying data. But lets say I had a pie chart which shows the sales by all regions. I want to be able to click on any region (say Europe) and go to a new dashboard which has the right data. What I need is the ability to apply a link to the pie chart pieces to make it work.
Amount convertion between Invoice and Zoho Reports
Hi, I imported invoice details report from Zoho invoice to Zoho reports (*.csv). I have an issue on invoice amount which one is not well converted by Zoho Report. Exemple ( 2 500,52 becomes 2.50052). Thanks,
Publish URL Permalink for this view
For some reason when I'm publishing a URL / Permalink for this view, it no longer gives me the option to allow for link access without login. And now, my charts are no longer showing up in my dashboard created where it calls the individual charts through a www frame. Can you help me? Thanks, Jamie
MuliCurrency Reports
Can we produce multicurrency reports in ZOHO. If yes please exlain how? Thanks
Importing Multiple Views Into a PDF
Is there a way to reorder the list of reports in the importing field? Kathy
User Filters
I have created a chart that shows the TOP FIVE KEYWORDS for a SEM campaign by click. No problem to do this, and the chart looks great. However, other fields in the database include "Campaign" and "Ad Group" and I would like to allow the user to select the "campaign" and "ad group" to see the TOP FIVE KEYWORDS by each combination. My problem is that ZOHO first generates the report of the TOP FIVE KEYWORDS for the entire account and then the user can only filter THAT data. Rather than the user filter
Zoho Reports-New features rolled out in September 15, 2011 update
New Feature: Conditional Formatting Newly added Conditional formatting feature allows you to highlight cells of a column with different background color and font color to make them easily identifiable and unique. In conditional formatting, you have to specify the required conditions/criteria for formatting. When data in a cell meets the condition, Zoho Reports applies the corresponding formatting style that you have specified. To apply conditional formatting: Select the column (by clicking the header)
Novice struggling with Inner Join in Zoho
This sql is working in Access, but not in my Zoho Reports environment that is a mirror image. SELECT Questions.Q_ID, Questions.Question, Schools.Fullname, Answers.Survey_Year, Answers.Response FROM Schools INNER JOIN (Questions INNER JOIN Answers ON Questions.Q_ID = Answers.Q_ID) ON Schools.School_ID = Answers.School_ID Any suggestions?
Export Chart as Image without ToolBar
Hi, I want to display my chart embedded on my WebSite and give possibility to export it as Image, however I only get it if I set Display Toolbar = True on publish options. The problem is: When Toolbar is visible the user can change chart type. I don't want this. I know that exists the option to publish as an image, but If I do this, I lose interactivity on chart. How Can I do it ?
Reports causing mass duplication
I am simply trying to run a query on our existing accounts with the following columns: Account Name Status Account Size Support Level DSM Status Account Person When I generate this report it's taking my 1101 clients and saying there are 1950 clients. When I look at the report, a bunch of the clients are listed more than one time (sometimes up to 6). What am I doing wrong that's generating all these duplicates? I went into the accounts section and none of these accounts are listed twice.
Dashboard
Hi I want to create DashBoard when user clicks on Day (it should display day's sale) , if month (it should display data of that month) , if year then it should display of that year. Thanks
Zoho integration module with openbravo
Hi, i'm tring to tesk the ZOHO integration module for Openbravo and after following the directions suggested by the openbravo people an error appears: La acción de guardado falló. No registration for name OBUZOHO_Config This appears into the openbravo Integration module. Does this sounds familiar to an known error to the zoho people or is it an openbravo Error, Regards
Free Account's
Although signing up for a free account to see what the database contains it has given me 15 days of the full database. I would rather start with the basic free package to see what I can do before moving up the ladder HOW CAN I CHANGE IT TO THE FREE FOREVER I dont want to trial parts of the database that i would loose in 15 days Any help Please
username account inactivated mistakely
sir this is a request to unblock "lpu10800622" user account as i inactivated it today mistakenly....i needed this account to give tests uploaded by my college for placements..please release it today...itz an urgent but humble request...plz plz...
Can we unshare a databse which we shared previously?
Hi I have created a database in zoho reports. I share this database with another user . now i want to unshare this database , and I want to know how can I do this.
Using PHP curl for Reports API
Hi ! I tried to use php code to connect to Reports API, but I'm getting a 505 error Array ( [headers] => Array ( [Date] => Sat, 26 Feb 2011 13:02:00 GMT [Server] => - [Connection] => close ) [body] => [info] => Array ( [url] => http://reportsapi.zoho.com/api/****/****?ZOHO_ACTION=EXPORT&ZOHO_OUTPUT_FORMAT=JSON&ZOHO_ERROR_FORMAT=XML&ZOHO_API_KEY=mykey&ticket=tiketvalue&ZOHO_API_VERSION=1.0&ZOHO_SQLQUERY=Some+sql+query [http_code] => 505 [header_size] => 110 [request_size] => 1574 [filetime] => -1
column data formats
I want to create a column that will contain a phone number in a format like this: (406) 656-3311 is there any way to enforce this format on data entered into the column? Also, Can I limit the amount of characters allowed in a column entry somehow?
simple text database with multiple identifying flags or similar?
Hello (ed. this is a bit long, sorry, and I might be wrong with my database terminology) I'm looking to build what I think will be a simple data base, but then again, I'm not a coder, and have not really done anything like this before. I'm an architect. I'm looking to build a very straight forward spec writing tool for small (but often complicated) building projects. I'm pretty sure this zoho will allow me to create multiple records with multiple fields, say a clause number, a title and some body
Nothing Showing up
Howdy, I imported all of my data for a week's worth of reporting and it all imported into campaign performance, however none of the charts are showing anything. Do I have to specify that I want these days and not a MONTH period, if so how do I do that. Cheers ANdrew
Zoho reports PHP seems to no longer work
Hey gang, any help would be appreciated. Background: Built a site sometime ago where I ported over what I believe was the Zoho reports php api library code. In particular, I think there was one that did the POST. I have not touched this code in ages, and recently it seems to be broke. Offending code: $params = array('http' => array( 'method' => 'POST', 'content' => $data )); if ($optional_headers !== null) { $params['http']['header']
New in Zoho API Reports
Hi I'm new in this. I do not understand where I should put this: <URI>?ZOHO_ACTION=[IMPORT/EXPORT...]&ZOHO_OUTPUT_FORMAT=[XML/JSON/PDF/...] &ZOHO_ERROR_FORMAT=[XML/JSON]&ZOHO_API_KEY=<your key>&ticket=<your ticket> &ZOHO_API_VERSION=1.0 if my form is in php, I know what I should change the code, but maybe I am putting in place incorecto that is not working. I've seen the example of the help but still I have doubts. Someone could help me with an example of a single record in a field with php and
Query Table Deactivated
When trying to use a query table I am seeing the following error: This query table is deactivated and cannot be saved or refreshed. Kindly Upgrade your plan to create and use more query tables This is in a database that had been downgraded to a free account and all previous tables etc deleted. However, it appears that the references to the old query tables are still persisting. Any help would be appreciated. Regards, Adrian.
Can I synchronize Zoho Reports folders with another site?
I would like to create a website on which their were embedded Zoho reports. I want to organize this reports into folders. How can I synchronize my folders with Zoho reports folders? There is an API which doing this? Thanks: miamano
Reports that ask for password input
Hello, i have made a table with a password column and then a report for that. I was wondering is there any way when i publish it, the report asks the user for the password field and displays only the row with that password? Thank you.
Is it possible include a HTML menu (button)
Dear Support, Could you inform if is possible include a HTML code that show a Dropdow Menu (eg. below printscreen1) at dashboard? I tried include the HTML code but it's showed only the text (please see printscreen2 below). thanks. Paulo Miguel. printscreen1 printscreen2
Convert Text String (Date Info) into Date Values
We have a number of reports where the data is coming from web input and is slated to be scheduled "daily" As such changing the Datatype of the field from Plain Text to Date would cause the scheduled "fetch" to remove the Date Values. Questions 1) Why can't Zoho Parse a text string (7/26/2011) into a Date DataType during the import - reason for the question is that we will probably learn that we can create a custom formula column but over the course of a 100 reports we have over 500 date fields to
Upable to connect to MYSQL DB
Following is the error I am getting connecting to MYSQL DB... Please Help... First time user 2011/04/28 15:40:19 PDT:Logging in... 2011/04/28 15:40:19 PDT:logging into https://accounts.zoho.com 2011/04/28 15:40:20 PDT:sucessfully loggedin 2011/04/28 15:40:20 PDT:Logged in successfully... 2011/04/28 15:40:20 PDT:Exception occured while establishing connection to the database server 2011/04/28 15:40:20 PDT:java.lang.RuntimeException: Exception occured while establishing connection to the database
Zoho reports
Hi Guys, I am using zoho reports to make my QA reports accessible from cloud. I would like to know is it possible to upload my csv files to upload with into my zoho reports and to create reports AUTOMATICALLY? I am exactly looking for a desktop sync API which upload files and generate reports.Thanks in advance. Bharat Junior Developer Arrowsight Inc.
Calculated date column
Hi, I have 3 columns: - Day (one or two digits) - Month (one or two digits) - Year (four digits) Can I create a calculated date column? Please note that the day and month data varies in number of digits: 1 = Jan 12 = Dec
Include the source name at the top of field list
Dear Support Is it possible include the source name at the top of field list? We've used a lot of Querys and we have difficult to identify the source of the data. Below a sample of Pivot Table, we'd like to know the name of source. Thanks. Paulo Miguel.
Limited number of records displaying on me iframe
Hello Zoho-ers, I have a question which I hope you may be able to shed light on. I have made a database with several records (about 20) however when I load the iframe on my website, I can only see 9 entries. I cannot seem to work out how to make all the records show as they do in the report view. Any suggestions?
Next Page