Performed changes in the query is not allowed due to following reason(s)
I have a pivot table that is not updating because of an increment in our Fiscal Year. I discovered that the table is built on many different query tables. Following that to the bottom, I found the source. A table that has a formula column with a date value hard-coded. When I try to change that formula, I get an error that it cannot be changed because it would affect other tables. I know that it will do that, and I am okay with it because I know that I am just updating the year. My next thought was
TO_INTEGER + TO_INTEGER generate a String not a Number
In a Query Table I put a formula like TO_INTEGER(IFNULL(MAX(xxx), 0)) + TO_INTEGER(IFNULL(MAX(yyy), 0)) AS "xxx + yyy". xxx and yyy are numeric columns with empty values. And the problem is that that formula output value like "014" or "080" instead of 14 or 80. Any idea ?
Find if a parameter exists across any contacts for a given account
Hi - I am trying to write a query that will find any account that purchases a certain Brand from our company but does not have any contacts identified as Buying for that Brand. Brands are listed in a custom multi-select "Brands" field in the Accounts Module. These brands have been split out in a query table "***NEW*** Account Brands Table" so that each Account-Brand combination has its own row. The same brand options are also available for selection in the Contacts Module under the custom multi-select
User Filter search Pivot Tables choose per text search
For user searches in pivot tables, you can enter text to get a list of records containing that text. Unfortunately those choices do not become automatically chosen as the search criteria (or a choice to uncheck all). This is a problem when your search results in many records, all of which you would like to look at. It would be great if this functionality worked similar to how the same functionality in excel works. Please let me know if this is possible, or if not, please consider this a suggestion
Alertas en los indicadores y gráficos
Sería genial que se pudiera configurar alertas cuando un campo, fuera mayor, menor o igual que otro, y te dejara configurar también a quién quieres que le llegue la alerta vía mail.
Import from feed fails for a common source that does work in Googl-Sheets
This source (https://analytics.usa.gov/data/live/os.csv) can easily be imported in google-sheets. But import fails in Zoho Analytics. It also fails in ZoHo Sheets. (sheets gets the encoding wrong or thinks it is an encrypted file) It is a very simple text-file.
SQL limit 1.000.000 lines
Hi. I'm facing a problem with the limit of 1.000.000 lines foe a SQL table. Is there any way to avoid this restriction? I really need to expand this limit. Please confirm. Kind Regards Matias
Can I add an auto-number column to a query table
Hi everyone, I'm working on creating an efficient database schema for my Zoho Analytics reports. I want to create auto-number columns in my tables as IDs to be used as primary keys so that my queries run faster. Right now I have unique columns that I'm using as PKs but most are plain text so as I join the tables through reports the response time is fairly slow. Is there a way to add a new auto-number column into a query table? Thanks! Katie
Charting Comparison: This month vs. This Month last Year
Hoe can i chart the following: - This month vs. This Month last Year - This week vs. This week last Year etc. Any help would be greatly appreciated!
Join Tables in Live Connection
So my understanding is that it's not possible to join tables (or create lookup columns) for Live Connections with cloud databases (like Amazon Redshift). I know I can set up Data Import instead, but that's not ideal because I would quickly run into trouble with reaching the row count quota. This is the one and only reason why I can't completely replace Tableau with Zoho Analytics and it's very unfortunate. Is it possible that I'm missing something? Or if not, is this something that may be developed
Line Chart
I have a line chart showing volume over the span of 4 years on a monthly basis. What I would like is to show each year with a different line. So 2016 will show Jan, Feb, Mar, etc on one line. 2017, on another, 2018 on another and 2019. I am not sure how to accomplish this though, can anyone help? Thanks Chad
How do you join tables?
I am trying to join tables to create a report combining them, but any documentation explaining it or instructional videos are showing "Edit Design" button which needs to be clicked in order to create lookup columns. However, I simply don't have that button on any of my tables. What am I missing?
How can I create a report based on users roles?
I need to create a report based on CRM showing the accounts per user role. I don't see any way to get the users roles on reports. Can this be done? How could I achieve that?
A report value created from the Desk data is wrong despite it being correct on Desk reports
I'm not sure about when this problem did occur. It was displaying the same value as the Zoho Desk report. My guess is that I did check it for the last time about a week ago and it was correct at the time. I have synchronized the data for more than one time to be sure that it wasn't a synchronization issue. Could you please check the reason for it. The total ticket count on the Analytics report should be 59 instead of 15. The total ticket count is being displayed as 762 on the Analytics report whereas
Data source ZOHO CRM is not available in My Analytics Project
Hello, I have a project_a where it have a data source with ZOHO CRM. I cloned project_a to project_b, but my project_b do not have data sources and I can not to add data source of ZOHO CRM, it is possible add it? Thanks.
Using one dashboard filter for more than 2 tables
Hi Guys. Can you please help me with the following issue?... I need to have one dashboard filter that applies to several tables shown in the same dashboard (some of them are SQL tables). The columns of these tables have the same data but different names. How can I achieve this? Please help me. Kind Regards Matias
User filter search
I have a user filter which has a list of more than 100 items. To search through this, I need to "select" the search box in the dropdown and type. Would it be possible to search as soon as I dropdown by typing without having to select the search box? Sony
Is it possible to hide unnecessary fields from the drilldown options on a stacked bar report ?
When you select the "Drill Down By ..." option on a stacked bar graph then you are presented with all of the fields available on the related module (We are analyzing the Zoho Desk data therefore I'm calling the tables used on the report as 'modules'). Is there a way to hide the unnecessary fields from the drilldown list or change the order of the fields listed ? It would also be useful to have a predefined drilldown option separate from the standard "Drill Down By ..." option.
Export as PDF Function in the embedded code
Good day! We have just recently tried the Zoho Analytics Application. Based on what we've explored that the exportation to PDF of a chart or a table is only done in the Zoho Analytics Application. Is there a feature in Zoho Analytics that can export the pdf version of charts or tables generated when it is already embedded in the website we are using? Thank you and I hope you can help me regarding this matter.
Access rights on Zoho Analytics report and dashboard folders and datasources
Hello, We have created a single workspace containing all datasource for our organisation. We would like to open it to everyone but we would like to secure access to some folders or datasources. Is it possible ? Thanks, Leonard
Updated Mongo DB Java Driver
I see the Zoho Analytics Upload Tool uses the mongo-java-driver-2.14.1.jar version of the driver. It doesn't look like that version is not compatible with MongoDB 4.0. Is there a work around on how we can update that JAR file? Or does Zoho not support the most recent versions of Mongo? https://docs.mongodb.com/ecosystem/drivers/java/#mongodb-compatibility
Pivot table not reflecting correct data
I have created a pivot table making Zoho poject as data source and it is not puling data correctly for the custom fields that are created in tasks of the projects
How to show average time in a panel
Hello, We currently have a requirement to build a label in a dashboard that shows the average wait time for a clinic. Our data is stored in Seconds (integer), so what we need is to calculate this column's average and show it in a formatted way (HH:mm:ss) inside a panel, simply as a label. How can we achieve that?
Error when using formula column with nested if conditions in a chart
While testing one of our multi-axis charts I've created a formula column in order to group up a few categories. My scenario considers data about public education, considering student enrollments. My formula nests 3 IF conditions and when checking the data by visualizing the table's data, everything looks fine, however every chart where I try to use it, the app crashes. Formula: if( "situacaomatricula" = 'Aprovado' or "situacaomatricula" = 'Aprovado por Conselho de Classe' or "situacaomatricula" =
Thames Valley Expo - Ascot, England, May 22, 2019
Our partner Matraxis is having a booth and exhibiting Zoho Analytics at the Thames Valley Expo in Ascot, England on May 22, 2019. If you are in the UK and want to know how Zoho Analytics can help in visualising your data and in taking informed business decisions, please do meet Matraxis at the Expo. Links Expo - http://www.greatbritishexpos.co.uk/thames-valley-expo-ascot/ Matraxis - https://www.matraxis.co.uk
API EXPORT JSON Formatting
I have successfully setup a API call to export data from an Analytics report table. I am using JSON format for the export. But the JSON formatting is not as expected. I would like to see the column names included as true JSON key / value pairing format, and not have the column names shown above as in the column_order field. Current output { "response":
{
"uri":"\/api\/dfgdsfjdfsdfjgdf",
"action":"EXPORT",
"result":
{
"column_order":["Market_Day","Stalls"],
"rows":[
New Features rolled out on May 8, 2019
Dashboard Layouting made easy Dashboard layout has been enhanced with the following flexible layout options: Drag and drop multiple components together to reorganize the dashboard Resize multiple components together Copy-paste desired component's dimension to other components Apply proportionate width to selected components in a row Click to resize component and fill available space in the layout Allow Export for Reports in Dashboard A new option to enable or disable export options for the embedded
Percentages in table with Top N are limited
We've created a Top 10 table using the Top N filter feature, but since our top 10 shows the percentage that each of the records represent, we found out that Zoho actually ignores everything else, which means a record that would normally represent 30% of the total values, is shown as representing 45%, as it only considers the 10 filtered records. Is there a way to fix that?
Having an issue with a Nested "IF" Condition statement
I am uzing Zoho Analytics: This statement does works: If(condition"Rep ID"='Rep 1', "Gross Margin"*.5,If(condition"Rep ID"='Rep 2', "Gross Margin"*.50,If(condition"Rep ID"='Rep 3', "Gross Margin"*.05,if(condition"REP ID"='Rep 4',"Gross Margin"*.05,if(condition"REP ID"='Rep 5',"Gross Margin"*.2,"Gross Margin"*.4))))) This statement doesn’t work: If(condition"Rep ID"='Rep 1', "Gross Margin"*.5,If(condition"Rep ID"='Rep 2', "Gross Margin"*.50,If(condition"Rep ID"='Rep 3', "Gross Margin"*.05,if(condition"REP
Add columns in user table - ZOHO Analytics
Hello! Is possible to add information extra of ZOHO CRM in my users table of ZOHO Analytics (when I make sync)? How I can do it? Thanks guys.
Converting a Date from imported data which is in Plain Text to a date field to use with "include Timeline Filter" in dashboard
HI All I have data that in being imported from an external application and all the dates are being imported as strings. I need a way to change or create a new colum based on the date passed in so that it can be used in a dashboard using the control "include Timeline Filter" I have tried to change the data type to date but it errors on import and removes all the dates This is the date from the import The error i get on import is Thanks
Is there a way to pass a parameter in the URL generated for the viewers?
Considering we generate the URL for a particular dashboard, is there a way to get a parameter through the URL and use it to filter what the viewer sees?
Create Aggregate Formula to Determine True Win Rate %
Good Morning, We are using Zoho connected to Salesforce. I am trying to create an aggregate formula similar to the "Win Rate %" formula that comes with the package and is used on salesperson performance reports. The current formula only addresses closed lost vs closed won. I need a formula that considers every lead a salesperson visits, using all of the stages in an opportunity. Excuse my ignorance, I do not write code... The formula I need would use the stage field in Salesforce Opportunity Object
multiple customers on Business Intelligence Analytics (on premise)
Hello, We have a Business Intelligence Server on Amazon (EC2) hosting database of more than 100 customer. Each customer has a separate database because it has millions of records and in addition to being large databases would like to allow each customer to have access privilege to customize their own dashboards. In this context, I would like to use Zoho Analytics on premise installed on that single server on Amazon (EC2) and create a workspace for each customer. I will configure the profile of each
Facebook ads Integration bug when using account in MXN currency
Hello Guys I've been trying to retrieve data from Facebook ads and campaigns, however, when I open the Accounts table created by zoho, I see the columns "Amount spent" and "Balance" quantities are wrong. They display $37,947.00 and $15,407.00 this is wrong, since when I see this in facebook, Amount spent is $379.47 and $154.07 its like is not reading the decimals or some weird conversion is happening. Hope you can help me with this. Thanks!
We require an aggregated formula which uses the Desk ticket modification time based on a text field
We want to create a monthly average time report calculated by the difference of the ticket creation time and the modification time from Desk which is based on a specific text type field called "quotation no". Is it possible to create an aggregated formula which can use the ticket modification time based on the content of a text field?
Geo Maps
I think it would be a great addition on the back end of Geo Maps if you can add "Display Specific Continent" right under the "Display Specific Country Map" This way we can have 3 levels of seeing data 1. World 2. Continent 3. Country
New Features rolled out on April 26, 2019
Geo Maps Visualization Enhancements Zoho Analytics Geo Map Visualization has been enhanced with the following features. New Map Themes Map themes has been enhanced with Satellite map theme and a custom theme. With Satellite map theme you can now plot a geo map chart over Satellite map. The custom theme allows you to design a theme with your own colors and apply the same on a map chart. The map themes now support an option to invert the land and water color using the Invert Color toggle button.
Why is my filter not working in my CRM report?
Hello! I have created a lead report and want to filter out leads from shows. We have designated these in a field titled 'Lead Quality' then denoted as '5 - Show List'. I have this filter set as 'Lead Quality isn't 5 - Show List' but they are still showing on my report. Any idea why? I also have a filter of 'Lead Status isn't Disqualified' and the pattern set as OR. I have also tried AND, but that doesn't work either. Thanks for the help.
Selected Desk Ticket Field is not being synchronized
I've created a few reports to see the weekly ticket status on all departments in our Desk data. One of the departments was missing a field called "Serial Numbers" and I have added it into the synchronization setup just now but after forcing the synchronization I can't find it on the "Show/Hide Column" of the report settings. Please check this problem. Our workspace is already shared with your Analytics support team. Be aware that there is already a field named as "Serial Number" in singular form
Next Page