Aggregate Formulas with 2 fields
(countif("STATUS"='SALE'))+sum("CALLS") Trying to add the total of the CALL fields only if the Status field equals SALE. Both of these formulas work fine when create them separate but when I combine them they do not work. Does anyone have any suggestions on how to make this work? Thanks
SQL Table Report
I am trying to add custom pick list to the SQL in the analytic sql table report, its not allowing me to do it. Any help would be appreciated.
SQL Server Connection fails
Despite specifying the details in the database_connections_params.conf file, my login fails. What could be the reason. I am referencing the HOSTNAME by name, not by its IP address. Do you think that could make a difference? I would like to resolve the issue as quickly as possible. Please help.
Export Report - PDF - Graphic Distortion
Hi Zoho, When I try and export a report to A4 PDF, Layout as in Dashboard (see attachments 'export 1.jpg' and 'export 2.jpg'), the end result appears distorted (see 'distorted zoho report.jpg'). Please advise as to whether the dimensions of the Exporting tool can be adjusted to repair this. Thanks,
Integration of zoho campaigns?
Is it possible to integrate also zoho.campaigns in zoho.reports? How can I integrate these applications? Many Thanks in advance and best regards Björn
Bar Chart Set Up
Hello, Can someone please help me to design a type of chart that I'd like to use frequently? On the x-axis, a list of a few columns, each of which contains data in the form of 1 or 0, and the y-axis to display the percentage of that column that is equal to 1 out of the total number of entries in that column. Can someone help with this? Thanks, Susie
Creating report using Multiple Modules
Greetings all! I am trying to create a report, that combines 3 different primary modules. I need to be able to gather details from the New Task, New Event, and New Call areas. All are listed under Activities, but do not show up as related modules when I select any of them as the primary module. Is there any way to pick multiple primary modules so I can access all the fields needed for my reports? Please let me know if you need any additional information from me to help make my question more understandable.
Filter a Panel
I create a panel called Cero, which I share with you, with all the sales info. But now I would like to duplicate this panel for each month. For example, a panel for May's sales other for June's sales, etc. Is there a way to filter in a panel all the tables a graphs by date. Im not referring to users filters because I dont want that the users see the info from other months when he is on a specific month. Thanks for your help.
How to create a chart that show Facebook fans over time
I believe this is an easy one but I am having an issue creating a report. I have a table that contains the export from Facebook that depicts insights over time. I am trying to create a chart that shows the increase of fans over time. The export I have from Facebook shows the Life Time Total Likes per day. I want to show the total likes at the end of each month, right now when I create a chart and select the x-axis to be month/year and the y-axis to be lifetime total likes it shows a bunch of point
Adding users/owners
I have 3 database owners and am trying to add a 4th I get a box come up saying: Sorry, you cannot share to a new user. Your plan limit allows you to have only 5 users. Kindly Upgrade your plan to share to more users. please rectify urgently
Set the same format for many columns
Hi support, I want to set all the 40 columns with decimal value with the same format (decimal place). How can I do it at the same time, not by adjust 40 columns one by one? Please help. Thanks
Exporting and Sharing Dashboards
I am the admin for our application and have created many reports and dashboards. All of my users can export these files if they desire. However, if any user creates a dashboard, they do not have an option to export. In terms of sharing, they can only share to the whole database group. If they just build their own report though, these problems do not exist as they can share at the individual level and can export. Why is there a difference for the dashboards?
Zoho Reports - New features rolled out on June 6, 2014
Support to Publish with Filter Criteria Zoho Reports now supports Filter Criteria option while publishing the views. With this feature, you can apply a filter criteria to display the filtered data in your embedded view or published Permalink as needed. Support to Share Folder Now Zoho Reports provides an option to share the views in a folder. This will reduce the tedious work of selecting the views from the entire views list available in that database, when you share them.
Rows will not delete from tables
Is anyone else having trouble deleting rows from tables?
Create a Query Table
I have shared the table "Radicación de Facturas with you". What I need to get from this table is a query where the cost (Column "Valor") of each service( Column "Servicio") is totalized per invoice ( Column "Nro Factura") Thanks
How to utilize an existing matrix data set with Zoho Reports
Hello My company's budget is currently captured in an excel spreadsheet relating estimated or budgeted expenditures by various categories (column) across future dates (ie many columns). I would like to use Zoho to report on this data set summing and analyzing by not only the categories but also by date. As the data is already in a matrix and not database format ie one row per datapoint, how can I modify or use the Report tool to accomplish my reporting needs? Thanks for any advice you can provide
Can I upload many CSV files at the same time?
Hi, I need to upload about 10 csv files to Zoho report. Can I upload all of them at the same time? I have tried and find that I can do that but I need your confirmation that there is no harm to upload many files at the same time Thanks
Zoho Reports - New features rolled out on Aug. 8, 2013
We are happy to announce that support for Activities module in Advanced Analytics Add-on for Zoho CRM, one of the most required features, is now available in the service. With this you will be able to create reports over Events, Tasks and Calls data in Zoho CRM, for better analysis & reporting. For Activities module we have added 20+ insightful reports & dashboards for your convenience. This module will be synchronized for new users setting up the Advanced Analytics Add-on. Existing users can synchronize
Problem with google drive document update
Hi Congrats for this great tool ! Once my problem will be solved, I will be so happy to work with it ! I have created a table fetched from a .csv file stored in googe drive. This is OK When I update the document in G Drive and I ask zoho report to refetch the document (Import/refetch...) It fetches the old version of the csv file ! I have tried to delete the csv file in g drive and zoho report still manages to fetch it... Is there any known glitch the could cause this ? Thank you !
Dynamic URL's for feeds
Is there a way i can provide a dynamic url? For example, my data feed requires a from date: www.example.com/jsonfeed?fromdate=25.05.2014 How do i make Zoho provide todays date?
Unable to import google drive doc
I'm unable to import any data via google drive. When I choose import and then browse to look at files in my google drive, no google docs are shown and the message "fetching google documents ... " remains. My ultimate goal is to import a shared google spreadsheet that is actually the results of a google form. I want to import that into into a database that I've been made "database owner" of. I've noticed that another user, the database administrator, is able to import the form spreadsheet while I
Problems importing a file from Google Docs
I have tried a couple of times importing a file from Google Docs but I get a message that I may not be the owner of the document or it has been delete. The problem is that neither of those option is true.
How to count quantity of text field?
I wish to create a report that answers the question: How many projects have we created in a certain County? We do not have "County" in Zoho CRM but we do have City. And we know which Cities are in the County. So I wish to make a Custom Formula that says - IF the Town is in this County, name it this, if not, do this instead. I have attempted to make this query using following code: if(Job City = 'Baldwin,Bridgton, Brunswick, Cape Elizabeth, Casco, Chebeague Island, Cumberland, Falmouth, Freeport,
Min DateTime for Each Day
I have a security access log and I want to find the earliest time entry for each day. I have one DateTime field. DateTime Access 2014/05/14 08:23 Door #1 Opened 2014/05/14 08:56 Door #1 Opened 2014/05/14 12:15 Door #1 Opened 2014/05/14 18:23 Door #1 Opened 2014/05/15 08:59 Door #1 Opened 2014/05/15 08:56 Door #1 Opened 2014/05/15 12:15 Door #1 Opened 2014/05/15 18:23 Door #1 Opened All I want is the first record for each day. Is this possible?
Enabling ALL columns for accessing underlying data when sharing reports with DB Group
Hoping someone can help me! When sharing views to the DB Group, I want to enable access ALL underlying data columns. However, I cannot see an option for doing this for ALL tables / reports in a DB at once. Instead, I have to (for EACH report): Select the report Select Share Select "Share Views to Database Group" Select "View Underlying Data" Select "Change Columns" Select all columns Select "Share" So this is 7 clicks PER report, which is really time consuming when creating DB's with 20+ reports.
Joining data from multiple query tables
Hi there, We've had to create multiple query tables to get around Zoho's inability to support multiple select statements in the same query. These are working fine, but we want to now join all five of the data tables so we can show the data from all five in one report. All five query tables only have one row and two columns (date and total columns) - we just want to include this row from each in a single report. Appreciate any advice on how to do this.
Zoho Reports - New features rolled out on May 14, 2014
Enable Reporting for NoSQL Databases Zoho Reports now enables you to analyze your data stored in NoSQL databases. You can connect and upload data from the following databases using Upload Tool and apply advanced reporting options in Zoho Reports over your data. MongoDB Apache Cassandra Apache Hadoop Hive Cloudera Hadoop Hive Hortonworks Hadoop Hive To know how to upload data from your NoSQL databases, refer to the help section here. We have also tested connecting the following relational databases
Nested Select on Query Tables
Hi, Is there any firm date for when/if nested select queries will be able to be used in Zoho Reports query tables? It's becoming a real limitation on how much functionality we can move to the Zoho platform when looking to use it as a complete enterprise solution. Cheers, James
How to hide from displaying the area in the chart w/o data
I have created a chart showing % change in weekly Sales for the current year vs last year. Is there a way to display only the period (up to date) rather than the whole 52 weeks?
Legend
Hi See attached image - i have a graph - some of the items in the legends have quite long names and when i export to an image these names are shortened to the top 13 options and the first 23 or so characters with dots..... Is there anyway I can produce a full legend without any of the information missing. I think that would mean giving the legend more space and the pie chart less space.
How can I merge Accounts and Potential
Working with the zoho Advanced CRM Reports Anyone who can update me on how I merge info from one zoho CRM section with other section - ex Accounts + Potentials - BR Finn
Add an increasing subID to zoho reports database
Hi, I have a Zoho reports database where I import data via APS from multiple sources. For each row, I need to have an unique row ID which is +1 from the previous row. On excel I could simply create a formula like B1=(A1+1) but I can't seem to do that on Zoho. Any ideas? Cheers, Ian
Pie chart label text truncated
Hi, I created a pie chart and added it to a dashboard. In both cases, the data labels for the pie chart truncates the values when viewing via web. Is there a way to make sure the values are not truncated? Also, if I export to dashboard the following happens: 1. The location of the label for each chart is different to viewing the dashboard on the web. 2. The label title does not show in the PDF. I have attached two documents for you to visualize the issue I am describing. Are these known issues? Thanks
Right ()
Attempting to use the right() string function to remove the front end text from the data in a field. The data is represented as "SRF-123456" with unique values for each entry. I want the column to only display the numbers. I have not had any success using the right() formula. Any help would be appreciated. Thanks, Brent
how to make progress bar in reports?
Hi how to make same progress bar in zoho reports? there is number 1 - example 1000 (equal to 100%) and growing number 2 - example 100-200-300 (equal to growing percentage)
Import Into Zoho Reports Not Working from Creator (permalink, publish URL - Unknown Host)
I am no longer able to import Creator data into Zoho Reports. Steps to recreate: Creator - Data Location = web, in the URL box I am inserting the URL from Creator "links" "permalink", "publish URL". It returns a message "unknown host or host not reachable. Please verify the URL provided"
Inversion of Y-Axis labels
Hello, im running into an problem whenever I view a chart in dashboard. When I created a chart the Y-axis (which has a scoring system of A,B,C,D,E) was initially descending but i was able to change this to ascending using the button next to the chart. however, when i add this chart to a dashboard and filter, the results that are produced flip around and are descending again (i.e. the worst score of E is at the top). Also the scale of the Y-axis changes to leave only those that are scored within the
Problem with UploadFromDB.bat
Dear Sir/Madam I’m having this error when trying to execute “UploadFromDB.Bat” file with Auth Token instead of the Password. Could you please give me some help? Note: When I run the same op with the password (instead of the auth token), everything works great. Thank you very much Matias
Cannot get "Text" of chart onto a 2 data point chart
I am unable to get the correct text onto a chart that has two data points. There is only one option for "text". Question: Is it possible to just have each data point show its own text? Please see screenshot.
Custom Reports containing multiple fields on one report row
I want to create (for export into .pdf format) a report just like I create in crystal reports. Below are my requirements - 0. One Record per page 1. A logo on top left corner of the page 2. Company name in bigger font size and bold letters 3. Insert lines (Horizontal Rules) to separate sections in report 4. Multiple fields per report row (e.g. Title, Name and Surname on same row), and then Profile Summary on next row etc. etc. Gone through reporting documentation, but couldn't find solutions for
Next Page