Reporting 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 reportAlternative 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 normallyGet 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.Line Chart - Do not draw lines between zero values?
Is it possible to skip drawing the lines between two data points (represented by dates) when the value is 'zero' between those dates? I also do not want 'zero' to be plotted (do not use "Show Missing Values"). Example of how I want the line chart toContinuous failed Sync of a Data Source
I have had a Data Source set up in my Zoho Analytics workspace for a long time, but recently it has been failing every scheduled time. I don't remember exactly when it started, but I think it was about a month ago. The details of the failed Sync are alwaysNew 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.Editing data sources as workspace admin?
Hi there, is there any way to allow workspace admins to edit data sources? I am a primary user of the account (across two workspaces), but not the account admin, so whenever I need to change import settings for data sources, I need to contact the account admin first and wait until they make the changes I asked for. This is very frustrating and time consuming. Please advise! Thanks, GerickeHow 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. CAMARA[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?Filter Widget on user
Hello, I shared a dashboard with users so that they only see their own data in that dashboard by: "New visit report"."Visit report owner" = ${system.login.fullname}. This data comes from our application "Visit Reports". But the 3rd widget in the dashboardZoho Analytics: Email schedule - dynamic filename
Hello, we have to send reports to our customers every day. The file names must therefore be dynamically structured (name including date) so that they can be easily saved, otherwise the customer has to rename them - not acceptable. Is there a solutionCan 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 limitationConstant 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 it constant. It would be nice if we can set that values color constant whenever we'll be using it. Example: Table: Sales table Salesperson: James, John, Jessica Bar graph: count of sales by salesperson (James - blue, Jessica - green, John - yellow).Help 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 duplicating8542 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 inBLANK 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 MonthReport 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'sIntegrating with the Google Play Store Console & Apple App Store
Has anyone integrated their Zoho Analytics Workspace with the app stores? We have a mobile app and I would like to be able to display the number of downloads, updates, and other statistics from the two app stores next to each other in Zoho Analytics.Embedding 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 meZoho Analytics integration with new Google Analytics 4
Hi, We recently migrated our website to a new ecommerce platform and started using the new Google Analytics 4 service (the new ID is G-xxx instead of UA-xxx). When we tried to add the data source of Google Analytics, it is only displaying our old UA-xxxHow can I calculate the physical stock available for sale?
Hey Zoho Team, I've tried to calculate the physical stock on hand in various ways - but always receive a mismatch between what's displayed in Zoho Inventory & analytics. Can you please let me know how the physical stock available for sale is calculated?Differences 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 acrossReport of the Week - Stage Analysis
Potential stage history analysis helps you track the stage movement of each potential. Tracking the wins and fails helps you avoid repeating the mistakes of the past and define better processes to convert more potentials into wins. This week, let'sGoogle Ads Data Source - Full Conversion Window
For our Google Ads account, we have a 30-day conversion attribution window. Using the built-in data source of Google Ads does not seem to accurately sync this. I presume the issue is that conversions that happen after a given day's data has already beenEvent 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 seeNext Page
Announcements
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.[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 building[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 across[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 decisions
Zoho Pagesense Resources
Zoho DataPrep Resources
Zoho CRM Resources
Zoho Subscriptions Resources
ご検討中の方
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
Zoho Desk 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.
Design. Discuss. Deliver.
Zoho Show Resources
Zoho Creator Resources
Nederlandse Hulpbronnen
Most Discussed Topics
Line Chart - Do not draw lines between zero values?
Is it possible to skip drawing the lines between two data points (represented by dates) when the value is 'zero' between those dates? I also do not want 'zero' to be plotted (do not use "Show Missing Values"). Example of how I want the line chart toZoho Analytics: Email schedule - dynamic filename
Hello, we have to send reports to our customers every day. The file names must therefore be dynamically structured (name including date) so that they can be easily saved, otherwise the customer has to rename them - not acceptable. Is there a solutionReport 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'BLANK 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", "ItemCombining 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
Sticky Posts
Zoho Analytics | Quarterly Newsletter | Q3 2022
Hello Everyone! We hope all of you are safe and well! Zoho Analytics - Q3 Quarterly Newsletter is out! Check out the newsletter (attachment) to know all about our new features, recognitions, webinars, blogs, and many more exciting things. Do let us know[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 PREMOAnnouncing Zoho Analytics 5.0 -- A Modern Self-service BI & Analytics Platform
We are extremely delighted to unveil Zoho Analytics 5.0 - A Modern Self-service BI and Analytics platform to the public. Experience analytics like never before with the following new capabilities and enhancements: Comprehensive AI-Powered Data PreparationZoho Analytics | Quarterly Newsletter | Q2 2022
Hello Everyone! I hope all of you are safe and well! Zoho Analytics - Q2 Quarterly Newsletter is out now! Check out the newsletter (attachment) to know all about our new features, recognitions, webinars, blogs, and many more exciting things. Do let usZoho 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
Top Contributors
Vaijayanthi V
Charanya R
François Ehret
Dan W
Ezra Prince Jebahar I