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 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 RudyHow 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 countsHow to make LAG function work?
The Add Formula column modal shows that Lag, Lead, etc. window functions are available. When I try to add the formula as lag( MAX("Date"), 1), it gives this error: Please use aggregate formula option to create aggregate formula. But the function descriptionChart showing Age in Months for each month
Hello. I have a Client record with a field for Date of Most Recent Enquiry (RecentDate). I want to track the number of clients with RecentDate between 12-24 months each month. So I can see, for example, in May 24 we had 1000 Clients aged 12-24 months,Frequent Zoho Analytics Sync Failures
Analytics sync is continuing to frequently fail - every 2 or 3 days we'll have a sync failure with unhelpful messages like this: When you try a manual sync on the failed table it typically says "sync already in process" even though it's clearly erroredKPI Widget - last month sales vs same period last year
I would like a KPI Widget that might compare data with the following date ranges: This month to date (meaning all of February through the current date, for example the 14th, if today was the 14th. So Feb 1-14th 2018)vs. last year this month to date (ShowingTip of the Week - Geo Chart from Text Column
When your dataset contains geographical data columns (continent, country, county, state or city), Zoho Analytics automatically sets them to the corresponding Geo data type. However, there may be cases where the auto-identification may not happen. Like when too many data values are mis-spelt, or are empty, the Geo column may get identified as a Text column. You can still use the Text column and specify it as Geo data type in the Chart editor. The following animation explains how this is done (creatingwarehouse level inventory valuation
Currently i have multiple warehouses in an organisation. When i select inventory valuation, i can view organisation level valuation. But i would like to filter it down to warehouse level inventory valuation. I was informed that i can create custom reportsERROR DECLARING DATEFORMAT IN ZOHO ANALYTICS
I am using the Zoho Analytics API (https://www.zoho.com/analytics/api/v2/data-api/add-row.html) and, as mentioned in the documentation, to record date and time data, the data must be formatted if you want to store it in a custom format. By default, theYear to date comparisons in widgets
Hi, I want to know how to configure a widget to compare a metric's current value against its value in the previous year (at the same day/month point of time). For example, cumulative revenue from Jan 1st to June 20th 2024 compared to the same period lastGoogle Calendar Integration
Is it possible to Integrate the Google Calendar data with Zoho Analytics? If yes Kindly Provide the Solution.[Upcoming Webinar] Fostering a data-first culture with enterprise analytics
Businesses today are fully aware of the importance of being data-driven, and there are countless companies catering to their needs. Technology and software vendors, specialized management firms, and more enable businesses to set up and maintain theirNext Page
Announcements
[Product Update] Deprecation of 'Inbound Transport Details' module in Zoho Analytics - Amazon Seller Central integration
Dear Customers, Please be informed that the Amazon Seller Central will be deprecating the 'Inbound Transport Details' module APIs effective December 20, 2024. As a result, this module will no longer be supported in the Amazon Seller Central - Zoho Analytics[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 team
Most Discussed Topics
Zoho Analytics: Requests for view access
Hello, We have a user that might request access to a certain view, report etc. However this request for access is being sent to different admins within the workspace, is is possible to set who the "approver" is of these requests? If not what are the rulesDouble Value in KPI - Zoho Analytics
Hi Team, I tried to implement this in Zoho Analytics but couldn't figure it out. Here's the scenario: I want to display the total number of tickets created, along with the count of closed and in-progress tickets, all in a single KPI. How can I achieveZoho Analytics Pivot Table - How to compare month vs last year same month
Hi, I had created a pivot table with setup as below: Column: - Delivery Date Row: - Customer Group Data as column - Total amount (sum > normal) (show data of the month) - Total amount (sum > % difference from previous value) (compare between this monthHow to suppress display of "USD" of currency field?
Cohort - Zoho Analytics
I am developing a cohort analysis in Zoho Analytics for Tickets/Service Desk, which tracks the number of tickets created each month and when those tickets were closed. I have added a user filter for classification. When I change the classification using
Zoho Subscriptions Resources
Zoho CRM コンテンツ
-
オンラインヘルプ
-
Webセミナー
-
機能活用動画
-
よくある質問
-
Ebook
-
-
Zoho Campaigns
- Zoho サービスのWebセミナー
その他のサービス コンテンツ
ご検討中の方
Zoho Sprints Resources
Zoho Books Resources
Zoho Projects Resources
Zoho Orchestly Resources
Zoho CRM Plus Resources
Zoho Campaigns Resources
Zoho WorkDrive 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.
Zoho Creator 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
Anitha Rajesh Kumar
Bhuvaneshwaran
Arthur
Charanya R