Zoho Reports - Invert Axis
I have a simple bar chart that shows the average number of people achieving a certain score (between 0 - 8). The chart shows the value 8 as the highest on the 'y' axis. This is fully understandable. However I need to display the results with 0 being the highest and 8 the lowest (i.e. invert the 'y' axis values with 8 at the base and 0 at the top). Is there any way I can do this with Zoho Reports?📢 : Zoho Analytics is a winner🏆 in 2022 Industry Excellence Awards
Dresner Advisory Services has recently named its 2022 Industry Excellence Award winners. The annual Industry Excellence Awards acknowledge vendors who have achieved leadership position in the company’s 2022 Wisdom of Crowds Analytical Data InfrastructureCountIf formula for multiple stringtypes
I am trying to calculate the amount of times I made contact with someone. The results require counting multiple string values. This is what I am trying. count(if("status"=('stringvale1,stringvalue2,stringvalue3'),1,Null)) Normally I would do a COUNT(FIND_IN_SET(status, 'stringvale1,stringvalue2,stringvalue3')) What should i try? Sincerely, JoshHow to use COUNTIF with a NOT IN operator
countif("Tickets"."Status"!= 'Completed' or"Tickets"."Status"!='Closed' OR"Tickets"."Status"!='Service Call Completed'') countif(NOT("Tickets"."Status Group" IN ('Completed','Closed','Service Call Completed') I have tried this in multiple ways includingEngagement Rate Discrepancies between Zoho & native data
While pulling data for a monthly report, our team noticed some pretty big discrepancies between engagement rates reported through native data, versus Zoho. For example, the top LinkedIn posts in November yielded engagement rates below 1% in Zoho, whileFilter Table by Values which don't appear in Join table
I am trying to filter a table to the values which are not in a joined table. I have tried many versions but none seem to work, not sure what I am missing. SELECT "Site Details with Display Unit"."Account_ID" as 'Site Account ID', "Site Details with Displaysubquery not working
Hi! I'm trying to make a subquery and the system will not let me, I've tried several ways with no result, Annex consultation to see if I can help SELECT DISTINCT "A"."Semanas", (SELECT SUM(CASE WHEN "Código"='SI' THEN "Saldo inicial del banco" ELSE 0 END ) FROM "Juan sql" WHERE "Semana anterior"= "A"."Semana anterior") AS "Saldo inicial del banco", "A"."Semana anterior" FROM "Juan sql" as 'A' GROUP BY "A"."Semanas","A"."Semana anterior" tells me that does not identify the alias thanks....How to copy workspace from one account to another?
I want to copy a workspace from one account to another account. It is written in the description of Copy Workspace API - "The Copy Workspace API is used to copy the workspace from one Zoho Analytics Account to another Zoho Analytics Account". But theUse Zoho Analyitcs instead of Data Studio (Google)
I use DATA STUDIO to GENERATE DASHBOARDS for my DIGITAL MARKETING clients (Google tool), but I would like to know IF I CAN USE ZOHO ANALYTICS instead: - I need to send my customers a LINK for them to ACCESS THEIR DASHBOARD (no need to login), LIKE I DOIssue with adding people to email distribution list
I have restrictions setup so that only accounts with specific email domains may be added to exports for emails, etc. As you can see in the image below, two domains have been added I am having problems adding a colleague to an email distributions list,[Webinar Alert] Nurturing data-driven decision-making with augmented analytics
Hi there! With the current explosion of data and data sources, BI and analytics has become an integral part of business workflows for gaining contextual insights. Businesses are steadily moving away from merely recognizing the need for BI and analyticsAnalytics Bulk API - Export Data (Asynchronous) JSON_PARSE_ERROR only on first try
Hello, inside a custom function in Zoho Flow I want to create an export job, but I get an error when I send the request. However, this error only occurs the first time, if I call the same custom function again in the flow I don't get an error messageKPI Widget
For comparing current and previous year sales reports, I am creating a KPI widget. In previous years, I would like to add a timeline or date filter for analyzing monthly sales. Let's say I want to compare my current month sale with my same month saleAnalytics-Update row; criteria
Hello Trying to update row in Analytics from Desk: headersMap = Map(); headersMap.put("ZANALYTICS-ORGID",orgId); config = Map(); config.put("columns",columnsMap); criteria = "(\"salesorder_id\"=" + creteria_salesorder_id + " and \"package_id\"=" + creteria_package_idHelp joining tables with a query.
Hello, I just can't seem to wrap my head around this issue... I am fairly new to Z analytics so sorry if this has already been solved before. Table 1 called "Campaign" with thousands of rows Campaign IDI Campaign Name ID 1 First ID 2 Second I have anotherHow can I use SQL to break comma-separated values into new rows
I have the following dataset: I need to use SQL to turn this dataset into the following: i tried to used like this: but it didn't worked.Desk TimeEntry to Analytics
Hi, How do we get the booked TimeEntry's from Desk visible in Analytics? We want to create a dashboard where we can see how much time is spend on tickets of each customer. We now have a dirty workaround to get the time from the "Invoice Items.Quantity"Is there a postman collection for the Zoho Analytics API?
The title.Estimated Invoice Payment Date
Hi all, I apologize if this is a "noobish" question. However, I'm trying to created a dashboard in which our finance team can quickly look at a spreadsheet and see the estimated payment date for incoming invoices. I've been able to set everything up inBar graph with PieChart
I was reading a Zoho Analytics release from the following link https://www.zoho.com/blog/analytics/powerful-end-to-end-marketing-analytics-with-zohos-modern-bi-analytics-platform.html The Image below came from the Zoho Analytics Marketing release andIs there a way to use Python as a middle layer between the database and Zoho Analytics?
So my company has been using Zoho for everything now for a while. We have a database connected to Zoho Analytics and I always use the query editor to write sql to join tables, do aggregations, or any necessary steps to prepare the data for analysis andZoho Analytics | Quarterly Newsletter | Q3 2022
Hello Everyone! We hope all of you are safe and well! Zoho Analytics - Q3 Quarterly Newsletter is out! Check out the newsletter (attachment) to know all about our new features, recognitions, webinars, blogs, and many more exciting things. Do let us knowNew Features rolled out on August 30, 2022
API Calls Audit Log You can now choose to audit the API calls log. This allows you to monitor information such as the API calls that were frequently made, who did it and when it was done, API units consumed by action etc. You will also get an insightfulApplying Count and Group By in an aggregate formula
We wrote a query that lists what we need and we are looking to create a graph to visualize the data monthly. Some IDs appear more than once in a month and we want to exclude those. Is it possible to do this in an aggregate formula? As much as possible,zoho analytics- dashboard creation
I have created a dashboard with widget based on some report and i want to show that widget in ZOHO CRM dashboard. So i created a new dashboard in crm and added a widget there with external and base url. but it is showing like ' loading' only. ScreenshotHow to use grouped aggregation formula and calculate the percentage based on some condition in Analytics Plus?
I'm trying to calculate a percentage. The numerator should be the sum of sales of the states that have more than 10 customers. That is to say, I have to group the data by State first, then calculate the number of customers in each state and find theHow to show total sum and the name of each category in Pie chart?
I want to show the sum(sales) and corresponding percentage of each category and the name of different categories together in the pie chart. However, I can only drag one column into the Text. Is there any way to show the name, percent, and sum togetherWeek date range in pivot table
Hello, I need to create a report that breakouts the data by week. I am using the pivot table report, and breaking out the date by week, however the date is displayed as 'Week 1 2014' format. Is there anyway to get the actual dates in there? ex. 1/6/2014-1/12/2014 Thanks,KPI widget with percentage
I'm trying to create a KPM widget that displays current performance as a percentage - something like the picture below. I've tried following the instructions at https://www.zoho.com/analytics/help/dashboard/kpi-widgets.html#chart but nothing ends up being[Webinar] What's New in Zoho Analytics: H1 2022
Hi there! 2022 has been an eventful year so far on the Zoho Analytics front, and we've brought in lots of exciting new features and updates to enhance your experience! With our well-rounded approach to development over the years, we've got you fully[Blog] Powerful end-to-end Marketing Analytics with Zoho’s Modern BI & Analytics Platform
In today’s digital economy, a buyer goes through multiple touchpoints before making a final purchase. This indicates the presence of marketing across every possible channel that drives customers towards these touchpoints. Understanding marketing activities[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 PREMOStatic column with Date changing column
Hi there. I am not a data techy and am more DIY. I am struggling with what is probably a very easy thing to do in Analytics. I want to be able to take our Stock on Hand at the date I run a report and compare it with a sales period from the past. It'sCan this report be done without SQL? How?
Sync Not Working
Zoho Analytics Sync appears to be down again. Have multiple accounts and when attempting syncs with various sources like Zoho CRM, Desk and Google Analytics the Status remains in 'Sync in Progress' without completing. This is at least the second timeIs there a way concatenate text from multiple rows into single cell?
I've build a delivery reporting system for a customer and they are looking to link the rounds data with route planning software, however as there are multiple lines generated for the same location (products to be delivered) and as such the route planningRow counts by workspace?
Does anyone know how to get a row count by workspace?Weekend ticket reports
I want to create a table report that show tickets for Saturday & Sunday afternoon(lets say from 18:00), is there an option to do this in Zoho Analytic without selecting specific dates? is there a way to filter by day(sunday) and time and not by calendarNeed help with Join function in Zoho reports
Team, I have 2 tables - and I need to get ALL matching results in one cell.. Ex: Table 1 contains a Pin code Table 2 contains many addresses corresponding to that Pin code How do i get a query result where for each unique pin code I can get all addresses in one cell.Zoho Analytics "Bulk API - Import Data". MORE_THAN_MAX_LENGTH
I have encountered a problem with "Bulk API - Import Data", it return { "status": "failure", "summary": "MORE_THAN_MAX_LENGTH", "data": { "errorCode": 8507, "errorMessage": "The length of the parameter FILE is more than requiredNext 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