[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%'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.45Zoho 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 NitithamDisplay 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 McConnellToday'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.Export 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 availableSolved: 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_zoneHow 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).Waterfall 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 importHow to include task comments in data
Hi, i'm trying to create a report in Analytics for tasks from Zoho Project. I need the report to show the status of certain tasks which is easy, but also want it to show the latest comments added to the task. Is there a way to do this? Thanks RobConservar 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 NitithanHow 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.Display 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 profilesQuestions 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,How 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 TimeDashboard 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.Looking for someone who has experience setting-up Zoho Data Bridge
We are looking for someone who has experience in setting-up Zoho Data Bridge. We need help in installing this.Dashboard header and logo alignment
Hi i added logo and header but its alignment is not proper and dashboard hedaing is not in center as shown below if i tried to make a dashboard title center aligned but we are getting a extra space below is there any way to get both logo and headerQuery table, select where with bool column
I am creating a Query table, when I use select with a where with a bool column, it doesn't compare well SELECT "PVC ASSEMBLY OUT" FROM "Item_Subform_SubItem" WHERE "Item_Subform_SubItem"."PVC ASSEMBLY OUT" = 0Error: View is not present in the workspace
When saving a dashboard, user receives a popup with the following error. "View is not present in the workspace" What does this mean or refer to? There is no further insight given.New Features rolled out on April 26, 2016
Enhancements in Conditional Formatting Conditional Formatting in Pivots and Summary Views offers enhanced features like adding/formatting text and icons to highlight your condition in addition to the earlier formatting capabilities. Click to know more. Wrapping Column Headers in Pivots and Summary Views Zoho Reports now allows you wrap lengthy column headers in Pivots and Summary Views. You can use this feature by clicking the Settings button in the toolbar and selecting Wrap Text in Column Headers.Some fields of my Zoho Desk Layout isn't accessible in Zoho Analytics
I frequently use Zoho Analytics to treat some data of my Zoho Desk tickets, but I've just noticed that some fields that I added to my layout are not shown in the Tickets table on the "Zoho Desk Modules (Data)" paste. Why is this happening, and is thereHow 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 descriptionChange Currency in reports
New to Zoho and starting to get my head round everything, so far I am very impressed and can't wait to get fluent. I apologise if I am being stupid but is it possible to change the currency in a report. In my main forms it shows as GBP (£) but in the reports I generate showing client spend etc it is all shown in USD ($) if someone could point me in the right direction I would appreciate it.How to change the format data from a table in Zoho Analytics
When importing a Google Sheets as a Data Source in my Zoho Analytics workspace, a "Month" column was imported as a "Text" data type, and not a "Date" data type, as shown in the image below. As I use its data in some Querys and Charts, I'd like to changeChange Default Currency in Zoho Reports
Is it possible to default all currency fields in my Reports and Tables to my local currency without having to reformat them every time?Notes in Zoho Reports
Will the "Notes" field in CRM be available to upload into Zoho Reports so we can add notes as a feild in the reports?Zoho Analytics Formula Column
Date column imported from Zoho workspace gets changed to text type. I tried converting the format, however it gives weird results. To counter this, I created a formula column - this however doesnt give me any output. It's always blank. Not sure, if theScheduled emails with html inline table do not take into account color of conditional format
Hi, I've a scheduled email of a html inline table which contains conditional format. But when the recipients of the scheduled mail receive the email they do not see the coloring: Please support. Thanks!Why is Zoho Analytics so damn hard to set up?
Hi I am a Zoho One user and small business owner. I use quite a few Zoho apps and for the most part can get things to work as long as it does not require Deluge. With one exception, Zoho Analytics! I have attempted setting somethings up on my own butSummary view grouped by date - can I include missing dates?
Let's say I have a table like this: May 1, A May 1, B May 1, C May 2, A May 3, A May 3, B May 5, A May 5, B Using the "Summary Report", grouping by Full Date, and displaying count for column B, I get this Summary: May 1, 3 May 2, 1 May 3, 2 May 5, 2 IsJoining Leads and Deals tables
By The Grace Of G-D. Hi, How can i join 2 tables that are already joined (Like Leads and Deals) Using another Column as lookup?ZOHO Reports - Filter Logic?
Hi, I need a way to apply filter logics such as ((1 AND 2) OR 3). All I can see as of now is a way to enter different AND filters in the respective filter column. But how can I add an OR filter? Any advice would be highly appreciated. MarkCalculate business days between dates in reports
Good afternoon, I'm trying to calculate the datediff excluding weekends/holidays. I can accomplish this in Excel using NETWORKDAYS. I saw there was a previous response about this, I have shared my DB with support and emailed in, but wanted to post here in case someone could template this out for others.Next Page
Zoho DataPrep Resources
New to Zoho DataPrep?
Zoho CRM Resources
Zoho Subscriptions Resources
Zoho CRM コンテンツ
-
オンラインヘルプ
-
Webセミナー
-
機能活用動画
-
よくある質問
-
Ebook
-
-
Zoho Campaigns
-
Zoho サービスのWebセミナー
-
その他のサービス コンテンツ
ご検討中の方
有料プランをご利用の方
Announcements
[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 thisNew Features rolled out on April 26, 2016
Enhancements in Conditional Formatting Conditional Formatting in Pivots and Summary Views offers enhanced features like adding/formatting text and icons to highlight your condition in addition to the earlier formatting capabilities. Click to know more. Wrapping Column Headers in Pivots and Summary Views Zoho Reports now allows you wrap lengthy column headers in Pivots and Summary Views. You can use this feature by clicking the Settings button in the toolbar and selecting Wrap Text in Column Headers.New in Zoho Reports: Criteria based sharing
Criteria based sharing Zoho Reports now offers a powerful feature that allows you to define a criteria when sharing a view/report/dashboard. The defined criteria will determine the data that will be displayed in the view to the shared user. When a report is shared to a user(s) with an associated filter criteria, the specified criteria will be applied on the report shared, there by filtering the data viewed when user accesses the report. For example, if you want to share a Sales report to a Manager[Webinar] 5 ways to supercharge your IT Help Desk with Advanced Analytics
Hi, The rapid adoption of remote and hybrid work models across the globe is disproportionately building pressure on IT help desks—adding more tickets to handle, assets to manage, projects to execute, and a lot more. Agility is one of the key factors thatNew Features rolled out on Mar 04, 2021
Share Slideshow UI Revamped with More Interactive Options! The Create Slideshow and Manage Slideshows pages have been revamped with more interactive options. The new UI captures: Slideshow Preview: You can now preview a created slideshow in the Copy URL
Zoho Sprints Resources
Zoho Show 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 Creator Resources
Most Discussed Topics
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 profilesDisplay 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 McConnellWaterfall 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?Query table, select where with bool column
I am creating a Query table, when I use select with a where with a bool column, it doesn't compare well SELECT "PVC ASSEMBLY OUT" FROM "Item_Subform_SubItem" WHERE "Item_Subform_SubItem"."PVC ASSEMBLY OUT" = 0Looking for someone who has experience setting-up Zoho Data Bridge
We are looking for someone who has experience in setting-up Zoho Data Bridge. We need help in installing this.
Sticky Posts
Ask 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 threeTransitioning to a new Zoho Community platform
Dear Zoho Reports Users, Our users forum here is being transitioned to a new Zoho Community platform. More details are available in the below URL. https://help.zoho.com/portal/community/topic/zoho-community-is-transitioning-to-a-new-platform We are excited about this and we believe you will like it too, as the new Zoho Community platform will result in more user engagement. Happy participating in the new forum!
Top Contributors
Parvathy K
1_Jeya Bharathi
Phil
11_Nazneen Rabia S
Saravanaprakash