Change Calendar
With addition of the change module to the ServiceDesk Plus Analytics, has anyone had any success in creating a change management calendar with Zoho Reports? Any suggestions on how one might accomplish with Zoho Reports? Thanks, Craig Rice
ADD Column API call with DEFAULT , MANDATORY values
Is it possible to set a default value and columns mandatory when using the ADDCOLUMN zoho action in the REST API ? I could not figure it out based on the documentation: https://www.zoho.com/reports/api/?shell#add-column THanks.
Invoice ID not unique?
Hi, using Zoho Reports I pulled a report from the table "Invoices" and exported it as Excel. The outcome is that in the Excel file the invoice ID does no longer match what is inside Zoho database. Please see screenshot attached and notice how the information differs. Please advise! Thanks, Mark
Inbox Bloqueada novamente
Por favor ajudem-me! Meu email havia sido desbloqueado e aí quando comecei a receber as mensagens de meus alunos depois de umas 40 mensagens voltou a bloquear-se a inbox e necessito manter contacto com eles porque lhes estou guiando através de um processo muito importante. Por favor alguem me pode explicar porquê isto está acontecendo porque não estou a entender. a mesma mensagem quando tento desbloquear. "You have reached the maximum self unblock limit within the past 24 hours." Por favor algum
Aggregate formula sumIF,AverageIF problem for sales calculation more than 10000
Dear Sir, I am working on Aggregate sumIf formula for sales report But unable to make it . There is a error coming specific formula is invalid .Please check my formula and find the problem . I think syntax of formula is not correct thats why its showing error .Please give me a demo example for same .Below is my formula sumif(( "Ford details"."amount" >10000)) ford detials is sales report amount is Ford details Column I have to calculate Amount greater than 10000. I have also attached the screenshot
crosstab report
Can get more than 2 factors in crosstab report ? or have any way to do it
The required action param is missing
I have passed data using node and every time i got the error "The required action param is missing". Reference URL : https://www.zoho.com/reports/api/?php#import-data API URL : https://reportsapi.zoho.com/api/xyz@gmail.com/testDB/Accounts POST PERAMETER : 'ZOHO_ACTION' : 'IMPORT', 'ZOHO_OUTPUT_FORMAT' : 'JSON', 'ZOHO_ERROR_FORMAT' : 'JSON', 'authtoken' : '38f207ac4a8a5b73ce427***********', 'ZOHO_API_VERSION' : '1.0', 'ZOHO_FILE' : 'Accounts.csv', 'ZOHO_IMPORT_FILETYPE'
Tick box in reports
Hi I have an table that includes entries from a list of tick boxes in 1 cell with each item separated by a pipe. . See example This makes adding the total number of any item difficult. Is there any way i can return the individual entries in the end column (advice given) into a filter where i could choose the individual item rather than the entire column of many individual items - which is what i can do just now. Thanks Joe
Combine Date Column and Time Column in Query Table
Hello, I have created the below sql query to combine a date field and a time field. The query works in Sql Management Studio, but, I receive an error when I attempt to run the same query in a Zoho query table. Query: SELECT PREP_START_DT = convert(varchar, Prep_Start_Date, 103) + ' ' + convert(varchar, Prep_Start_Time, 108) FROM "HQProductionPerformance" WHERE Prep_Start_Date >= '2017-08-27' Zoho Query Error: Length of the display column name 'CAST(PREP_START_DT as CHAR) CAST(CONVERT(varchar, Prep_Start_Date,
Sales vs target
Hi, I would like to create a combined chart, with target in line and sales in bars, like this : The target for each sales reps is different from month to month. So I create a table of target : (example of Q3 2017 below) The problem is I can't join this with the data "won amount" from opportunities table. How can I do this ? Thank for your help Opportunity owner date Target A Jul-17 5,000.00 A Aug-17 0.00 A Sep-17 4,000.00 B Jul-17 1,200.00 B Aug-17 0.00 B Sep-17 2,000.00 C Jul-17 0.00 C Aug-17 0.00
List reports that reference a table
Hello, Is there a way to list what reports are referencing a specified table? I want to know which reports are referencing it so I can see how a change I want to make would affect reports that are using it.
Account Inactive
Hi, Please Urgent help needed! when I tried to login into my account info@workapay.com it returns "account inactive"'. please how do I get my account reactivated?
Is there way to check the usage of the shared dashboards?
Is there way to check/track the usage of the shared dashboards in Reports? I like to track the things like whom has accessed to it at when. Any idea? Thanks
Connecting to MySQL database on a hosted server - need incoming server IP/domain
We have a hosted MySQL database siting on our website hosting service (Dreamhost). I've created a MySQL connection in reports with the credentials for the database, but the connection fails with "Access denied for user zohoreports. Login failed.". I know the credentials are correct, because when I connect to the database using the 'MySQLWorkbench' off my laptop, it connects just fine (I Whitelisted my laptop's IP address). The Dreamhost service restricts access based on the inbound IP address or
Average Sales per Day Formula Over Selected From To Dates
Hi I have a Sales table wherein I have Invoice Dates, Item Description, Qty per Invoice, Invoice value. I have made a pivot for sales data with different user filters. One of them is Sale Invoice From Date and To Date. I want a formula to calculate average sale qty per day with respect to the number of days selected in the date filter including the selected dates.
New Features rolled out on Sep 7, 2017
Public Release: Microsoft Dynamics CRM Advanced Analytics We at Zoho Reports are extremely excited to announce the public release of the Microsoft Dynamics CRM Advanced Analytics connector. This integration empowers you with deep sales analytic capabilities over your data in Microsoft Dynamics CRM. Thereby enabling you to keep track of your Key Sales Performance metrics and optimize your sales execution. It comes with over 100+ handpicked reports and dashboards that you will find of great value.
Keep the filters floated at the top of the page
One suggestion, could we have the option to keep the filters floated at the top, or side, of the page? This option would be useful especially when the dashboard page is long. With the filters always on the page, users could easily check what filters have been set and easily toggle the setting wherever they are on the page.
Why is my project not showing up in my reports
Hi - my projects from Zoho Project Mgmt used to automatically integrate to reports. Then, for some reason, I had to go through and choose the projects I wanted to integrate. Now, I can't even choose a project. So - Im adding projects into Zoho Project Manager but, they don't show up on reports. Any ideas why?
Lookup Column
Hi I have created lookup column in one of my tables. However, values in that are not populated automatically in the table. How do we achieve this? Regards. Vaibhav
Aggregate Forumula - Variance %
Hi, I have financial data with Actual and Budget $s. I need to create a Variance and Variance % calculation. I created the Variance calculation as an aggregate formula: Var. = SUM(Budget - Actual) I then tried to create a Var. % which using the aggregate forumula "Var.". Var. % = SUM(Var.) / SUM(Budget). I get an error. See attached screenshot. Thanks Sunil
Aggregate formula in table not available in view
Hi, I created a few aggregate formulas in my table. I then would like to have a view on top of the table followed by pivot table. Prefer not to have a report (pivot or chart) directly connect to a table but to connect via a view. I noticed that aggregate formulas in a table do not transfer to the view. Is this correct? If yes, they do I rebuild the aggregate formulas in the view? Thanks Sunil
Whitelabel Solution Implementation
Hello! We've recently bought Zoho Whitelabel solution. We've implemented all the other technical things like domain mapping and all. Can anyone suggest how we can implement login for the solution?
CloudSQL - Insert, Delete, Update operations
Hi, According to the online docs: SQL querying over HTTPS Currently it supports SELECT querying over HTTPS INSERT, UPDATE and DELETE statements will be supported soon Can you confirm if INSERT, UPDATE and DELETE operation is implemented, and if not, any thoughts on when this would be implemented? I can use the traditional SQL_ACTION=DELETE but I do prefer the native SQL structure that CloudSQL provides. Thanks Sunil
New Features rolled out on Aug 30, 2017
Zoho Creator Advanced Analytics We at Zoho Reports are extremely thrilled to announce the general availability of the much awaited Zoho Creator Advanced Analytics Integration. Zoho Reports Advanced Analytics Add-on for Zoho Creator enables you to easily slice & dice your application data and create insightful reports & dashboards. Users can embed reports and dashboards within your Zoho Creator apps. Empower your creator applications with deeper analytical capabilities from Zoho Reports. This integration
Query SQL with inner join
Hi, I have a transaction table with heaps of rows. I want to create a SQL script that gets all transactions with the minimum transaction date. Eventually I want to purge/delete old rows using the delete API. Logically this is two steps: 1. Get minimum trans date from transaction table. 2. Select all rows in the transaction table where trans date equals the minimum trans date from previous step. I tried the following 2 SQL statements but receive different errors messages: SELECT COUNT(*) FROM
SQL Query for adding previous row with current row
Hi ZOHO Reports Team, I have the following table (See attached) that has 5 columns and each column has 4 rows. I want to create a new Column that will add the value from Previous Row to the current row and display. For Eg: For the column "Revenue Difference", the Rows should have the Formula like below: Row 1: April 2017 :: (Budgeted Revenue - Actual Revenue) = "Revenue Difference Row 1" Row 2: August 2017 :: "Revenue Difference Row 1" + (Budgeted Revenue - Actual Revenue) = "Revenue Difference
Number of rows used in a database
Hi, Is there any easy way to write a SQL or call an API to find out how many rows are used in a database i.e. sum the rows counts of each table (not view) in a database. I tried the SQL path as shown below. When click the Execute button it works. However, if I try to save the SQL as a view and error pops up - "Parsing of Query failed, please check the syntax ". SELECT SUM(rc.row_count) row_count FROM (SELECT count(*) as row_count FROM "event_log" UNION SELECT count(*) as row_count FROM "job_log")
If statement Issue
I wrote this if statement in the Markup Qualified Formula Column if(("Type" = 'PV' and "Markup" > 0.3999), 1, (if(("Type" = 'HEAT' and "Markup" > 0.3999), 1, (if(("Type" = 'TANK' and "Markup" > 0.3999), 1, (if(("Type" = 'EV' and "Markup" > 0.3999), 1, (if(("Type" = 'BATT' and "Markup" > 0.1999),1, 0))))))))) I am trying to say: If (Type = PV or HEAT or TANK or EV) and Markup is greater than .3999 then 1 Else If Type = BATT and Markup > .1999 then 1 Else 0 However in the screenshot below it
Using variables in Pivot Reports' filter
Hello, Is there any way that I can use a variable, instead of a value or range or top/bottom %, when adding a filter to the report. Example: I would like to pass a variable from a script that calls a chart/table. The value in that variable will be used to filter the records to be displayed or charted. Any help would be appreciated Thank you
Gantt Chart not showing correct dates
I am importing a project report from ServiceDesk Plus into Zoho in hopes of creating a delivery schedule report (Gantt chart). We are using the schedule start and scheduled end dates, but everything on the chart is showing Jan. 1972 as the date. The date fields I imported and used the mm/dd/yyyy format in Zoho from a CSV file. I have attached a couple of screen shots. Screen01 shows my report and report config. Screen02 show what I get when I click on one of the bars in the chart, no data but
LookUp and Relational Errors
Hello, I'm trying to change the relational model of my database because they are improperly linked when I sync and no data is showing up- see attached proposed relationship. When I attempt to create a lookup I receive an error message- see attached. Any help would be greatly appreciated. Thanks!!
Error 7309 when sending REST call to API
Hello, My compagny is currently starting to use Zoho report. We need to automaticaly send and get data from Zoho report so I am using the API. I ran into error 7309 which is not documented. I use the command curl : curl -d "ZOHO_ACTION=EXPORT&ZOHO_API_VERSION=1.0&authToken=fc7737f589d6ee8353b0fd396bbce16a&ZOHO_OUTPUT_FORMAT=HTML&ZOHO_ERROR_FORMAT=XML" https://reportsapi.zoho.com/api/bastien.a.meunier@capgemini.com/SalesTest/sales I am just trying to get table "sales" from database "SalesTest" which
What's New Monthly Digest: July and August 2017
August --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Zoho Desk Advanced Analytics The Zoho Desk Advanced Analytics integration which was previously in beta has been rolled out. This connector enables Zoho Desk users to easily analyze their help desk data and track their key help desk metrics. The Zoho Desk Advanced Analytics connector comes bundled with over
New Features rolled out on Aug 22, 2017
Zoho Desk Advanced Analytics We at Zoho Reports are happy to announce the general availability of Zoho Desk Advanced Analytics integration. This connector enables Zoho Desk users to easily analyze their help desk data and track their key help desk metrics. The Zoho Desk Advanced Analytics connector comes bundled with over 75+ domain specific default reports & dashboards such as agents' performance, customer analytics, deadline complience, satisfaction rating, and much more. You can also create
Column containing multiple values with a delimiter
Hi, I have a column containing multiple data values separated by a pipe delimiter. I know the number of values packed in the column. Is it possible to write a SQL query to extract the individual values? For example. Transaction Details (single column) =============== SUCS|$50|SALE|REF10291 We have a single column containing 4 pieces of information. Using SQL (or may be a column formula?) I would like to extract the four pieces of information as separate columns i.e. TransStatus, TransValue, TransType,
Zoho Desk & Zoho Reports Integration
Need I say more? Ok, I'll explain further. It would be great to have access to our ticket data & happiness ratings in zoho reports. We use zoho reports to keep track of all of our key metrics & i'd love to see how our support interaction dataset influences items like lifetime value, etc.
Need to create a report that reflects all the accounts with open activities as well as the activity description
Hi, I need to see the list of activities/ tasks that are pending (open activities) along with the activity description along with the due date (even if it has passed) Can you please tell me the exact procedure to pull this report out. Thanks!
How to measure first reply time and solution time in woking day and hours
Hi, In order to measure our performance on SLAs, I need to get the first reply time and the resolution time calculated on a working days / hours base. Can you help on this? Thanks Jeremy
Creating Zoho Reports customized for specific industry verticals?
Is anyone creating Zoho Reports integrated with Zoho Books that are customized for specific industry verticals? Looking to do so for lawyers and would like to share and collaborate if others are interested. Earl Rudolfo
Integration between Books and Proyects
Good day! I have both Books and Proyect databases imported into Reports. Books and Proyects are integrated so expenses can be registered on Proyects and be reflected in Books. I can see in both Books and Proyects that when I register an Expense (Proyect, Amount, Supplier, etc) this information can be seen on both apps. I need to make a report on Reports that shows how much has been spent per Proyect, but i cant see what ID or data lets me relate both databases, nor can i find a table/s on either
Next Page