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. Thanks
Zoho 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 design
How 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. Sony
Not 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? Thanks
Using 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). But
Can'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! Christopher
How 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 WRITTEN
Formatting 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 will
Drill 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? Thanks
Report 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"."Created
Lookup 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 enter
Add 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 Sunil
Why 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. xEDS
Enable Drill Down in Dashboard Views...
Hello, I am trying to make drilldown available on dashboards viewed view permalink You can check this link for an example: https://analytics.zoho.com/open-view/1497532000000156243/85c2726b127a59455d349bd912bec856 For this dashboard, under settings I have "Enable Drilldown" Checked! But, as you can see, there is no drill down functionality in the dashboard, unless it's actually inside of the Zoho Analytics Workspace. How can I turn on the Drill down function for dashboards accessed via link?
Burndown report empty
Hello all, I'm new to Zoho analytics, and I would need to simply use the default burndown chart. I follwoed all steps described here : https://www.zoho.com/analytics/setting-up-zoho-projects-analytics-add-on.html : please see the last slides at bottom page. So: - I added to the burn down milestone entry table - template my milestone (which is a sprint), like that - According to the tutoial, the milestone burndown calculation query should be filled automatically, which is not the case - And as a
Upload Tool for MS ACCESS - URGENT
Hi There. I'm facing some troubles to configure the upload tool to import a MS Access table from my PC to Zoho. Here is the error: 2019/02/14 20:27:53 ART: OS : Windows 8.1 6.3 x86 2019/02/14 20:27:53 ART: JVM Version : 1.8.0_51 2019/02/14 20:27:53 ART:System Properties os.arch :: x86 java.version :: 1.8.0_51 TESTRUN :: false CONN_PARAMS_FILE :: conf\database_connection_params.conf user.dir :: C:\Users\jy8694\Desktop\ZohoAnalytics\UploadTool os.name :: Windows 8.1 os.version :: 6.3 CONFFILE :: conf\common_params.conf
Columns - titles
Hello, I have created a tabular view and would like to change the column titles. I did that for my source table which I use in my tabular view. Titles changed in the table but not in tabular view. Is there any possibility to update the titles or do I have to build my tabular view from the scratch (hope not, it was a lot of work and titles are the last issue..) Best regards, Magdalena Osys
Report for Individuals?
When I have looked at the numerous pre-built reports in ZA, all of them are mainly for company wide data such as total sales, total service tickets in a month etc. Is it possible to use AI to generate dashboards for employees that show list of their CRM tasks, CRM opportunities, Desk tasks, Project tasks and so on? Right now if you are a small business where one employee might use both CRM, Projects and Desk, there is no single place to go to see all your work. I would like to know if it would be
How do I get a unique list?
I have a "database" with a number of customer names. Most there multiple times. I'd like to have a report to show the list of unique names and the order in which they are. Eg. 1 - Tom Jones 2 - Jake Smith . . . . 567 - Betty Jean How do I create a report like that? So no name should be shown more than once
Zoho Subscriptions
Hello, Are there any plans in the near future to add Zoho Subscriptions to Reports? Bob Lozinak Twelve/Three Marketing, Inc. Zoho Certified Solution provider
SAML/SSO with Azure AD
Is it possible to set up single sing-on through Azure AD with Zoho Analytics? I see several other Zoho applications listed as "enterprise applications" with an integration there but not Analytics. Thanks
Analytics isn't syncing all of the CRM data I need...
Hi, I have a module in CRM that I am trying to get to sync and link with my CRM accounts for reporting in Analytics, but it's not pulling the data. The module is called "Negative Reviews" which is associated with each individual account in the CRM. I've attached screenshots of my Sync settings and of the data I am getting
New Features rolled out on Feb 8, 2019
Enhancements to Zoho Projects and Zoho Bugtracker connectors The Zoho Projects and Zoho Bugtracker connectors has been enhanced with the following options. The User Rates module is supported in the connectors. Now, users need not manually enter the user rate value in the Zoho Analytics Workspace to create revenue based reports. From now on, the custom fields added in the Zoho Projects the Zoho Bugtracker modules will be synchronized into Zoho Analytics workspace. If you have set the Custom Project
Linking 5 tables in 1 new query table :-O
Hi, I need to create a query table relating several different tables (all in the same database). This is the specific case: TABLE 1 columns (transaction data): - Transaction ID - Specific data columns TABLE 2 columns (client data): - Transaction ID - Specific data columns TABLE 3 columns (invoice data): - Transaction ID - Specific data columns TABLE 4 columns (paid transactions data): - Transaction ID - Specific data columns TABLE 5 columns (cancelled transactions data): - Transaction ID - Specific
Notice board
I have an external notice board with the info pulled via the api which gives me all of the relevant information I need at a glance. It would be great if Zoho would give us a feature like this where we can build reports & save them to this notice board which would update automatically. See attached ....
Exclude Weekends
I have created some first response reports for the last 30 days. My Helpdesk is only open 07:30 - 17:30 Monday to Friday but people will log requests out with this time. I need the report to reflect only the times the Helpdesk is actually open. The report is skewed because it is counting 24x7 and not just open times.
Create sections in dashboards that you can show or hide based on dashboard filters
Hi I'd love to be able to create sections in my dashboard and set display rules based on my dashboard filters.
Reports & analytics
We have been using Zoho for a year and want to start receiving Sales, Conversion and Forecasting analytical reports. Reports at this time are weak and tell us nothing. Is there a service that we can enlist to help us with obtaining these tasks?
New Features rolled out on Jan 24, 2019
Country Specific Map Chart Zoho Analytics now allows you to plot a country-specific map chart. So far, Zoho Analytic displays the entire global map even if you have data for one country alone. Zoho Analytics will auto focus on the specific region alone. However, the neighbouring regions will be visible. Now Zoho Analytics allows you to choose a country specific map. This allows you to highlight the relevant region alone. Click here to know more on this. Support to Choose Multiple Lookup Column
Next Page