Analytics Crashing on Safari 13 (MacOS)
Anyone else having Zoho Analytics crashing on them while working on reports? Causes my browser to hang and only happened when I upgraded to Safari 13. Zoho Projects also has some bugs too that are at least can be worked around. Zoho response was to acknowledge my request and then close it!
combinations of items report
I am trying to build a report and I'm a bit stuck. I will try to simplify the example of what I'm trying to do, I wonder if someone may be able to help me. So I have a table looking like something like this: ID Product 1 A 1 B 1 D 2 B 2 C 3 A 4 A 4 C 4 D 4 E So a report would show, for each product, the number of
Are PIVOT and UNPIVOT available as SQL statements?
I'm just learning how to use PIVOT and UNPIVOT in SQL, but I'm getting an error when I try to use UNPIVOT: "Parse error at line 5, column 9. Encountered: FOR" I think I've otherwise got the query right. Are PIVOT and UNPIVOT operators allowed in Zoho Reports query tables? Thanks.
Currency symbols in professional reporting
In financial reports, we generally do not want to see a currency symbol on every number. The standard going back my entire career is $ on the first record and then on the total, usually at the bottom. I know how to include or exclude currency symbols entirely. But I do not see how to do this for just top and bottom rows. Example: Product Category Sales Furniture $ 1,500 Groceries 1,200 Stationery 1,950 Total $ 4,650
Unable to Change Column Data Type in Analytics to Date
I'm trying to change my column I created with a formula to a date type so it can be used correctly. However, when I change column to Date and select the correct format it fails to change the data type. I have made sure all data in the column is of the same format, so I do not understand the issue. Any help on this would be great.
Unable to Execute query in query table
I am trying to convert a string into integer array everything work fine in postgres but when I am trying to excute the same in zoho analytics its showing an error QUERY I am trying to achieve SELECT round(sum(ear.chainage_to -ear.chainage_from) / 1000) as diff FROM tableear ear INNER JOIN tableH H ON H.ID=ANY(STRING_TO_ARRAY(ear.Comma_Separated_values,',')::interger[]) WHERE ear.status = '2'Error I am getting Error Details: Parsing of SQL query failed. Please check the SQL syntax. Some tips:
Using Aggregate Formula to Take Specific Data
I have created a table in Zoho Analytics with four columns, Company Name, Support Start Date (Custom Field from CRM), Support Type (Custom Field from CRM), and Time (From Zoho Desk). I am trying to create an aggregate formula which takes the data from Time that has taken place only since the Support Start Date column. So in essence, I'm trying to filter each company's data by a different time period (the date in Support Start Date). Does anyone have any ideas?
Ask the Experts #1: Five hours live Q&A session with Zoho Analytics product experts
Hello everyone, We're excited to host our first Ask the Experts session. Right from connecting your data sources to the visualizations, AI, forecasting and collaboration; our experts are keen to address your questions and collect your valuable feedbacks. We're going live on 18th September 2019 (Wednesday) at 5:30 am PDT for five hours straight. Start posting your questions right away in the comments section. A decade-old experienced Zoho Analytics team members are the panellist for this session.
Projects - On hold time
Hi. I am trying to create a report which would show how much time a project is on hold. I would prefer not to create a custom date field for projects layout because we would have to manually fill it out... Is there any way to check that without adding fields? Unfortunately, I don't see any corresponding fields in Projects data tables :/
Saving Sheet View formatting
From my dashboard; When I have a summary report setup and I go to Sheet view can I save the formatting so it is always formatted the way I want when I go to Sheet View from that particular summary report?
How Best Can I Track Support Time Used?
Hi, My company keeps track of and charges for the support time we offer to clients in desk. I want to be able to track how much time each customer against how long they have left on their contract, ideally this process will end up being fully automated and integrated in Zoho. I have found the tickets data in Zoho Analytics and have set up a table showing how much support time each of our customers have used per month. However, I want to be able to track this against how much time they have available
Conditional column formula
Hi Folks, I can't figure out to create a formula that returns me a value of 1, 2, 3, or 4 depending on the % value of another column. 0-50% = 1 >50%>=75% = 2 >75%>=90% =3 >90% = 4 Can you help me out with this? Thanks
Save common filter for end user
Hi Team, I have users that want to filter on a set of choices. For example a filter that shows all Cost Centres, but they want to filter the data on a set of say 8 Cost Centres (out of say 100). The cost centres will always be the same that they want to filter on for their report. Is there a way that they can save the set of filters as a common or reuseable set that they can select at any time without having to manually select the 8 out of the 100. They may do this for various reports, (a second
Update Time for Databridge Sync
I have a Databridge set up to collect data from a remote database. We use this for metrics tracking for one of our customers, and I initially set up the Databridge to collect data at 6:00 PM, after their office closed for the day. They recently added a night shift from 5:00 PM - 2:00 AM, and want to include tracking metrics for the night shift's work, which means that I want the sync to run at 3:00 AM instead of 6:00 PM. I found that while I did have some options available to make minor adjustments
Multi-Program Agency: Creating Report To Check for Program CrossOver?
Hi! My NGO currently has 4 programs tied to Extended Reach. As an administrator, I can see, run reports on, and manage all of them. Functionally, all programs are separate, collect different data, provide separate services, etc and quite frequently we have a client that is receiving services from 2 or more of these programs. We can see these client's program files are tied within Extended Reach, but we can't seem to find a way to run a report under zoho that captures/shows an overview of this
Custom IF - Zoho Analytics
I am trying to get a formula that returns a negative number if a field is marked with a certain value. Otherwise it gives the positive value. Whatever I try, I'm only getting a positive return ... This is the formula I'm using - whereby if policy status = lapsed, the return is negative - otherwise it is positive. If_case("Policy Status",'Lapsed', '("PC (£) Lapse Reserve" *-1)', ["PC (£) Lapse Reserve"]) Can anyone tell what I am doing wrong? Thanks in advance James
Report of the Week - Horizontal Bar Chart
Ploting a bar chart horizontally looks better when you view a chart in a narrow layout such as mobile view. This can be easily done in Zoho Analytics. To create a horizontal bar chart, drop columns in the fields as given below. Y-Axis - Drop the dimension column (to categorize the data). X-Axis - Drop the metric column. The following animation illustrates how to create a bar chart that shows High Priority Tasks that are Overdue. You can also create a horizontal stacked bar by categorizing the data
New Features rolled out on Aug 28, 2019
Import Data from Statistical Files You can now import data from statistical files, generated by statistical applications like SAS (*.sas7bdat), SPSS (*.sav), and R (*.rdata), into Zoho Analytics for reporting & analysis. These files can be imported from Local drives, FTP servers, or Web. Import from more Local Databases with Zoho Databridge Zoho Databridge now extends to support importing data from the following databases. DB2 Exasol Greenplum Vertica Actian Vector Denedo Pervasive SQL Any Database
Can't add Costum Formular to Summary View table
Hi I have a problem. I want to calculate the difference between two columns (two dates) and return the value in a new column. However, i cant seem to ad a custom function, only aggregate functions. Can anybody please help? Thanks
Import Data to Zoho Analytics from Zoho Creator
Hello, I am experiencing a problem importing data from Zoho Creator to Zoho Analytics. Specifically, when I import tables that have Lookup fields inside those Lookup columns display incorrectly inside Zoho Analytics. For example: Lookup value "SmithJ4" shows up as "3806741000000037551" and column type becomes a number '#' Am I missing something here? Thanks!
Multiple Administrators
Is it possible to have multiple users who have full administrative right to the database? Currently I only see the option to enable read/write for certain users.
Multiple fields on x-axis
Hi I'm new to Analytics. I'm trying to create a chart that counts the number of leads on the y axis. Along the x axis I would like to display multiple fields ie. We have 4 date fields. I want to display the count of leads where a particular date field is not empty as one column and then replicate that for each date field. Is this possible? Thanks, Bianca
Email schedule - Zoho CRM contact
Hi, Here is the use case: I want to send a report as an email. When I chose "pick a user" I am presented with the following options: I would like to select an existing contact from Zoho Mail and Zoho CRM. Zoho Contacts does not contain all my Zoho Mail or CRM contacts
Pending Sales Order Reports
Pending sale order report is available for any single customer, Individual report is available after 3-4 clicks but consolidated list is needed to know the status each item. please help me.
Sending multiple reports as a pack
I would like to know if there is an option to send multiple reports as a bundle or pack.
We're sorry to inform you that the data synchronization has failed
Submitted this to the Analytics support email but did not hear back. Anyone else getting this error? Hi, We're sorry to inform you that the data synchronization of Zoho CRM data with Zoho Analytics into the workspace '[workspace name]' has failed on 28 Aug 2019 08:07:06 PM GMT due to an internal error. We appreciate your patience and understanding. Please contact us at support@zohoanalytics.com for any further clarifications. We appreciate your patience and understanding. Thank you and Have a great
Internal error While making api call
I am getting the following error while making api call to add row to my table Sorry, an unexpected error occurred when performing this operation. The error has been logged and will be looked into.nnIt would be of great help if you could provide us with additional information using the ''Feedback'' link. Error_code: 7005 Can you please check why am i getting the following error?
Report- Horizontal Bar
Hi, I'm looking to make a horizontal bar chart, similar to the one attached. X axis: Project names Y Axis: Dates (started date and completed date) *For the dates, I would like the beginning of the horizontal bar to be the start date and the end of the bar to be the completion date. The point of this report is to show overlapping studies
Can we Convert seconds into days,hours,minutes and seconds
Hi, I have a column called processing time which will be in seconds. I want to show average processing time in the format "days,hours,minutes and seconds" Is it possible to do like that??
Error 8518 over API call.
Hi I have a working setup for updating data over the API, but for a specific account I got a 8518 error. After a mistake from my side https://help.zoho.com/portal/community/topic/7005-error-on-importdataasstring-request my setup works for the account with email address: fl**is@a**m.nl But i'm not able to get it to work for the account with email info@c**.nl where I receive the 8518 error code. My configuration: email: info@c**.nl token: 56a3************************b09a token generated with url: https://accounts.zoho.eu/apiauthtoken/create?SCOPE=ZohoReports%2Freportsapi
Date Format
Hello! I just noticed that all the data we've synced from Zoho Recruit are displaying incorrect date. I've checked Zoho Recruit and the date there are correct. This is affecting all the data we've synced from Recruit regardless of the table. As an example: Zoho Analytics date: 01 Mar, 2609 Zoho Recruit date: 02 Aug, 2017 UPDATE: It's affecting our Quickbooks data too
Comparison
Hello Together, is it possible to create a comparison in Analytics similar to how in CRM the funnel? I would like to have a comparison between the sum of the sales chances and the sum of the won sales chances in a certain period of time.
Format Number on Trendline
Hi, I have a trend line showing an average but it is not rounding. Am I able to format this number? Ideally to an integer? Ideally I want this trend line rounded to show 12,423
Any Zoho users in Des Moines?
I am a new Zoho Super Admin (3 months) and looking to connect with other Zoho users.
7005 Error on importDataAsString request
In februari this year we created an importDataAsString functionality which was working at that time. Now I was running this functionality again and I got a 7005 error: Sorry, an unexpected error occurred when performing this operation. The error has been logged and will be looked into.nnIt would be of great help if you could provide us with additional information using the ''Feedback'' link. Error Code: 7005 HTTP_status_code: 500 From line 1368 on ReportClient.php Below a part of the php script
New Features rolled out on Aug 21, 2019
New Butterfly Chart Zoho Analytics now supports a new chart type, Butterfly chart (also be referred as Tornado chart or Divergent chart). This chart will be plotted as two horizontal bars with the same X-axis in the center, resembling the butterfly wings. This will be useful in comparing contrasting data sets such as male vs female, income vs expense, positive vs negative, completed on time vs overdue etc., easily. Click here to learn more. Customize Pivot Summary Position Now you can customize
How to Create a Heat Map
Hello, So I saw this picture on creating a heat map in Zoho Analytics that said you need an x-axis, multiple y-axes, and an aggregate function for the color box. However, I have data I am trying to make into a heat map and I cannot figure out for the life of me how to make an aggregate function that works for a heat map chart. Does anybody have any sample data and sample functions I could look at or anything? Thank you, Jonah
Accidental free account
Hi, I have somehow managed to log in through my own free account, even though my organization has Zoho One. How can I remove this and instead log into Analytics through our Zoho One account? Can someone help me, so me so I can start building reports from different data sources and business apps? I-m not the admin of Zoho Analytics in our organisation.
data connector to vkontakte?
Hi! is there any connector to Vkontakte vk.com?
New Features rolled out on Aug 14, 2019
Advanced Analytics for Shopify Advanced Analytics for Shopify provides you in-depth e-commerce analytics on your store data in Shopify. With this connector, you can effectively track key business metrics such as product performance, shipment handling, customer preferences, order transactions, inventory management and many more.... This connector is bundled with 100+ pre-built reports and dashboards that provide deep driven insights to grow your e-commerce business. Apart from the pre-built reports,
Next Page