Analytics plan level on Zoho One account
Which plan level on Analytics will be available to Zoho One account users when they are subscribed to the "Flexible User Pricing" model? For example which plan level for the Analytics will be assigned to us if we subscribe to "Flexible User Pricing" model with 10 users? If it's going to be one of the "Premium" or "Enterprise" plans on Analytics then how many users will we have on these plans? These plans are normally defined to have 15 and 50 users respectively. https://www.zoho.com/one/pricing/
Deleted tickets are showing up in a SQL query
I'm trying to write a query that shows me all tickets that are missing a time entry, so I can make sure the agents are logging their time accurately. My script is: SELECT "Request ID", "Ticket Owner Name", "Created Time","Department Name" FROM "Tickets" LEFT JOIN "Time Entry" ON "Time Entry"."Request" = "Tickets"."ID" LEFT JOIN "Agent" ON "Agent"."ID" = "Time Entry"."Agent" WHERE (MONTH(Tickets."Created Time") = MONTH(Curdate()) AND YEAR("Created Time") = YEAR(CURDATE())) AND "Executed Time"
Zoho Reports Database
Hi! I have a database in zoho reports but when you migrate to zoho analytics I cant view my database, Can you help me to solve my issue? Cordially Edgar MOntoya
How to handle JSON feed with nested variables
Hi, beginner user of Zoho Analytics (long-time Zoho CRM user, if that's any help). I'm trying to pull together some info from Zoho CRM and our payment gateway, Iugu. For Iugu, I do it via a JSON feed - I make a call to its invoices API which returns all the invoices. All good until here. The problem starts when Zoho Analytics hits the nested parts of the JSON response. The nested part, "variables", can have 0 to 10+ items. I'm trying to catch the variable "subscription_id". In Zoho Analytics, I end
Aggregate formula not yielding correct result
I'm trying to use an aggregate formula to calculate % of one value to another in two different tables but in same relationship path. However, it's not returning the correct result although the absolute values are correct as I can see by including those columns in the tooltip. Below are the screen grabs of the formula, the absolute values and the result of the formula in %. As can be seen from the second image below, Total Debt is 657,354 and Total GDP is 240,216, which are both correct but the %
Zoho CRM/Projects/Desk
I'm using Zoho Analytics to report on a few combinations of items that relate to Accounts (CRM) being associated with Tickets (desk) and Projects (projects). For example, I have an account in CRM "ABC Corp" and in CRM I've linked a project from ZProjects "ABC Project." I would like to be able to create a report that shows me how much time I've logged for the Account across all of their linked projects and helpdesk tickets, however I can't seem to find the one-to-many key fields that make this type
Zoho Analytics Release 4.0
We are happy to announce the much awaited Zoho Analytics 4.0 public release. Zoho Analytics comes with several exciting features and a fresh look that you will love. Here is a summary of what's new in Release 4.0 Reporting to Analytics Zoho Reports is now renamed as Zoho Analytics!! Since we offer in-depth data analytics beyond reporting already, it is only fitting that we make this name change to reflect the power of the product. Refreshed User Interface Introducing an all new user interface with
Zoho inventory table
I have a new client that use Zoho Analytics for doing reporting on Zoho Inventory. It’s a bakery. In sales order we have all items that have been ordered by his clients. We need to do a report by items to have the production scheduled. We need to sum all orders by items for each expected delivery date. We have activated Zoho Analytics with their Zoho Books account, but I only saw the table on Sales Order with subtotal by order. I don’t have all items by sales order. I guess it’s like Sales Invoice,
Cannot open dashboards
I'm unable to open dashboards I made or the associated query tables linked to those dashbaords, and I keep getting shown the same error message: Alert Message 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.
Cannot close the announcement page for 4.0 release
Hello. When I open the Analytics app I get an announcement for the 4.0 Release which completely blocks my page from opening (see th attached image). How do I close it? There's a "next" button but when I click on it nothing happens
Cursor Position when editing SQL queries
When Creating or editing an SQL query I need to move the bottom of the query box up and down frequently to show or hide the bottom panel. To get the mouse in exactly the correct position to show the double arrow symbol is very difficult. Is it possible to enlarge the area where the double arrow shows to make this easier and quicker.
Show percentage of a value other than total
Hi Newbie to Zoho analytics so please excuse my ignorance. The chart below shows the appliances that householders had fitted in their new kitchen. The percentage figure is showing the percentage of the total count (2128) but I need this to be the percentage of the number of respondents in the survey (503). Can this be done? Many thanks in anticipation Jane
Count all Yes from radio button
I have a multiple fields with radio buttons. For all these fields only the option to select Yes or No. I would like to get a count of how many times the value Yes was selected in the row. Something like Yes + Yes + No + No = count the yes Field 1 + Field 2 + Field 3 + Field 4 = Countif YES = 2
Connect to Shipstation's API
Shipstation is a very big service, with lots of users, tons of order data.....and poor un-customizable reporting. This is perfect for Zoho analytics. The Shipstation API is modern and efficient. Today I think many people pay Zapier to get Shipstation data into Reports/CRM/Books - why not have a direct connection? -can pull in shipments via webhook or polling. -also nice to pull in order data along with shipment data
file: protocol in URL
Hello! I make a field with a URL. Links on the protocol http: and ftp: work. But file: links do not work. What to do?
Report to show most recent case for all accounts
I need a report to show the most recent case date/time for all accounts, so I can see which accounts require more immediate attention.
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.
Next Page