Making a graph from a pivot chart
Is it possible to make a graph out of a pivot chart?View Mode does not apply SQL "ORDER BY", how to sort by multiple fields?
When running a query directly from the edit view it works fine, but in "View Mode" it doesn't work. What can one do to see results sorted by multiple criteria?Unable to Renew
Pay now option is missing after adding all the necessary details.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?Import from a stored procedure
Is there a way to import a tables from a database that is a stored procedure? If so, please provide details or link to steps. I have tried to import from a stored procedure and have been unable to ThanksWould like to change the String Datatype to Date Datatype extracted from absWeek(),Week()...etc
Hi Zoho, As I need the sum of sales per week which has to be automatted every year weekly,I have extracted the Created data on absWeek() ,As the data is changed to string. I would like to change String format absWeek() data to Date format,So that I canIn analytics there is a history of change of stage in releases
I need to know the date on which a release is changed stage, in the release table are the creation, last update and Released on dates. But I need to know when I change to On Going, I understand that it can be taken from the last update field but onceAggregate Formula - Time
I have a CRM table which has phone call start and end time. I have created a Query table that also includes a Call Duration column (using Time_Diff). I am creating a summary report on Analytics and want to show the sum of the duration of inbound/outboundnot able to access zoho analytics
Since 3 days, we are not able to synchronize data (zoho books) and we are not able to access zoho analytics .Tip of the Week - Customized User Filters for Views in Dashboard
Did you know that you can associate/disassociate user filters with the reports in your dashboard? Zoho Analytics allows you to include/exclude user filters for the views in the dashboard. Say, you have multiple reports in your dashboard and you do notQuery multiple keywords
I am trying to create a query off a table to generate data based on multiple conditions. Below is the query that works, based on one condition (WHERE "ActivityText" = 'Non Productive Time - General Admin') SELECT "EmployeeID", "FirstNameLastName", "FormattedDate",[Webinar] Analytics does not age well: Why fast implementations deliver more benefits
Hi there, Based on more than 20 years’ experience with software selection in analytics and BI, BARC shows why it's so important to implement analytics and BI quickly. Recommendations for how to achieve successful projects and gain the most benefits fromNew Features rolled out on Oct 18, 2021
Enhancement in Importing Zoho Analytics Workspace From now on, when you are importing data from another Zoho Analytics Workspace, the data types of the columns will be copied as is from the source table. For example, when you import currency data, itRemove limitation to import only up to 100 fields from a single Zoho CRM module
Zoho CRM support creating of over 300 fields per module. Zoho Analytics support import of only 100 fields per Zoho CRM module. Please consider removing this limitation. Best regards, Mladen Svraka Zoho Consultant and Authorized Partner www.mladen-svraka.hrIs Zoho Reports Advanced Analytic Add-on to sync NOTES module into Zoho Reports available now?
Is Zoho Reports Advanced Analytic Add-on to sync NOTES module into Zoho Reports available now?Adding annotations to dashboards and reports
Hello fellow Zoholics, Is there a possibility to add an annotation to a dashboard or report like in Google Analytics? For example: A successful campaign reflects as a spike in our lead generation for this month. We will flag the start date in the report manually. Or, a colleague is on sick leave and sales plummet in their territory for the month but spike again when they return. It would be great to be able to flag events as such to retain the information and make it immediately visible for anyonewidget setting to a cutoff date
I need to configure a widgets so that it compares information to the cut of a date, for example the sale of this month accumulated to today 10/12/2021 vs. the accumulated sale of the previous month accumulated as of 09/12/2021? In this image the comparisonHow to split the list of strings seprated with ; in a column
Good Morning, I have a column with client id and a column with list of strings which i have to bring down each string in the list into column. ID list 1. WOMAN,MAN,KID 2. WOMAN,KID 3. MAN,KID I would likePremium User - Unable to use Advanced Slideshow
I am a premium user, and am trying to use the "Advanced Slideshow" option in Zoho Analytics. Unfortunately I am getting a prompt saying I need to uprgrade my plan to premium... except my plan already is premium. How can you fix this? ThanksTip of the Week : Show the Conversion Rate
Do you want to know the overall conversion rate of your sales funnel? This can easily be done in Zoho Reports with a few clicks. The funnel chart in general, will show the progressive conversion rate of each stage, using the Show Convertion Rate option in Charts Settings. Zoho Reports enables you to calculate the overall conversion rate by comparing the first stage and the last stage in the funnel. The below gif shows how to add the conversion rate to your funnel chart.SQL Pivot Table
Hi, So I am new to SQL and have been actively learning it whilst we have some time on our hands to improve our reporting. I need to take data and present it as per a pivoted table the standard pivot function presents the data like this; What I am tryingChart/widget logged in user
Hello, Is it possible to make a generic dashboard where all the info/data on widgets and charts changes automatically based on the user that logs in ? In other words a filter that shows the data from the logged in user. We don't want logged in users toHow 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).Error: 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.How to get Stage history in zoho report
I am trying to create a report in zoho advance analytical that fetches all the potentials which had a change in Stage during the past year but we can’t find any formula to get potentials whose Stage were changed past Year. Could you please help me to find formula available in the Reports section in Zoho CRM?Help with a Query formula - latest date from unique values in another column
I have a query table I am developing to show only unique value (Project Name) and most recent date (Last Modified) and total all of the time entries from all the values (Hours) in a report from the query, but I do not know how to do this. The data tableZoho Analytics Free Lessons for Beginners
Hello friends Let me share my first Zoho Analytics course for Beginners via a youtube playlist. 14 free lessons for the first touch with the Zoho Analytics BI tool. https://www.youtube.com/playlist?list=PLnusL2XA4g1HmSGVZB51TyuiGZL8EhnCr Announce: TheCopy Widget to another Dashboard
I can see the option to clone a widget to the same dashboard but is it possible to copy it to another dashboard?Databridge Error / Please Help
I get a pop up error message that says "Login Failed" (image attached) when attempting to execute a query in the databridge. However, this cannot be true because I can see all the tables available to me, via the login. I have attached an image. PleaseSerarated userfilters in dashboard
Hello, I know it's possible to create a user filter on a Chart A or on a separate Pivot Table B But when I make a dashboard with Chart A and Pivot table B, those 2 user filters are on tap of the Dashboard and are applicable for both Chart A and Pivotwidget setting to a cutoff date
I need to configure a widgets so that it compares information to the cut of a date, for example the sale of this month accumulated to today 10/12/2021 vs. the accumulated sale of the previous month accumulated as of 09/12/2021?[Webinar] Growing an Agile Project Portfolio with Advanced Analytics
Hi there, Agile project management has paved the way for businesses to adapt to changing requirements. As organizations scale, rising interdependencies and complexities in projects can slow down growth. With advanced analytics, businesses can improveChange 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.OAuth 2.0 API Requests
Hi team I'm having an issue while trying to pull data from Survey Monkey Apply, through their OAuth2.0 API I have generated the OAuth2 credentials through Survey Monkey Apply which creates: Client ID: xxx Client Secret: xxx Refresh Token: xxx AccessNew Features rolled out on Oct 18, 2021
From now on, when you are importing data from another Zoho Analytics Workspace, the data types of the columns will be copied as is from the source table. For example, when you import currency data, it could be be identified as Number or Positive NumberZoho CRM connection is down with Zoho Analytics
I didn't see any announcement of this issue so thought I'd share that the Zoho Analytics to Zoho CRM data source is down. This can lead to queries, reports, etc. being deleted.Chart background color
How can I change the background color of a chart? Probably a silly question but I have tried several things and can't seem to figure it out. Our app has a grey background color throughout and the charts have a plain white background and it sticks out.[Webinar] Intro to Advanced Analytics for Zoho Books
Hi there, In this session, participants will receive a walkthrough of the best practices for using Zoho Analytics as an advanced analytics platform for Zoho Books. Join Brett and Tyler from Zenatta Consulting, and the Zoho Team for a top-level guide toAsk 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 in 2021 - Ask the Experts #18 on 07 October 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 discussionZoho Analytics on-premise connect to DataPrep
Hi, I installed the On Premise version of Zoho Analytics, when i try to connect Analytics with the Data Prep gave me the error in the attached file, checking in the web console and in the server logs i saw that's a 500 internal server error, obviouslyNext Page
Zoho DataPrep Resources
New to Zoho DataPrep?
Zoho CRM Resources
Zoho Subscriptions Resources
Zoho CRM コンテンツ
-
オンラインヘルプ
-
Webセミナー
-
機能活用動画
-
よくある質問
-
Ebook
-
-
Zoho Campaigns
-
Zoho サービスのWebセミナー
-
その他のサービス コンテンツ
ご検討中の方
有料プランをご利用の方
Announcements
[Webinar] Analytics does not age well: Why fast implementations deliver more benefits
Hi there, Based on more than 20 years’ experience with software selection in analytics and BI, BARC shows why it's so important to implement analytics and BI quickly. Recommendations for how to achieve successful projects and gain the most benefits fromNew Features rolled out on Oct 18, 2021
Enhancement in Importing Zoho Analytics Workspace From now on, when you are importing data from another Zoho Analytics Workspace, the data types of the columns will be copied as is from the source table. For example, when you import currency data, it[Webinar] Growing an Agile Project Portfolio with Advanced Analytics
Hi there, Agile project management has paved the way for businesses to adapt to changing requirements. As organizations scale, rising interdependencies and complexities in projects can slow down growth. With advanced analytics, businesses can improve[Webinar] Intro to Advanced Analytics for Zoho Books
Hi there, In this session, participants will receive a walkthrough of the best practices for using Zoho Analytics as an advanced analytics platform for Zoho Books. Join Brett and Tyler from Zenatta Consulting, and the Zoho Team for a top-level guide to[Webinar] How a Modern BI & Analytics platform is the key to insights-driven business
Hi there, To become market leaders, organizations need to make sense of their data. An insights-driven business model helps companies make better decisions underpinned by data. In this webinar Senior Evangelist Chandrashekar LSP and a guest speaker, Forrester
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
Most Discussed Topics
Ask the Experts #19: Five hours live Q&A session with Zoho Analytics product experts
Hello all, We are excited to host the next online community event in 2021 - Ask the Experts #19 on 25 November 2021 between 05:00 AM - 10:00 AM PT. If you've had any questions about the Zoho Analytics features or prefer to learn more, join the discussionContinuous 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 alwaysHow do I remove a data source from Zoho Analytics?
I am unable to find a delte option on a datasource that i put in the system as an error. On teh web it refers to a setup icon but I do not see that on my interface?Analytics export to excell
I am trying to get some data into another analysis program to do make use of some other functions. Would I be able to use the api to auto update into an excel file for example? If not are there any other options that I have?Adding 2 columns with '+' treats numbers as strings (not fixed with cast)
Why does the '+' sign converts numbers into strings? How to fix it? Note: cast( as int) + cast( as int) does not work ("Parsing of Query failed, please check the syntax"). The following SQL should sum up two numbers, like: 0 + 10000 Expected result: 10000
Sticky Posts
Ask the Experts #19: Five hours live Q&A session with Zoho Analytics product experts
Hello all, We are excited to host the next online community event in 2021 - Ask the Experts #19 on 25 November 2021 between 05:00 AM - 10:00 AM PT. If you've had any questions about the Zoho Analytics features or prefer to learn more, join the discussionAnnouncing 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 PreparationFree 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
Sailas S
mtietz
Mark