Create a live account count
Hi I am new to zoho analytics, trying to make a dashboard which is entirely customisable by date range. I want to create a widget with a count of live accounts. my accounts table has 3 columns which I need to reference. ID, created time, churn date I
How to Duplicate a Dashboard and Point the Duplicated Dashboard to a New/Different Dashboard
Is it possible to duplicate a dashboard view, its reports and point the duplicated dashboard to a new/different dashboard? If so, how do I achieve this?
Can the text data be displayed in the dashboard from a source table (inside a widget or text element?
In a KPI dashboard, wanted to show the customized comment about the filtered user from the source table
Reports and Dashboard required on targets vs achieved -
We have a CRM module that has information about the targets and another module that stores information about the achievements. The target table has the target set for an entire year and has a field called target start date as 1st of April that year. There
Multi Select Filter off comma separated values
Hey friends! I have a query table for a couple of dashboards/ charts. In one of the dashboards, I'm trying to create a multi select filter for the service that is being sold. The way we look at services is by a CRM field titled, "Mail Lead Entities,"
Drill down on Widget Number for underlying Data
I have a dashboard with single number Widgets that when shared the users can't see the "Underlying Data" when they click on them. Am I missing something? Thanks!
Realtime Updates on Zoho Analytics
Hello, I'd like to ask, how do I do a real-time update on Zoho Analytics for query tables? Kindly advise.
CRM fields not showing up in Zoho Analytics
We are using Zoho CRM + Analytics to run a student support program, and we are trying to build out basic reports in Analytics about this program. We keep encountering a problem where important fields do not show up in Analytics even though they are checking
Zoho Analytics - Deleted records are also showing
Hi, in Zoho Analytics, we've set up a form in Zoho Creator and synced both data sources. We’ve also created some reports and dashboards based on this data. However, deleted records are still appearing in Zoho Analytics. What should be done to resolve
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?
How to filter by null values
Is there a way to filter a widget by null? I want to get a list of records that don't have a date filled in and can't seem to see how without going through a query. Is it possible to do it through the widget filters? Thanks.
Tracking History of Picklist Values - how to get data in Zoho Analytics
Hello! I've read that now I can Enable picklist history tracking in Zoho CRM (https://help.zoho.com/portal/en/kb/crm/customize-crm-account/customizing-fields/articles/picklist-history) That is exactly what I need to monitor leads status changing. However
Drill Down - Pivot Table
Is there anyway to have drill down options in pivot tables like in the chart function?
Zoho Resource Usage Dashboard
Hello, I would love to know if there would be a dashboard that I can build or that is readily available in Zoho Analytics to track the resource usage of our tables. Information like Who created which tables, how big they are and how fast they are growing
Message "...does not support more than 100 distinct values..." WHY????
I get this message on one of my reports: Sorry, Zoho Reports currently does not support more than 100 distinct values in columns. 'Account Name * Sum(Amount),Count(Amount Tier)' contains more than 100 distinct values. Possibly, you can apply filter to reduce the number of distinct values in 'Account Name' or drop the 'Account Name' field in Rows. I want to list all ACCOUNT NAMES (about 500) with SALES BY ACCOUNT. What is blocking this?
Everything is gone!
I set up Zoho Analytics over a year ago to pull data from Excel spreadsheets that are saved to my onedrive. I created reports that calculated scores based on the data and then dashboards to display these results. It took a long time to set up. I run these
Hiding Empty Reports in Dashboard
I'd like to create a dashboard which summarizes all information related to an individual. As an example let's say there are 20 tables each with 1000 rows, person X appears in 5 of those tables. I've learned how to setup the dashboard with a url filter
Tooltip/ Explanation text on KPI Widget
Greetings! I have a report with multiples KPI widgets and I want to include a tooltip with a small text with an explanation of what that KPI means and where that value comes from. Is it possible? If not, there a way to explain to the final user the meaning
Zoho Projects Work Hours into Analytics
Since the most recent update, my Analytics reports that were comparing Zoho Projects Work Hours (estimate) against Timesheet Hours are gone. They were actually deleted. When I try to recreate them in Analytics there is no "Work Hours" field. Where
Balance Sheet and Trial Balance in Analytics Books Sample Not Balancing
I have connected Analytics to Books and when view the TB and Balance Sheet reports they are not in balance
Tip of the Week - Split Columns in Zoho Analytics Table
Want to split a column containing distinct values into multiple columns in your Zoho Analytics table? The below video demonstrates how you can split columns in a Zoho Analytics table.
Zoho analytics two column LookUp
If i have two tables that need to be joined matching two values from each table, lets say Columns 1 and 2 on both table. If i set in one table two lookups to the same table will it work? Or would I need to create a query table like so: SELECT Table1.[Columns]
Anypone document a jdbc for databricks connection?
It seems it takes hours to find a fix to every problem and once I find a fix there is a new issue, have not even gotten data into Zoho yet and there is no documentation on the topic. Anyone attempt to connect to databricks using a jdbc driver and have
Announcing Zoho Analytics 6.0 Beta!
We are delighted to open up the next major version, Zoho Analytics 6.0 Beta! The new version comes packed with a wide range of functionalities for all persona, namely business users, data analysts, data engineers, and data scientists. Zoho Analytics team
Need a working ODBC/JDBC driver to get Zoho Data into Crrystal Reports XI
Need a working ODBC/JDBC driver to get Zoho Data into Crystal Reports XI William
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.
Constant color of a legend value
It would be nice if we can set a constant color/pattern to a value when creating a chart. We would often use the same value in different graph options and I always have to copy the color that we've set to a certain value from a previous graph to make
Duplicate dropdown items
When there are duplicates in the dropdown items, selection isn't working properly. I've added attachment for your reference.
Create a race chart to show phase changes over time?
I would like to create a race chart showing the different phases an Account has been over time. Is it possible to do this with Zoho Analytics? If so, what do I put in the different fields: X, Y, colour, text, size, and the data (actual value, count, distinct
Create lookup between two module is not allowed
Hi , May I ask what is this msg means for?
How do I create a report for emails sent out
I want to create a report that shows the emails that were sent out to Leads. I see it can be done with Call but not with Emails. Any help? Thanks
Z Books Inventory Balance
I am trying to prepare a list of the stock on hand for each item and looking for the table in Books that contains this information
zoho analytics
Good day, Zoho team. I would like your help to find out if anyone, when creating a dashboard, can separate the chart by owner. In other words, can each owner have their own metric in the dashboard, or can it only be generated as a whole? I greatly appreciate
"The above query cannot be saved, a maximum of 3 levels of Query over Query tables only allowed."
Did this ever get fixed? Since we can't nest select functions, I need to do different group by clauses in separate queries to get data into one table. For example, I need the 6mo aggregate average and another calculation to get another number based on
Failed Sync Shopify Data Source
Since last tuesday im having some troubles with the Shopify Data source as it won't sync properly, leading every attempt to a failed sync.
Last sync time of a data source.
Hello, Is there a way to show last sync time of a data source in a report or a dashboard? also, is anyone facing shopify sync issue constantly.
Single Zoho Analytics connection to multiple QB Online Accounts
We have a requirement from Bookkeeping firm using Zoho Analytics to fetch data from multiple client QB Online accounts using single Zoho Analytics Account. Can you please confirm if single Zoho Analytics Account datasource can connect to multiple QB Online
What's New in Zoho Analytics - August 2024
Hello Users! We are back with the latest updates and enhancements made to Zoho Analytics. Keep reading to learn more about them. Connect to the data hosted in the cloud without allow-listing the IP addresses Utilize Zoho Databridge to connect to the data
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
Copy Widget to another Dashboard
I can see the option to clone a widget to the same dashboard but is it possible to copy it to another dashboard?
Next Page