Default value for Timeline Filter
Hi, Does anyone know if I can set a default value for a Timeline Filter? Thanks SteveMoving a Summarize Column to the middle of a Summary View Report
How can I move a Summarize Column in a Summary View to the second column in the report?When was the 100K records per employee cap implemented for Zoho One subscriptions.
When I signed up for Zoho One, the limit for Analytics was 5.2 million records with NO "per employee" restriction. Today, I see there is a 100k record per employee limit. I'm a Zoho One single-seat license holder (a Solopreneur) and feel like the ground keeps shifting beneath my feat. When using Zoho Forms, records are stored in Analytics. My license allows for either 20,000 or 200,000 form submissions per month. Unsure because the number has a typo in your plan details page (see attached.) AssumingTicket Backlog Trends graph is being refreshed when backlog tickets get closed
We have created a ticket backlogs (Data is being transferred from Desk) trend graph which is based on Ticket Creation date and the actual values of the Unresolved Tickets count. This graph does refresh itself when we close those backlog tickets later on. For example its January column displays 5 total tickets at the moment but when we close one of those tickets then it does refresh itself down to 4. We want the monthly columns to always display the count of tickets which weren't closed at the endDeleted emails from trash
Few emails has been accidentally removed from one of our client sales@freezee.us Missing emails from 15-01-2019 to 01-04-2019 please retrieve the emails soon .Emails has been deleted 01-04-2019. .New Features rolled out on Mar 20, 2019
Security Control Options Zoho Analytics provides a set of security options that enable you to control and manage access to your account. This includes setting up IP restriction as well as controlling the various sharing & collaboration options being made available. Allows you to restrict accessing views in your organization account only from the allowed IP ranges. Allows you to restrict sharing of data/views in Zoho Analytics only to users from the trusted domains. Allows you to restrict the generationInvited user for a standard plan can't access our workspace
This user has accidentally created a free account on Analytics instead of joining our workspace and unfortunately they can't access the workspace at the moment. How can we delete their free account from the system or at least let them join to our workspace?Moving Count of previous 12 months
I am trying to create a graph that counts the number of entries in 2 tables per month as a moving count of the previous 12 months. Based on this count, I am calculating the average by dividing the count of one table by the other (by adding a formula). The data I have is for 10 years, but I would like to see only the last 12 months in my graph. I am attaching 2 graphs. One is with Null values selected. This shows the correct data for the previous 12 months, but has 13-24 months also shown as a nullZOHO Forms to input data into the Tables
I would like to know if it is possible to integrate ZOHO Forms with ZOHO Analytics. This way I an create a form for end users to enter data into the tables. This would need to have drop downs and selections to make it easy and prevent data errors during data entry. Best regards, SonyNew Features rolled out on Mar 27, 2019
New Chart Type - Bubble Pie A new chart type called Bubble Pie Chart is now added. This is a combination of pie and bubble charts. The data column dropped in the Size determines the size of the bubble. Other aggregation will be plotted as a proportional division of the bubble. This will be useful in displaying multiple pie charts to compare the proportion of data across a series. For more details refer here . Combination Chart - More Chart Types Supported Now Combination Chart supports moreError to share Workspace in Zoho Analytics
We are getting this error: "Alert Message" "One or more specified users do not exist in the Zoho One organization. add users and try again" But the user exists in Zoho One. Any help would really appreciated, it's really urgent. Thanks,Blueprint and SLA violations reports on Zoho Analytics
We want the Blueprint and SLA violations reports to be placed into the Helpdesk Reports folder on Zoho Anaytics by Zoho. We don't know the rules behind these dashboard kind of reports on Desk so it would take us a lot of trial and error to create them on Analytics by ourselves. Please help us out by directly creating the templates for these reports on Analytics.Heatmap in Zoho Reports Dashboard
Hi, Is it possible to create a heatmap chart, such as the attached, for viewing in Reports Dashboard, or is it possible to import one from excel, or integrate a plugin from google maybe? I've attached an image of the type of heatmap I would like to use. Thanks, LeonCannot add another dashboard
I have a db which currently has 2 dashboards. I am attempting to add a third, however when I drag a report to the "right hand side" it doesn't drop into place. I seem to be able to add widgets and text but no reports. Possibly related is that when I try to add another report to one of the existing dashboards the same thing happens. Thanks.Aggregation based on user filters
I have seen this in other analytics packages, but when a user enters a different time period in a filter, the ability to change the time period that the data is aggregated by is also provided (for example, you can change from monthly to a quarterly data aggregation when you extend the period from 6mths to 24mths)dashboard update automatically after 5 minutes
Hi, Hello, I set up a dashboard to let on a LED TV 40 "presenting graphs (full screen chrome navigate, key F11), how to do that it is updating the dashboard from time to time (5 in 5 minutes)? Rgs, Fabio.Zero boot panel
Good afternoon, I would like to know how I can do to the panel, not display all the data initially, only after using the filter display data.Map Chart - Needs better contrast and Roads
The Map Chart is great and is very functional but the State lines are very hard to see and need darker contrast. Also when will roads be added to the Map Chart?Edit Permission for Shared User
I would like to give Edit functions of a report to a co-worker so both of us can work on building/updating the report for our organization but I do not see how that is possible. Can you help I cannot give ADMIN access of our entire Workspace to this co-worker just certain Databases within the Workspace and Reports created from those Databases.Data comparison report for current and previous periods like WTD, MTD, YTD
Hi, We have base tables with day-wise transacational data. How to make the reports of data comparison for current and previous period like WTD, MTD, YTD.(Week / Month / Year to Date) Is this possible to configure in widgets as well. ThanksZoho UploadTool and OpenJDK
Hello all I have been using the UploadTool provided from Zoho to upload information from our server DB to Zoho Analytics and it worked like a charm with no issue. Thing is that now we have upgraded our server to Ubuntu 18 and configured it with Java "OpenJDK 10". When we try to run the Uploadtoold we get serveral java errors.... Exception in thread "main" java.lang.NullPointerException at com.adventnet.zoho.client.report.advancedtool.AdvancedUploader.logException(AdvancedUploader.java:887)Create Table JSON Spec
Hello, The API Documents explains that a ZOHO_ACTION= CREATETABLE is possible. https://www.zoho.com/reports/api/#create-table However the payload info only say ZOHO_TABLE_DESIGN (mandatory) Design content in JSON format Table structure in JSON format (includes table name, description, folder name, column and lookup details). There is no spec on how to actually design the table... Table name, column names, column types, etc ... Are there any guides or a examples how I can use a JSON table designHow to get this function to return a currency?
I am using a column formula to create a report that shows what will be invoiced each month (projected out years in advance). For example, my August 2021 column contains this formula: if((iscontains( "Invoice Dates",'Aug21')), "Standard Invoice Amount",'' ) The "Invoice Dates" column contains all the dates that a customer will be invoiced. For example a row in the column might say, "Aug19; Aug20; Aug21", and the "Standard Invoice Amount" will be whatever the contract says the customer will be invoiced.Chart responsiveness
How can I make charts that are embedded responsive?Using Zoho Upload Tool to connect more then one Database
Currently I`m using the Upload Tool to connect a Firebird local DB with my Zoho Account, but now I need to add a new local DB in the process (also Firebird). Is it possible to do this? I can do it just editing the configuration archives or do I need to create a new archive and do a separated process? Thanks for de help.Lookup column unresponsive
When amending data in my table (TblInspection) where there is a lookup column, I almost always get the "page is unresponsive" error. On clicking on wait, it normally disappears. This is getting to be quite a distraction and would request that the response time is reduced. The lookup column is linked to a table where there are 18500 rows to lookup from. SonyNot able to share any Dashboard created
Hello All I am using Zoho Analytics and tried to share a Dashboard I have created with another user sending the invitation by mail through the normal "Share This View" link. When the user clicks on the link he only sees an error page saying that was not possible to open the view. What am I doing wrong? ThanksUsing Zoho DataBridge to connect a Firebird Database
I`m trying to connect my local firebird DB with my zoho analytics account, but in the importing page there isn't the firebird type of DB. Databridge can`t be used with firebird? Currently I`m using zoho upload tool to do the job, but now I need to connect more then one dataset, so i thought that would be easier to use databridge. Thanks for the help.Minimum range in bullet chart widget
I am plotting bond prices, which have a range that centers on 100, rather than being zero-based. The bullet chart widget currently has a dynamically assignable maximum value percentage, but I would like to also be able to specify a minimum value so smaller variances can be seen. For instance, if my values are all between 95-105, a chart that shows a range of (105 - 0) = 105 values shows very little visual difference between a price of 101 or a price of 104 (approximately 3% visual difference). ButCan't upload images on dashboard
Hi, I can't upload images on zoho analytics dashboard. The screenshot shows the image is being uploaded, but it stays that way for ever. It never ends. The image is in "png" format and it weights 51 kb. Thank you! ChristopherHow do I get rid of this error Whenever a table alias is defined, kindly use table alias name before the respective columns used in SELECT query
Here is a copy of my code. I am not sure waht I am doing wrong here. Thaks! SELECT "effective date", actioncount1 = (SELECT COUNT("Name") from "WRITTEN/NOT WRITTEN TRACKER" T1 WHERE T1."EFFECTIVE DATE" = "WRITTEN/NOT WRITTEN TRACKER"."EFFECTIVE DATE" AND MONTH("Effective Date")=(MONTH(GETDATE())-1)), actioncount2 = (SELECT COUNT("Name") from "WRITTEN/NOT WRITTEN TRACKER" T2 WHERE ("WR/NW"='WR') AND MONTH("Effective Date")=((MONTH(GETDATE())-1)) AND T2."EFFECTIVE DATE" = "WRITTEN/NOT WRITTENFormatting summary view without gridlines
This seems like it should be a simple update to the table themes. We get requests for client lists fairly routinely, and I have a summary view that is user-filterable for things like budget size, region, sector, etc. I also have a branded dashboard that I export as pdf containing this table. I would really like the table to appear as a list instead of as an spreadsheet. Is it possible to create a table "theme" where the grid lines are invisible? Or just the topline is visible? Not this:AVG of total ammount per day of month
Hello I have a table that stores a column "QTY" related to a Month and a Year. What I would like to get from Zoho Analytics is a chart that would reflect the Average of the "SUM(QTY") but per days of the month. For example,. if I have the table like this Year | Month | QTY | User 2019 | January | 10 | 1 2019 | January | 12 | 2 2019 | January | 18 |4 2019 | January | 15 | 3 The chart would be a column where QTY per day for January would be SUM(QTY)/DaysofMonth(Month) 43/31 = 1,38 So then table willDrill down into a bar on a stacked bar graph changes the per bar counting method
When I drill down into a bar on a stacked bar type graph then the bar counts on the resulting graph do change to "adding style". What I mean with "adding style" is that each consequent bar on the resulting graph does display the total value of the former (the ones to the left) bar values plus its self value. This problem only happens on the drill down graphs but not on the main report. Please check the following sample. Is there a way to fix this issue ?Add same column in multiple reports
Hi, I have added a new field on Zoho and I now want to display this in several reports. I've added it into the list of fields easily and it now shows in one of my reports. Is there an easy way to add this column to several (40) reports without going in and adding it to each one individually please? ThanksReport Filtering Question - Dependancies
Hi Folks - I have a bit of a unique business need regarding a desired format on an Incident report i have created. My current report is to show any Incident requests (any status) by Subcategory for the prior month. However, there is a need to also include ANY incidents that remain 'open' (i.e. not 'Closed' or 'Resolved'). How would I combine these two conditions? I can't seem to get it.Assistance Needed for SQL Code
Hi Team - I am having difficulty getting a UNION ALL query to work correctly. For the first part of my query, I need to returns all requests that were created in the previous month, which I tried like this with no luck: SELECT "Site" , "Request Custom FIelds"."Request Type" AS "Request Type" , "Sub Category" , "Request Status" , "Requester" FROM "Request" INNER JOIN "Request Custom Fields" ON "Request Custom FIelds"."RequestID" = "Request"."RequestID" WHERE "Request"."CreatedLookup Column based on ID and not name
I have imported my Acccess Database into Analytics. The tables are connected using Lookup Column which is linked to the ID. e.g. I have a table called 'Inspector' and 'Company'. The lookup column in 'Inspector' looksup the Company ID. However that is a number and is meaningless unless I know the name. Is there a way to lookup the ID, but display the name, like we can do in Access. The difficulty is that to update the 'Inspector' table, I need to find the Company ID first from 'Company' to enterAdd user filter that filters data values that CONTAIN a search term
Hi, Is it possible to create a user filter for a report that includes all items in a column that contains a text value? For example, create user filter on Customer Name where Customer Name contains the value 'smith'. The equivalent SQL statement would be: Select * From Customer Where [Customer Name] Like '%smith%' Of course I do not want to create a query table for this. The report is for a business user who may want to change the user filter dynamically when running a report. Cheers SunilWhy can't I select chart types other than Line Chart?
Hi Why can't I select chart types other than Line and Scatterd Chart? The other types are disabled!!! Is it because I am on the free plan? For example, I can't select a Pie chart, 3-D chart of any kind it is all grayed out. Thanks. xEDSNext 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
Make 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 linkHow 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 formulaContextual 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