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 OnlineWhat'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 dataLooking 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 theCopy 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?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 toUsing 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, SheilaHow 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, AjeePeople - 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 usingShowing % 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 TopSync 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 ratioMerging 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 canEmpty 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 RudyLink 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 in advance for any ideas!How to capture last communication with customer
Hello, We're looking to run a report in Analytics against Desk that will identify the last public comment or the last reply to a customer. Is there a way to extract the last public comment date from tickets as well as the last reply to the contact? ThanksWhere to integrate Price Book and Product List Price
Hello, We sync zoho crm all modules with all data to zoho analytics. In zoho crm, we have "Price Books" and "Products" modules, where each product is assigned to a few price books with different list prices. From zoho crm, I am able to export a datasetHow do I remove a data source from Zoho Analytics?
I am unable to find a delte option on a datasource that i put in the system as an error. On teh web it refers to a setup icon but I do not see that on my interface?How to change a table's Data Source (ex: from MariaDb to MongoDb)?
Hi, I have a table that receives it's data through a Custom Query performed on a MariaDb database and I would like to change the data source to a MongoDb collection (with the exact same columns/fields), but I can't find the option to do this (creatingAnalytics not listening on 8443
Hi I've installed Zoho Analytics on-prem on Windows 10 a couple of times now and everything seems to go to plan and the service runs. I'm leaving the setup on the default port 8443, although I have changed this to try another port. But when I check listeningMissing data rows in Zoho QuickBooks Analytics
Dear All, We seems to be experiencing an issue where we are missing data rows at least one of the tables synced via Zoho Analytics QuickBooks Analytics. The Budget Details, and related Budgets, tables are not synced by default when establishing/settingUrgent: Transferring Zoho Analytics organisation ownership and migrating Workspaces
Hi, we have quite a complicated issue to explain, so please bear with me as we urgently request support on it if anyone can please help us. Our contact at Zoho Analytics is on leave today so I'm really hoping someone here can help with the answer in theirReporting on who booked a meeting
Good afternoon, We're using Analytics to pull data directly from CRM. One of the reports I'm trying to create is a 'Booked By'. In Leads we have a 'Meeting Date' (Date/Time) and 'Booked By' (User) field, which we use to generate a report on all meetingsI want Date Difference in Days
Hi I have a table where i want to calculate TAT from 2 columns one is from the date of submission of document to Claim paid date and another is Date of submission of document to till date. I am unable to achieve it with formula column please help me toReplace Lookup fields ID value with their actual name and adding inormation from subforms
Hi everyone, I wanted to see if someone smarter than me has managed to find any solutions to two problems we have. I will explain both below. To start we are syncing data from Zoho CRM to Zoho Analytics and I will use the Sales Order module when givingQuickbooks Profit & Loss
I wonder if anyone here has experienced any difficulty creating their Profit and Loss report in Zoho Analytics from Quickbooks. At first, I've synced our Invoices, Credit Memos, Journal Entries, and Deposit table along with their line items to createMagento 2 as data source for Analytics
I see that Shopify is in Beta as a data source, any change that Magento 2 is in the works? We currently use Metrilo to parse our eCommerce data for marketing and would love to keep that inside our Zoho ecosystem. Thank you!How can I list all views (tables, queries, etc) related to a single dashboard?
Hi, I was wondering if it is possible to list all files / views related to each of my dashboards so that I can best relocate them in folders.Monthly averages based on "FULL" weeks in month
My data is set for a start day of the week being Monday. I want to pull monthly averages for our events that run on Mondays, Wednesdays, Thursdays and Sundays. The problem I run into is a monthly average for January 2024 runs Monday Jan 1st - WednesdayJoining Two Tables on Multiple Ids
Hello all, I'm guessing there is an obvious solution for this, but definitely not an expert in sql. On our Deals module, we have two user lookup fields. In Analytics, those fields have the user's ids in those table rows, and I'm trying to create a queryWidgets Compare Values
Is there any way to compare 2 columns rather than just the latest and previous based on a date filter. So for example I have Sales Value and Sales Target. As part of the Widget I would like to compare the difference between these 2 based on the Year orReport Data Table in Microsoft Excel or Zoho Sheet
we are built automatically generate po order as per our item qty reorder level etc... in excel sheet prepared for po import in zoho book. I create item-related report in zoho analyst. i was daily report download excel sheet in my folder and this excelPie Chart: Top 10 Values
Hi there. I am creating a pie chart where the sections (the x-axis) each represent a company, and the section sizes (the y-axis) represent the the sum of the respective company's revenue. I have added a filter that only includes the 10 companies withWhat am I doing wrong or is not do able?
I am trying to create a report and group by specific field with a total count. If all I want is a total for the "full name," why is it giving a total for other fields? I would greatly appreciate any help. This is my pivot This is the result;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 theSub Folders
It would be great if there could be sub-folders in reports. We have a ton of individual reports and folders that would be easier to navigate this wayWorking with Monthly averages
Hi everyone! I am trying to work out an issue...our church has a week of Monday through Sunday. I am trying to do averages on our months (which is dicated by Sundays) For example, the first Sunday in February is 2/4, so I want Monday - Sunday to be aCreating a Report using a multi-line text
How do I create a report to determine to distinct count from two columns: (i) a unique ID column and (ii) multi-text column (with a ; delimiter) For example User ID Colour Preferences 1001 Blue; Black 1002 Black; Red I want to create a chart that countsNext Page
Access your files securely from anywhere
New to Zoho LandingPage?
Zoho LandingPage Resources
New to Zoho Survey?
New to Zoho Marketing Plus?
Everything you need to run your marketing
New to Zoho Marketing Plus?
Everything you need to run your marketing
New to Zoho CRM Plus?
Deliver unforgettable customer experiences
New to Zoho CRM Plus?
Deliver unforgettable customer experiences
New to Bigin?
Announcements
[Upcoming Webinar] Power up LinkedIn marketing with Advanced Analytics
Modern businesses are leveraging social media like never before to generate, retain, and expand their customer base while driving revenue. LinkedIn continues to be one of the most preferred marketing platforms for businesses. Based on our interactionsAnnouncing Zoho Analytics 6.0 - An AI Powered Self-Service BI & Analytics Platform!
At Zoho Analytics, our mission is to democratize analytics for everyone. We recognize that team members across an organization rely on data to make both simple and complex decisions every day. These tasks shouldn’t require ongoing support from IT and[Fireside Chat on 6.0] Experience the AI powered self-service BI & Analytics platform
Ballooning data volumes at breakneck speed, expanding data diversity, the increasing importance of data management and governance, and the emerging complexities in analytics—BI vendors and customers are turning to cutting-edge technologies to addressAnnouncing 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 teamWhat'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
Most Discussed Topics
How to create comparison time periods like these examples
In a Pivot Report I would like to be able to select any date range and show a set of metrics for that date range e.g. revenue, orders, units sold. I would then like to be able to compare to the previous period based on the amount of days on the selectedIs it possible to have an Aggregate or a formula data column that only sums subtotals?
So I am trying to make a data columns that would only sum the subtotal. let me explain, I want to sums the hours worked of employes. I also need to split the hours when they reach 40 hours into another column. I can make this work perfectly with formulaMake Widgets Clickable or Copiable
Hi, I created a KPI Widget in Zoho Analytics whose content I would like the users that see my dashboard could copy or click and be redirected elsewhere. Yes, I'm aware I can create a Text Box for that instead of a Widget, but the problem is that the linkSolution of the Week: Financial Reports with Impactful Visuals
Finance reporting is a critical part of understanding an organization’s financial health. With Zoho Analytics, you can easily create dynamic reports such as Balance Sheets, Budget Statements, and Profit and Loss Statements. Now, with the release of ZohoContextual Information when Apply Filters
Hello, Let's say I had a pivot report looking at an "Accounts" table, if I had a user filter to select a specific account. When a user hover overs an individual option in the "Accounts" user filter, is it possible to have a pop-up display with additional
Zoho Developer Community
Zoho DataPrep Resources
Zoho Subscriptions Resources
Zoho CRM コンテンツ
-
オンラインヘルプ
-
Webセミナー
-
機能活用動画
-
よくある質問
-
Ebook
-
-
Zoho Campaigns
- Zoho サービスのWebセミナー
その他のサービス コンテンツ
ご検討中の方
Zoho Sprints Resources
New to Zoho TeamInbox?
Zoho TeamInbox Resources
Zoho Books Resources
Zoho Projects Resources
Qntrl Resources
Zoho CRM Plus Resources
Zoho Campaigns Resources
Migrate to Show’s New Community
A place to share, discuss and stay updated about everything relating to Zoho Show presentations.
Get Started. Write Away!
Writer is a powerful online word processor, designed for collaborative work.
Design. Discuss. Deliver.
Zoho Show Resources
Zoho Creator Resources
Nederlandse Hulpbronnen
Zoho Inventory Resources
Zoho CRM Resources
Sticky Posts
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 teamWhat'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 dataWe are coming to your city! Zoho Analytics Community Meetup
Hello, business leaders and data enthusiasts! We are delighted to announce that registrations are now open for the ZUG meetups, and we can't wait for you to be a part of them. Our in-house analytics experts are geared up to lead discussions on constructingZoho Analytics: 2021 Look Back
As we start a new year in 2022, here's some of our top moments from 2021. Zoho Analytics in 2021[Customer Talk] PREMO Group's Analyst Interview at Zoho Day 2022
Premo Group, a 50 year old Spanish Manufacturing Company, has been our long-standing customer with #ZohoAnalytics. They've been using our platform for their end-to-end, unified business analytics solution. Hear more from Claudio Cabeza, Director at PREMO
Top Contributors
Naresh Kumar K K R
Arthur
Charanya R
Data Sailing
Anitha Rajesh Kumar