User filter in Analytics Report
We have connected Projects to Analytics so we can generate have a dashboard on task progress and completion. I've added a "User Name" user filter, with the intention that we will be able to quickly see tasks per task owner and what the statuses of those
Custom Field in Zoho Projects pulling into Analytics
We have a client that we have built our their new business process using Zoho Projects, and we have build a lot of custom fields with their their Projects where they are capturing specific data points that we want to be able to track and pull data, as well as give them some semi-real time dashboards using Analytics. When we setup the Analytics and linked to Projects we pulled in all of the modules, and there is no data point showing for the custom fields within any of the different modules in Analytics.
[Product Update] Locations module migration in Zoho Books integration with Zoho Analytics
Dear Customers, As Zoho Books are starting to support an advance version of the Branches/Warehouses module called the Locations module, users who choose to migrate to the Locations module in Zoho Books will also be migrated in Zoho Analytics-Zoho Books
How to Calculate Trimmed Average
How can I calculate a trimmed average by using percentile ranks? I would like to eliminate the top and bottom 5% of my data in order to get a more accurate average. For example, if I have: 1, 2, 3, 4, 5, 6, 7, 8, 9, 10 in my data I want to exclude the
Access to what Products are associated with which accounts
Is there a table that can be accessed to report on Products associated with accounts in the CRM?
Pivot report with SUM for months and AVG across months
Hi I am looking to create what I think should be a simple report but I cannot seem to get it right. I have a table filled with Expenses spanning multiples months. I want to create a Pivot report (or something that works) where each month is displayed
Creating email schedules with custom filters for Pivot/Summary Reports in Zoho Analytics
Hi Zoho, I have a Weekly Inventory Report that I'd like to send out to various vendors. Is it possible to create an email schedule for each vendor with customized filtering at the scheduling level? Currently, we generate two pre-filtered reports (copies
KPI Widget dashboard select periods
I have a problem with selecting periods as a user filter. In the beste scenario I would like to have to have a period filter like Google Analytics has of Datastudio (see attachment). In the KPI widget I "Group by "inquiry_date" on week&Year". It selects
Data refreshed X mins ago
How can I permanently have the "Data refreshed X mins ago" in my dashboards? It would be nice to know how old the data is since the minimum refresh time is every 3 hours. So when you open the dashboard you can immediately see the data is X hours old
Tip of the Week - Timeline User Filter for Dashboard
Does the Date User Filter in your Dashboard leave out a few reports from filtering? This happens when the reports are not created over the same table and the (time) column over which the user filter is created. To solve this, Zoho Reports has a Timeline User Filter. This filter applies the criteria on all reports, matching it with the best possible date column associated with a report. i.e., if your reports are based on a date column, then it will filter it for that data column. To know more on
Zoho Analytics and Linked Workspaces
I have a main workspace that contains all of the data for my company. I have need to allow users to build dashboards and reports for their departments, BUT I can't give them access to the main workspace as it contains all the company financial and employee
Map view - Zoho Analytics
In Zoho Analytics, the Overall Map is duplicating, with the global map appearing twice, which makes it hard to view clearly. Let me know what needs to be done
Combine Small Pie Slices in Pie Chart
Hello, I am trying to make a pie chart showing our sales in each of our product categories. The problem is that we have over 80 product categories, and not that much room from which to look at it. I am wondering if there is a way to combine the smallest
Connexion Woo / Zoho Analytics . API
Hello, I'm trying to set up the Zoho Analytics and Woocommerce connector but when I enter the user key and the secret key, I get this error message: Error building/reading/writing data. we've changed the path to access the /wp-json/ API to /secu_api/
Mantener visible solamente el primer nivel de la vista dinámica.
Saludos. En esta ocasión ocupo su atención para preguntar de que forma puedo mantener solamente visible el primer nivel de la información colocada en el campo filas de la tabla dinámica y que se visualice únicamente esa etiqueta y su consiguiente sub total. En el caso del ejemplo que adjunto, allí quisiera ver los estados con el sub total de cada uno de ellos. Como siempre, Gracias por su atención. Saludos. Adel Bahsas El Maaz.
User Filter for Dynamic Date Dimensions in Zoho Analytics
One challenge I frequently encounter is the need to create multiple versions of the same report—one for yearly data, another for quarterly data, another for monthly, and so on. While this works, it leads to unnecessary duplication, making maintenance
Zoho Analytics - Only show certain data labels
How do I only show certain data labels on my charts? I have a combo chart with 3 data bars and 1 data line. I only want to show the data label for the data line, not the data bars. How can I do that?
Zoho Analytics - Level on level queries
I am facing a limitation of having too many level on level queries however some of my queries are complex and rely on multiple joins to get my desired output. How can I bypass this limitation as this is hindering my report creation.
Create/Update Query Tables through API
We need an API to edit the query tables. Currently if columns are added/removed from a normal table, we have to edit the query tables made on top of that table manually to reflect the changes. We want to automate this task to automatically update the
Create Dashboard with information pulled from multiple modules?
I am looking to create an overview dashboard for each account we have within the CRM. This will need to include information from Books, Bookings, Analytics (want to see the graphs). I am new to using Zoho but am trying to help streamline our processes
Need Marketing specialist for Zoho client
HI, I am looking for someone to help a client with their social media marketing. I have set up Zoho for them, but they want to start various social media campaigns and are looking for a referral. This is for a marketing person who is familiar with Zoho
ZOHO Reports - Filter Logic?
Hi, I need a way to apply filter logics such as ((1 AND 2) OR 3). All I can see as of now is a way to enter different AND filters in the respective filter column. But how can I add an OR filter? Any advice would be highly appreciated. Mark
Zoho Analytics - Values gets Duplicated
In Zoho Analytics, I have two tables: one for Country-wise Sales and another for Country-wise Budget with Region. I am attempting to create a stacked bar chart to compare the Region-wise Budget and Sales Revenue. I have set up a lookup between the two
Aggregate Formulas with Multiple Tables
I get a 'Communications link failure...last packet successfully received..." error when trying to create an Aggregate formula that references two separate tables. I've made sure they are connected properly. It almost seems like it might be timing out?
Zoho Analytics - CRM Sync Failure
We have experienced consistent sync failures between our Zoho CRM and Analytics apps, but there aren't any details provided as to why this failure might be occuring. Please advise on troubleshooting steps so we can figure out how to restore the sync.
Duplicate Column Data with Individual Filters
Is it possible to create a report using the Zoho Desk Connector which would look something like this: | Account Name | Ticket Count (filtered by department 1) | Ticket Count (filtered by department 2) | For Example: Where Dept. 1 = Support Tickets, and
KPI Widget - last month sales vs same period last year
I would like a KPI Widget that might compare data with the following date ranges: This month to date (meaning all of February through the current date, for example the 14th, if today was the 14th. So Feb 1-14th 2018)vs. last year this month to date (Showing
I need to add difference for Average Row at the end
(Confidential data hidden here) Guys, hello! I have this graph, it calculates the averages of Retention and then shows the delta (2024 - 2023). In the 3rd column with delta Churn %, I want to show the difference between averages too, which would be (16.99
Unable to import data into zoho analytics using the post man APIs of udemy for business
Hi Can some one help me with the following Unable to import data into zoho analytics using the post man APIs of udemy for business through API beta feature, I have created the sample report in zoho analytics through the table structure but i am unable
errorCode":8504. What is wrong with my CONFIG?
I can't determine what is wrong with my config. It worked properly until I added an additional field, but the additional field is just a number and shouldn't effect the config. I am attempting to do a bulk update add to an existing table based on this
Analytics report issue
Hey, does anyone know why suddenly our Analytics report goes blank whenever we add a field from the contacts module? It shows when adding fields from all other modules. Thanks.
Ho to restrict access to row level to Zoho Analytics users
Let me explain the scenario we are trying to achieve. We have an online system our team members work with. On it we have 6 users that manage data from different areas (North, South, East and West). We would like to transfer this information to a Zoho
Waterfall Chart
Hello, I would like to create a waterfall chart on Zoho analytics which shows the movement in changes of budget throughout a few months, on a weekly basis. Should look something like the picture below. Does anyone know how to?
Case and Left Join Problem
I am attempting to find the cost per lead, however they are on different tables. I am using the Case and Left Join Functions to do so. The following Queries are working correctly. These are below: SELECT "Campaign", COUNT("Id") AS 'total_leads' FROM "Deals"
LinkedIn Followers not correct
It looks like Zoho Analytics only counts followers from the day it was connected to our LinkedIn-page. The Total Followers Count in Analytics only displays 549 followers, while in reality we have 1,036 followers. The information is correct in Zoho Social,
Sending two different reports through one e-mail schedule
Hi. I have two different reports which I want to send to someone. However, I don't want two separate emails, but only one. Is this possible?
Conditional formatting based on another cell value
I am looking for an option to highlight cells which is greater than value in another cell. For example, I have planned completion dates and actual completion dates in different columns, I want to highlight cells whose actual completion dates are greater
How to filter dynamically in query table report?
I created the tabular view report using the query table below. How can I do if I want to add Invoice Date filter in the report and pass the value to this query? SELECT "Customer ID", SUM("Total (BCY)") as "Total Sales (BCY)", COUNT("Invoice ID") as "Total
I want to know the gross profit by sales person. How?
Kindly guide me how to know the amount of gross profit which is calculated on the basis of sales person. That means, how much is the amount of gross profit made by a particular sales person.
Important Update: Mandatory Email Domain Verification for Zoho Analytics Users
To enhance the security and reliability of email notifications, we are implementing an important update. Starting February 1, 2025, verifying your email domain will be mandatory to continue sending email notifications via Zoho Analytics. Failure to verify
Next Page