Display an Image of an Employee in a Report
I'd like to display an image of an employee in a report or dynamically on a dashboard with relevant data in reports below. Can I do this? Diane McConnellZoho Campaigns Not Syncing in Analytics
I am trying to sync Zoho Campaign data to Zoho Analytics and when I hit sync now it just says 'Sync in process' and has been doing so for almost a day now. Can someone help me fix this issue?"Pivot Table" Conditional Formatting
Team, I there a way to use conditional formatting a "Pivot Table" report? Thanks, Arron Blue Pumpkin Hosting | Solutions Made SimpleFinal Notice - Deprecating Authtokens in Zoho Analytics
In our commitment to continuous improvement, we've been working on to upgrade Zoho's authentication method from authtokens to a more secure OAuth. We have been communicating about this important migration process in the recent post. This is the finalPossible to create calculated fields with Pivots?
Hi, we're thinking of evaluating your product, however we need a calculated field in a pivot. Is this possible? For example, we have a table with columns for Country, State, Sales, SqM. In the pivot we will group by Country and then State, and in order to get a Sales / SqM column, we need to add it as a calculated field in the Pivot table. It would, on a record basis, calculate the total sales divided by the total sqm. In Excel we use a calculated field inserted into the Pivot table to do this.ZoHo Reports / ZoHo CRM Realtime Data
ZoHo CRM is always being updated with data required by a remote sales team, this data is real-time in ZoHo CRM. Whilst the dashboards in ZoHo CRM meet basic requirements, ZoHo Reports add that additional layer of information representation. It baffles me why ZoHo Reports doesn't have real-time integration with ZoHo CRM. This would be a huge advantage for our business and I'm sure others. I'm forever being asked by our sales team, "why is the data out of date?" in this dashboard. Is realtime reportingVertical Bar Chart
I'm trying to draw a chart which would show me the sales person name on X Axis and Y Axis would show sales total amount. I need two columns per sales person (one for 2020 and other for 2021) and I need my sales figures broken down by product sold. I understandHow do I change the time zone in Zoho Analytics (under data sources > Next Schedule Time
As show on the enclosed screen shot the time zone is shown in GMT. How do we change this? Data Sources > Last Data Import/Sync Status and Next Scheduled TimeCustom Zoho CRM Fields Not Appearing in Zoho Reports
Hello, I added four custom fields to the Events module in Zoho CRM, which are important to us: When I went to Zoho Reports to build a report using this module, these fields are not available for me to select, as can be seen from this grouping of screen shots from the "Show/Hide/Reorder Columns" pop-up: I have created custom fields before and these always show up in Zoho Reporting. Please advise if there is a way to resolve this issue. Thank you, John GalichHow to group Leads and Deals (from Zoho CRM) by week of the year in Summary Views?
How do I make the below two Summary Views? Grouped by week of the year. Leads and Deals. Columns = # of Leads created # of Leads converted # of Deals won # of Leads lost The same as above BUT they are related e.g. # of Leads created, of those Leads howZoho Analytics with Facebook API
I connected my business's facebook account to Zoho Analytics. I am trying to make sense of the data, but I need someone to provide an assist. Looking at the premade "Page Insights" dashboard - The first column presents "Impressions" and "Post Impressions".Formatting and conditional formatting for multiple columns
Dear Zoho, we're building user retention views where large tables have data where we need to color code the background depending on value in a field. We also have to change the data format (to percentage), and set the digits shown (to 1), and then createKPI Widget dashboard select periods
I have a problem with selecting periods as a user filter. In the beste scenario I would like to have to have a period filter like Google Analytics has of Datastudio (see attachment). In the KPI widget I "Group by "inquiry_date" on week&Year". It selects the most recent week vs. the previous week. No matter what is select as a range (a whole month, it picks the most recent week vs. the week before). The KPI widget is configured as follows: Primary -> Latest Secondary-> % Difference Secondary ->Zoho Analytics : How to transfer "Zoho Databridge" and "Datasources" ownership
Dear Zoho Agent, I'm looking for a way to transfer "Zoho Databridge" and "Datasources" ownership but I cannot find a way or Document to achieve. Could you please provide me an information? Best Regards, Karanig NitithamChange font of PDA File
When I export the dashboard as a PDF, the Japanese fonts are very hard to read. Is there a way to change the Japanese font in a PDF file?Zoho Desk - Ticket ID field data type change in Zoho Analytics
Dear Customers, This is an announcement to the Zoho Desk integration users in Zoho Analytics. With reference to this post in Zoho Desk, the data type of 'Request ID' (Ticket ID) field in the 'Tickets' module will change from 'Number' to 'Plain Text'Threshold Scope and Reference Axis not available to amend
Hi All I have a report built where the Y Axis is made using a simple formula to return a % result. I want to add a target, static line in to the Y axis using threshold. However, when I do this I cannot select Scope of Axis to apply to. If i add 0.45Error in Connecting with data source
I have a connection error with sql server data source. How can i connect with sql server data source please give some instruction to connect. It will showing an error message like connection problem with host name. Thanking you in advance.How can I merge two tables into one formula?
Hello dear Zoho community, I would like to create a graph for my dashboard, where the Total Direct Costs / Client can be seen according to the respective month. However, this is currently causing problems as this data comes from two different tables.Questions about syncing with Zoho CRM.
I have a question about synchronizing with Zoho CRM. I changed the name of a single selection item in Zoho CRM and then synchronized, but some of the changes in the above items are not reflected in Zoho Analytics. After changing the items of Zoho CRM,Report Of the Week - Customer Retention Report
This week we will see how to create a Customer Retention report based on your CRM data. This lets you know how better you are engaging with your existing customers and make them continue buying products or services. Here we will use Zoho CRM data as an example. This can also be achieved in Salesforce CRM, Microsoft Dynamics CRM, and HubSpot CRM by slightly modifying the queries. To create the customer retention report, you need to create the following Query Tables. Customer Start Date Invoice'Ask Zia' is now available in the Zoho Analytics mobile app
Hello All, In the latest version (v3.4.0) of the Zoho Analytics app, we have brought in support for Ask Zia, the AI powered analytical assistant which provides powerful insights on the go. I've attached GIF's covering the feature below for your reference:Widget Not Included in Slideshow
I am unable to include / add - Widget in Manage Slide show in Zoho Reports / AnalyticsExport query results as pdf on mobile
On the desktop version, I can export the query results/ user filters as a pdf report. On the mobile, the pdf export creates a pdf of the entire table, not just the filtered records. I need the same functionality on the mobile app that is availableAnother import is in progess in UploadTool. No other imports.
Suddenly started getting an error message when running UploadTool: Another import is in progess in this table started by the user 'yourstruly' at '24 Sep 2014 04:33:23(GMT)'. Please try again after some time or contact the Reporting Database ("mydb") Administrator. There are no other imports in progress. Uploading multiple tables. The failure is NOT on the first one. The setup was working fine for quite some time. No changes were made. - Best RegardsCustom Predefined Date Range Filter?
I need to hardcode pre-defined date ranges in a dashboard. I want my user to be able to select "Year 1" or "Year 2". However, Year 1 is not a January - December calendar year, it begins on March 16. I must be missing something, because I do not seeHow to I report on CRM Notes related to a custom Module?
I have a custom module (called Agreements) that I'd like to show the last Note added to the CRM record. As far as I can tell, Zoho Reports allows you to import custom modules, activities, events etc, but not Notes. Does anyone know how to do this? (I want to create a tabular report, one Agreement per line with the last Note as a 'Comment' column at the end).[Webinar] Accelerate Multichannel Online Retail With Advanced Analytics
Hi there, Hope you are safe and well. We have made a practical webinar to help online retailers centralize their inventory, supercharge multichannel sales, and apply the insights derived from advanced analytics to scale up faster. We believe that thisSQL Alias error?
I keep getting this error: Whenever a table alias is defined, kindly use table alias name before the respective columns used in SELECT query I don't know where I've went wrong. SELECT Distinct "Book Title", t1."Author" as 'Authors1', t2."Author" as 'Authors2', FROM "SET1" t1 LEFT JOIN "SET2" t2 ON t1."Book Title" = t2."Book Title" WHERE Authors1 LIKE '%John%' OR Authors2 LIKE '%John%'Today's Date Widget?
I love the new in-line e-mail feature, but before I'm ready to start using it for my company, I'm hoping to solve one thing: When I send the PDF version of my weekly dashboard, I've embedded a little iframe in the title that simply pulls in "today's date." So, today's dashboard will say "Dashboard for the week of September 18th, 2015" where the date is pulled in via and styled with HTML. Is there a way to achieve this with a widget or other method? The iframe doesn't survive the e-mailing process.Solved: Zoho Databridge JDBC driver problem with European time zones and MySQL
If you are running in problems with following configuration: - Zoho Analytics and Zoho Databridge - MySQL on Windows server - default timeZone configuration just run following commands in mysql: SET GLOBAL time_zone = '+1:00'; or SET GLOBAL time_zoneWaterfall Chart
Hello, I would like to create a waterfall chart on Zoho analytics which shows the movement in changes of budget throughout a few months, on a weekly basis. Should look something like the picture below. Does anyone know how to?How to import from a file local to the server running Analytics
This seems like it should be the easiest thing in the world, but I can't find a way to do it. We run the on-premise version, under Linux. We have jobs that deposit files in a particular directory on the machine running Zoho Analyltics. I want to importConservar Formato en Tabla Dinamica
Saludos. Al crear una tabla dinámica quisiera pre establecer el tamaño de las columnas y que este se mantenga aunque se actualice la información. Actualmente reduzco de manera manual el ancho de las columnas y cada vez que actualizo la data, las columnas retornan al ancho habitual. Podrían Orientarme. Gracias.Zoho Analytics : Import [Zoho Desk History] table
Dear Zoho Agent, Would it be possible to Import Zoho Desk History table into Zoho Analytics? I couldn't find any table that could be History Table. Best Regard, Karanig NitithanDisplay an image in Zoho reports report
I have a table report in which i'd like to display an image made up of data from another column, something like: <img src="records.photo"> However, when i do that, nothing happens. How do i pull it off?Enhancement Suggestion: Tabular View Report Adj Header Row Height, Text Wrapping
The Tabular View Report is incredibly useful. However, even if you adjust a query to display a shorter version of the field name at the top of the column using the "As" statement, often the width of the field name is much wider than the data in the column. So it would be really helpful if you could have either adjustable row height for the top row or text wrapping with an automatic top row height adjustment that would allow for the field name to be displayed at any column width. This way youMultiple Axis Graphs
Hi, It would be great if you could pick which axis a series will be plotted on rather than each on their own or all on one as is current. Eg 2 series measuring volume plotted on one axis with a percentile line plotted on a second axis (currently you would have to have all 3 series on 3 separate axis or all on the same one).Automatically changing the Y-axis range
Hi guys! In this chart, I'm analyzing the data input average per customer profile. In the image below you can see that there's two profile and the Y-axis range is set according to the data related to both profiles: When I deselect one of the profilesDashboard 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.Next Page
Zoho DataPrep Resources
New to Zoho DataPrep?
Zoho CRM Resources
Zoho Subscriptions Resources
Zoho CRM コンテンツ
-
オンラインヘルプ
-
Webセミナー
-
機能活用動画
-
よくある質問
-
Ebook
-
-
Zoho Campaigns
-
Zoho サービスのWebセミナー
-
その他のサービス コンテンツ
ご検討中の方
有料プランをご利用の方
Announcements
Announcing 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 Preparation[Event Alert] Experience The Modern BI & Analytics Platform
Hi there, Technology has enabled businesses to cash in on markets on a global scale, fuelling data generation at astronomical volumes and breakneck speeds. Successful businesses have harnessed the power of this data to build their competitive edge acrossFinal Notice - Deprecating Authtokens in Zoho Analytics
In our commitment to continuous improvement, we've been working on to upgrade Zoho's authentication method from authtokens to a more secure OAuth. We have been communicating about this important migration process in the recent post. This is the final'Ask Zia' is now available in the Zoho Analytics mobile app
Hello All, In the latest version (v3.4.0) of the Zoho Analytics app, we have brought in support for Ask Zia, the AI powered analytical assistant which provides powerful insights on the go. I've attached GIF's covering the feature below for your reference:[Webinar] Accelerate Multichannel Online Retail With Advanced Analytics
Hi there, Hope you are safe and well. We have made a practical webinar to help online retailers centralize their inventory, supercharge multichannel sales, and apply the insights derived from advanced analytics to scale up faster. We believe that this
Zoho Sprints Resources
New to Zoho TeamInbox?
Zoho TeamInbox Resources
Zoho Books Resources
Zoho Projects Resources
Zoho Orchestly 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
Most Discussed Topics
Announcing 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 PreparationReport of the Week - Pareto Chart
A Pareto Chart helps identify the frequency of a factor (count) and its cumulative impact. The chart is a combination of a bar and a line chart. The bar represents the count of the components being analyzed and the line represents the cumulative impactPartition BY for running totals
Does Zoho SQL support any version of PARTITION BY? I see that SUM(VALUE) OVER (ORDER BY Column1 DESC) works, but not anything that includes a partition before the Order By clause. I know you can get a running total in pivot tables, but I need a columnZoho analytics SQL
Hii Team, Is there any way to improve the SQL part in Zoho analytics? I have used SQL in zoho analytics and lot of function are missing and full outer join is also missing.Setting up a "hot backup" server
We run Zoho Analytics On-Premise, with a license for two servers, one each in two different physical locations. We run one location "primary", with the other site serving as a "hot backup" that can be switched to if something happens to the primary site.
Sticky Posts
Announcing 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 PreparationAsk the Experts #18: Five hours live Q&A session with Zoho Analytics product experts
Hello all, We are excited to host the next online community event - Ask the Experts #18 on 24 March 2021 between 05:30 AM - 10:30 AM PDT. If you've had any questions about the Zoho Analytics features or prefer to learn more, join the discussion withFree Webinar: 5 Must have inventory reports for online sellers | Zoho Analytics & Zoho Inventory
Hello All, Selling goods online? These 5 inventory reports will help you make better informed decisions. Join us on this free webinar hosted by Zoho Analytics and Inventory domain experts to learn more. Register now! Friday, December 13th: 9am PSTZoho Reports to be renamed and launched as Zoho Analytics 4.0
We made the Zoho Reports 4.0 Beta announcement a few months back. As we worked on new features in 4.0, we realized we are moving away from just Reporting, and getting more and more into the Analytics realm. And that's the reason why we have decided to rename Zoho Reports as Zoho Analytics. This post is just to give you a heads up on the Zoho Analytics 4.0 launch in mid November 2018. As present users of Zoho Reports, be assured that the new product will continue to work the same as the current one.Zoho Reports Release 4.0 Beta
We are delighted to announce the new Zoho Reports Release 4.0 Beta. Your favorite Zoho Reports now comes with a fresh new-look and exciting features. The new Zoho Reports 4.0 includes the following features: Dashboards in Single Click The UI has been completely revamped focusing on easy navigation. Now you can access any dashboard in a single click using the Preview Cards. Easy Navigation The main navigational elements are made bolder and bigger now. The analytics elements are organized into three
Top Contributors
Parvathy K
Janani Thakshayani
anubhav pandey
Anizudeen I
Rhodes