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!
Zoho Analytics to Zoho Sheets - automatic update?
Hi all, If I create a zoho sheet from an Analytics Report or Analytics Data, is there a way for the zoho sheet to automatically update as the Report / Data in analytics updates?
Reset Password for Reports
Hello Is there away to reset password for scheduled reports in Analytics? If so, how can this be done?
Help createing Inventory Volume report
I've been working with Zoho support for a few months now trying to develop a inventory volume report. Though they have been helpful, it never seems to generate exactly what we're looking for. I thought I'd turn to the community for further help. We've
Commenting and Collaboration
Commenting and collaboration facilitates real-time communication, knowledge sharing, and data quality assurance. They boost decision-making, ensure compliance, engage teams, and support scalability, improving overall organizational performance. Watch
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
Tip of the Week: Exclude from Dashboard Filter
Sometimes you want your reports to remain unchanged regardless of the filters applied in your dashboard. For example, if you have a report comparing current and previous year performance, filtering by year will make it lose its purpose. In Zoho Reports, you can easily choose to exclude a particular report in a dashboard from getting filtered using the Exclude Dashboard Filter option.
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
Data Alerts
Data Alerts offers real-time monitoring, timely decision-making, and proactive issue identification. Customizable triggers enables tailored alerts, aiding efficient resource allocation and remote monitoring. These alerts foster user engagement, accountability,
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,
Zoho Analytics integrates with OpenAI to enhance Generative BI
Zoho Analytics integrates with OpenAI's ChatGPT, a Generative AI assistant to augment Zoho Analytics Generative AI capabilities. You can now easily generate formulas, build complex SQL queries, discover public datasets and even train Ask Zia to enhance
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.
Data Storytelling with Zoho Analytics
Zoho Analytics is a unique self-service BI tool that comes with unique benefits. It is a reporting and analysis tool that targets at helping business users in a comprehensive way. With the use of individualized dashboards, over 76% of Zoho analytics businesses
Query Table
Query tables provides a versatile and efficient way to retrieve, transform, and manage data for analysis and reporting purposes. They enhance data manipulation capabilities, improve performance, and contribute to better decision-making. Watch this video
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
Join tables using Lookup
Joining multiple tables using lookup can provide several benefits in relational database management systems. By joining multiple tables using lookup, you can consolidate data from different sources into a single, comprehensive dataset. This can simplify
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.
Next Page