Needed clarification on KPI Widget feasibility in Zoho Analytics
Hi Support, We have a common requirement in Widget to see Latest and previous values. Requirement : We need to see a comparison between the numbers in the "Payment Details" module. We need to see numbers with the same Time Period for all Widgets. We think
Expanded View of tables not shown
Hello, We created a dashboard with multiple widgets, multiple charts and 4x Pilot views. When I create an PDF from the dashboard without any filters I see that the 4x Pilot views are added as "Expanded view" at the end of the PDF, which is great. When
Arbeitsbereiche zusammenführen möglich und wie?
Bei uns gibt es „standardmäßig" drei Arbeitsbereiche, "CRM, "Projects" und "Books". Um am Ende eine Auswertung zu erhalten, würden wir gern die CRM und Books-Daten und dann noch Subscriptions zusammenführen. 1. Kann man Arbeitsbereiche zusammenführen?
[Blog] Applying Data Literacy for Embedded BI Success
The term “data literacy” denotes the skillset that’s required to understand, interpret, utilize, and communicate data across the organizational hierarchy. With the variety and diversity in the scope of data usage across different job roles, the approach
(Blog Post) Zoho Analytics: Most Popular Integrations with Zoho Apps
A high quality data analysis will boost almost any part of your business. It helps you evaluate your processes, productivity and efficiency, as well as giving you insights about where your business might be lagging. That’s where Zoho Analytics top features
Sort by Total Line ( Horizontal)
Please add the possibility to Sort by Total Line ( Horizontal)
Bar Chart -- Multiple Y-axes, separate scales
Hi! I created a bar chart ("Sales by Day of Week") X-axis: Day of Week Y-axis 1: $ Sales (this is a large $ amount) Y-axis 2: # Sales (this is a small number Here's a picture: http://screencast.com/t/YjIzNDk0ZG The columns for "# Sales" are tiny next to the columns for "$ sales". How can I force the two Y-axes to use different scales?
Getting Error : Report Cannot Be Joined
Looking for some advice. I am getting the following error when trying to join reports in a table view I am trying to Add "DueDate" from the Table "Eagle _Network_DueDates" to a pivot table primarily built on a table titled "Eagle_All_Hours_Report" by
Zoho Analytics Seems to Forget Zoho Projects Data Structure
I am in a proof of concept with Zoho Projects and Zoho Analytics. Management wants to see how long tasks are with specific users in specific stages of a project. I came up with a query to give us a pseudotable (a view) which would neatly provide that
ZIA auf Deutsch?
Wann können wir mit ZIA auf Deutsch rechnen?
[Integration Enhancement Update] Supporting Debit Notes data in Zoho Books - Zoho Analytics integration
Dear Customers, We are glad to share that the debit notes data will be supported in Zoho Books - Zoho Analytics integration from 16-January-2023. As debit note is an integral part of invoice module, we will be importing the debit notes data in the Invoice
[Product Update] Business apps integration settings edit access to account and organization administrators in Zoho Analytics
Dear Customers, We are glad to share this private beta update! Users with account administrator and organization administrator roles can edit an existing business app integration setting irrespective of the integration owner who configured it in their
Dynamic or calculated date ranges
Is it possible to use a calculated or relative date range in Zoho Desk reports? i.e. say "Current time" - 28 days. I'm attempting to report on tickets that have had no activity for a defined period e.g. Dormant tickets would be any active ticker (i.e.
Pagination Causing Duplicates
I am using Analytics to pull in data from an API. When I use the pagination protocol provided by the API (offset & limit), it is causing duplicates instead of paginated results (so, as an example, I'd be expecting records 1,2,3,4,5,6,7,8,9,10, but getting
[Integration Update] New Authentication Model in Shopify - Zoho Analytics Integration
Dear Shopify integration users, This is an important update from Zoho Analytics. Due to some technical and policy limitations in Shopify - Zoho Analytics integration, we are discontinuing the OAuth based authentication model. From now, Zoho Analytics
how to make separator for thousands?
hi made widget in reports how to make separator for thousands? for example - 1,000 - 1'000 - 1 000
Where with a boolean NOT !=
Hi, I have a SELECT which does a SUM() on some column FROM a table, WHERE another column in the table does not equal to a specific string. The NOT is not working and it is still being summed up. I'm trying to SUM up all the payments of invoices that were
[Webinar] 2022 - The state of business intelligence
In hyper-competitive markets, modern businesses need to stay dynamic and evolving. That's why many organizations have embraced data-driven decision-making as the fulcrum for accelerated business growth. And this trend is here to stay. Given the rapid
Problem with data type
I have a problem with changing a data type from Plain text to number. I need to have a sum of hours spent but because when the database was built Hours Spent column was put as Plain Text instead of as Number. I've tried it in query but I can't convert
Aggregate formula to get previous months data
Hello, I was wondering if there is a way to write formula to get the data from the previous month? So I would want to get the sum of sales from previous month to use it in the current month. thank you
[Blog] Project analytics: 360° insights for successful project delivery
Project management is a key enabler for efficiently managing the volume and velocity of business efforts and delivering ambitious growth rates. With growing data volumes, more project managers are adopting data analytics to make better business decisions.
Please add the option to be able to share the Folder with filter creterium
Please add the option to be able to share the folder with filter creterium funktion.
Collapse Columns should be added as option
Dear Zoho Team, I miss the option to collapse columns ( see picture). Could you please integrate this option? Ana Jeva
Picklist History in Reports or Zoho Analytics
Hi there, I am trying to track our Lead-Funnel Stages with a Picklist. While I see the history through the stages I cannot find a way to access the history in reports or Zoho Analytics. is there a way to do this? Thanks, Hannes
send Alert to User Groups and not only per Email Id
Dear Team, How can I create an ALER message that will be sent to the specific User Group? We have 40 users who should receive alerts. It's really time consuming to add each email separately for each alert setting. Thank You , Ana Jeva
User filter contains
Hello, Is it possible to have custom made user filters ? We would like to have a user filter that combines Accounts which are containing a same piece of text in the Account Name. Example of some Account Names: Warehouse 1 Warehouse X Mini Warehouse West
share folder to user group with filter criteria
Dear Zoho team, Could you include an option to share the folder with filter criteria? Problem: I have many reports in one folder, to save time and use the same filter criteria it would be much more efficient to share the complete folder directly rather
Controlling external sharing of zoho analytics data
We face an issue where User A and User B, where both user A and user B are both present in workspace C are not able to share their own reports with each other to collaborate. Zoho support told me today that to allow user A and user B to share data, then
Historical data - to remain unchanged
Hi I have created comparison funnle charts to show different stages of my B2B sales pipeline. Th charts are based on
Add more values to database variable
Hi, Is there way to add multiple values, perhaps separated by comma in the variable value that is associated to an email address. I understand the work around would be to create a new map value pointing to the same email address. But that would be a bit tedious. Say we have John Doe who can view reports for West and East region. I am assuming currently we have to add two map values. This is not too hard if you just had two map values. What happens if you had 100 product categories and need to may
Collapse groups in a summary view?
How do you collapse group rows in a summary view? Or to collapse a section in a pivot view? Is there anything like a tree control? This would seem like basic functionality for display of grouped data. For example, suppose I have a pivot view with a summary
Date filter
Hello, Our fiscal year is starting in september. I created a chart with filter to start in Y2023 and that it should be possible during the year to see chart results per Month in the new fiscal year. However when I create a dashboard with that chart, it
Zoho Desk integration - information about time entries whether they have already been invoiced
Hello, we use zoho desk with the zoho books add-on. Thus, the time entries that are marked as billable ("isBillable": true) can be charged with zoho books. Using the Desk API, I can access the information of the time entry I need, so it's definitely
ACCOUNTID being "Truncated"
I am using ZOHO Reports in conjunction with ZOHO CRM. When I export the Events table to either and Excel or CSV file, the ACCOUNTID number gets truncated, or rather the last three digits get replaced by 0s in the Excel or CSV. I have attached an example with screen shots. In ZOHO, ACCOUNTID is an 18-digit field (e.g., 917037000000222130). When you exporting it either to Excel or CSV, you see 9.17037E+17 in the Excel/CSV column; when you look at the actual number in the field it is 917037000000222000.
Join Tables
Hello Dear Zoho Team, When I want to join two tables from the same source, I get this error that I uploaded in the attachment. It is very important that we join these two tables. How can we fix this problem ? Thank you in advance for your help. Kind
Zoho Desk - Analytics Sync failure
Hello, The synchro between our Desk and Analytics Apps does not work anymore. The error message says: Reason for Sync Failure: The plan for your Zoho Desk account does not support Zoho Analytics integration. Solution: Please upgrade your plan if you want
Linking two tables by value
Hello, I am new with Zoho Analytics and would like to know how could I link two separate report tables/pivot tables? I have pivot views: sales and detailed sales These views has filter OrderNo In sales viewI have OrderNo, totals sale price In detailed
Date Field not Populating
Hello when uploading data, the Date columns return with no data at all, the data table has about 6 million rows. I am not sure how to fix this?
Date setting
I have my dates all set to USA format (mm/dd/yyyy) for my data imports, but after import Zoho still flips the format to dd/mm/yyyy in my raw data after its imported. How can i stop this from happening?
Analytics IP WhiteList
Hello, please, tell my whitelist IP addresses for data center analytics.zoho.jp Thanks
Next Page