Google Analytics 4 (GA4) data is duplicating in the imported tables of Zoho Analytics after each import
I am importing Google Analytics 4 (GA) data into Zoho Analytics and Scheduled it for daily import. But the data in each tables are duplicated after each import from GA4. How to solve this issue of duplication of data after each import. Thanks and Regards,
Dashboard emailed as inline message cuts off table
Hi I have a dashboard that consists out of a pivot and a few charts. When I email this view the pivot gets cut off and only the charts are visible. If I remove the charts from the dashboard the pivot is sent out complete. Thanks in advance!
Reset Password for Reports
Hello Is there away to reset password for scheduled reports in Analytics? If so, how can this be done?
Cash Flow Report
Hi, I'm trying to make a Cash Flow Report in Zoho Analytics like the screenshot attached. I would like to know if it's possible to get the "Closing Balance" from previous month as "Net Opening Balance" in the next month. Any idea? Workaround? Thanks in
Anyone else getting "Sorry, refresh operation of the underlying query table was aborted....." error in Zoho Analytics
Full error: Sorry, refresh operation of the underlying query table was aborted, as processing time exceeded the allowed time limit. Please try after some time. Contact support, if the issue persists
Analytics Aggregate Formula
I have been trying to write an Aggregate formula to Sum a column based on certain criteria and then multiply that number by 10%. The data table is called - "Deals (Zoho CRM)" The column name is - "Amount" The conditions for the Sum are - -"Stage isn't
Row exceed limit in Zoho Analytics
Hi, I am generating the reports in Zoho Analytics by syncing the data from the Zoho desk. As soon as I moved to the live plan, the limit was about to be exceeded, though I specifically asked whether I'd face any issue with this, and the presales rep said
Cannot drag and drop reports into dashboards
I have been building a new dashboard for awhile now. Today I went to add a new report to an existing dashboard and it just has a red x when I drag it over. I thought it might be report or dashboard specific. I then tried standard reports on the existing
How to get KPI'S Difference in between Latest values to Previous values in percentages
Please how can I get this below KPI's difference of previous value to Latest value Please let me know how to achieve it. I need to Know How to Show the below KPI's Percentage Values. This is my dashboard KPI's How can get that negative values of KPI
Cant export a panel from a public view
Hi! Since yesterday users that access through a public view cant export a panel as a PDF. The option is enable but it loads and loads but nothing happens
Grouping the data for chart.
Could you please tell me how to add all the Darkness values As a group, I need to Display all the Darkness values as a group and sum of all the percentage values. Please kindly Respond anyone, How can I Achieve this Please Tell me How to all Darkness
Grouping the values in chart
Could you please tell me, How to add all MotorCycle's as a Group
[Upcoming Webinar] Delivering delightful customer service with support analytics
Take your customer service game to the next level with support analytics! Join our upcoming webinar as we discuss insight-driven helpdesk strategies for optimizing various aspects of customer service, like operational efficiency, customer satisfaction,
New Features rolled out on August 16, 2023
Advanced Analytics for Klaviyo Advanced Analytics for Klaviyo enables marketers to assess the campaign's performance, helps refine strategies to improve audience engagement, and personalize email campaigns based on demographics to achieve a higher ROI.
KPI Widget - Distance to Target?
Hey all, In a KPI widget, is there any way to display how far you are from target? Eg/. - Sales is at $10,000 - Target is at $15,000 Distance to target = $5,000 I am wondering if this is possible somehow with a dynamic label?
[Product Update] NPS Surveys, NPS Responses and NPS Recipients Modules Deprecation in Zendesk - Zoho Analytics integration
Dear Customers, As Zendesk has recently deprecated the modules listed below, we are no longer offering support for these modules in the Zoho Analytics integration. 1. NPS Surveys 2. NPS Responses 3. NPS Recipients Data in these deprecated module tables
[Product Update] 'Total Price USD' Field Deprecation in Shopify - Zoho Analytics integration
Dear Customers, Due to the recent update in Shopify API, the 'Total Price USD' field within the 'Orders' module is no longer supported in the Shopify - Zoho Analytics integration. As we move ahead, this particular field will not be available during the
[Product Update] Price Lists and Sales Price List Details Modules Deprecation in Exact Online - Zoho Analytics integration
Dear Customers, As Exact Online has recently deprecated the modules listed below, we are no longer offering support for these modules in the Zoho Analytics integration. 1. Price Lists 2. Sales Price List Details Exact Online has introduced the following
Query Cannot be saved because of performance
SELECT "Invoice Number", "Total (BCY)", "i'm creating clothing for my", "Account id" FROM "Invoices (Apliiq Inc)" LEFT JOIN "Contacts (Apliiq Inc)" ON "Contacts (Apliiq Inc)"."Customer ID" = "Invoices (Apliiq Inc)"."Customer ID" LEFT JOIN "Accounts" ON "Accounts"."Account Id" = "CRM ID" WHERE "Invoice Status" = 'Closed' I am trying to get all invoices (from zoho books) with their associated account id (from zoho crm)
[Upcoming Webinar] Optimizing 5 focus areas of online businesses using ecommerce analytics
According to Forbes, 79% of shoppers make online purchases on a monthly basis. With explosive ecommerce growth and its substantial share of global retail, businesses must prioritize optimizing their digital storefronts for success. Join our upcoming webinar
Tip of the Week - Create KPI Widgets with Dynamic Images
Images are the favored medium and a powerful tool for communication as it is easy to process visual information far more efficiently than raw numbers and lengthy descriptions. With KPIs being the prime source to gauge progress and understand the health
Zoho analytics wrong query?
Hello again, I have created a dashboard and I want to have a table to display all projects that were lost before the project entered the "Offer" stage. I created a custom query table, but after running the code it still displays projects that were transitioned
Zoho Analytics Current Date Returning UTC
After this https://help.zoho.com/portal/en/community/topic/new-features-rolled-out-on-july-10-2023, current_date() is now returning UTC time
Zoho Analytics connect with Salesforce
I get an error when connecting to salesforce
Using data fields in Zoho Show presentation to extract a number from Zia insights.
Is it possible to use data fields in Zoho Show presentations to extract key numbers from Zia insights based on a report created? For example, using this text below: (note that the numbers in bold would be from Zia Insights) Revenue - The Total Revenue
Default format for all of Zoho Analytics
Hi all, I am wondering if there is an option to set default formats across Zoho Analytics. For example, 1. Currency should be $ Australian with 2 decimal places 2. Percentages should be centred Is any of this possible at all?
Zoho Analytics connect with Salesforce
I get an error when connecting to salesforce
emulation of SQL Minus operator
Hello good morning, I've been using Analytics for a while now and I notice that it doesn't have the SQL Minus operator, to make a difference between two data sets. Searching the internet, mysql did not have it some time ago, and all that was left was
Get SUM of Amount based by remove the duplicate id
From the below table I want to sum collection amount based on the unique Opportunity-ID. If there are two duplicate opp ids I need to consider one row to count the sum. Note I cannot remove the duplicate rows as these rows merged with another table which
Adding Custom Tables with GA4 Data
Hey everyone! I'm trying to create a Table data from my GA4 database. Basically, a table of a specific event based on Geo (Country). I'm able to see the Geo Table however, my Events Tracking table does not have a Country column for the tables to be combined
Google Analytics and Zoho CRM
I want to track the amount of users that successfully made a purchase by combining Google Analytics data with Zoho CRM data. Right now I don't see any user specific information in the Google Analytics modules within Zoho Analytics, like email addresses,
Do ZoHo Query Tables support GROUP BY GROUPING SETS?
I am attempting to use the following: GROUP BY GROUPING SETS ( ("Salesperson", DATE_FORMAT("date created", '%Y-%m')), -- Individual month-level data ("Salesperson") -- Rollup for all months ); I have been unable to find a list of supported SQL commands.
Create a Variance Column with comparison from 2 other columns in pivot table report
How to create a Variance Column with comparison from 2 other columns in pivot table report? So for example, would like to create Column # 1 with Current mth data and Column # 2 with Previous mth data with difference between these columns shown in Column
Transacciones de bancos de Zoho Books
Buen día, Espero alguien me pueda ayudar en lo siguiente, estoy intentando sacar un reporte de las transacciones categorizadas de bancos de Zoho Books: La cuestión es que no encuentro como identificar estas transacciones en las tablas de Zoho Analytics,
Aggregate Formula Help
Hi - I'm trying to convert a working Aggregate formula in analytics to pull the data from CRM versus a data table. Here is my scenario - we need to pull sales numbers up to today's current date based on a previous sales cycle. I cannot use a basic YTD
2 Modules combined
Hello, We have 2 modules : 1. Visit Reports 2. Hits I would like to make charts and widgets to see how many visits are done per hit and this ideally per user over the months. How can I do this because when I create "add aggregate formula" in the table
Sharing Editing Rights of a Dashboard in Zoho Analytics
Hi, Being an Account/Org Admin how do we share the rights to edit a dashboard with with other people? Let's say with a workspace admin?
What's the best way to combine and chart data from two pivot tables?
I have two tables of raw data: "product sales" (raw individual product sales) and "product work" (raw time log entries) I want to create a chart that contains total revenue (sum of all sales) and total cost (sum of all work) on a monthly basis. What is the best way to do this? I can easily create a pivot view for sales and a pivot view for work, but what I want to do is create a view that combines two pivot views. One challenge is that the pivot view cannot be queried by a query table, nor can it
New Features rolled out on July 10, 2023
Advanced Analytics for LiveAgent We are happy to announce the Advanced Analytics connector for LiveAgent. It enables you to probe and identify bottlenecks within the support process, take measures to solve recurring problems, and optimize resource allocation
Filter exlude person from certain month
Hello, We are tracking the visits of several salespeople on Zoho Analytics in a Pivot Table We use filter to include/exclude persons on this Table. How is it possible to include person X for several months and exclude that person starting from a specific
Next Page