Zoho Reports Upgrade
I've recently completed the Zoho analytic reports trial and want to keep on using them as part of my subscription. But theirs no way off adding it! All i get is this message: "You have been downgraded to Free Edition of Zoho Reports. Please upgrade to "standard" or higher edition of Zoho Reports to continue the integration." When I go to Reports, click on Analytics, there is no zoho reports option to upgrade with! Why do you make it hard to updgrade?
Query Error: Improper usage of GROUP BY clause.
When I execute a query made and stored six months ago I get the following error: "Please ensure that all the non aggregate columns used in the SELECT clause is also used in GROUP BY clause." The query is saved which is why the error most be due to changes you made in the past 6 months. Could you please help me solve this problem. My Query Table looks like this: ------------ select customer_id,timestamp(max(created_at)),firstname,lastname,company,sales_responsible_uk,sales_responsible,store_name,
Let users pick the date grouping
Hi Is it possible to let users pick the date grouping? If not, any workarounds? If a user pick a short time period we would like to group by day. If longer periods, group by week, month, etc.
Combining Field to filter
Hello I am wanting to combine some values when I create a graph. We have got a number of different stages against our opportunities eg - Follow this month, Follow this week, Lead etc. I would like to group them all together so they just show up as Open quotes. Is this possible when filtering or is there some other way it can be done? Thanks Karen
SQL Query with SUM and GROUP BY stopped working
Hi, I have the following query: SELECT "MESBRASIL", "PRODUTOMETA", "Qtd", "Valor" ,"DESCFMCOM", "MÊS", "TIPO PEDIDO", SUM ("VALOR TOTAL ITEM") FROM "Mytable2" JOIN "Meta Brasil" ON "PRODUTOMETA" = "DESCFMCOM" ON "MESBRASIL" = "MÊS" GROUP BY "MÊS" and I got the message error: Query Error: Improper usage of GROUP BY clause. Please ensure that all the non aggregate columns used in the SELECT clause is also used in GROUP BY clause. This was correct some time ago, being able to save the query table,
Changing sender in automatic emails
How can I cange the sender address in the automatic email notifications?
Creating Forecast reports
Hi I am trying to create forecast reports by type (renewal) and by quarter, I can do it by month but I want that grouped by quarter . Can you direct me accordingly. Many thanks.
Zoho Reports - New features rolled out on Dec. 4, 2013
White Label site home page with Multi-tab Dashboard/Reports viewNow Zoho Reports allows the White Label Customers to configure the home page with a multi-tab dashboard. With this your users will be able easily navigate between the views. White Label customers who wanted to configure this for their site can write to us. We will get your requirements and handle this.
Pie Chart & Unknown Value
My charts used to show the amount of fields that were unknown or blank (in underlying data). When i do a pie chart or similar the "unknown" field is highlighted at the side but there are no "unknowns" appearing on my pie chart - see attached pie chart unknowns in that chart should make up 75% of the chart. Thanks joe
Limitations?
Hi, as a subscriber of Zoho Reports (2M + 10M upgrade), I just noticed that 800.000 rows limit for query tables. Since we are going to upload a lot of data (15-25m rows), I am now unsure if Zoho Reports is the right tool for us. Can you tell me about the limitions of the tool? Is it currently possible to run reports over let's say 5 millions of rows of data, which (example) joins to another table with 5 millions of rows? Thanks four your help!
Display columns as rows
Is it possible? Example:
Zoho CRM and Zoho Reports Synchronization
Hello, I have been using Zoho reports to manage our entire business statistics. We pull in a lot of information directly from Zoho Creator, Zoho CRM, and an internal database. Currently we are also using the campaigns module directly within Zoho CRM which relates to events that we run all over the US and is used to track all events related to each campaign, as well as the contacts and leads whom attend each event. Is there any timeframe for which the campaigns module within Zoho CRM will be synchronized
puling data from one table to another for given period
I need to be able to look at a table of data and then grab data covering a 7 day period into another table where it will remain unchanged while main table continually updates every hour. Basically I want something that I can go in at the end of a week and run a query that returns rows of data that were entered or changed in that last 7 day. period. Is this possible in Zoho and how do I do it?
Customize the name of legend items
Is there anyway to customize the name of my legend items without renaming the columns upon which those items are based? http://screencast.com/t/FtUIjEdH
Zoho Reports - New features rolled out on Nov. 21, 2013
Enhancements for Table Designer Zoho Reports has enhanced the table Edit Design for a better usability. With this you will be able to perform the following operations while designing a table. Add Formula Now you can add custom formula or aggregate formula in your table from the designer. It is also supported to edit the formula from the designer. Also the Add Formula link in the new row give easy access for creating Custom Formula . Export the Table Design Now you could export the table design
Problem with Upload Tool (UploadFromDB.bat)
Dear Sir/Madam. I'm having the following error when trying to upload data from a local databas (MSAccess): I'm using the following sql query: <?xml version="1.0" encoding="UTF-8" ?> <!-- $Id$ --> <Queries> <Query dbname="BaseDatos1" tablename="AAAAAA" importtype="TRUNCATEADD" matchingcols="" selectcols="" skiptop=""> SELECT BBDDFinal.Explotacion, BBDDFinal.[Punto Operacional], BBDDFinal.SubFamilia, BBDDFinal.EAN, BBDDFinal.[Descripcion Larga], BBDDFinal.[Descripcion Corta], BBDDFinal.[Precio
Cannot view underlying data
The image below appears when I try to view underlying data on zoho reports on Firefox. What is causing this issue?
ZCRM and External Databases
Hi, We have setup CRM Analytics against Zoho CRM and also imported data from an onsite DB to a DB in Zoho Reports. From what I understand you cannot link DB's in a query so we will need to move data from one DB to another so we can link them. Could some one please confirm this is correct. Is there a way to automate this, either moving data from ZCRM DB to the Imported DB or vice versa? This link between DB's is a big limitation especially if you cannot automate moving data between DB's, I can see
importing data
I can't see anywhere t import data into this system. We would like to organise an automated (if possible) import and export to this system. Is it possible? thanks
Calculated fields not updating after data import
Hi, I have encountered an issue when using calculated columns in my table. When I import new data (delete records and replace with new data) the calculations are not updating. The only way to get the fields to refresh is to edit the formula and either add or remove a space in it. How can I get it to recalculate after the import without having to manually intervene? Thanks.
Zoho Reports - New features rolled out on Oct.30, 2013
Zoho Projects Advanced Analytics Add-on The Zoho Projects Advanced Analytics Add-on is now available in the service. With this add-on Zoho Projects users can slice & dice their projects data to analyze & track their key project metrics. Importing Data Setting up this add-on will sync data from your Zoho Projects portals into Zoho Reports. Data from the following modules will be imported and stored in Tables in Zoho Reports. Milestones Tasks Task owners Timesheet Users We plan to support synchronizing
Zoho Reports - New features rolled out on Oct.23, 2013
The following features were rollout in Zoho Reports service on Oct. 23, 2013. Support to Apply Share Filter Criteria for E-mailing Reports With this build, you will be able to apply the same filter criteria you have applied while sharing to a user for E-mailing the reports too. Support to Import More File Formats From now Zoho Reports supports importing XLSX format of Excel files from your local drive. It is also supported to import Excel files (both XLS and XLSX format) and HTML files from
Comparison of reports
Hi guys, We check our reports each Friday. Is it possible for ZOHO to compare this week's report to last week's report, and show us the changes that were implemented in the past week for the same report? Please let me know. Kind regards, Ninke
Lead Owner Problem - A simple question
Hello All, It is my first question on this help forum and it'll be a simple one i guess :) The basic idea for me was to monitor on a weekly basis the ability of my salesmen to create leads and turn them into opportunities. To do so i'm editing the Leads to Potentiel Drop out Analysis and i've changed the first variable which is lead source to Lead Owner. The output looks like this : It is the french version so "Tous" means "ALL" The problem is that Paul is not my only salesman and i only get his
Only two charts available?
AlsoHello all, Can anyone shed some light on why I only have "Scatter" and "Line" charts available in my application? I am plotting a decimal value over time. Also are normal distribution curves supported in reports? Jason Rapp
Newbie: needs help with EPOCH dates
Hi, I am extracting data from a mysql database and putting the data into a configured table on Zohoreports. All was working fine untill the company upgraded their database and now instead of a nice easy to read date format, I see an EPOCH. What do I need to do to make my report realise that the epoch is a date and can translate it? I tried just making it a date field but no joy :( Totally lost now. Any help would be appreciated
Zoho Reports for Zoho Creator users/applications
We are current zoho creator subscriber. 1) If we want more than just charts and pivot tables for reporting, is it suggested that we get a subscription of zoho reports? 2) Within our zoho reports area, is there a way all of the data is immediately available to zoho reports from our zoho creator app? Do we need to make some setting change within zoho creator for the app to share with zoho reports?
Reports on POTENTIAL, where is the "QUANTITY" field?
Report for POTENTIALS have access to all fields but QUANTITY. By this, I mean the actual QUANTITY field on the LEAD. I am in the coffee business and that field is used for number of kilograms of coffee. I am trying to create a report that summarizes the following by CLIENT (Account Name) per MONTH: AMOUNT total (Value of the sale) QUATITY total (number of KGs of coffee) COUNT (number of orders made during the period) Sample from SalesForce: Please HELP. It is a very useful report for us.
Connect to my local database and upload data to zoho report
Hi, I'm evaluating zoho Report for it apply in my organization a dashboard of information, but i want to connect my local sql server database to zoho report. I was reading that is process to do with an API, but a I dont know how to use this app. The Zoho wiki have information of this app, but I dont understand what i need configure for to begin.
how to open different underlying data tables in zoho reports from query table
we are getting data from only first view but how to get second view to get particular no detail and according to particular date can we get different pivot view for different items in table.
zoho - magento database integration guide
hi i am trying to integrate the data taken from the zoho database and post it into a magento(e commerce frame work) all that i could find is a very expensive(400$) third party plugin for doing that can any one guide me in a step by step format of doing that .
Error Code: 8509
I want to connect my local DB with zoho reports. However, upon connecting i keep getting the following error UploadFromDB. 2013/10/01 10:54:34 EAT:Error Occured in uploadData. Error Code: 8509, Error Message: The parameter authtoken does not match the accepted input pattern Kindly help
Hide a Bar in chart
Dear all. Would you be so kind to confirm me how can a manage to build a "bridge Chart" or similar like the one in this picture (using excel)? Any tip/help will be very wellcome. Thanks
Update calculated field in table after import of a new data
I have the table with custom formula field (concatentate of two strings). After import of a new rows this field stay empty. I'm looking for solution how to automatically relalculate it. How to solve it? Thank you in advance Jiri Vlcek
Top 10 % fromTOTAL
Hi, I create a pivot table with the top 10 customers with more spend but I want to create a graphic where it shows how much % of the total spend does these 10 customers represent and how much does the rest of the customers represent. Hope you can help me.
JQuery Datatables - how to delete a newly added row?
I am looking at some legacy code where the user can add new rows to a datatables grid, click submit and they are saved on the database. When they are saved they are give a primary key each. However the bug occurs BEFORE the rows are saved. The user decides to delete one of the newly added rows, but when he clicks save the rows added after the deleted row are NOT saved. So how do I fix it so that they are? My table is defined as; var oTable = $('#AjaxGrid').dataTable({ "sScrollY": 290,
Custom Report Help
made a custom report using contacts and activities. added a filter to show me events over next 7 days. report works but extra records show up, contacts with no event or past events.
Zoho Reports - New features rolled out on Sept. 20, 2013
The following new features were out on Sept. 20, 2013 in Zoho Reports service. More Advanced Summary Functions for Chart With this build, more advance summary functions have been added for Charts. They are: Moving Calculation 100% Group Moving Calculation Calculates the moving value of each data point based on the inputs you provide. The summary function selected will be taken as the basis for calculation. You can perform sum, average, minimum and maximum calculation using this. This will be useful
Chart colors of bar graphs keep resetting from custom colours
It's happened the last two days. The bar graphs in the charts that we have configured have reset twice over the last two days. We already spent a lot of time configuring them back to color codes we wanted, but after they reset again in the last 24 hours, I'm curious if this will continue. Is anyone else seeing this?
Error - Charts not loading
We are getting the following error when we attempt to view any of the charts in any of our databases "Sorry, an unexpected error occurred when performing this operation. The error has been logged and will be looked into. It would be of great help if you could provide us with additional information using the ''Feedback'' link at the top of this page." Are there adjustments we need to make on our end? We need to this resolved as soon as possible as we have these charts embedded on our site to clients
Next Page