Getting a join error on a query table that has always worked before
Hello, I am getting a join error "Sorry, query execution failed as the columns used in the JOIN conditions might contain too many duplicate values. Please ensure that at-least one of the column used in JOIN condition contains unique values." This is a
Zoho Analytics Sync Interval
Hello Zoho team, I hope you're well. I'm wondering if it's possible to change the sync interval for specific data sources in Zoho Analytics from 3 hours to 1 hour. I need to sync certain data sources hourly to achieve real-time analytics on our wallboard.
Show date of a record on dashboard
Hello. I want to add widget/text which will show me the date when last deal was signed as well as how many days passed since the last deal signed. Is there any way I can do this? Date is defined in CRM under the DEAL field named "Date of order". Thank
Monitoring the Website Performance of an E-commerce Platform
In the realm of e-commerce, effective monitoring of website performance is crucial for sustained success. Seamless functionality of your e-commerce platform is imperative for maximizing business growth. Watch this video to know about the comprehensive
Need advice on project
Hello, this request is rather generic and could resemble many of the previous ones and I apologize if this is the case. I'm currently doing a work-study programme in my 1st year of a Master's degree in IT and I've just been given a new project and I'd
Filtering based on Text Blocks
Hi I want to be able to create a number of text blocks within Zoho Analytics, whereby when a user chooses a fitler for a report X text block will show - is this possible?
No data is showing when importing GA4 to Zoho Analytics
I'm new in using Zoho Analytics and I already have several GA4 properties with lots of data. I tried to import the GA4 to my Zoho Analytics, but after the setup and check the dashboard it doesn't show any data at all. Tried it with the older UA and it
Total Data Widget
I`m writing to request your collaboration because when I use a Widget to count IDs the total data recorded in the database, but the total is not being reported. For example, if I have 30k id´s in the database, the Widget just report 28k. I have been waiting
[Databridge] Spawn EC2 machine with Databridge every 3 hours to run DataSource Syncronization job
Hi, currently I have a Databridge installed onpremise in a Mac machine that is always on. The syncronization between local DB and Zoho is configured to happen every 3 hours. I'm going to migrate DB to AWS and use an EC2 instance as the databridge. In
5 focus areas of online businesses using e-commerce analytics
As the digital realm evolves, it has become imperative for businesses to have a digital storefront. To thrive in the dynamic realm of the online business, keen understanding of the operations and optimising them is crucial. Watch this video to learn about
[Upcoming Webinar] Embedded Analytics: A faster route to modern, data-driven applications
Today's most innovative software takes advantage of next-gen embedded analytics offerings that speed development and power data-driven insights. Next-gen platforms are API-rich, enabling you to deliver concise and contextual analytics at decision points
What metrics do you track in your sales dashboard?
We need your help creating the ultimate sales dashboard. As you know, having the right metrics at your fingertips is critical for sales success. But with so much data to choose from, how do you decide what to track? That's where you come in! In the comments
API Export Dashboard as PDF with Filter Criteria from Multiple Tables
When exporting a PDF of a Dashboard using the API, it accepts ZOHO_CRITERIA which comes from a single table, but won't export when the criteria contains more than one table. For example, imagine a simple dashboard with two charts, one showing sales by
Trying to get Zoho Marketing Automation to sync data into Zoho Analytics
Hey friends! I'm trying to use the beta data source of Zoho Marketing Automation of Zoho Analytics. Every time I click on the Zoho Marketing Automation box, I get a pop up that says, "Unexpected Error." Any ideas?
Google spreadsheet =importdata or =importhtml
I'm trying to import data into a google spreadsheet from a published URL / Permalink of a table from Zoho Reports. I'm attempting to use the Google spreadsheet =importdata or the =importhtml functions. I can't get either to work. Is what I'm attempting possible?
Full screen mode on a tablet
Hello! I created a dashboard Id like to permanently show on a tablet. I noticed you have two android apps to view dashboards on the phone/tablet. Zoho Dashboards shows dashboards properly but doesn't maintain colors and doesn't show a lot of important
Issue creating a YTD report with last years numbers
I am looking to create a widget to compare the YTD leads we have in 2023 to the YTD leads we had in 2022. I'm having issues with the aggregate formula creation to gain access to the 2022 Leads YTD data point. Feeling like this is a common view of data
Error: Sorry!! Unable to display this page
Is Zoho Analytics down?
SELECT with UNION ALL and LIMITS
Hi, I have a query I'm trying to run that has a UNION ALL but I need different limits on each SELECT. See below: (SELECT "Users"."User ID" as "User ID", "Users"."Employee ID" as "Employee ID", "Users"."Role" as "Role", "Users"."First Name" as "First Name", "Users"."Last Name" as "Last Name", "UserProduct"."Product ID" as "Product ID" FROM "Users", "UserProduct" WHERE ("Users"."User ID" = "UserProduct"."User ID" AND "Users"."Role" = 'Child') LIMIT 1 OFFSET 2) UNION ALL (SELECT "Users"."User
SKU Run rate in zoho analytics
How do i create a run rate
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
How to add a Zoho CRM custom upload field as a data source
How do I add a field to Zoho Analytics that displays the uploaded file names? Or it can simply be a true or false if there are files uploaded to that field.
Cannot change data type from multi line text to plain text
Hey team, I have a column of data that has values which are no longer than 12 characters in length. There are no blanks. But I cannot change the data type of this from multi line text to plain text. Any ideas how I can force this? Thanks Carl
Which network ports need to be allowerd for Analytics API (Export and Import Data)
Good afternoon, I would like to kindly ask you which ports I need to allow for Auth API and Analytics API (Export and Import Data) Thank you in advance, Petr
Report using business_hours function in a query combined with User Filter in pivot table
Hello, I am wanting to create past utilization reports on users based on available hours vs hours logged in timesheets for the same period. I know that I can "hard code" a few queries that will provide specific periods, i.e. 1. Query for Year-To-Date
Pass value in business_minutes()
Hello there, I would like to use the function business_minutes() and pass data for the start and end of the working time. The times may be different for each data record, so I cannot use a fixed value. How can I do this? Something like this: business_minutes('2023-01-01
How to merge two columns into one to create universal user filter on dashboard?
Hello, In Zoho CRM, our Leads and Deals modules are separate (as is normal). In the Leads module there is a field called "Lead Owner", and in the Deals module there is a field called "Deal Owner". For our company, the lead owner and deal owner for the
Data not flowing properly from Deals (CRM) into Analytics Table
I am trying to sync data from Zoho CRM Deals Module into Zoho Analytics and am having some issues Below is a Test Deal. Under finance information you can see that I have three lines of finance data (3 lines that would go to a customer PO). When this data
Questions about printing a Summary report to PDF
We have two questions about printing a summary report to a PDF file. Firstly, I see that I can adjust all columns to be a specific width. Are there any options to make one column larger than others? For example, we have a weekly notes report. We print
Using CASE in a Query Table
Hi, I'm trying to use a CASE in a Query table, but I'm unable to do it. It should be as simple as: SELECT "FIELD 1", "FIELD 2" CASE WHEN "FIELD 2" = "CASE1" THEN "ABCD" ELSE "WXYZ" END FROM "Potentials" What am I doing wrong or how could i do it? Thank you very much (I'm new at both sql and zoho reports).
Creating custom date ranges in Zoho Analytics report
We want to track our aging inventory based on receipt date. We would like to use a date range not available in the options of Zoho Analytics. We would like to see aged inventory based on receipt date for 3 months or less / 3-6 months / 6-9 months / 9-12
Calculate time on the basis of manipulated/custom time values
Hello there, I have the following requirement: I need to set a start time and an end time based on a condition and calculate the duration in between. Example: If condition A is met ---> Start time = <date> 08:00:00 If condition B is met ---> Start time
Compare two tables over time
I would like to know a proper way to compare two tables over a period of time. In the most basic example: I want a bar chart in the following way: In Y-Axis, the count of distinct records from table 1 Also in Y-Axis, I want the same for table 2. In X-Axis
Tip of the Week: Forecasting with what-if analysis
You make challenging decisions in your business everyday. These decisions, good or bad, determine the future of your business. Good decision-making often involves guess work—you guess the outcome of your actions against various external factors. Wouldn't
How do I delete some tables from an integrated data source?
Is it possible to delete some tables that I don't need from a particular data source or do I have to delete the entire data source? I do not want to do the latter as I need some tables from it but some are not required.
map a key
email = zoho.encryption.urlEncode("email "); workspaceName = zoho.encryption.urlEncode("Book"); viewName = zoho.encryption.urlEncode("Stock_Sum"); paramsMap = Map(); paramsMap.put("ZOHO_ACTION","EXPORT"); paramsMap.put("ZOHO_OUTPUT_FORMAT","JSON"); paramsMap.put("ZOHO_ERROR_FORMAT","JSON");
Zohoanalytics : formula to calculate the number of months between two dates
Hi everybody, I have a report on ZohoAnalytics : In the Column "SOCIAL Ancienneté", I want the number of months between two dates (column B and C) Thanks for your help
Can't set the type to Date / Datetime
Why can't I set the type to Date or Datetime?
New Features rolled out on October 20, 2023
New Chart Type - Tree Map We're thrilled to announce that Zoho Analytics now supports Tree Map visualization. Tree Map helps you to explore your data hierarchically with ease and uncover trends with precision. Click here to learn more. Chart Styling Enhancements
ZOHO API Analytics: Add new record if it not exist, else update row existing
Is possible to add a new record if it does not exist in my table, otherwise update existing record. I'm using ZOHO API Analytics V1. Thanks.
Next Page