Last Synced indicator
Is it possible to have a last synced widget/system data field, which would include: date of last sync, status of last sync, # of rows synced This way I can show this info to my users so they know how 'old' the data is?Constant color of a legend value
It would be nice if we can set a constant color/pattern to a value when creating a chart. We would often use the same value in different graph options and I always have to copy the color that we've set to a certain value from a previous graph to make it constant. It would be nice if we can set that values color constant whenever we'll be using it. Example: Table: Sales table Salesperson: James, John, Jessica Bar graph: count of sales by salesperson (James - blue, Jessica - green, John - yellow).How 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?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 discussionZoho Analytics integration with new Google Analytics 4
Hi, We recently migrated our website to a new ecommerce platform and started using the new Google Analytics 4 service (the new ID is G-xxx instead of UA-xxx). When we tried to add the data source of Google Analytics, it is only displaying our old UA-xxxCount at given moment in time
In Zoho Analytics, I want a pie chart to show how many people of each gender were employed on a particular user defined date (User Filter - Single Date Selector). I have the following fields within my employee records: Employee Number Start Date LeavingZoho Analytics Mass Add Field
Hi, is it possible to add the same field to several reports at once in Zoho Analytics? It will take a long time to do each one individually. Thanks.Continuous 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 alwaysReport of the Week - Comparative Analysis with Top N Items
Previously, we saw how to create a report for Top N Items in Each Category . Now let's see how to do comparative analysis along with top values with the following reports as examples. Comparing Current and Previous Month Customers' Invoices - This reportAnalytics 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?Timestamp for Dashboard
I'd like to insert a timestamp onto a dashboard, and have the timestamp be for when the table(s) were last updated used in the reports. Any way this is possible?Exporting a report to a specific format (following company brand guidelines)
Hi, I would like to start a discussion on the different ways to format a Zoho Analytics Reports in order to follow company brand guidelines. I would like to know if any of you had some suggestions on how I could make the format of my reports more seamlessDisplay Order for Stacked Bar Charts
I've got a stacked bar chart that is correctly displaying the data I want it to, but I want the data sorted in descending order by value - it's currently sorted in alphabetical order by name (so reading from left to right it shows Alpha (3) Beta (1) Gamma (5). I'd like it to display in Gamma Alpha Beta order. Is this possible (without switching the axes). ThanksGet a list of Date in Zoho Analytics Database Query
Hi, is there an option for me to populate a date in the query? For example, 2009-01-01 2009-01-02 2009-01-03 2009-01-04 2009-01-05 2009-01-06 2009-01-07 2009-01-08 2009-01-09 2009-01-10 2009-01-11 2009-01-12 2009-01-13 is what I am looking for the column populate. I am looking forward to have this. I will also LEFT JOIN the other table 'Date' into this populated date.Plain text to date data type
How would I be able to set a plain text field that contains month and year("June, 2021") as a date? I am currently trying to change it in a query table by clicking the change data type button but its not allowing me it says "it is not compatible". IsChanging format from imported Zoho Projects tables
Hi, I am using Zoho Projects with Zoho Analytics. I use several tables from Projects were fields are formatted in .# (decimal) as Projects does not allow you to select other type. Is it possible to format this field differently in Analytics ? like .#How to access department data for each project and job from Zoho People
Using Zoho Analytics how can I see the departments that belong to each job and project from Zoho People? I don't see the related fields in Zoho Analytics.Not able to change the data type
Hi Team, I am trying to change the data type of Avg. Time on Page but I got an error message as below. Please advise me how I can change to the Time format for Avg. Time on Page.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: 10000Formula avg for specific month/ avg of total
I'm hoping to make a formula where the average of sales for specific months is divided by the average of overall sales. This is what I have so far: avg_if("TEST FORECAST SALES"."Month 2" = "TEST FORECAST SALES"."Month 2","TEST FORECAST SALES"."Total")/ignore_filters(avg("TESTZOHO 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. MarkDatabridge on multiple machines
Hello We have set a databridge up on a machine where our database will sit but I cannot see this when I log in (it was set up by a different user). Should I be able to see this? I am setup as an Organization Admin. Also, if I also connect to the machineReports Deleted
Hi Team, I login this morning and saw my Leads Dahsboard showing "View Deleted" on each report. I logged in and checked, Except three reports, each report under "Leads" folder of "Experitest CRM Reports" is deleted. I have like around 15 reports in there. Can you please quickly check what just happened and how can I recover those ? Thanks, Hasandynamic threshold value based on required average for a target
Hi, I am looking at adding a dynamic threshold for an entire table on a chart report. For example our target is £30,000 the required average total sales is £1000 per day, however this isnt always the case for obvious reasons such as the weekend, weakerNotes 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?Break Glass Admin Suggestion
There are several issues we have ran into, involving not being able to use "Premium" features, which we have paid for, unless we are logged into the account as the owner. A minor example of this, is our ability to link zoho analytics organization to zohoFormula to sum sales for last YTD
Hi there, I'm looking for help with an aggregate formula to sum sales for last YTD. I'm trying to create a report that will show the Months sales for 2019 and the TOTAL YTD for 2019 compared to Month sales in 2020 and the TOTAL YTD for 2020. Any help would be appreciated.Create a dashboard with a formula in Analytic
Hi everyone, I need to know the average date of purchase per a product per a customer. Here is how I count it. For example: Customer A bought product B in Jan. I count it "1" Customer A bought product B in Feb. I count it "1" Customer A bought "0" inData snapshot every 2 weeks in Zoho Analytics?
I know you can take data snapshots in Analytics once every day, week, and month. However, I am wondering if there is a way to set up data snapshots to happen automatically only every other week?Lookup two reports / Duplicating Data in table
I have two Labor reports I am trying to reconcile. One report is a payroll report with employee ID's, Date's worked, and Hours. The other report is a time ticket report to track labor activities, which also has employee ID's Hours worked, and the date.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 notNext 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 discussionAdding 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: 10000Tip 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 notAggregate 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/outboundAnalytics 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?
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