Report of Week - Customer Preferred Brands over Finance Data
People tend to choose a few brands over the other. The popularity of the brand or the quality attached to it makes consumers gravitate toward the brand names. Understanding the customers' purchase behavior and measuring their brand preference is vitalAlternative approach to correlated sub queries
We are using Zoho Analytics with data from Xero, we wish to show the bank account balances per day, charted over 30 days. To do this we need the sum of all account transactions to date grouped by account and day. How can I achieve this? I would normallyReporting on Multi Picklists from CRM
Hi, I have a multi picklist within the accounts module, for this example called "Previous_Attendance" which has fields such as MAN22,LON22,BIR22,DUB22,MAN21 - when I put this into analytics it reports them as I've jsut written, I want to be able to reportHow to get module remarks in zoho Analytics?
Hello I need help. I want to analyze module remarks in analytics. But I can't identify the remarks data table in the import settings in analytics. I thank you in advance. CAMARABLANK values from no transaction data
Hi all, Having an issue with what should be a seemingly easy report, but keep coming up against roadblocks. Hoping someone has troubleshooted this. Goal is to have an easy, quick glance report for Buyers/Sales of a full list of inventory: "Item", "ItemCan I amortise revenue / cost by month in Query Table
Hello, I conduct revenue and cost comparison usually in excel. I would like to know if I can achieve the following transformation within zoho analytics query table: From this table: ++++++++++++++++++++++++++++++++ Item MRR Start Month8542 Error code in Zoho analytics API
In a single firebase cloud function, I want to fetch data from two different tables, but when I hit zoho analytics API using Zoho analytic's Nodejs client library, I get error as, { "errorCode": 8542, "errorMessage": "Unknown JSON attribute(s) found inGet Baseline Data Zoho Analytics
HOW I CAN GET THE Baseline Data of project in Zoho Analytics.. currently. Baseline Data missing from Zoho Analytics milestone table.New Features rolled out on November 22, 2022
Support for Zoho Cliq To enable easy collaboration among the members of the organization, we have now integrated Zoho Cliq messaging service in Zoho Analytics. You can also create a Cliq group for each of your Workspace Groups. Click here to learn more.Joining Two Tables - Error says "Same display columns presents in multiple tables..."
I am trying to write a query, but also join two tables to extract two columns from a different table The query below works perfectly without the "JOIN" at the bottom. My goal with the join is to join "Eagle_AllHoursReport" table to "Eagle_SAP_PlanHours"[Upcoming Webinar] Automate your data pipeline and time to insight with a modern BI platform
Hi there! Businesses worldwide, small and large alike, are rapidly adopting automation across their workflows. Automation has become a key enabler to transform regular tasks into value adds for businesses, helping them focus more on revenue generation.[Blog] Delivering embedded analytics for ISVs with Zoho Analytics
When it comes to independent software vendors (ISVs) providing analytics to their customers, the question of “build vs. buy” isn’t as relevant as it was before. A recent study shows that 75% of ISVs prefer to embed an analytics platform rather than buildingImprove data sources/Data model diagram
It would be nice to have an exportable version of the data model diagram, either in PDF or in some tool like visual paradigm. ¿Why? When I have meetings with my developers/management, we find the model really useful, however, we keep taking screenshots for making notes or to highlight new ideas. Are there any plans to enhance this?Can we make the values of unselected options greyed out when applying user filter?
I'm trying to compare the costs of different products. When I apply user filter to choose one product, only the cost of the selected product keeps. I can't just exempt the filter because I have hundreds of products and I have to set a upper limitationHelp with KPI Widget for Stage History (CRM)
I am a Zoho Partner, and I have a client that needs an Analytics Dashboard Widget that will display all Deals that were in "Proposal Sent" stage in the last 365 days. The problem is that some of the Deals entered that stage twice and are duplicatingReport Data and Widgets Not Showing Latest Data
Starting on October 28, some Zoho Analytics reports and Widgets have stopped updating to show the correct values from the underlying data and tables. I spoke to Zoho One support that day and after much review they determined in was 'a server caching issue'Export Limit for exporting data to PDF
Hello, I use Zoho Analytics to create payroll charts for my commission-based business. When I am sending out employee checks, I like to send them a PDF of the different services performed that make up their paycheck. I do this by viewing each employee'sEmbedding a Zoho Analytics view into Creator with user-based criteria
I have a Creator app where organisations can track projects for groups of young people. I want to report back to them a nice set of stats about the impact of their projects and the young people's demographics, so I have created a dashboard in Zoho Analytics,Error import: Not even one column name match with the header data in file. Check your file data.
Hi, in the last synchronization it has failed in 4 tables. The error I get is: "Not even one column name match with the header data in file. Check your file data." So far it had worked fine. I have deleted the data table, changed the import settings,Using Wildcard filtering with other filters
Looking for a solution and hoping you pros can help. I am trying to exclude certain users from our reporting: 1) Users whose email address contains one of (6) words (e.g, test, givmail) 2) Users who are a member of our Partner or Internal accounts. TheProtect view via token or URL encoded password
HI, I want to know if this is possible please? I have a View in Zoho Analytics that I do not want to be publicly accessible, but I do want someone with the correct URL to be able to access it without a password. This sounds like nonsense, but hear meDifferences between Books and Analytics that make a client go crazy
see linked video https://workdrive.zohoexternal.com/external/8e09b8a34e3bccbdebc9a92bf9bbd07eaccb4fbf13e4c2298ccbca38ce1aa96b📢[Analyst Talk]: Zoho Analytics continues to be a leader in BARC Research's latest survey
BARC Research's latest BI & Analytics Survey 23 is based on findings from the world‘s largest and most comprehensive survey of business intelligence end users. The BI & Analytics Survey 23 examines user feedback on BI product selection and usage acrossEvent performance measuring
Hi all, I'm re- building reports and dashboards in my org to measure event performance from our salesforce. We obviously take in account sales activities (meetings, calls and tasks) and amount of won deals and revenue as key metrics. My question wouldAverage below the 95th Percentile
Hi, If i have numbers 0 through 100, the 95th percentile would be 95.9, so number 96->100 are above the 95th percentile. I would like to exclude everything above 95th percentile and get the average for 0->95.9 which should be 47.5. In excel its easy,Why is Billing Type a decision box instead of a dropdown menu?
Hello, I've come across a problem. I am making reports in Analytics with data from Zoho Desk. The problem is that when I look up tickets in desk I can see 3 different billing types (Billable, Non-billable and Invoiced) but in Analytics this changes toMulti currency support in zoho books analytics
Greetings Zoho books shows reports only in the base currency of the organizations and there is no way to change the report currency to another like the client country's currency for example..i was wondering if analytics provides a feature as such to changeCombining values from same column
Hi there, I'm wondering if it is possible in Zoho Analytics to combine values from the same column together into a new column. We have a classifications column from our Zoho Desk ticket data and there is several classifications of different types of complaints[Upcoming Webinar] Unified data management and analytics - An essential need for today's businesses.
Hi there! BI and analytics enable businesses to gain deep insights, drive strategic growth, and sustain their competitive edge in dynamic market conditions. Having become imperative, BI and analytics are being adopted by more and more businesses acrossImport data from Zoho Analytics to CRM
Hello, we are connecting several data source to Zoho Analytics. Is there a way to import these data inside the CRM? Example: import data from multiple Campaigns portals to Analytics and then import them from Analytics to Zoho CRM contacts (so we can seeProblem Connecting Google Analytics Data Source.
Hi, all. So I am trying to connect Google Analytics data source to Zoho Analytics workspace. The problem I am facing is that when I authenticate Google Analytics on Zoho, it only shows me the red-circled view. It does not show the other properties, thisFirst item as default filter value
In a dashboard is there a way to set a default value of a user filter to the first item in the filter list? This way there is always some value selected when the dashboard is loaded. I cannot rely on setting the value statically because the values inZoho Anayltics very slow today
We are finding Analytics very very slow today.... so much so it is practically unusable! Dashboards have been either showing as a blank page or taking an age to load....and once loaded buffer for an age when a filter is applied. Can you advise if thiscolumn width limit 100
Hi, Could the column width limit be increased to 254. When I import data via a csv it seems to accept the data beyond 100, but when I edit it it reports an error when I try and save. CheersLookup Column on Imported Data
I am trying to link various tables using the date field as the lookup on data imported from Zoho Creator however no results are shown when I click to convert. The option does show on manually entered data.[BLOG] What is a KPI Dashboard? Examples, Templates, and Benefits
Effective decisions can be made using insights from data. But what are all the different data sources you refer to when you want to make decisions for your business? The more data sources you havethe more time it consumes and the less efficient the decisionsUser Group member search
Dear Team, I'm starting to create user groups, in each group I will have 2 - 15/25 Members. Could you please integrate the Member search option? So that I can find out much faster in which user group a certain member is in. Or at least, if I hover overHow do I set my Analytics Workspace as Shared
I added a new workspace for Zoho PEOPLE to my Analytics Workspaces. A previous ADMIN had added other workspaces which all show as SHARED. How do I SHARE the PEOPLE workspace which currently is listed as Owned rather than Shared TIA GregEmail schedule not sending emails
Hi Since yesterday my programmed emails are not getting sent, any idea perhaps? Thanks!Numeric field as User Filter not working
I'm trying to use actual values of a numeric column called "Long-Term Debt" as a user filter (slider option) but the slider wouldn't show any values. Last week, I've walked Zoho Reports support through this problem via online chat but am yet to receive any response. Below are relevant screen grabs again for your reference.Next 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 linkContextual 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 additionalHow can I find invisible characters in my Deals table?
Hi, I'm using Zoho Analytics to investigate some formatting issues we've come across in our Deals from Zoho CRM and it seems that something's wrong with some of our records. Although we defined a global set to pick from in our "Lead Channel" picklist,
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
Data Sailing
Anitha Rajesh Kumar
Will Young