Importing Google Sheet - date format problems
I have a Google Sheet with a "Date" column and its format is set to yyyy-MM-dd. When I create a table in Zoho Analytics and import this sheet, the preview screen shows the Date column format as "dd MMM yyyy HH:mm:ss" (e.g., 28 Sep 2023 00:00:00). When
Changing Ownership of Zoho Analytics
How do I change the owner of Zoho Analytics
[Webinar Announcement] Transforming raw data into actionable insights using data visualization
Are you looking to maximize the impact of your data insights through effective data visualization practices? Look no further than our upcoming webinar on the best practices for visualizing data with a modern BI platform. In this webinar, we'll cover how
Access Data Source from Another Workspace
If there a way to use data or a query from another workspace in Zoho Analytics? Thanks Simon
Plot a count of records during a date range
Hi all, I am far from a SQL expert, but this feels doable and I just don't know how. If I had a table that looked something like Stage History.. Record Id Start Date End Date Stage Duration (Days) 11111 10/01/2020 10/21/2020 Needs Analysis 20 11112 09/20/2020
Report: Show data based on changes over last time period? Ex: This month to date vs. Last month to date
This might be a complex question, but I was curious if it is possible to do the following: 1) I would like a chart that can compare data with the following date ranges. This month to date (meaning all of November through the current date, for example
Query doesn't refresh if subquery value change
Hi Zoho People, I run through a simple problem of a query not being refreshed. I have a table called "Params" with a column "Mois". The table has a unique row with the value of say "8". I have written this Query statement : SELECT "Date", "Qui", "Jour" , count(1) 'Nb Vis' FROM "Visites" where month("Date") = (select "Mois" from "Params") group by "Jour", "Qui" This statement runs without problems and reports all rows whose date is the 8th month. If I update the table "Params", changing the value
Multiple Left Joins Causing Duplication of Data
In Zoho Analytics I have an SQL Query that has multiple Left Joins. These Left Joins are causing some duplication of data, which for the most part is okay, as I can use a distinct count to collect data between certain things. I am trying to display some
Market Basket Analysis
Has anyone successfully done any market basket analysis / measuring product lifts in Zoho analytics and if so, how did you do it?
[Product Update] Changes to Zoho Analytics Integration with X (formerly Twitter)
Dear Customers, We would like to inform you about some upcoming changes to our integration with X (formerly Twitter). As X has requested all users to migrate from Version 1 to Version 2 of their APIs, we are revamping the Zoho Analytics integration with
Joining the same table several times?
Hello there, a (Zoho CRM) table is given with, among other things, two columns that have a company ID. The base table therefore points twice to the company table. I have set up the lookups accordingly. Base table with "CRM_Unternehmen_ID" und "CRM_übergeordnetes_Unternehmen_ID":
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
[Upcoming Webinar with Industry Analyst] GenAI in BI
In today's BI and analytics landscape, data reigns supreme, and AI is transforming the way businesses derive value from raw data. Of all the facets of AI, GenAI is further democratizing BI, enabling businesses to build a more sustainable and scalable
Zoho CRM Sales Orders and Products -> Report which products are sold in a period
Hi, How can I create a report (in CRM or Zoho Reports) in which I can use Sales Orders and the Products registered on those orders. It looks like there is no link between the 2 tables in the database while in CRM it's presented as there should be a link between the tables. Anybody any idea how I can combine these 2 tables so I can use them for reporting? Thanks Frank
Row size exceeded the allowed limit.
We have been uploading data to a Zoho Analytics dashboard using a very simple pipe, OneDrive with an Excel doc. Since today we are unable to update the set, and get the error "row size exceeded the allowed limit." Assuming they meant the data allowance
Automatic Left Aligment for Formulated Column in Pivot Table
HI, From last 3 days, all the pivot table where we created a column with formula is automatically setting left alignment and very hard to change to right aligment. some time it take morethan 10 attement to change the format in setting option to but fail
Sort/Filtering on List of Import Tables (Data Sources)
I would like to see at least some sorting (filtering would be nice too) in the 'Data Sources' tab, on any given data source, where you are provided a grid of your imported/synced tables. This would make sync troubleshooting and analysis much easier.
Zoho Campaigns Not Syncing in Analytics
I am trying to sync Zoho Campaign data to Zoho Analytics and when I hit sync now it just says 'Sync in process' and has been doing so for almost a day now. Can someone help me fix this issue?
Adding variables to a formula column
I have records that have a start date, end date, and funding for a year rate. I am trying to write a formula that will read how long the record was active in months and give me the rate for that period. The only thing is, if the start date happens on
Simple MTD forecast in KPI Widget
I want to display, in a KPI widget, a simple forecast of the current month of sales. To get this forecasted number, I need to divide the current MTD sales by the number of business days elapsed in the current month, then multiply that by the total number
Comparison; This month current sales vs. Last Month Cumulative sales
I would like a Widget/Chart that can compare data with the following date ranges. This month to date (meaning all of September through the current date, for example the 14th, if today was the 14th. So Sep 1-14th)vs. last month to date (Showing August 1st to 14th) It would be great if could provide some sample widgets.
How to filter by a distant relative range?
We are coming from Salesforce where we can filter by the 3rd last relative month doing: Example 1: Close date = Last 3 months & Close date <> Last 2 months Example 2 (last 7th quarter): Custom date = Last 7 quarters & Custom date <> Last 6 months can
Change name of column
Need to be able to change the name of a column when it is already being used in a chart/report.
Better way to update field name in data query and dependent reports.
I want to rename a field in a data query. That's not a problem by itself but I am not allowed to rename and save if that field is used in any other reports. The only way I found so far was to MANUALLY add the field again with a new name, MANUALLY edit
IF (formula Zoho Analytics)
Is there any way to create an "IF" condition that can search between two values, for example: >30 but <40, or something that can say "between these two numbers" to condition a field? In Excel, it exists, but in Zoho, the logic doesn't work the same way.
Reporting on multi-select picklist data
I'm wondering how others have solved this problem: My company has a number of "strategic goals" that we attach to various potentials as they come in. So, a potential can tick off none, one, or more than one of these as it moves through the pipeline. Let's call them by fruit names: Apple, Banana, Cherry, Durian. The data then appear as a comma separated list in the field for that question. Potential Name Strategic Goal Potential 1 Apple, Banana Potential 2 Banana,
JVM error when executing Zoho Databridge for first time (Windows Server 2019)
Hi, I have followed the guide defined here https://help.zoho.com/portal/en/kb/analytics/user-guide/import-connect-to-data/relational-databases/articles/zoho-databridge#4_Can_I_independently_download_Zoho_Databridge in order to install the Databridge (it's
Change Currency in reports
New to Zoho and starting to get my head round everything, so far I am very impressed and can't wait to get fluent. I apologise if I am being stupid but is it possible to change the currency in a report. In my main forms it shows as GBP (£) but in the reports I generate showing client spend etc it is all shown in USD ($) if someone could point me in the right direction I would appreciate it.
Date Column Import Failed from MySQL DB
I am trying to import some tables and they all seem to have the same issue with the date format. It is a MySQL 8 DB in DigitalOcean and in the database the date is stored in this format YYYY-MM-DD, However when attempting to import the preview screen
Show picklist options in alphabetical order
Hi, How can I show my picklist options in alphabetical order? In Zoho Analytics, the order of the labels is wrong. The correct order should be Correcties; Factuur; Verlof uren
New Features rolled out on Feb 26, 2024
Advanced Analytics Connector for Pipedrive You can now seamlessly import Pipedrive data into Zoho Analytics to gain enhanced insights. Attain a comprehensive understanding of your business processes, optimize sales strategies with detailed insights, and
Zoho Desk custom fields
Our organization uses Zoho Desk and is testing Zoho Analytics as a solution for more advanced reporting. We set up a connection to Zoho Desk, which appears to be mostly working, but none of our Desk custom fields are visible. Is there a setting in either Zoho Analytics or Zoho Desk to make the custom fields available for reporting? All the existing questions on this topic I've been able to find are specific to Zoho CRM, which our organization doesn't use.
Combining data from Zoho Books, Zoho Projects and Zoho CRM
Hi team is it possible to generate a report with a table that contains: - From Zoho CRM: - Client name - Opportunity name - Sales stage - Amount - From Zoho Projects: - Project name - regarding client A - Project stage
Changing summer time on table time
Hi we have a table containing several data, including a column with a date and time (in this format 2023-02-17∙08:40:56.000). I need to add an hour (+1 hour) to some cells, those of the period between march and october, but I cant find how to do. I usually
How to verify if a chart is used in some dashboard
Please add a feature to check for each chart, if it is used on some dashboard. This would be useful, when you have hundreds of charts and you want to delete some of them without affecting your dashboards, thanks! Best regards, Juan
Two items on X axis
Hi How do I get two values onto the x axis, say for excample I would like to see sales totals broken down by year and rep?
Splitting Data in a Reports Table
Hi, I am working with a phone log which is provided to us automatically by a third party. The Date field for the phone log includes the date and also the time stamp of when a call was initiated. I would like to analyse trends relating to the time when calls are made. However this is difficult to do as both values are in the same cell. What I would like to do is configure Zoho Reports to split the data or copy part of the data into a new column. I have successfully copied the data in the Date column
How to Create this Table using SQL Table
Thanks for hosting such an informative forum and helping community. I want to create following data table using SQL Table option, I am struggling to find the correct SQL codes for leads module. Lead Source Total Leads Total Appt Set Facebook 1000 15 Google
Unified Business Analytics - An essential step to business success
With exponential data growth today, a commonly pursued objective among businesses is Unified Business Analytics. This allows businesses to bring all their data to one place, build smart data models, and analyze data across domains—highlighting the cross-functional
Display Weight symbols to Values in a Widget
Hi there, I was wondering if there is a way to display weight symbols, similar to how you format units as in the screen shot for this widget: Want to show Weight with Metric units: Grams = g Kilograms = kg Tonnes = t etc. Thanks Andrew
Next Page