[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 PREMOStatic column with Date changing column
Hi there. I am not a data techy and am more DIY. I am struggling with what is probably a very easy thing to do in Analytics. I want to be able to take our Stock on Hand at the date I run a report and compare it with a sales period from the past. It'sCan this report be done without SQL? How?
Sync Not Working
Zoho Analytics Sync appears to be down again. Have multiple accounts and when attempting syncs with various sources like Zoho CRM, Desk and Google Analytics the Status remains in 'Sync in Progress' without completing. This is at least the second timeIs there a way concatenate text from multiple rows into single cell?
I've build a delivery reporting system for a customer and they are looking to link the rounds data with route planning software, however as there are multiple lines generated for the same location (products to be delivered) and as such the route planningRow counts by workspace?
Does anyone know how to get a row count by workspace?Weekend ticket reports
I want to create a table report that show tickets for Saturday & Sunday afternoon(lets say from 18:00), is there an option to do this in Zoho Analytic without selecting specific dates? is there a way to filter by day(sunday) and time and not by calendarNeed help with Join function in Zoho reports
Team, I have 2 tables - and I need to get ALL matching results in one cell.. Ex: Table 1 contains a Pin code Table 2 contains many addresses corresponding to that Pin code How do i get a query result where for each unique pin code I can get all addresses in one cell.Zoho Analytics "Bulk API - Import Data". MORE_THAN_MAX_LENGTH
I have encountered a problem with "Bulk API - Import Data", it return { "status": "failure", "summary": "MORE_THAN_MAX_LENGTH", "data": { "errorCode": 8507, "errorMessage": "The length of the parameter FILE is more than requiredEmbedding dashboard for mobile browsing
Hello folks, i successfully embedded my dashboard in my website via iframe, and works fine from desktop but is stuck from mobile. We cannot scroll the iframe and the reports are very heavy for the browser. Does anyone have a workaround that doesn't involve using the Zoho mobile app?New Features rolled out on July 26, 2022
Advanced Analytics for Teamwork CRM Advanced Analytics for Teamwork CRM empowers you by providing deep sales analytics over your CRM data. This integration helps you to keep track of your key sales performance metrics and optimize your sales team's execution.[BLOG] 4 Shopify sales analytics reports to grow your online store
There are many benefits to selling on Shopify—a full-fledged website builder, easy set up, a customized online store, and an extensive marketplace to cater to any Shopify store needs. The question, however, is how can merchants better translate theseScheduled import using local database option (file location) and htm files
I am having an issue with the import feature available for scheduled file imports Background: My quality team uses a system called Gagepack. Gagepack will automate scheduled reporting and save them to our network as htm files. Unfortunately there isPivot Table color is grayed out
Pivot Table color is grayed out on dashboards for some reason. Even though they were created with different 'theme' color in the report view See images provided below First image is view on dashboard, second image is view from the report screenUnderlying Data
Hi, When I made a Chart or a View I used to click on the data I want to consult, and it brought back the information detailed and ALL the columns that were on the report or view data base, I just found out that now the same reports are just showing the columns that are in the view...is this a bug? o how can I add columns to those underlying consults.Open tickets per day
Hi, Day 1 of working with Zoho Analytics for me. I'm want to create a dashboard with multiple widgets and bar sets on it. One of them is a Line chart with the following info: X-axis = first day of the month untill the last day of the month (so if i selectExclude alpha numeric characters
I have fields with both numbers and letters in them. The length of both numbers and letters can vary. I am looking for a way to return the information as two columns - one for numbers, one for letters. Can anyone help please?Create Report of Zoho Project Tasks with a certain tag
In Zoho Projects we use the tag field. I am trying to create a report in Zoho Analytics that will list out the tasks across all projects that have a specific tag but I am having trouble figuring out how the tags are linked to the tasks in projects. CanZoho Books - Payments Made does not Connect to Invoices table?
Hello Zoho team, We have set up a sync from Zoho Books for most modules including Invoices and Customer Payments. All our payments are always applied to an invoice. Using API we can always find the invoices that a payment has been applied to. However,Zoho Projects Integration - Project Completion %
Hi everyone I've connected our Zoho Projects to Zoho Analytics to pull specific types of reporting. One area I am battling with is finding the field data that shows completion % of specific projects. In Zoho Projects I can see the complete % per projectReport of the Week: Top Tags in Zoho Projects
Advanced Analytics for Zoho Projects now supports the "Tags" module. This enables you to create reports over the Tags in Tasks, Bugs, Milestone, Projects and Timesheet modules. This week let's see how to create a report over your Tags data. Follow theLogical Operators in Zoho Analytics Query
if_case ( "Customer Address"."Item Wise Weight" > 100, ("Quantity Ordered" * "Weight") * 30) as "Zone Cost" Hello All, Requirement is to check the weight of the item and add a custom rate as a different column, but the above query is resulting in theAny Changes to Source Data File Requires Remapping in Zoho Analytics
I have set up scheduled imports of various tables from a master Excel spreadsheet to perform various Zoho Analytics functions. The problem I have is that if I make any changes to the structure of the source spreadsheet, Zoho Analytics stops importingHow to Remove Time from Current Date Function in SQL Query?
Hi, I'm writing a query that counts rows where the value in a date column is equal to today. When I use getdate(), today(), current_date(), etc I get a total of 0, because all of those functions return the exact current date and time, whereas the valuesChange font and/or font size?
Is it possible to change font and/or font size in any of the report views? I've seen a few older post indicating that it may be a feature in progress. Has there been any progress? -KenIssue with SalesIQ/Analytics integration
Hello, I'm facing an issue with the integration of SalesIQ and Zoho Analytic. Our goal is to export SalesIQ data into Analytics, to analyse the people coing to our website. It is a really vluable tool for us. Everything was working well, but one day[WEBINAR] KPI dashboards—an indispensable business enabler
Here’s an interesting piece of trivia. IBM once reported that 2.5 quintillion bytes of data are created everyday, worldwide. However, nearly 90% of that structured data goes unanalyzed. This data is known as dark data. Now let’s switch gears to your business.Converting to one currency within report
Hello - my business has sales in various currencies - ZAR, GBP, EURO, CAD and USD to name a few. I have created a report that shows monthly sales by rep. It's made up deals in all of these currencies. I would like each deal to be converted to USD. Is there a way to do this using a formula column? If so, i'd love some step by step guidance. Thank you!Change over Time Graph (or Trend Line Graph) of Daily Average of Staging Duration
I'm not sure if my question title does explain my issue but I will try to explain it in detail. We are creating dashboards which include staging reports created with data from Zoho Desk. The main report on these dashboards has a bar chart which showsSpread value between start and finish dates
hi there. I have a project value, start date and finish date. I'm hoping to spread the project value evenly over the months in a chart, rather than the entire value being in Jan 2022 just because this is the start date. See attached what the chart looksRelative Date Filter
The Tabular View report is a useful reporting tool, except you are unable to use 'relative date filters.' Can you please add a feature that allows for relative date filtering while using the tabular view reportUsing chosen user filter as a parameter
Hi I have a report that is used to calculate profit over a period. One of the custom fields I have in "Accounts" is "Monthly rate". In the report I have a user filter that allows to choose the period of the records (work log) to show. However, if for[Webinar] Project analytics: 360° insights for successful project delivery
Hi there! Project management is a key enabler for efficiently managing the volume and velocity of business efforts and delivering ambitious growth rates. By adding a layer of 360° analytical insights, project managers are better empowered to successfullyHighlight and Copy from Reports/Dashboards
The most recent round of updates has removed the ability to highlight and copy data from reports and dashboards. You can export or view underlying data and copy from there, but that is not very efficient when I just want to copy some basic info to anHow to apply a text-display formula on an aggregated value?
Hi, I've been struggling with a display issue on a report for quite some time now, but I can't seem to find a solution... Basically, my report has the X-axis with time-based values (weeks of the year), and the Y-axis with duration values (in milliseconds).Tip of the Week - Report as Filter
" My dashboard is comprised of marketing data from multiple countries. I want the countries plotted in the reports to act as filters. Say, when I click on a particular country name, I want only the values corresponding to this country to be displayedHow to read backend data for reports?
Hi All - How do I analyze the data behind the "Average First Reply Time - Tier Report"? For example, we want to look at tickets that took over 24 hours to send a first time reply to. I clicked the icon that shows the reports that create the graph butUnion 2 tables
Hi Guys! Its me again.. I was trying to use the union all or union instruction but looks like there is an error there. Basically I have one table: Table 1: Document date / document type / customer / product / sales amount / Quantity / Margin / Cost /Custom Percentage Formula as Data Label
Hello, I have a chart with 2 lines from 2 different custom formulas. One shows the $ amount of sales from our Top 5 Customers and the other shows the $ amount of sales from our Top 10 Customers. Right now the data labels just show the amount spent. ITip of the Week - View Underlying Data
The View Underlying Data option in Zoho Analytics allows you to view the underlying data of any data point in your view. To view the underlying data of a point (or bar, or cell) in your view, mouse hover the data point. The related information to thatNext Page
Access your files securely from anywhere
New to Zoho Recruit?
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
What's New in Zoho Analytics - October 2025
Hello Users! We're are back with a fresh set of updates and enhancements to make data analysis faster and more insightful. Take a quick look at what’s new and see how these updates can power up your reports and dashboards. Explore What's New! ExtremeWhat’s New in Zoho Analytics – September 2025
Hello Users!! In this month’s update, we’re raising the bar across multiple touchpoints, from how you bring in data, plan and track projects to how you design and brand your dashboards. We’ve added the all-new Gantt chart for project visualization, expanded[Webinar] The Transformative Power of Gen BI
Traditional decision-making tools are no longer enough. The integration of generative AI into business intelligence (BI) is proving to be a true game changer—enabling businesses to make faster, smarter, and better informed decisions. Early adopters ofUpcoming Change: Snowflake Username/Password Authentication Deprecation – Action Required
Hello Users, Snowflake has officially announced that username and password-based authentication will be deprecated by November 2025. You can find the official announcement [here]. If you're using a Snowflake connection in Zoho Analytics to import data,Zoholics Europe 2025: Your Ultimate Data Analysis (Zoho Analytics) Workshop Experience
Why should you attend? This year, Zoholics Europe 2025 is putting data analysis centre stage. With a dedicated workshop designed to answer all your data-related questions, you’ll gain practical skills, real-time solutions, and expert insights that you
Most Discussed Topics
What's New in Zoho Analytics - October 2025
Hello Users! We're are back with a fresh set of updates and enhancements to make data analysis faster and more insightful. Take a quick look at what’s new and see how these updates can power up your reports and dashboards. Explore What's New! ExtremeZoho Analytics - Make text clickable in underlying data
Hi Community, I have a simple sales report based on a Invoice query table. I have included a link on to each invoice on the table and sent the Invoice number URL to the link. This works find in the query table, but when I click underlying data on theCRM Related list table in Zoho analytics
In Zoho Analytics, where can I view the tables created from zoho crm related lists? For example, in my Zoho CRM setup, I have added the Product module as a related list in the Lead module, and also the Lead module as a related list in the Product module.Is it possible to create a word cloud chart in ZoHo Analystics?
Hi there, I have a volume of transaction text that I would like to analyse using word cloud (or other approcah to detect and present word frequency in a dataset). For example, I have 50,000 records describing menu items in restaurants. I want to be ableIs it possible to pull the Zoho desk data into Zoho analytics in real time
Hi - I am looking to add more dashboards and reports of Zoho Desk in analytics. I see there is a schedule to pull the data into analytics, but I'm wondering if there is an option to pull the data in real time instead of a specific interval?
Zoho Developer Community
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
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
What's New in Zoho Analytics - October 2025
Hello Users! We're are back with a fresh set of updates and enhancements to make data analysis faster and more insightful. Take a quick look at what’s new and see how these updates can power up your reports and dashboards. Explore What's New! ExtremeTip of the Week - Spot Risky Sales with Conditional Formatting
In Zoho Analytics, small tweaks can lead to big insights. One such feature is Conditional formatting based on other columns, your key to instantly spotting where sales success is overshadowed by product returns. Our tip this week shows you how to applyWhat’s New in Zoho Analytics – September 2025
Hello Users!! In this month’s update, we’re raising the bar across multiple touchpoints, from how you bring in data, plan and track projects to how you design and brand your dashboards. We’ve added the all-new Gantt chart for project visualization, expandedAnnouncing Agentic AI - Ask Zia!
We are delighted to roll out the new agentic AI capabilities in Ask Zia, where every stage of the BI workflow is assisted by AI. With a human-in-the-loop approach, Ask Zia ensures that you’re in command of the decision, while AI handles the complexity.Invitation-Based User Access in Zoho Analytics
Hello everyone, We’re rolling out an important update on how users are added to your Zoho Analytics Organization and Workspaces. Previously, when admins added users, they were automatically added to the organization. Moving forward, to improve security
Top Contributors
Jaivin Joy Eapen
Roy Vargis
Naresh Kumar K K R
Sudhakar
Mikhail Koval