I need help with a column
I need to help me to make a formula for a column, it is to determine that when the data is greater within a specific column, is a type of retention, if it is less, is another type of retention, and if it is much less, is another type of retention, I getHow to put a dashboard offline?
Hi, I have a dashboard which is shared to several people within the organisation. I need to make some significant changes to the dashboard. What is the easiest way to make the dashboard offline during development of new features and put them live againHow to compare data from last 7 days to previous period?
I would like to create Widget that shows data - counts the number of specific contacts that changed their Stage to a Win Stage in the last 7 days. After that, and at the same widget, I would like to see same data from the previous period. Can I do that?Pivot chart - Formula (customisable) rows
Currently, the Pivot chart has a "grand total" bottom row that adds the values in the chart. However, I need this row to perform a different calculation. Specifically, I'm building a multi-dimensional income statement which need to subtract expenses fromApply Filter to multiple tabs in a Dashboard
Like the subject says, I have a Dashboard with 6 tabs across the top first tab is an overview Subsequent tabs are different views of the same data, to show computers that are out of compliance ie. needs operating system upgrade, not enough RAM etc. AllEditing data sources as workspace admin?
Hi there, is there any way to allow workspace admins to edit data sources? I am a primary user of the account (across two workspaces), but not the account admin, so whenever I need to change import settings for data sources, I need to contact the account admin first and wait until they make the changes I asked for. This is very frustrating and time consuming. Please advise! Thanks, GerickeExporting Analytics Dashboards as PDF Reports
I am trying export PDF reports from analytics reports/dashboards that are aesthetically pleasing enough to send to clients. The native export has been a clunky process for me and the formatting has been inconsistent. Is there a 3rd party app that I canWhat kind of SQL uses Analytics?
Hello, I find confusing how the SQL queries work in Zoho Analytics. Coming from other platforms, these queries have sometimes different results with the same query. Does Zoho Analytics use personalize SQL? Also, some queries fail without any kind of information,Add column with logic function
Hello, Please, i need help for the following function in Analytics I have a column TIME with difrent numbers from 0 to 23. I have other 2 colums DAY and NIGHT with random numbers I nead an other column with following conditions. If the value in the TIMEURL data type - Link name & link address
Hi, I have a url data type filed called "link" in a table. I currently store the url address in this field. e.g. http://www.google.com I would like to show a link name instead, e.g. "Google" - Which points to http://www.google.com Is it possible to doChange database settings
Hello, I recently created a new database and created some queries. However when I'm trying to change one of the queries, I get the following error message: Performed changes in the query is not allowed due to following reason(s): Column 'totaltransactions'How to retain Currency formatting in the concatenated the column
Hi Support Team, I would like to keep the Thousand Separator for the " Refund Amt" column. This " Refund Amt" column has been concatenated with the "Bill no" Column. The Table is generated via SQL Query. SELECT DISTINCT (VC."Vendor Credit Number") asStarting y axis at 0 on line graph
Hi, Is it possible to change the default start point of a y axis on a line graph to 0 and not the minimum detected value? I can see that you can manually define the start and end of the range but this means that if I manually define the start as 0 then I also have to continually update the upper range limit when the data is refreshed. Cheers, JamesFormula Column 'aaa' cannot be removed.
how do i remove a Formula Column? this product is frustrating... Table reportSolution of the Week : Consolidated Balance Sheet for Multiple Organizations with different base currencies
In the previous solution, we discussed in detail about creating a Multiple Organizations Setup with the same base currency. In this solution, we will be addressing the process of creating consolidated financial reports, such as a Balance sheet, for multipleSpark Line in Zoho Analytics
Dear Team, I just noticed the Spark Line option within Zoho Analytics. However at Face Value I can not see what criteria are being used to group the data. Apart from the graphical representation I also did not find anything on this in the settings page.Conditional display and formatting of dashboard elements
It would be great if we could set conditions for whether or not to display dashboard elements and KPIs. For instance, in the settings for a given element, there could be an item that says "if the value/count/average/max/etc. of this columnNameData isAnalytics Table Data
I would like to include a field in my analytics tables to include the name associated with the ID. For instance, in the potentials/deals table to include the contact name associated with the contact ID. Can someone advise how to accomplish this?Zoho Books to Zoho Analytics sync fails consistently every other time
Different values between Google Ads and data in Zoho Analytics
Hi. We've actived the Google Ads integration to Zoho Analytics. However, we see that there are different values in Zoho Analytics if we compare the same data to Google Ads. How is this possible? Is it possible that values are rounded off after they areHow do you append all CSV files in folder using data bridge - i.e. like excels get data from folder function?
Currently we use Excel for our dashboards with power query and power pivot. The power query dataset is set to grab all csv files in a particular folder and append them together. (as we have a folder that automatically has a new sales file added to itZoho Analytics sync period on "standard" plan
The pricing page of Analytics claims that the data sync interval is hourly without pinpointing specific applications. The shortest interval on the Data Setup page for data sync settings is "3 hours". Is the info on the pricing page incorrect or are there some other settings for the data sync setup which will allow us to set it to "1 hour" ?MongoDB Integration Data Sync
I am currently using the MongoDB integration for Zoho Analytics. The only issue I'm having is that fields that are arrays do not sync in Zoho. It would be great to have an option for each table to unwind arrays if needed so that data could sync as well.What's New in Zoho Analytics - March 2024
Hello Users, We are back with the latest update and enhancements in Zoho Analytics to improve your experience. Read on to learn more about what's new in Zoho Analytics. New Database Connectivity We've added two new database connectivity options: HFSQLChange language dynamically
Hi, Is it possible to change the language in Zoho analytics without changing the user? Maybe there is a parameter in the url to be able to do it? thank youHow to work on separate files created on different dates
I have different set of tables updated on different dates Table 1 - Location 1, Work Done %, Date A - Location 2, Work Done %, Date A - Location 3, Work Done %, Date A - Location 4, Work Done %, Date A Table 2 - Location 1, Work Done %, Date B - LocationWhy do I need to check for null fields when excluding fields with certain content?
If I get all records and use WHERE "Lead Source" != 'Webinar' my report removes all records where Lead Source is Webinar or is null. It removes null fields. If I want to just get all records where Lead Source is not Webinar, I need to use this WHERE ("LeadMerge Pivot Table Columns to count as one column
I am new to using Zoho Analytics and I am trying to run some simple pivot tables. Basically I need to know how I can merge columns together so I can count them as one. We use Deal stages to track a record progress. Some deal stages need to be rolled upCombining two reports
I am a Microsoft Access Developer new to Zoho Analytics. I ran into an issue where filter two sets of dates cancel out one of the other. For example, I have client Start Date column and a client discharge date column. When I filter the start date andZoho Survey Table: "Respondents", Column: "Survey Modified Time"
Hello there, I wonder what the time is in the Respondents.Survey Modified Time column. This cannot be the data from the survey, as the two data are not the same: However, it cannot be the time at which the user last edited the survey, it generally cannotZoho Survey Table: "Surveys", Column: "Type"
Hello there, when creating a query in Zoho Analytics, I noticed the "Type" column in the "Surveys" table (table was automatically created by the sync between Analytics and Survey). It only ever says survey... I wonder what this information is even usedChart 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.Same Year filter for two date fields
I have a report that includes a FosterIntake Date and a FosterDischarge Date. I want users to view the number of youth that entered the program this year (2024) - Year of FosterIntake, and the number of youth that were discharged from the program thisInverse Scoring Results
I have a set of 6 text choices and they were ranked by users from 1-6, 1 being the Highest and 6 the lowest. I am trying to calculate the inverse scores and display them in a chart for all the respondents in the survey to show which answer had the highestImporting Google Sheet - date format problems
I have a Google Sheet with a "Date" column and its format is set to yyyy-MM-dd. When I create a table in Zoho Analytics and import this sheet, the preview screen shows the Date column format as "dd MMM yyyy HH:mm:ss" (e.g., 28 Sep 2023 00:00:00). WhenChanging Ownership of Zoho Analytics
How do I change the owner of Zoho Analytics[Webinar Announcement] Transforming raw data into actionable insights using data visualization
Are you looking to maximize the impact of your data insights through effective data visualization practices? Look no further than our upcoming webinar on the best practices for visualizing data with a modern BI platform. In this webinar, we'll cover howAccess Data Source from Another Workspace
If there a way to use data or a query from another workspace in Zoho Analytics? Thanks SimonPlot a count of records during a date range
Hi all, I am far from a SQL expert, but this feels doable and I just don't know how. If I had a table that looked something like Stage History.. Record Id Start Date End Date Stage Duration (Days) 11111 10/01/2020 10/21/2020 Needs Analysis 20 11112 09/20/2020Gantt Chart - Zoho Analytics
Are there any plans to add Gantt Charts capabilities to Zoho Analytics?Next Page
Announcements
New Features rolled out on April, 2024
Sunburst Chart We're thrilled to announce that Zoho Analytics now supports the Sunburst Chart. Explore the power of hierarchical data with our sleek and intuitive Sunburst Chart and uncover trends with precision. This dynamic chart visualization transforms[Upcoming Webinar] Refined data and faster insights with data preparation
Data preparation forms the bedrock upon which insightful analyses and informed decision-making stand, directly impacting business revenue. However, preparing data is often perceived to be a complex and time-consuming task that often demands IT intervention.We 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 constructingWhat's New in Zoho Analytics - March 2024
Hello Users, We are back with the latest update and enhancements in Zoho Analytics to improve your experience. Read on to learn more about what's new in Zoho Analytics. New Database Connectivity We've added two new database connectivity options: HFSQL[Webinar Announcement] Transforming raw data into actionable insights using data visualization
Are you looking to maximize the impact of your data insights through effective data visualization practices? Look no further than our upcoming webinar on the best practices for visualizing data with a modern BI platform. In this webinar, we'll cover how
Most Discussed Topics
Worked hour report help.
Good day everyone, I need some advice with Zoho Analytics. I am trying to get a report that will show the work hours of a user. We are using Zoho People timesheet/time logs. I connected Zoho People and Zoho Analytics, and everything is working fine. So,GROUP BY error message with IF statement
Hi, I'm reasonably new to coding so this may be a really simple fix (i hope anyway!) I'm building a query table to identify cases for inclusion in a healthcare quality indicator as well as produce an output column that provides a true or false statementImport Pandas data frame into an existing table in ZOHO analytics
I need to import pandas dataframe into zoho analytics table which is already existing in ZOHO analytics. How should I do that?How can I generate a report on dormant Accounts in Zoho CRM and Zoho Analytics?
I can't imagine this is a unique ask, but can't find an answer in the community. We have lots of Clients (i.e. Accounts) with various levels of 'dormancy' i.e. they have not engaged with us for # months. This is based on the date of the most recent EnquiryCan we consolidate data from multiple Zoho Books organizations having different home currency in Zoho Analytics?
Hello, Can we connect Zoho Books account having multi organizations with Zoho Analytics to consolidate data from all organizations? Each Books organization has it's own home currency like INR, USD, GBP etc. How to consolidated Sales figure and show amount
Zoho Subscriptions Resources
Zoho CRM コンテンツ
-
オンラインヘルプ
-
Webセミナー
-
機能活用動画
-
よくある質問
-
Ebook
-
-
Zoho Campaigns
- Zoho サービスのWebセミナー
その他のサービス コンテンツ
ご検討中の方
Zoho Sprints Resources
Zoho Books Resources
Zoho Projects Resources
Zoho Orchestly Resources
Zoho CRM Plus Resources
Zoho Campaigns 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.
Zoho Creator Resources
Sticky Posts
We 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 PREMOAnnouncing 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 PreparationZoho Analytics | Quarterly Newsletter | Q2 2022
Hello Everyone! I hope all of you are safe and well! Zoho Analytics - Q2 Quarterly Newsletter is out now! Check out the newsletter (attachment) to know all about our new features, recognitions, webinars, blogs, and many more exciting things. Do let us