Announcing 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 Preparation
Email Scheduled Tab Or Button required on Front
Dear Team, Please add Button Left side panel for Email Schedule to add edit or delete & etc. Regards, Subhash K
Path visualization from Departure to Arrival airport
Hi Zoho team, Is there any way to map or show the routing activity of airlines from source to destination? Thank you! Swathi
Introduce "3 axis" / "3 dimensional" chart reports
"3 axis" or "3 dimensional" (bar) charts are extremely useful to visualize complex data with (at least) 3 different data points. We keep 3 levels of "problem" and "solution" classification data in our Zoho Desk tickets (for example main/sub/sub-sub problem
Analyze Semrush data with Zoho Analytics
How #ZohoAnalytics can help in analyzing your Semrush data Perform detailed competitive analysis across domains Track the performance of keyword-driven content marketing Measure effectiveness of organic & paid search campaigns Find out more about our
Query Assistance
Hi, Wonder if I could get a bit of help, I want to create a new column within a query table and am going round in circles, I want a new column to be that of "Acquisition Type" and if a Lead Source is Facebook it goes down as Social, if Adwords its PPC.
Minutes between creation of a lead and the first call
Hello. I want to measure the (business) minutes between the creation of a lead and the first call. I have two seperate modules: Leads and Calls. When I combine them into one pivot table, I am not able to substract from each other. So, I created a query
Cannot Find "Edit Design" button in Zoho analytics table
Hi All, I am not able to find "Edit Design" button in Zoho analytics table which were integrated with books and auto-join feature was used to connect them. I am able to lookup on query tables or tables generated without auto join feature. Any Idea on
Compare YTD Sales vs Last Year's Sales in the same period
Hi, Is there a way to compare this year's sales with the same period of last year? So we are in June as I write this. I want to be able to compare sales from Jan-June 2022 to Jan-June 2021 and so on.
More Color Palletes
One of the things that I find to be the most time consuming, is coming up with a color palette. I know that Zoho offers several different types and formats for color palettes, but it would be nice if that preset library was greatly expanded. It would
Query Assistance
I am trying to do the following within a query but am getting a bit stuck, can you help me please? I want to round these 2 datapoints below to the nearest 15 minute interval from Leads (ZOHO CRM) and Deals (ZOHO CRM) Leads.”Created Time” Deals.”Created
The lookup column dropdown menu is a major pain point
This is in the screen called 'Change to Lookup Column'. To get to this screen, go to any table, right-click on a column, click on 'Change to Lookup Column'. There is a dropdown menu under the header 'Column to Lookup'. See screenshot below. Try doing
Zoho Analytics is rated as an overall leader in Dresner's latest survey
Dresner Advisory Services is an independent industry resource which provides an alternative perspective on information management, business intelligence, analytics, performance management and related markets through the objective, non-sponsored and crowd-sourced
Number of lines in quota
Hi, I'm using Zoho analytics cloud version and I would like to know How do the number of lines used are counted, does the number include the number of lines of query tables as well or it includes only the number of lines that are imported from a source
Stacked bar chart - display the % value of the bar segment as a percentage of the bar total.
Hi, I'm trying to figure out if it is possible to create a stacked bar chart where we can display the % value of the bar segment as a percentage of the bar total. Please refer to the attached image "ZA_Stacked_bar" of what i mean. I would like this information
[Action Required] - Bing Ads Integration in Zoho Analytics
Dear Customers, As Microsoft updating the OAuth scope (authentication), all users who are signed-in through a third-party application that uses the Bing Ads API will require multi-factor authentication in their Bing Ads account. Microsoft Announcement:
zoho analytics to do 3D bar map like Excel 3D maps graphs
Hello, It would be nice to have Zoho analytics do a 3D bar map like Excel 3D maps graphs see images:
Change widget label depending on filter value
Hello, Is it possible to change widget label depending on the selected filter value? Example use case: if the user selects a country in the filter, the text after the widget value shows the currency of that country. Please see attached screenshot. Thanks
Hours Between
Hi, I am trying to get hours_between on this query but its coming up as an unsupported function? SELECT dl."Lead Source" AS "Lead Source", dl."Lead Created Time" AS "Lead Created Time", days_between(dl."Lead Created Time", dl."First Activity Occurred")
Export report to PDF keeping the user filters
Hi I am having some issues exporting reports to PDF and filters, If I select show user filter criteria, I get everything coming back instead of the filtered report I expected, am I doing something wrong
ZOHO Analytics page not running after clean install
Hi. I have downloaded ZOHO Analytics and installed on Windows machine. Everything looks ok but https://localhost:8443 is not working. Service is running Firewall disabled - still nothing. In wrapper.log the last line is this: INFO | jvm 1 | 2022/05/20
How to get Unique Count
Hi Team, I have a table that shows users. The users have one row each for what language they can speak. In each row, they also have the country they are in. Example: Name - Language - Country Steve French Germany Steve Italian Germany Steve Spanish Germany
Zoho 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
Dashboard KPI widget: quarter versus same quarter last year.
Hi, I would like to set up KPI Widgets that track sales quarter v quarter. So I would need one widget that tracks the current quarter versus the same quarter last year. Then I would also need Q1 sales for this year versus q1 the previous year. (Then
Widgets
Hi Zoho, Two suggestions for enhancing the widgets. - A duplicate widget option for report dashboards would save us lot's of time. - Multi-data type widget with the main value pulling from one table/column source and the second value pulling from a
HELP please. I need a widget that is NOT dependant upon the Timeline filter
Hi Team, I want to have a widget that does NOT refresh based upon the timeline filter. I need a widget that shows the count for something for this current month. I don't want it to change if the user changes the timeline filter to look at other information.
New Features rolled out on May 12, 2022
Enhancements for Business Application Connectors Business Application Connectors in Zoho Analytics are enhanced with the following options. Advanced Analytics connector for Zoho Forms We are happy to announce that Advanced Analytics for Zoho Forms is
%Percentage
I don't know how to divide and have total in percentage, as I explain in the following image. https://www.screencast.com/t/oNZTctOG If someone have an idea, I will appreciate.
New Features rolled out on April 13, 2016
Use 'Look-up' Fields in Formula columns Zoho Reports now supports 'Look-up ' fields in formula columns. Previously, it was not possible to use formulas on a lookup field. You can refer to the Defining lookup section in this help documentation to learn about creating a lookup. Note This functionality will be applicable only if the lookup column has been created with the delete criteria set as No Action on this (child) table . You can use the lookup field to create both custom and aggregate
Dashboard - Report scroll bar
Dear Zoho Staff, Would it be possible to scroll chart report horizontally. Other BI Tool also have this feature and I expect Zoho Analytic would have too. But I cannot find a way to achieve. Best Regards, Karanig Nititham
Remove HTML Tag from a column
Hi all, I'm looking for a solution to remove html tags from a column. Example: <div>Test Worklog<br /></div> Expected Output: Test Worklog Many thanks for your help in advance. Regards Anish
[Product Update] Change in Zoho Analytics Business Apps Integration Data Sync Notification Settings
Dear Customers, In our continuous effort to improve the Zoho Analytics product with new features and enhancements, we are making some updates to the business apps integration data sync notification settings. Currently, the Zoho Analytics account admin
Responsive charts on imbedded website
Has anyone figured out the trick to having the reports/charts responsive when embedding? I'm using bootstrap as a framework but when changing the browser size on a desktop or mobile, the chart sometimes runs off of the screen depending on the browser/desktop
Aggregate Formula Using SumIF(Column A) When Column B Contains 'ABC'
I have a text column A with different values and a column B with numeric values. I would like to sum column B for all the different text values in column A (i.e. column A = 'ABC', sum(column B)) How do I create an aggregate formula for this? I've tried
Can't Delete Imported Tables
I have some old imported tables from "Survey Monkey" - I no longer am using Survey Monkey and would like to delete these tables, but am getting an error forbidding me from doing so The error is: is a system table and cannot be deleted How do I get around
Roll-up Dashboard
Hi Brainstrust, I have several (about 10) workspaces that are used for different Regions. Each region has it's own discrete data, although the data tables are the same structure in each of the workspaces. Each region makes bookings, and has costs associated
Filtering the date as in write query
Hi Zoho Team, iam experiencing to cannot resolve how to filtering the date as in Query as below e.g date filter in query "2022-02-01 between Date_Arrive and Date_Depart OR 2022-02-05 between Date_Arrive and Date_Depart" in this filtering we can have
I do not want "-No Value-" to appear in the pivot report.
I do not want "-No Value-" to appear in the pivot report. Can this behavior be suppressed? Please help.
highlight current period in bar chart
I have a bar chart the shows the current value of bookings/appointments for past and future weeks along the horizontal axis. There are roughly 40 weeks shown on the chart with the current week somewhere in the middle. Is it possible to highlight or change
New Features rolled out on April 13, 2022
Enhancement in White Label Solution White Label users can now do the domain mapping and domain verification from Zoho Analytics' user interface itself. This allows them to configure the White Label Solution in a secured and user-friendly manner. Click
Next Page