Please bring back 3d charts
Does anyone else completely disagree with all 3 of these points? The data is just as easy to read to me in 2d or 3d. I would love to see 3d charts come back. They just visually looked great and I see no issue with how the data is seen. It should be upCurrency in Pivot Charts
All data labels on the charts are provided with USD ("$") character, although the corresponding values are in other currencies. Annoying. Any chance to customize the labels?Zoho analytics Sql
Hii Team, I need to have a view of all the people who haven't log their time in the report. Basically, I am looking for null values and I have used the join properly but I am not able to figure it out. SELECT users.login, t1.time, t1.b2 FROM users LEFTConcat without duplicates
Hi All I have a formula I use in a query concat.("Table 1".`Barriers`, '|', "opf_nesf_barriers".`Barriers`) as `Unified Barriers` The result gives me a list of values but includes duplicate values where the same value exists on both tables. (eg ifZoho Analytics Data column and formula issue.
Hii Team, I have created a formula column and used it in data and add the aggregation function also but when I am going to add the formula some columns are missing. I have attached the screenshot I just need to total the row in my report but it's notTime Log Report in Zoho Analytics
I need to create a time log report from where we can get the time log report but i am running the SQL query and used the joins properly but it's not showing the null data. is there a bug in Zoho analytics regarding joins?Partition 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 columnAdding costs to a sales report to enable profit & loss reporting
Hey, I currently have a good dashboard to report our internally monthly/quarterly sales. The request I have had is to show for each product (condensed into categories) what the actual profit is that month/on that product etc. Is it simply overlaying theReordering no longer working from tabular view
Hi there, Previously it was possible to re-order columns by dragging them within the tabular view/edit view. After the update if you try this now, the cursor changes to the move cursor, and the blue "new position" arrow appears where you're looking toIs there a plan for a Data Prep App at Zoho ?
Hello, I was wondering if Zoho was planning to release an app to clean and prepare the data before the analysis? Thank you, Regards, Victor M. da SilvaReporting: Count Picklist records?
I have 5 picklist fields within one lead. All with 3 options which contain qualitative values, not quantitative (text values) FIeld1 - Option 1, Option 2, Option 3 Field2 - Option 1, Option 2, Option 3 Field3 - Option 1, Option 2, Option 3 Field4 - OptionZoho Analytics - Error
Hi, I accidentally removed some fields from the data sync on Zoho Analytics and now several of the reports are saying 'View is not present in the workspace'. I have re-added the fields to the sync but this still doesn't fix the problem. Is there a wayFilter closest addresses from latitude & longitud
Hi, I have a list of business address with latitude & longitude, I am trying to filter just the ones near a specific coordinate. I am trying to achieve with an SQL query: SELECT id, ( 3959 * acos(cos(radians(37)) * cos(radians(lat)) * cos(radians(lng)Progress Bar
Hi Zoho Team, 1. Please add a progress bar from which we can get the %age of the Synchronization status. 2. As Currently we are not testing the connection which we are making with the SQL Server or any other source please do make it alsoHow to calc cost % of all income
Hi, I would like to calc the percentage of cogs but don't know how to achieve this with a aggregate formula: Hope you guys can help! :) My data is is modelled like this: GLMain Cat GLSub Cat GLMain Desc Amount 7 70Display 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 McConnellPossible 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.Vertical 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 TimeChange 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?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,'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 Regards[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_zoneHow 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 NitithanMultiple 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 profilesLooking 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" = 0Next 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