How To Give Access for Zoho Analytics
We are using Zoho Analytics for Prestige Park Grove to monitor our client's activity But We Need to Share the Access With Our Crew Members and maximize how many people can have access to that Please Help Us to resolve with this issue
Double quotes in the header of the query table
Hello. I have created a query table in analytics and exported it as a csv file. Then the header row values are converted to double quoted values and output. English values are not enclosed in double quotes, but Japanese values are enclosed in double quotes.
Limit Forecast Values Below Certain Value
Hi, Just wondering if there is a way to limit the forecasted values from going above a certain value. What we are measuring should never go above 100%. Can I set it so that anything predicted that is over 100% just defaults to 100%? Thank you!
data from url not working
I have this Url that is from freshservice that is basically a CSV file that gets updated periodically. when I try to add it is says that is not accessible. Any other way to accomplish this or idea why this does not work? https://corefone.freshservic
Filtering email PDF Dashboard layout
I have created one dashboard for ZOHO DESK tickets that we handle for different companies. I have also scheduled emails that send the managers the dashboard layout via PDF and a URL that uses a variable COMPANY to filter the dashboard data and show only
How refresh the dashboard everyday
How to display data properly each day on zoho analytics across multiple graphs please tell me how to do
Filter group
Good afternoon, I would like to know if it is possible to create groups of filters. For example, offering users an "English traffic" dashboard filter, corresponding to the addition of several unique filters from several fields or even do tables
Month-on-month Growth Chart
I want to create a month-on-month growth chart but I'm not sure how to go about it. For example: Jan 2023: 100 customers Feb 2023: 200 customers (100 signed up) Mar 2023: 220 customers (20 signed up) Apr 2023: 210 customers (10 cancelled) May 2023: 280
emailed as inline message cuts off table
Hello, I am facing a problem, please help 【emailed as inline message cuts off table】 please see following screen shot from the eamil recipient
Row usage on Zoho Analytics
Dear community, I've found out that my Zoho Analytics is not syncing due the limit of rows present on my plan. I've checked and found out the following: But I have no idea which tables of mine are using such a great quantity of rows. Is there an easy
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
Next Page