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. ThanksHours 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 wrongZOHO 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/20How 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 GermanyZoho 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 usDashboard 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. (ThenWidgets
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 aHELP 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 aggregateDashboard - 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 NitithamRemove 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 adminResponsive 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/desktopAggregate 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 triedCan'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 aroundRoll-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 associatedFiltering 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 haveI 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.Funnel Chart Percentage Decimal Point
Hi, I am trying to round up to the nearest percentage on a funnel report, but whatever I do it isnt playing ball, any ideas?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 changeNew 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. ClickCalculate Average based of date filter
Hello, We want to calculate the average of rows that appear when a date filter is applied in a dashboard. Is there any way to achieve this? Thanks,Google Ads - Zoho Analytics Integration API Update
Dear Customers, As Google suggested to upgrade the AdWords service API to the latest Ads API, on 22 April 2022, we have upgraded the APIs used in the Google Ads integration framework in Zoho Analytics. Google's Official Notice: https://ads-developers.googleblog.com/2021/04/upgrade-to-google-ads-api-from-adwords.htmlHow to split the y axis on a combo graph?
I have a stacked combo graph where the 2 bar graph items are sums and the line is a percentage (count % of total). The line is showing really low, because it's comparing the percentage to the count. Is this currently possible? According to the post in this topic it is: https://help.zoho.com/portal/en/community/topic/split-axis-combo-chartStatusIQ
Please add StatusIQ to data sources. We using site24x7 and StatusIQ together and site24x7 integration is already there. Thanks and regards, TorstenSending emails to the share group using Apply filter Criteria
I am looking forward to sending emails to multiple users using Apply corresponding share filter criteria. Whenever I add a new member or a group in the 'To' column, the following error pops up - "Apply filter Criteria is not available when email reports to Share Group.". I would like to know the options available for sending emails to multiple users using Apply corresponding share filter criteria. I have attached the screenshot of the error message for your reference. Thank you.Multiple filters for the same data in widgets
Hi, I'd like to set up a widget that shows the values of the same data according to different filters, like this: Primary value: Created time - This month Secondary value: Created time - Custom range Is this possible?Plugin for Analytics
Hello All, How can I create a plugin setup for Zoho analytics wherein I can push data from third party application to Zoho Analytics table? Do I have to create something on Zoho Catalyst or using Sigma or what? Please guide me here.Zoho Charts and Trendiness
I'm pretty new to Zoho Analytics, and this is a pretty basic question. I've created some solid vertical bar charts. Everything looks the way I want it. However, I went in and decided I wanted to add a linear trend line to overlay the bar chart. ItZip Code Location - GeoMap
See image below For Zip Code 2139 (Cambridge MA, USA) the ZOHO GeoMap defaults the location to somewhere in Australia.... this is not correct. Can you please correct this or show me how I can correct it locally? Correct Latitude and Longitude for zipHow to add analysis across n:m modules into a dashboard?
Hello, let's assume we'd like to get the total amount of all potentials, that are related to campaigns. I'd like to filter by campaign name / start & end date in a dashboard. Then, I'd like to have either a widget or something else to display the sumLink Smart Elements (Zoho Show) to tables in Zoho Analytics
It would be GREAT if you could create a feature that can connect the Smart Elements in Zoho Show with tables that exist in Zoho Analytics so the Smart Elements can automatically update themselves in the same way that Widgets do in Zoho AnalyticsNew Features rolled out on Mar 11, 2022
New Business Application Connectors We are happy to announce the following new Business Application Connectors. Advanced Analytics for Google Search Console The new Advanced Analytics connector enables you to deeply analyze data from Google Search Console.EOMONTH Function
Does Zoho not support an EOMONTH function? I keep getting an error code. Is there a workaround? SELECT "Act. Gds Mvmnt Date", "Shipping Value", "Plant", "Name of sold-to party", "Network", EOMONTH("Act. Gds Mvmnt Date",1) AS "End of Month" FROMGradient Coloring for Conditional Formatting
It would be a good addition if for pivot tables (and other types of data tables) you added a conditional formatting option so that you can apply gradient color formatting based on the value being high to lowlast 90 days vs the 90 days before - widget
Hi, How do I add a widget that shows the sum of sales for example of the previous/last 90 days vs the 90 days before those days. So, last 90 days vs last 91-180 days? Kind Regards, RobinNext Page
Access your files securely from anywhere
New to Zoho LandingPage?
Zoho LandingPage Resources
New to Zoho Survey?
New to Zoho Marketing Plus?
Everything you need to run your marketing
New to Zoho Marketing Plus?
Everything you need to run your marketing
New to Zoho CRM Plus?
Deliver unforgettable customer experiences
New to Zoho CRM Plus?
Deliver unforgettable customer experiences
New to Bigin?
Announcements
[Upcoming Webinar] Power up LinkedIn marketing with Advanced Analytics
Modern businesses are leveraging social media like never before to generate, retain, and expand their customer base while driving revenue. LinkedIn continues to be one of the most preferred marketing platforms for businesses. Based on our interactionsAnnouncing Zoho Analytics 6.0 - An AI Powered Self-Service BI & Analytics Platform!
At Zoho Analytics, our mission is to democratize analytics for everyone. We recognize that team members across an organization rely on data to make both simple and complex decisions every day. These tasks shouldn’t require ongoing support from IT and[Fireside Chat on 6.0] Experience the AI powered self-service BI & Analytics platform
Ballooning data volumes at breakneck speed, expanding data diversity, the increasing importance of data management and governance, and the emerging complexities in analytics—BI vendors and customers are turning to cutting-edge technologies to addressAnnouncing Zoho Analytics 6.0 Beta!
We are delighted to open up the next major version, Zoho Analytics 6.0 Beta! The new version comes packed with a wide range of functionalities for all persona, namely business users, data analysts, data engineers, and data scientists. Zoho Analytics teamWhat's New in Zoho Analytics - August 2024
Hello Users! We are back with the latest updates and enhancements made to Zoho Analytics. Keep reading to learn more about them. Connect to the data hosted in the cloud without allow-listing the IP addresses Utilize Zoho Databridge to connect to the data
Most Discussed Topics
How to create comparison time periods like these examples
In a Pivot Report I would like to be able to select any date range and show a set of metrics for that date range e.g. revenue, orders, units sold. I would then like to be able to compare to the previous period based on the amount of days on the selectedIs it possible to have an Aggregate or a formula data column that only sums subtotals?
So I am trying to make a data columns that would only sum the subtotal. let me explain, I want to sums the hours worked of employes. I also need to split the hours when they reach 40 hours into another column. I can make this work perfectly with formulaMake Widgets Clickable or Copiable
Hi, I created a KPI Widget in Zoho Analytics whose content I would like the users that see my dashboard could copy or click and be redirected elsewhere. Yes, I'm aware I can create a Text Box for that instead of a Widget, but the problem is that the linkContextual Information when Apply Filters
Hello, Let's say I had a pivot report looking at an "Accounts" table, if I had a user filter to select a specific account. When a user hover overs an individual option in the "Accounts" user filter, is it possible to have a pop-up display with additionalHow can I find invisible characters in my Deals table?
Hi, I'm using Zoho Analytics to investigate some formatting issues we've come across in our Deals from Zoho CRM and it seems that something's wrong with some of our records. Although we defined a global set to pick from in our "Lead Channel" picklist,
Zoho Developer Community
Zoho DataPrep Resources
Zoho Subscriptions Resources
Zoho CRM コンテンツ
-
オンラインヘルプ
-
Webセミナー
-
機能活用動画
-
よくある質問
-
Ebook
-
-
Zoho Campaigns
- Zoho サービスのWebセミナー
その他のサービス コンテンツ
ご検討中の方
Zoho Sprints Resources
New to Zoho TeamInbox?
Zoho TeamInbox Resources
Zoho Books Resources
Zoho Projects Resources
Qntrl Resources
Zoho CRM Plus Resources
Zoho Campaigns Resources
Migrate to Show’s New Community
A place to share, discuss and stay updated about everything relating to Zoho Show presentations.
Get Started. Write Away!
Writer is a powerful online word processor, designed for collaborative work.
Design. Discuss. Deliver.
Zoho Show Resources
Zoho Creator Resources
Nederlandse Hulpbronnen
Zoho Inventory Resources
Zoho CRM Resources
Sticky Posts
Announcing Zoho Analytics 6.0 Beta!
We are delighted to open up the next major version, Zoho Analytics 6.0 Beta! The new version comes packed with a wide range of functionalities for all persona, namely business users, data analysts, data engineers, and data scientists. Zoho Analytics teamWhat's New in Zoho Analytics - August 2024
Hello Users! We are back with the latest updates and enhancements made to Zoho Analytics. Keep reading to learn more about them. Connect to the data hosted in the cloud without allow-listing the IP addresses Utilize Zoho Databridge to connect to the dataWe are coming to your city! Zoho Analytics Community Meetup
Hello, business leaders and data enthusiasts! We are delighted to announce that registrations are now open for the ZUG meetups, and we can't wait for you to be a part of them. Our in-house analytics experts are geared up to lead discussions on constructingZoho Analytics: 2021 Look Back
As we start a new year in 2022, here's some of our top moments from 2021. Zoho Analytics in 2021[Customer Talk] PREMO Group's Analyst Interview at Zoho Day 2022
Premo Group, a 50 year old Spanish Manufacturing Company, has been our long-standing customer with #ZohoAnalytics. They've been using our platform for their end-to-end, unified business analytics solution. Hear more from Claudio Cabeza, Director at PREMO
Top Contributors
Naresh Kumar K K R
Arthur
Data Sailing
Anitha Rajesh Kumar
Will Young