Problem saving a Tabular View with filter
Hi, I have a table called "Person" with a column for City. Out of 87 records in the table, some 10 or so have City=Cambridge. I want to filter the records for that value. So, I click on "Person", then "New Tabular View", then "Filter", then change the drop-down under "City" column to "Is" and type in "Cambridge" (without the quotes), save, and then click on "Apply." That filters the records correctly. But, if I move away from the screen and then click again on the "Person-Cambridge" view, I get the
Massive Issue With Select All Statement
We have been building reports in Analytics for some time now, and have commonly been using Select All Statements. Recently we reached our limit of 100 fields synced from a module, so we had to turn off 2 fields we no longer use in order to add 2 new ones.
Exclude weekends from charts
Hi I'm trying to create a chart to show the number of sales on each day. The problem is that although I want to show days during the week with no sales, I don't want to show the weekend days on the chart. I've ticked the 'Show missing values' box in the
import time field data from zoho creator to zoho analytics
I'm making a dashboard in Analytics with some data from the Creator, but Analytics is not importing time fields. Is there any way to solve this problem?
Tip of the Week - Your Own Customized Color Palette for a Workspace
A Color Palette is a collection of colors that you can easily apply to your charts and dashboards created in Zoho Analytics. A need for a custom palette arises based on the data being analyzed. Also, a brand could be easily recognized by the colors used.
Collapse vs un Collapse data in dashboard, pivot tables
Hi, Is there anyway to collapse / uncollapse data in the pivot tables in the dashboards?
Zoho SalesIQ + Zoho Analytics Integration issues
Just noticed that the "Visits (Zoho SalesIQ)" table in Zoho Analytics clears all data more than a year old. This means important data such as refferer is lost after a year. Is there a way to import all SalesIQ data? If not, is there any way to import
Can the quadrant Analysis function that has been created for Zoho CRM be used in Zoho Analytics?
I am wanting to create a dashboard on our website which will show a bar chat based on some Zoho Survey information, I then want a quadrant to be shown when the user selects one of the bar chart bars. Is this functionality available?
How to edit the underlying query for a predefined datasource report?
I love love the fact that you can display the data model for a datasource. I want to edit the underlying query (SQL or is it ZOHO-QL), so that I can relate additional tables and display additional field values. Maybe i need to clone the report first??
Zoho Analytics - Summary View Records Missing
I have created a summary view that joins data from multiple tables, however if a record that should be included was created by someone other than me it is not appearing on the report. If I duplicate the missing record and recreate it under my own user
Report that show count of records by Month using 2 date fields
Have a table with records that include a client Start Date and End Date. Want to make a report that shows a count per month of how many records for that month have a Start Date in or before that month and have an End Date after that month (or no End Date
Question regarding aging report
Hi, I have a question on how to make ageing details report using the intergration between Zoho Books and Zoho Analytics. Here is what I want to make Customer Name, Invoice date, Invoice numbers, Total Invoices, 0-30, 30-60, 60-90 I can see the “ageing tier” has the function for 0-30. So for sure we can make the 30-60 and the 60-90. But I don’t know how. Please help. Thanks, Albert
Dashboard Permalink auto refresh not showing new data
I have a dashboard with just one widget tracking current value against previous value. A new value is uploaded to the table every 15 minutes. When I create a permalink for this dashboard, even with auto refresh turned on at 120 seconds, it doesn't keep
I can't change 'Unknown' to zero value
I cant make formula because instant of making the field ZERO it shows me 'Unknown' If data in Aggregate Formula is "Unknown" because of no data, is it possible to make it as '0' so my next Formula wont be "Unknown" also?
Shopify, Instagram, LinkedIn, Youtube and 7 more extensions for Zoho Analytics
Connect your existing tools with Zoho Analytics to analyze your data visually. Create stunning data visualizations and discover hidden insights in minutes. Shopify for Zoho Analytics Measure, analyze, and run your ecommerce business efficiently with a
Is there anyway to replace the data source in duplicate dashboard instead of create from scratch
Hi there Right now, I have the final dashboard's template and I want to duplicate them for my clients(with different fb ads account) But, I'm not be able to replace the new data source on duplicate dashboard Any tip to do that? Thank you
User Filters and Widgets
Hello, I have a widget that I want to compare the Latest vs Previous day's values. When I apply a date user filter, say for a few day's ago, I do not get any data on the 'latest' column, but instead it shows up on the previous column. When I remove the
change 'Unknown' to zero valu
If data in Aggregate Formula is "Unknown" becouse of no data, is it possible to make it as '0' so my next Formula wont be "Unknown" also?
How to show a zero value in the KPI widget
I'm using a KPI widget to track week by week sales performance. I have it set up to be grouped by date and then show as latest. My problem is that If I don't have a sale in the last week, the widget takes the value from the week before. How can I configure it to show me a value for the week I need rather than a value closest week with non-zero sales. M
Zoho Analytics API Authtoken - Deprecation Notice
If you are using Zoho Analytics APIs and using authtokens for authentication, please note that the support for authtoken will be deprecated very soon. We recommend to use Zoho OAuthTokens instead, which are much more secure. Zoho OAuthTokens work much
Sprints to Analytics
How to import project information from Sprints to Analytics? I know there is no direct connection, but how can I turn it around while developing the integration?
Contacts with zero tickets
I want to create a report showing contacts that have zero tickets associated with the contact. When using Analytics, summary or pivot table, it won't show me records with zero count.
Create Sperate Portal for Zoho analytics for each account
Hello Zoho Support Can we create separate portals for each user? I want each user to only access/view/edit the reports, the data they are authorized, they can only create the report that they are authorized in data as well. Please guide me if it's possible?
Brazilian at zoho analyst
Olá pessoa meu nome é matheus oliveira e uso o zoho analista para elaborar painéis de gestão no brasil, haveria algum brasileiro na comunidade onde ele pudesse trocar experiências e conhecimentos sobre a ferramenta? por favor contacte-me e-mail: mat
Zoho Analytics Inventory Dashboard
We are looking to have a one stop dashboard where our sales team can pull up an invnetory dashboard that they can quickly and easily see inventory per style with the ability to drill down to style/size. Anyone have anything out there that can do that?
Calculating Weighted Average
I have a table of people with an age and a value. I need to calculate the weighted Age of these rows, where "Value" is the weight. Age 50, Value 100 Age 40, Value 150 Age 30, Value 175 Here's the weighted average age formula: (100×50+150×40+175×30) /
How to I edit a onedrive datasource?
Hi. How do I edit a onedrive datasource without loosing charts connected with that datasource? For some reason it stopped syncing with a excel file.
Monthly Average
Hi, I have this pivot table, which i share for technical assitance, where i calculate a monthly total for CANTIDAD DE FACTURAS, VALOR DE FACTURA and NUMERO DE RADICACIÓN. I need your help on how to calculate a daily average for this 3 concepts according to the days of FECHA DE DIGITACÍON of each month. Its important to understand that VALOR DE FACTURA can be added up but the other two need to be counted . I made an example on excel for august so you can understand more or less what im looking for
If statement for after this year
Hi I'm looking to create a formula column that will look at a particular date field (in this case it's called Renewal Due Date) and if the date is after this year return the word 'Yes' or 'No' for all other dates and blanks. Any help would be much appreciated.
aggregate formual
Dear Team, I have created one aggregate formual as duplicatecount in main Table ie "Lead" table , "Lead" table joined with other "B" table , I created "LeadB"query , i need that aggregate formaia column in created query "LeadB". please suggest how to
Error while executing query
I am using this code for executing query, IReportClient RepClient = new ReportClient("1000.xxx", "xxx", refreshToken); //'Zoho CRM Analytics' //Enquiry , leads string tableURI = RepClient.GetURI("xxx",
Does Trusted IP ranges mean user's IP address in Zoho Analytics Whitelabel?
I'm trying to setup the Zoho Analytics Whitelabel. I want to know whose IP does "Trusted IP ranges" refer to? Client user who is trying to login, or the SAML Identity Provider? If the client user's don't have any specific IP, can I leave it blank? For reference: https://www.zoho.com/analytics/help/whitelabel-setup.html
Count new customers in graph
Hey there, I have a small question: I want to see in a graph how many new customers we created in each month. So I want analytics to look for sales orders in a given month and count every order that came from a new customer for that month. I thought I could easily do this with a graph, where the x-axis is the order date from the sales orders module (by month&year) and the y-axis is the account-ID (set to "individual count" in a running sum). However, it counts only individually in the given month,
How to graph two two data points on a single graph
Hello, We're trying to represent the number of Zoho desk tickets opened and the number of desk tickets closed each month on the same graph. We're looking to create something like this: With perhaps the blue area being the number of tickets opened, and the grey being the number of tickets closed. I'm not sure what to make the X axis, as I'm looking at both ticket create date, and ticket closed date. Do we need to create another table that somehow counts each of these values in a row dedicated to a
Calculating time cost with different rate periods
Hi We have a table of timesheet data, with hours spent on a specific date, by a person. We also have a table with a persons cost rate between two dates. For example, £25, from 01/04/19, to 31/03/20. This table allows us to track changes in a persons cost rate of the get a salary increase. So the same person may also have a row in addition to the above for: £28, from 01/04/20, to 31/03/21. We then have a table for people, which links the two tables above. So the time and cost rate tables both have
Re-authenticate your Twitter Competitive Analytics integration
Dear Customers, With the continuous effort to enhance the Zoho Analytics product, we have made some changes in the Twitter Competitive Analytics integration framework. As a part of this update, the Twitter integration account authenticate was revoked.
Sync Failure
Hi, I am trying to either create new dashboard or updated preexisting one (preferred) but there is a sync failure. See attached. How should I reconnect?
How to use ZOHO CRITERIA on public panel url
Hello, I created a panel with different graphs that use different tables as a base but all of them got the same column called seller, I configured in all graph options filter parameters to link to the same filter. I want to use this filter in the URL so u show different panel for every seller.
Create a subtotal in a summary table
How do you create a subtotal in a summary table. I would assume that there is a formula that calculates a subtotal and/or grand total. Can you show a formula example? In the attached image, I would like to subtotal the three numbers at the "NOT ASSIGNED" brake etc. And, add a grand total at the bottom. Thanks
How to stop embedded Zoho Creator form from minimising when viewed in a Zoho Analytics dashboard
Hi, Not sure if anyone can help - but I have embedded a creator form into a Zoho analytics dashboard. This form is used to add quick notes to the crm opportunity/organisation/contact modules. The form works fine - however when viewed in the dashboard it is only 2 fields high and the user needs to scroll to input information - which is a bit of a pain. Is there a way to ensure that the form does not collapse when embedded in an analytics dashboard?
Next Page