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?
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 time
Is 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 planning
Row 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 calendar
Need 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.
New Features rolled out on July 26, 2022
Advanced Analytics for Teamwork CRM Advanced Analytics for Teamwork CRM empowers you by providing deep sales analytics over your CRM data. This integration helps you to keep track of your key sales performance metrics and optimize your sales team's execution.
[BLOG] 4 Shopify sales analytics reports to grow your online store
There are many benefits to selling on Shopify—a full-fledged website builder, easy set up, a customized online store, and an extensive marketplace to cater to any Shopify store needs. The question, however, is how can merchants better translate these
Scheduled import using local database option (file location) and htm files
I am having an issue with the import feature available for scheduled file imports Background: My quality team uses a system called Gagepack. Gagepack will automate scheduled reporting and save them to our network as htm files. Unfortunately there is
Pivot Table color is grayed out
Pivot Table color is grayed out on dashboards for some reason. Even though they were created with different 'theme' color in the report view See images provided below First image is view on dashboard, second image is view from the report screen
Underlying Data
Hi, When I made a Chart or a View I used to click on the data I want to consult, and it brought back the information detailed and ALL the columns that were on the report or view data base, I just found out that now the same reports are just showing the columns that are in the view...is this a bug? o how can I add columns to those underlying consults.
Open tickets per day
Hi, Day 1 of working with Zoho Analytics for me. I'm want to create a dashboard with multiple widgets and bar sets on it. One of them is a Line chart with the following info: X-axis = first day of the month untill the last day of the month (so if i select
Exclude alpha numeric characters
I have fields with both numbers and letters in them. The length of both numbers and letters can vary. I am looking for a way to return the information as two columns - one for numbers, one for letters. Can anyone help please?
Create Report of Zoho Project Tasks with a certain tag
In Zoho Projects we use the tag field. I am trying to create a report in Zoho Analytics that will list out the tasks across all projects that have a specific tag but I am having trouble figuring out how the tags are linked to the tasks in projects. Can
Zoho Books - Payments Made does not Connect to Invoices table?
Hello Zoho team, We have set up a sync from Zoho Books for most modules including Invoices and Customer Payments. All our payments are always applied to an invoice. Using API we can always find the invoices that a payment has been applied to. However,
Logical Operators in Zoho Analytics Query
if_case ( "Customer Address"."Item Wise Weight" > 100, ("Quantity Ordered" * "Weight") * 30) as "Zone Cost" Hello All, Requirement is to check the weight of the item and add a custom rate as a different column, but the above query is resulting in the
Any Changes to Source Data File Requires Remapping in Zoho Analytics
I have set up scheduled imports of various tables from a master Excel spreadsheet to perform various Zoho Analytics functions. The problem I have is that if I make any changes to the structure of the source spreadsheet, Zoho Analytics stops importing
How to Remove Time from Current Date Function in SQL Query?
Hi, I'm writing a query that counts rows where the value in a date column is equal to today. When I use getdate(), today(), current_date(), etc I get a total of 0, because all of those functions return the exact current date and time, whereas the values
Change font and/or font size?
Is it possible to change font and/or font size in any of the report views? I've seen a few older post indicating that it may be a feature in progress. Has there been any progress? -Ken
Issue with SalesIQ/Analytics integration
Hello, I'm facing an issue with the integration of SalesIQ and Zoho Analytic. Our goal is to export SalesIQ data into Analytics, to analyse the people coing to our website. It is a really vluable tool for us. Everything was working well, but one day
[WEBINAR] KPI dashboards—an indispensable business enabler
Here’s an interesting piece of trivia. IBM once reported that 2.5 quintillion bytes of data are created everyday, worldwide. However, nearly 90% of that structured data goes unanalyzed. This data is known as dark data. Now let’s switch gears to your business.
Converting to one currency within report
Hello - my business has sales in various currencies - ZAR, GBP, EURO, CAD and USD to name a few. I have created a report that shows monthly sales by rep. It's made up deals in all of these currencies. I would like each deal to be converted to USD. Is there a way to do this using a formula column? If so, i'd love some step by step guidance. Thank you!
Change over Time Graph (or Trend Line Graph) of Daily Average of Staging Duration
I'm not sure if my question title does explain my issue but I will try to explain it in detail. We are creating dashboards which include staging reports created with data from Zoho Desk. The main report on these dashboards has a bar chart which shows
Spread value between start and finish dates
hi there. I have a project value, start date and finish date. I'm hoping to spread the project value evenly over the months in a chart, rather than the entire value being in Jan 2022 just because this is the start date. See attached what the chart looks
Relative Date Filter
The Tabular View report is a useful reporting tool, except you are unable to use 'relative date filters.' Can you please add a feature that allows for relative date filtering while using the tabular view report
Using chosen user filter as a parameter
Hi I have a report that is used to calculate profit over a period. One of the custom fields I have in "Accounts" is "Monthly rate". In the report I have a user filter that allows to choose the period of the records (work log) to show. However, if for
[Webinar] Project analytics: 360° insights for successful project delivery
Hi there! Project management is a key enabler for efficiently managing the volume and velocity of business efforts and delivering ambitious growth rates. By adding a layer of 360° analytical insights, project managers are better empowered to successfully
Highlight and Copy from Reports/Dashboards
The most recent round of updates has removed the ability to highlight and copy data from reports and dashboards. You can export or view underlying data and copy from there, but that is not very efficient when I just want to copy some basic info to an
How to apply a text-display formula on an aggregated value?
Hi, I've been struggling with a display issue on a report for quite some time now, but I can't seem to find a solution... Basically, my report has the X-axis with time-based values (weeks of the year), and the Y-axis with duration values (in milliseconds).
Next Page