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
Calls module deleted on CRM, Sync Failures on Zoho Analytics
Recently the calls and meetings module was removed on crm side. Since it was removed, our zoho analytics sync is resulting in failures. I tried removing calls and meetings from the data sources edit setup menu but neither of them show up. Do I need to
Using Conditional Formatting in a Pivot Table (Zoho Reports)
Hi When will Conditional Formatting be available on Pivot Tables? Also, will we be able to format a column by comparing it to a value in another column e.g. If Service Level >= Target, Then GREEN Else RED Thanks, Sheila
How to capture the agent details first responded in chat
Hello, We're looking to run a report in Analytics against Desk that will identify the agent who responded first to a customer in Chat. Is there a way to extract these details from the tables linked from Desk to Analytics? Thanks for any advice, Ajee
People - Leave Tracker
I need to create a report that contains the leave tracker of the people in Zoho Analytics, but when integrating People I do not see the table with the information.
How to match colors for same label names in different charts on the same dashboard?
Hi, I'm having trouble with matching colors between two pie charts on the same dashboard. The issue is that I would like both charts to use the same colors for the same label names ("books", "crm_and_desk", etc), but I'm not able to do so neither using
Showing % of total share for top ten buyers
Hi Guys I am trying to generate a report for Top 10 buyers and using the default Top 10 filter. But when I try sum > % of total, it only considers share among the top 10. I want to show the buyer's share of the total amount sold E.g. Total Sales: 1M Top
Sync failing with AWS RDS Aurora
Previously working sync is now often failing with the error: All is fine at the AWS end - maybe Zoho Analytics can't work with AWS anymore?
Dashboard last time refresh indicator
I have some dashboards open all day on the browser, and I refresh them several times on the day. It would be great to know when the dashboard was last refresh. Maybe we could have a widget that, when the dashboard is refresh, the widget get and display the time (a fixed time, not a clock), so we could have a "Last Time Refresh" indicator on the dashboard.
Performing calculations with data in widgets
Hi there, I would like to know if it is possible to create custom summary widgets that rely on aggregate data from columns. For example, I want to calculate the ratio of qualified leads to sales, so if I have 40 sales and 400 qualified leads, the ratio
Merging 2 columns
Hi, I would like to merge two columns together (in the same table). One is a date type column and the other is a number type column.
How to show 2 date fields on the same line chart?
I have a projects table. The table has 2 date fields. One for when the task is started and one for when the task is completed. I want to show the total for each date field per year month. It works if I put one of them in the X-axis but I obviously can
Empty Cells and line counts
Good day, How can I present cells with no value\empty blank? When i have a total is there a way to hide the individual line count "1" and only show the total Thanks Rudy
Next Page