How to properly setup Databridge on Linux Server?
Hello guys, i am running a Linux server on which I am installing the Zoho Databridge via command line. The Zoho tutorial ( https://help.zoho.com/portal/en/kb/analytics/user-guide/import-connect-to-data/databases-and-datalakes/articles/postgresql-3-3-2021#1_How_do_I_install_Zoho_Databridge
New User Invite Changes Email Address
Hello, When inviting a new user, I noticed that after I keyed in the email address and sent the invite, that the invite had changed the email address. Is this because the address may have been an alias? This was a gmail based account with a company domain.
Task Completion vs Estimated Time
I need to represent the Estimated Date vs Actual Completion Date for multiple Tasks. How Can I Do this in Zoho Analytics.
Link to Desk tickets
Hello, We are using Analytics to analyze data in Desk. Is there a way to embed a link to a ticket in reports? We'd love to be able to see the drill down data, and click a value in a result row that would launch the Desk Ticket in another window/tab. Thanks
Cohort - Zoho Analytics
I am developing a cohort analysis in Zoho Analytics for Tickets/Service Desk, which tracks the number of tickets created each month and when those tickets were closed. I have added a user filter for classification. When I change the classification using
How to troubleshoot Google Pub Sub beta connector in Zoho analytics
Hi We are working with another development team to get Google Pub Sub Stream connected with Analytics and they are receiving 400 errors and when I try to validate I get the following: Failure Reason(s) Stream data does not contain any matching column
Zoho Analytics - Pivot: Lookup Column is showing IDs instead of their actual names
Hi, I'm new to Zoho and have no prior experience with the platform. Has anyone encountered a similar issue in a pivot table, where the values in the columns are showing as IDs instead of the actual names? See image: I am pulling these fields from a module
How do I get a running total of active accounts in Zoho Analytic reports based on Layout change?
We currently have two types of layouts for accounts - "SQL Layout" & "Member Layout". Since we can't group multiple leads to a common point in Zoho, our work around is we now convert our leads after a demo to track all contacts associated with that company.
Where is my domain? How do I login? Why is it so hard? Why is it separate from my email?
Where is my domain? How do I login? Why is it so hard? Why is it separate from my email?
Zoho Analytics - Custom Design
Is it possible to customize the design of Zoho Analytics by integrating it with Figma? I need more design flexibility for the dashboard, similar to what other BI platforms like Tableau offer.
Looking for help with Pivot tables.
Good day everyone, I am playing with some test data now, and I have a question. So I am using data that comes from Zoho Projects. I made a SQL query to combine 4 tables together and it all work fine. Now this is an image of the test data. I got all the
Hiding row in pivot table
In a pivot report it is possible to show/hide coloumns, but if i want to hide a specific row I can not get it to work without doing it mannually. I have 6 data rows showed each month. By removing the same check each month, I can in the end remove the
COMMON_INTERNAL_SERVER_ERROR
Hello, I am getting error one send post request via python( ) to Zoho analytics, the error is COMMON_INTERNAL_SERVER_ERROR. how to fix it? ***I don't want to use the SDK package** error: {"status":"failure","summary":"COMMON_INTERNAL_SERVER_ERROR","data":{"errorCode":7005,"errorMessage":"Sorry,
Duplicates
Is there a way to highlight duplicates in a report duplicates? e.g., using conditional formatting. We do not do manual import. We auto-import data from Zoho Desk Thanks Rudy
Slideshow from Zoho Analytics no longer displaying on TV screens
Hello. I hope you can help. We use the Analytics module to general company dashboards that are displayed on smart Tv's throughout the company. We have found recently, that they are no longer displaying when the browser on the TV goes to the URL of the
How can I calculate the physical stock available for sale?
Hey Zoho Team, I've tried to calculate the physical stock on hand in various ways - but always receive a mismatch between what's displayed in Zoho Inventory & analytics. Can you please let me know how the physical stock available for sale is calculated?
I am unable to get details of particular channel.
I see the following error. https://cliq.zoho.com/api/v2/chats/{chat-id}/messages?fromtime=1546344120000&limit=1000 { "message": "Sorry! Looks like you are not part of this channel.", "code": "not_channel_user" } Also, I notice that I am not able to view
Create a report/chart with differents paths and joins
Hi there, I'm having a hard time trying to join tables as needed to create a proper report. I would say that my use case is quite basic, I'm using (from Desk) the Tickets, Tasks, and Agent tables. I want to list all tickets with a custom boolean field
ZOHO ANALYTICS - HOW TO GET THE DATA VALUE?
Hi ZOHO Team, Good day. How can I get the data for Invoice Date, Invoice Number & Total Amount of Invoice from the Purchase Order Items as Source? Will appreciate immediate response Thank you Best Regards, Raffy Laoang
Zoho Project - Total Forecasted Hours
Does anyone know an easy way to get a total of all the forecasted hours across the portfolio? I'm aware trying to create a custom report that can generate this figure for each task and the total up but the completion percentage doesn't seem to come back
Plain text column loses leading zero when exported to csv
I have opened using notepad as per this old post https://help.zoho.com/portal/en/community/topic/leading-zero-for-zip-code-disappears and the leading zero is still there. However I cannot access the recommended solution (I guess because the post is so
Limit Forecast Values Below Certain Value
Hi, Just wondering if there is a way to limit the forecasted values from going above a certain value. What we are measuring should never go above 100%. Can I set it so that anything predicted that is over 100% just defaults to 100%? Thank you!
Call Result from Calls Module
The " Call Result " from the calls module does not show up under the tables, everything else does, is there a way to recitfy this?
Dashboard user filters are causing bug in dashboard widgets
Greetings i'm trying out the "Tasks Dashboard" from the zoho projects analytics integration, at the top of the board we have widgets that show overall tasks' statistics, the dashboard also includes user-filters, one of which is the user name filter to
Lookup Column on Imported Data
I am trying to link various tables using the date field as the lookup on data imported from Zoho Creator however no results are shown when I click to convert. The option does show on manually entered data.
Join Tables
Hello Dear Zoho Team, When I want to join two tables from the same source, I get this error that I uploaded in the attachment. It is very important that we join these two tables. How can we fix this problem ? Thank you in advance for your help. Kind
Cumulative stacked bar grouped by status
Hello, I did that chart: Its almost what I want, but when I try yo color by status, I got that: So, I'm having trouble to group my status and get a cumulative stackedbar, like that: Any idea how to manage that? Thanks in advance!
Help with the creation of a report
Hello, We need a report "Hours by projects" with a way to reduce the hours by 20% if the employee is a junior. I would like to see the last column with the adjustments and the previous one with the real hours. I've tried with a customizes field in Staff
Static column with Date changing column
Hi there. I am not a data techy and am more DIY. I am struggling with what is probably a very easy thing to do in Analytics. I want to be able to take our Stock on Hand at the date I run a report and compare it with a sales period from the past. It's
Issue with SalesIQ/Analytics integration
Hello, I'm facing an issue with the integration of SalesIQ and Zoho Analytic. Our goal is to export SalesIQ data into Analytics, to analyse the people coing to our website. It is a really vluable tool for us. Everything was working well, but one day
Change over Time Graph (or Trend Line Graph) of Daily Average of Staging Duration
I'm not sure if my question title does explain my issue but I will try to explain it in detail. We are creating dashboards which include staging reports created with data from Zoho Desk. The main report on these dashboards has a bar chart which shows
Need help with date conversion - extract Month()
Need help with date conversion/math. Here's my code. The "Predicted Receive" is a simple CRM date field in a custom module. current_date() must be return a date-time and extracting "month" from "Predicted Receive" is incorrect...I think. SELECT Vendors."Vendor
How to make an accumulated sum?
Hi, can anyone help me on this? I need to make report with a column with a running balance for the data: DATE NAME AMOUNT RUNNING BALANCE (accumulated sum) 01/01/10 alksdjfañlskf $30.00 $30.00
Joining 2 tables
Hope someone can help. We are a service delivery company and I am trying to keep track of each technicians completion percentage as the day goes on. The "starting Services" column is the amount of services they start the day with, then we export from our CRM to dropbox hourly to get the "services completed" number, then also a formula for the % complete. The problem i am having is that the "services completed" column references the total number of services completed between all technicians, and does
How to modify query for P&L report to include invoices that are in "Draft" state in Books?
How to modify query for P&L report to include invoices that are in "Draft" state in Books?
Item Profit Chart - Cant figure it out.
Hi folks, I am trying to make a report that will list all the items we sold in a period and show them in order of "Profit". I cant seem to figure out how to do it. Can anyone help me on the right path?
Referrals differences
What is the difference between referrals from potential: google.cl and google.com
SAML/SSO with Azure AD
Is it possible to set up single sing-on through Azure AD with Zoho Analytics? I see several other Zoho applications listed as "enterprise applications" with an integration there but not Analytics. Thanks