Underlying data columns
Is it possible to change the columns (make visible/invisible/reorder) when clicking "view underlying data" on a chart? See attachment Thanks
URL data type seems to have size limit
I have created a custom formula against the Zoho Projects "Tasks" table in Zoho Reports. The custom formula concatenates the following. <zoho projects portal url>#taskdetail/<Project ID>/<TaskList ID>/<Task ID> The goal of this concatenation is to create
Zoho Analytic-hyperlink from value in the grid/column
I’m trying to create a hyperlink from the data-grid result whereby the hyperlink will open Zoho CRM records. Appreciate if anyone can advice if this is possible or any alternate ways to handle this. TellTims Survey
Tip of the Week - Customize KPI Widget with Label Parameter
A KPI widget is not just for calculating a single metric. You can add more details to a KPI widget like 'Top salesperson', 'Region with the lowest sales', 'Percentage achieved against target' etc., using the label parameter. When you type $ in the KPI value field in the Settings tab, the supported label parameters will be listed. The following are the available parameters to customize the KPI widget. ${Metric-Column-Name}.VALUE ${Metric-Column-Name}.LABEL ${OPERATION} ${Grouping-Column-Name}.LABEL
Sync data from Zoho Analytics to Zoho Campaigns
I use the integration between Zoho CRM and Zoho Analytics to sync specific modules, but I want to sync specific tables from Zoho Analytics to Zoho Campaigns. At the moment you can't sync data from Analytics to Campaigns. Could there be an integration
Integration between Zoho Campaigns and Zoho Analytics
Hello. Is there an integration between Zoho Campaigns and Zoho Analytics? I use the integration with Zoho CRM to sync specific modules, but can I sync specific tables from Analytics to Campaigns?
Remove specific Text from a String
I want to remove specific text from all Job Numbers in a specific column. In my specific case, I want to REMOVE the letter T from the "JobNumber" column I get an error when I use the code below. Any suggestions what I am doing wrong, how to fix this?
Conditional format linked to fields
Will be great if you add and option to link the conditional format value to a field, so the user can do it manually or linked on a table. The X on the image should be able to linked to a field in another table.
Hide first column of summary table
Dear Sir. Is there any way to hide or eliminate the first column of summary tables: Thanks for your support.
Error in IF Formula while adding Column Formula
Hello, I am trying to clean my column which has responses like '2.Self-employed/Business स्वरोजगार' , '3. Labor श्रमिक'. My objective is to add a formula column so that it returns values like 'Self-Employed', 'Labor'. Basically, want to get rid of
Zoho Finance - Missing Relationship in Native Integration
I'm just getting started using Zoho Analytics, so it's possible that I am missing something here. However, it appears to me that a natural relationship in the data synced from the Zoho Finance suite is missing. In the Bundle table, the Composite Item
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
Report of the Week - Customer Balance Report
How much do your customers owe you? How about customers with payments long overdue? How much advance payments do you have in hand? For all these questions, the Customer Balance Report provides you with the answer. This week we'll see how to create a customer
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.
Next Page