SQL databases and Zoho
Hi, I am very new to the world of analytics and data, I have a product that end users log in to. They create a profile that includes email address and mobile number. There are other fields for profile content. I want to run the product and look at how
MAT/MQT/YTD calculations
Hi, I'd need some help with calculations in Analytics. Having a simple table with data imported from local Excel, how can I do MAT, MQT, YTD and also MAT growth rate and MQT growth rate calculations for different products and countries. Knowing that the
Help with Complicated YTD Aggregate Formula
I need help with an aggregate formula to get sales up to the current date based on the previous sales cycle. I cannot use a basic YTD formula as my needs are a bit more complex. We run annual events and sales can overlap calendar years. Example if todays
Zoho Historical data unchanged
hi i have created funnel charts to show different stages of my B2B pipeline However, I would like my previous historical data to remain unchanged Can I have a filter for that?
Bing Ads import is often incorrect
We use your system to pull cost data from Bing Ads, and calculate margin. Frustratingly the Bing Ads data is often incorrect. We have reported this bug to your support team over 10 times. Sometimes the data is double or triple counted. And sometimes large
Custom field in ZOHO Analytics
Hello Zoho TReam I have a custom field in supplier invoices in ZOHO Books and I would like to use it in the reports within ZOHO Analytics but, it is not visible in the configuration of the ZOHO Analytics data source. Regards
Read value from report in Zoho Analytics
An email is sent from Zoho Flow. I would like one dollar amount to retrieve based on customer ID. This amount is available as two column (customer ID / total amount) report in Zoho Analytics. How do I retrieve the "Total Amount" and have it included in
Analytics Dashboard Click to Lead Record
I'm creating a dashboard (in Analytics) that shows a table of leads that is filtered based on certain criteria and shows the name of the lead. How can I set up the data so someone can click on the name of the lead and navigate directly to that lead record.
Contributions by employee and managers
Hi We have created an application in Zoho where we have sales invoices and for every sales invoice, we have employee contributions captured. So, there are 2 tables in Zoho Creator. One table for the invoice with the a field for the associated employee
Customer spotlight: Zoho Analytics enables end-to-end business insights for ON TIME Logistics
ON TIME Logistics is the result of the acquisition of different companies that have data in legacy systems and in different formats. Till now, the teams have used different systems for storing information. This means they created reports in silos and
The elapsed time from when a synchronization begins and ends is long enough to create the possibility for error and confusion.
The elapsed time from when a synchronization begins and ends is long enough to create confusion. I understand that Analytics is a reporting tool, and that data latency caused by synchronization is unavoidable. It would be helpful if every report, whether
How to integrate dashboards from Zoho CRM into Zoho Analytics?
Hi all, We mainly rely on Zoho Analytics for our BI work, and I'd like to import the already made dashboard on Zoho CRM or other business apps into Zoho Analytics to have all the BI work in one place. I only want the dashboard, not the raw data. Is that
New Features rolled out on October 14, 2022
Introducing a Data Type - Duration Zoho Analytics now supports time Duration as a data type. This opens up a whole new category of time-based data analytics. Now you can get to know how long it took to accomplish something, to complete your projects,
Replace Base Table
I have dashboards retrieving data from a table linked to OneDrive. I would like to change the table to an identical table with different name without reworking the dashboards one by one. How can I achieve this? This is due to an issue where I am unable
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
Can I track weekly dashboard difference?
Hello, I am building a weekly dashboard in zoho analytics. Since the data changes all the time, every week's result is different, for example, this week our total predictive number of this year is 100, but last week the total predictive number of this
How to parse JSON data with SQL in Zoho Analytics?
Hi all, I have a column with JSON data. I want to show this column in a chart, but it is very messy, and no JSON parsing function is supported on Zoho Analytics. data example: {"id": 5, "status": "false", "date": "15/10/22"} what I want to do in SQL is
I cannot join tables within internal data source from Zoho CRM
Hello there, We have been sync'ing zoho crm and zoho analytics for a while. In zoho CRM, "Purchase Orders" and "Purchased Items" are 2 related tables on a same field, so I can export data from zoho crm, like 1 Purchase Order linking to 5 purchased items.
[Upcoming Webinar] What's new in Zoho Analytics: Q3 2022
Hi there! At Zoho Analytics, we provide a comprehensive analytics offering with an ever-evolving range of modern-day analytical capabilities. We seek to constantly enhance your analytics experience by introducing useful features that offer more firepower
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?
Need help with KPI Widget on Dashboard
What I am trying to accomplish seems simple, but I cannot figure it out. Please help. I would like to show in a KPI Comparison Widget: Number of Meetings (CRM) Held in Last 30 Days compared to Number of Meetings Held the previous 30 days (from the date
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
Next Page