Problem in Zoho Upload tool
Hi Team, we are getting below error on uploading file from zoho uploader. Please advise
Creating account wise activity report in zoho reports
Hello, I need to create the Account-wise Activity count report. I am facing issue as i am not getting account name or activity count together. Please help me with this. Thanks, Murali S
Problem with Imports on Zoho Reports C# api
I'm having no luck getting bulk Import function to work with the c# api library. I can add or update rows to a Zoho database table just fine but when I try to use the ImportData function I get nothing. I don't even get a response so I can debug what I'm sending. I am trying to import a JSON data string but I have had no luck importing from a file either. Does the free version of Zoho Reports not allow API Imports? I pasted my code snippet below. I have tried every combination of settings for
Reporting on Google, Yelp & Facebook Reviews
We'd like to see the ability to pull in data on our Google, Yelp and Facebook reviews into a Zoho Report. It would be great to be able to build reports this data such as current 'star' rating (i.e 4.6 stars on Google); and perhaps be able to display the most recent reviews. Even better would be to have a report for review rating over time such as 4.5 stars in Jan, 4.6 Stars in feb, 4.7 stars in Mar etc.
Zoho Reports to be renamed and launched as Zoho Analytics 4.0
We made the Zoho Reports 4.0 Beta announcement a few months back. As we worked on new features in 4.0, we realized we are moving away from just Reporting, and getting more and more into the Analytics realm. And that's the reason why we have decided to rename Zoho Reports as Zoho Analytics. This post is just to give you a heads up on the Zoho Analytics 4.0 launch in mid November 2018. As present users of Zoho Reports, be assured that the new product will continue to work the same as the current one.
How could I access to product details?
How could I access to the information of product details of Transaction Module?
New Features rolled out on Oct 15, 2018
New settings to customize Interactions in Dashboards As part of Zoho Reports 4.0 release, we are introducing a new set of options to customize the interactions in dashboards. You can customize the following: Enable or disable drill down option for all charts in a dashboard. Enable or disable view underlying data option for all reports in a dashboard Provide sort option for all grid views such as Tables, Pivots etc., in a dashboard Enable or disable the Show/Hide Columns option for all tabular views
I want to create a custom financial Report
Hello, I am looking forward to create a custom report where in i can calculate Owed(Liabilities) - Amount, Own (Assets)- Amount and Net Amount. I am having difficulty understanding which data to refer. Kindly help please.
Unable to connect to AWS-RDS
Hi, I just start a new account and am trying to connect to my RDS DB. Here is what I have done so far: 1. Created a new Security Group in AWS and added all the whitelist IP's 216.52.72.0/23 204.141.32.0/23 8.40.222.0/23 135.84.80.0/23 8.39.54.0/23 8.45.169.0/24 204.141.42.0/23 65.154.166.0/24 2. Created a new user for the Reports - 'zohoreport'@'%' 3. Step 1: Connect to Cloud Database and added the connection details for RDS. I am getting the following error: Sorry,there is a problem in connecting
Pivot Tables Grand Totals
Hi, Is it possible to make column grand total visible at all times even if the number of rows means you need to scroll to the end to see it? This would help as it would avoid having to scroll all the way to the last row to be able to see the grand total. Is it also possible to have the option of viewing the row grand total on the left instead of the right, also to minimise scrolling. Thanks. Kind regards, Jack
Can't add database
I don't see any options to import or create a database. I have attached a screenshot. I want to connect a Google Analytics profile. Thank you.
Consistently getting action: DELETE, error code: 7005
I have several integrations for different users. They were working fine, but a couple of days ago this error started coming up: { "response":{ "action":"DELETE", "error":{ "code":7005, "message":"Sorry, an unexpected error occurred when performing this operation. The error has been logged and will be looked into.\n\nIt would be of great help if you could provide us with additional information using the \'\'Feedback\'\' link." } } } Is there something that can be done about this?
"Mark as Personal Data" multiple column selection
Is there a reason why we cant select multiple columns simultainiously as PERSONAL DATA?
Dynamic data source in dashboard OR dashboard clone/copy
Dear Zoho Team, I want to offer the same dashboard to different companies, and in my architechture each company data resides in a dedicated MySQL database. So I would like to be able to embed the same dashboard and pass as embedding parameter the proper databsource related to the db of the specific company. Is it doable? I think not. So I thought to a different solution: I duplicate the dashboard for each company. But surprise: I neither cannot fond a Duplicate/copy button for my dashboard! This
Line Chart
Hi, I am trying to create a line chart from an excel file which has data from Jan to Dec. The line chart draws a line where it plots all the amount in the ascending order. So that results in a chart where Apr may appear before Jan if Apr has the less amount. So i want to know that can i do to not let line chart sort by amount and show the months in sequential fashion. And where can i learn about all the functions that can be used in zoho reports? Ram
How can I change the number of decimal places displayed in a pivot table without changing source data?
How can I change the decimal places in pivot tables without changing the source table? Different pivot tables require different accuracy i.e 2 decimal places or none so I can't change the source data. It seems very odd to restrict data views formats to only the source data's format.
¿En zoho reports, se puede hacer procedimientos almacenados como en una base de datos SQL?
Es que necesito filtrar unas fechas par hacer un indicador y dependiendo de la fecha se van a mostrar campos calculados.
Sorting in a report (not an in source table)
Hi, I have created some reports based on one datasource table. Everything is working fine, except that I cannot sort by data columns, just by rows data. I am doing anything wrong ? or functionality does not exist ? Cheers, Denis
How to set the velocity meter value in percent
HI everyone; I need some help to change the speed value for percentage Thank you very much
Can I export data from Zoho People using Zoho Reports ?
We use Zoho People as trial to know function. I would like to know how to export data which i input. Please advice.
Time Log Report Across Zoho Apps?
Currently there are at least 4 different apps in Zoho where users can book time. Projects Desk Books People In our case for instance, the same user may book time against both Projects and Desk Tickets. So we have no way to see a simple timesheet for a user that shows all their hours. Using Zoho Reports, would it be possible to create a report that combines the hours logged by employee across Projects and Desk. So that we could see total hours per employee logged for the week, and what project tasks
Automatic-recurrent import from a google spreadsheet
Hi, I have a google apps spreadsheet that I use as customer feedback questionnaire. I would like to import any NEW entry in Zoho reports to monitor results (mostly numeric - service quality scores). An automatic import once a day would be enough. Is it possible?
Replace errors with warnings
Hello I have a lot of data sources imported on a nightly basis. If the source didn't change, the system doesn't update the table (which is logical), and showing red Error in the log (which is NOT logical). So I have to check every error to be sure this is actually not an error. So the proposal is to introduce Warnings at least for the following cases: 1. The data was not imported because the source didn't change 2. First rows of the source were not imported because the import parameters required
Different Totals with different filters, Same Graph
I'd like to have a bar graph in zoho reports of my service desk tickets whereby I can see two totals. First total is the number of tickets opened in the current month, which is easy. But in addition, I'd like to see the total number of tickets closed in the same month BUT regardless of whether or not they were opened that month. For example 100 tickets are opened in October. That's the first total. The second total could be 120 tickets closed in October because 20 of those were opened in September.
Expenses by categories - field missing for split transactions
Hi, I'm trying to do a query on the expenses table to show expenses by project. I was able to do the query, but I have double entry for split expenses. There is not field in the Expense table for the amount of a plit line. Any clues how to solve this? Thank you
Show percent difference between the 12 month moving average of a month vs the previous month
Hi, I was wondering if this was possible in Zoho. I have created a report that shows the moving average of a count of items in a table based on the 12 months previous. I would like the text above each data point to show the percent difference between the moving average of the month of the data point vs the moving average of the previous month. Ultimately I would like to place these data points in its own chart to see the trend of percentage changes. I know you can show the % difference between previous
UploadTool JDBC driver MySQL?
Hello, I'm trying to upload data from my remote MySQL database into Zoho reports and I got a lot of problems and I already solved it, but this one I can't handle it so please can you help the problem is I got that error while trying to upload data with UploadFromDB.bat file :- Driver class is missing. Ensure the required jar file for the current database is placed in lib folder. I already downloaded (mysql-connector-java-3.0.17-ga-bin) and placed it in lib folder Thanks in advance
Dates Filter - up until Today
Hi there, I'm trying to report on something based on a date set as 'up until today' (obviously this would automatically take the current day)...however I don't see this available, why? There is a 'Today' & there is the ability to set a range 'To' but that input is an exact date not a moving date like 'today'
Multiline text field removes carriage return/linefeed after sync with Reports
Hi, I have a multiline text field in Zoho Projects which I sync with Zoho Reports. After sync it seems that the carriage return/linefeed is removed. Therefore when I create a report, the multiline field is now shown as 1 long line. Anything I am missing ? Kind regards, Peter Verschueren
Zoho Reports Release 4.0 Beta
We are delighted to announce the new Zoho Reports Release 4.0 Beta. Your favorite Zoho Reports now comes with a fresh new-look and exciting features. The new Zoho Reports 4.0 includes the following features: Dashboards in Single Click The UI has been completely revamped focusing on easy navigation. Now you can access any dashboard in a single click using the Preview Cards. Easy Navigation The main navigational elements are made bolder and bigger now. The analytics elements are organized into three
Zoho Rports with Zoho Desk report help
Hello, I am using Zoho Desk and the data has been pulled into Zoho Reports. I'm trying to create a specific report that shows the number of tickets by Agent that have been closed per day against total number of unresolved tickets. Though I can get to show the resolved total on a daily basis the total unresolved shows 0. I'm guessing that the user filter has been set to completed time as "yesterday". I'm sure there is a way to show tickets that have been closed against number of outstanding.
Suggestions for Zoho Reports
A few important features that are missing that can really make this product super great. 1. Dashboard: Ability to add multiple reports side by side like a 4-6 column layout (currently limited to 2) 2. Dashboard: Ability to copy widget. 3. Dashboard: Widgets don’t stretch across the entire width if using multiple widgets. 4. General: Ability to set standard color sett (CSS styles) for reports used in a database or account. So much time is wasted customization colors. 5.
zoho reports with zoho desk data
we are using Zoho Reports with data from Zoho desk. I am trying to create a dashboard that will show me the total time from the TIME ENTRY data per account. I see you have several resolution time or calculations that are for calculating time between ticket open and ticket close but I am looking to find out how much time we spent on each ticket or per account.
Zoho Creator Assets Tracker report fields in Zoho Reports
Hi, we have configured a form and report in Assets Tracker (Zoho Creator app) with a data from CRM Product field (Product Name). So in Assets Tracker we can see the product name of the item. Then we have made reports in Zoho Reports with data from Assets Tracker. But in the Data Source we don't have the Product Name field, so in Zoho Reports we can't show the Product Name if the items. Is there any way to import this kind of field from Assets Tracker into Zoho Reports? Thanks in advance, Regards.
Total Fee for this Financial Year MoM comparison
I am not sure if this question has been asked before but i have a table with 4 columns, Trip Name, Fee, Booked Date and Closing date. Trip Name and Fee are quite obvious. Booked date is the date the trip is booked and closing month is the the time when the Trip File is closed (as in after the trip is completed). So what i am trying to achieve here is Total Fee for a specific Closing date this Financial Year booked until today (or any other specific day) So for example if the closing date is June
Summary View - Sort by the aggregated sum column
Let's say a simple sold product report based on product table and order table (linked by sku relationship) Group by: Product name [product.name] Summarize: Sold Quantity [sum(order.ordered_qty)] User filters: Date picker - (titled: Orders from within date period) [order.order_created] This works in principle, however we can't sort by the Sold Quantity, the business stakeholder want to see the top selling products for the period they selected at the top of the report by default. Sorting does not
Dashboard Column Mapping for Date Fields
Howdy, The Column Mapping feature with User filters is very powerful, but it only appears to work with string values. It would be great to have the column mapping available for date values, too. Is this possible?
How to customize your subtotals in Zoho report?
I have a table something line this ID TotalFees AdminFees A 100 10 A 100 10 B 200 10 B 200 10 I need to generate a report (table view, pivot) something like below ID TotalFees A 200 SubTotal A 200 - 10 = 190 B 400 SubTotal B 400 - 10 = 390 Can someone help please
New Features rolled out on Sept 19, 2018
New Advanced Summarizing Functions for Pivot Table Zoho Reports new supports the following advanced summarizing functions in Pivot Table to enhance the analytical ability. % of Row in Group - Displays the data in each cell as a percentage of the total value, of each row within a group. % of Column in Group - Displays the data in each cell as a percentage of the total value, of each column within a group. Lookup Value - Displays the data in each cell by fetching value from any of Previous/Next/First/Last
Multiple date format
Hi, I'm trying to import and keep in sync a database with Zoho reports. I have date times and date fields, the problem is that i can't specify more than one date format so only one is being picked up as date. Is there a way to set both to the correct date type? I found an anwser in these forums but is from 6 years ago, is there a way to do this now?
Next Page