'Click to see the data' Tooltip works intermittently
Hi, I'm having difficulty with the 'click to see the data' tooltip not always working. From what I can tell, this happens when I'm trying to click through to a pie chart. This has occurred while using both Chrome and IE10. Can you please provide any possible solutions? Kind regards,
Stacked bar graph not pulling correct numbers
I have a stacked Bar graph that get posted information of some of our agents weekly. The issue is that its not pulling the correct number count the agent's submissions. If I manually search the data I get a higher number then what the report is finding. Here are the settings I am using for the graph. The filters are only to take out agents I am no longer using, and to select month ranges for the data to display I am not too sure what is causing this and if needed I can supply screenshots of the
Pivot Table question
How do you display the report Description?
Zoho DB Permissions
Hi all, I have a Zoho db and would like to make only certain fields editable. We have a lot of columns of important information that some of our staffers accidently edit which takes a lot of time and energy to fix. Also, does anyone know if there is a way to transfer the administrative email address. I sent an email asking for help but only got an offer to upgrade my service. Any help here would be greatly appreciated. Thank you,
Constant error message
I'm producing a report but constantly get an error message when i try to move the report to the Dahsboard. The error message doesn't tell me anything useful apart from the fact that the error is logged. Any ideas what's wrong
Creating bar graphs that compares monthly data with year to date
I am interesting in creating a bar chart that compares data from a current month, the previous month and year to date. If you put date in the colour field it gives you the option to compare different months and different years etc. But what if a want to compare two different time measurements. Like as I mentioned before, current month, previous month and year to date? Thanks
Can only export in PDF and HTML:
I think i'm selecting the appropriate options but i can only export in HTML and PDF when publishing a dashboard. Excel and CSV are missing
Cant resize dashboard widgets
Hi I've just signed up for a 14 day trial of the standard product. All going fine except that i cant find a way to resize a dashboard widget. I only have the option of expanding or contracting the widget. I've seen this article https://help.zoho.com/portal/en/community/topic/june-30-2011-update-dashboard-customization-more-sorting-options but rather than get a double arrow I get a four headed arrow that only allows me to move the widget and not resize it. Is this a restricted feature or am i missing
Google Spreadsheet refetch works, but scheduled import does not
I have a Google Spreadsheet hooked up and am able to manually update by selecting refetch. However, my scheduled imports are not successful. The table does not update and I get emails that it was unsuccessful. Is there anything I can do to to update my table through the scheduled imports successfully?
Column Width
I created a table chart with 3 columns in it but one of the columns isn't wide enough for the entire text to fit on one line. When it goes to the second line it's illegible. How can I set the column width so that all my text fits on one line?
Creating Y-o-Y percentage change pivot table
Good Afternoon, Below is a small excerpt of monthly data compiled over the past two years. Would you be able to help me with a formula which may provide me with a monthly year-over-year percentage change for each of the columns? I'm stumped. Month Run OnOff Minneapolis Minneapolis-UofM MSP Airport St. Paul St. Paul Amtrak MOA 1/1/2013 711 Off 3 1/1/2013 711 On 68 2/1/2013 711 On 76 3 7 2/1/2013 711 Off 3/1/2013 711 On 96 9 19 3/1/2013 711 Off 3 2/1/2013 712 Off 40 2 2/1/2013 712 On 3/1/2013 712
IF Statement in a SQL Query
I would like some help creating the following query if anyone is able to help. I am running into an error and not sure if it is my logic or a Zoho reports limitation. Goal: I would like to add a column in my table where if the MinDate is within 6 months of the TransactionDate then put 40, and if the MinDate is older than 6 months from the TransactionDate put 20. I currently have a query in Table2 with the MinDate Expression and then another table Tabe1 with the TranacationDate. I have already joined
Zoho Reports - New features rolled out on May 6
New Import Option for Deleting Missing Records Now Zoho Reports has added one more import option to update an existing table. This allows you to delete the removed/missing records while importing. When this option is selected, the file to be imported will be matched with the existing Zoho Reports table based on the matching columns and the following action will be executed: Existing records will be updated with the new value. New records will be appended at the end of the table. Records which
Is it possible to pull data from googledocs / zohodocs (Spreadsheets) into ZReports via API
Hi, Is it possible to pull data from googledocs / zohodocs (Spreadsheets) into ZReports via API ? Any help is great help thank you Best Regards -Deepa Govind http://homepreneur-online.com/
Query Table Join Limit
Is there a limit to the number of tables you can join together in a query table?
Add the results of aggregation formulas
Hi there, I have a table that essentially contains timesheet data. - Date - Available hours - Billable hours - Sick hours - Annual Leave Hours etc The current version of my formula calculating effective utilisation is sum("available hours")/(sum("billable hours"-sum("sick hours")-sum("annual leave hours")) But I'm getting a null result. I'm wondering if there is a way I can sum the results of aggregations. Thanks.
Require data as percentage based on a calculated column
Hi, my Base Data looks like this: SRID StoreID Availability 1 A 1 1 B 0 2 C 1 1 D 1 I want this output SR #ofStores Availability 1 3 66% 2 1 100% I have been able to work out the #ofStores as Count of SRID. But I'm unable to figure out how to calculate a percentage on a calculate field - #ofStores. I can get counts in Availability (2 for SRID 1 and 1 for SRID 2). How do
Allowing users to change date function in a chart
Hi, Is it possible to allow users to change the date function in a chart? For example, I have a sales chart where the date function is set to 'month'. I would like for my users to be able to update this to week/quarter/year/etc. to be able to see their sales broken down by different time frames. I know that when I publish to users, I can provide them with the option to filter in different ways and show different time periods, but in all cases, the data is shown monthly. Thank you for your help.
Is there a way to create a check list report within each account?
I am trying to come up with a check list for a reporting system, but currently we have about 70 accounts, and the report will need a checklist of about 100 items. I am wondering if this is a possibility through Zoho reports, rather than creating a field within each account. I do not want to create a new field because there are only so may fields one can create. Also some accounts will be needing a different checklist then others so I think it would be easier to create a checklist report and attach
Where is this demo? It surface 2 years ago. I need to see how to do historical comparison reports.
Here is the forum answer but the links are gone now. Thanks. Blake Good Day! Using Zoho Reports, it is possible to compare the data of this month with the data of the same month of previous years. Below is a demo database(Store Sales) to illustrate this, http://reports.zoho.com/ZDBDataSheetView.cc?DBID=106610000002929059 The chart "Historical Data Comparison" compares the Sales of the month Jan/Feb.../Dec for all the years. If we want to further analyze the specific products/market/... sales, then
Can I put the company name on a pipeline report in Zoho Reports?
I have a opportunity/pipeline report. Is it possible to include the Company name associated with the opportunity on the report? I believe I can get the company ID, but not the company name.
Zoho Reports - Data visualization from Zoho CRM data
Hey guys, Maybe I've missed something but am I able to access data from my zoho CRM in zoho reports so that I can generate better and more dynamic reports (via zoho reports) from my CRM data? Great products! J.
Read ZOHO reports on Talend
Hi, I would like to know how to read data from ZOHO reports using a Talend component ? Is there any connector ? Regard ajegou.
Get the Date of First Transaction
I have a table with the following data points: Date Gallons Customer Name I would like to somehow be able to automatically pull the FIRST TRANSACTION DATE of a customer. For Example: Billy's Gas Station [Customer Name] | March 25, 2013 [Date of First transaction or first entry] Doug's Truck Stop [Customer Name] | March 11, 2013 [Date of First transaction or first entry] Any idea on how to do this if I only have the data of the table up top? Thanks!
compare value to baseline
Hello, I need to produce a report that shows the evolution of regional or office sales figure compared to a national baseline. I was hoping to use filters to let the user change region or office, but I can't find a way to keep the baseline value on the same graph. Is there a way to do this? Best wishes, Eric
Display filter value on email reportes
Hi, I am using the Email Schedule to send out all my reports. i use also the different date filters. I need to find a method that in the email itself or in the description the date of the filter report will be written. if I use the option to filter "last 30 days", for the user is very difficult to see what are the chosen dates. any ideas?
Calculating visits in a month as a percentage?
First, thanks for your time. I'm sure this is possible, I just can't figure out how to configure it. I have a table that lists the visitors to our business and what day they come in. I'd like to calculate how many days they visit as a percentage of how many days they possibly could in that month (in our situation, any day Monday to Friday). I've created an aggregate formula in the base table to calculate how many possible days visitors could come in, but I can't figure out how to format any pivot
Changing Report Type
Is there a way of changing the type of report - i.e I created a pivot table but would like to see it in the Bar graph format?
Using data from different tables in one report
Hi, I have 3 tables with sales information from 3 different stores. Every table look exactly the same with the structure: 2012-01-01, Sales, KPI1, KPI2, KPI3 2012-01-02, Sales, KPI1, KPI2, KPI3 2012-01-03, Sales, KPI1, KPI2, KPI3 I want to be able to join the numbers into one report and be able to compare the numbers. Q1 Possible to add them up in one querytable or report? Q2 Possible to join them and see them in the same chart separately. thanks Henrik
Can't load log handler "java.util.logging.FileHandler
Hi, This have previously been working just fine, but recently it started acting up. Running on linux with Cron. Can you help please? Thank you in advance. mv: overwrite 'logs/tool_old.log'? y mv: can't rename 'logs/tool0.log': Permission denied Can't load log handler "java.util.logging.FileHandler" java.io.IOException: Couldn't get lock for logs/tool%u.log java.io.IOException: Couldn't get lock for logs/tool%u.log at java.util.logging.FileHandler.openFiles(Unknown Source) at
Personal DBMS Migration from Foxpro 2.5 a for DOS to Zoho Reporter
I have been using, for over 20 years, MS DOS 6.22, Foxpro for DOS v 2.5a and Qbasic 1.1 for all my data processing - for my Medical Practice, Retail Pharmacy, Banking and an Educational Trust. These were good enough for me to make data entry, retrieval, editing, report generation etc., and I have been using them comfortably for over two decades only moving upwards in Hardware upto P4 but still working with the same OS - MS DOS and Flat-table DBMS - Foxpro for DOS. I am a single
Upload data from SQL Server to Zoho Reports through vb.net App
Hi , How can i upload data from SQL server to Zoho reports through my VB.net application. I want to upload data when i hit the button in my application. My application and Sql server are sitting in two different servers.
File upload issue on window.
Hello zoho-team, Please help me.. I want to upload XLS.csv file on zoho through curl in php but I am getting error. I am a novice in this field. so Please tell me where i am wrong. On linux code is working fine but on window it's not working and showing the error :-( .Sorry for my bad english. ---------------------------------------FILE TEST.csv--------------------------------------------------- TEST.csv contains: Service Provider,Date & Time,Title aircel,19-Mar-2013
zoho report loader - java out of memory error
just noticed that my data was not going through to zoho reports from the upload tool. i ran it from ssh and got an exception: in thread "main" java.lang.outofmemoryerror: java heap space stackspace had this: http://stackoverflow.com/questions/2381849/exception-in-thread-main-java-lang-outofmemoryerror-java-heap-space so i opened the uploadfromdb.sh file and added -Xmx256m to this line: export JAVA_OPTS="$JAVA_OPTS -Xmx256m -DCONN_PARAMS_FILE=conf/database_connection_params.conf -DIMPORT_OPTIONS_FILE=conf/database_sql_queries.xml
Advanced CRM Analytics and Reports Upload Tool
Hello, we have our CRM database linked to Reports using Advanced CRM Analytics. We are trying to use the Upload Tool to upload additional information to a new table in the database but the upload tool is telling us that the database does not exist. Is this possible to do? The database name we are using is "Zoho CRM Reports".
Sync Account Created By and Modified By From CRM to Reports
I selected the fields 'Created By' and 'Modified By' from the Accounts table when setting up my sync from Zoho CRM to Reports. When I get over to Reports and try to make a report using the Account fields, I cannot see these fields as options. What happened to them during the sync?
Lookup Column and aggregate functions
Hi, I have 2 db´s. 1. Stores_db with information about stores (ie city, adress, storenumber) with a lookupfield "store id" 2. Sales_db In the Sales_db i have two fields that I would like to have a formula just dividing one with the other. After that i would like to have a report where I can filter the sales data by parameters found in the Stores_db. I have tried joining the tables but get no luck because of the aggregate formula. I have also tried using Query table but I dont understand how to join
Timezone
sorry for my english! We have problems for 10 days on the planning reports. They are sent 1 hour before and yet I think being in the right time zone for France (Central European Time France / Paris). An idea? Is it related to a possible change time on your side?
Blank Primary Key on Import / Odd Table Join Setup
The way we are doing this isn't ideal. We are taking the CSV reports generated from our software and importing those into Zoho tables. This means that we have three different tables with "OrderID" as a primary key. Obviously in a real database most of this data would be in one table or sectioned off into different ID lookups. Anyway, there are two problems we are running into: 1) We can't easily join these three tables together on the same column in each one because "a lookup on another lookup column
Drilldown to underlying data
Hello, I am having a problem with Pivot table report that sometimes show underlying data when I click on a cell and sometimes it does not. Sometimes I click on a cell and it shows me the underlying data, I try to do it the second time and it does not show it, or it does not drill down. Any ideas what's going on?? Thanks
Next Page