[Upcoming Webinar] Retail analytics: Identifying revenue hotspots and optimizing retail operations
Hi there! With the number of individual moving parts involved in the retail value chain, advanced retail analytics has become an integral part of decision making for retailers of all sizes. By transforming raw data into actionable insights, retailers
New Features rolled out on September 15, 2022
Enhancements for Advanced Analytics Connector Advanced Analytics for Zoho Commerce Advanced Analytics for Zoho Finance suites now supports Zoho Commerce too. This helps you to manage your online store effectively and market it with ease. You can also
📢 [Blog]: Boost your online store sales with Shopify sales reports
For businesses of all sizes, it’s imperative to keep an eye out for particular sales metrics. Specifically for an online store run on Shopify. What’ll be your Shopify store’s average order value for the next 3 months (or the next 2 quarters? or the next
Web chart - change fill colour?
Hi I have a web chart which is perfect for what I want to show but I can't see any way to change the colour of the fill from default blue. Am I missing something?
Cumulative stacked bar grouped by status
Hello, I did that chart: Its almost what I want, but when I try yo color by status, I got that: So, I'm having trouble to group my status and get a cumulative stackedbar, like that: Any idea how to manage that? Thanks in advance!
Remove limitation to import only up to 100 fields from a single Zoho CRM module
Zoho CRM supports creating of over 300 fields per module. Zoho Analytics supports import of only 100 fields per Zoho CRM module. Please consider removing this limitation. Best regards, Mladen Svraka Zoho Consultant and Authorized Partner www.mladen-
Help with the creation of a report
Hello, We need a report "Hours by projects" with a way to reduce the hours by 20% if the employee is a junior. I would like to see the last column with the adjustments and the previous one with the real hours. I've tried with a customizes field in Staff
Query with WHERE function not working
Below is my query code SELECT DISTINCT "Network", "DepartmentName", "ActStartDate", "ActEndDate", "Actual Days to Complete", "EstStartDate", "EstEndDate", "Estimated Days to Complete", "On Time vs Late" AS 'Aero Build OTD' FROM "Eagle_AllHoursReport"
Transfer Data Source ownership in Zoho Analytics
Hi, I am an "Organization Admin" in Zoho Analytics, and I'm managing the whole thing on my own. Eventually, I'm gonna be an "Account Admin" so that I have no further issues or restrictions, but for now, I'm not. My problem is that I'm working on a Data
Count with Multiple Conditions
Hi Everyone, I have simple DAX formulae which I have been trying to implement as an aggregate formula in Zoho Analytics. If anyone could give some inputs for the same. Attaching the DAX which I created in excel: 1. Formula I: 2. Formula II : Any help
Custom Query Editor: Selected text is automatically removed when clicked on
Hello, in the Query Table Editor the selected text is automatically removed when clicked on. Repro Steps: 1. select text 2. click on the selected section (somewhere on the purple highlighted area) 3. the selected text gets deleted This is very critical
Major Issue with Data Import using 'Prepare Data'
The end goal for my project is to schedule booked capacity in my business by importing from my Project Manager database. The imported data will include the department, the job number, the estimated and actual hours for that job, and the projected start
Page Break
How do I add a page break to a Dashboard for printing?
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 Infrastructure
CountIf 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, Josh
How 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 including
Engagement 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, while
Filter 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 Display
subquery 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....
Use 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 DO
Issue 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 analytics
KPI 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 sale
Help 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 another
How 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"
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 in
Bar 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 and
Is 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 and
New 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 insightful
Applying 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. Screenshot
How 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 the
How 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 together
[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 PREMO
Static 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's
Can this report be done without SQL? How?
Next Page