Zoho Analytics | Quarterly Newsletter | Q2 2022
Hello Everyone! I hope all of you are safe and well! Zoho Analytics - Q2 Quarterly Newsletter is out now! Check out the newsletter (attachment) to know all about our new features, recognitions, webinars, blogs, and many more exciting things. Do let us
Dashboard KPI widget: quarter versus same quarter last year.
Hi, I would like to set up KPI Widgets that track sales quarter v quarter. So I would need one widget that tracks the current quarter versus the same quarter last year. Then I would also need Q1 sales for this year versus q1 the previous year. (Then
Widgets
Hi Zoho, Two suggestions for enhancing the widgets. - A duplicate widget option for report dashboards would save us lot's of time. - Multi-data type widget with the main value pulling from one table/column source and the second value pulling from a
HELP please. I need a widget that is NOT dependant upon the Timeline filter
Hi Team, I want to have a widget that does NOT refresh based upon the timeline filter. I need a widget that shows the count for something for this current month. I don't want it to change if the user changes the timeline filter to look at other information.
New Features rolled out on May 12, 2022
Enhancements for Business Application Connectors Business Application Connectors in Zoho Analytics are enhanced with the following options. Advanced Analytics connector for Zoho Forms We are happy to announce that Advanced Analytics for Zoho Forms is
%Percentage
I don't know how to divide and have total in percentage, as I explain in the following image. https://www.screencast.com/t/oNZTctOG If someone have an idea, I will appreciate.
New Features rolled out on April 13, 2016
Use 'Look-up' Fields in Formula columns Zoho Reports now supports 'Look-up ' fields in formula columns. Previously, it was not possible to use formulas on a lookup field. You can refer to the Defining lookup section in this help documentation to learn about creating a lookup. Note This functionality will be applicable only if the lookup column has been created with the delete criteria set as No Action on this (child) table . You can use the lookup field to create both custom and aggregate
Dashboard - Report scroll bar
Dear Zoho Staff, Would it be possible to scroll chart report horizontally. Other BI Tool also have this feature and I expect Zoho Analytic would have too. But I cannot find a way to achieve. Best Regards, Karanig Nititham
Remove HTML Tag from a column
Hi all, I'm looking for a solution to remove html tags from a column. Example: <div>Test Worklog<br /></div> Expected Output: Test Worklog Many thanks for your help in advance. Regards Anish
[Product Update] Change in Zoho Analytics Business Apps Integration Data Sync Notification Settings
Dear Customers, In our continuous effort to improve the Zoho Analytics product with new features and enhancements, we are making some updates to the business apps integration data sync notification settings. Currently, the Zoho Analytics account admin
Responsive charts on imbedded website
Has anyone figured out the trick to having the reports/charts responsive when embedding? I'm using bootstrap as a framework but when changing the browser size on a desktop or mobile, the chart sometimes runs off of the screen depending on the browser/desktop
Aggregate Formula Using SumIF(Column A) When Column B Contains 'ABC'
I have a text column A with different values and a column B with numeric values. I would like to sum column B for all the different text values in column A (i.e. column A = 'ABC', sum(column B)) How do I create an aggregate formula for this? I've tried
Can't Delete Imported Tables
I have some old imported tables from "Survey Monkey" - I no longer am using Survey Monkey and would like to delete these tables, but am getting an error forbidding me from doing so The error is: is a system table and cannot be deleted How do I get around
Roll-up Dashboard
Hi Brainstrust, I have several (about 10) workspaces that are used for different Regions. Each region has it's own discrete data, although the data tables are the same structure in each of the workspaces. Each region makes bookings, and has costs associated
Filtering the date as in write query
Hi Zoho Team, iam experiencing to cannot resolve how to filtering the date as in Query as below e.g date filter in query "2022-02-01 between Date_Arrive and Date_Depart OR 2022-02-05 between Date_Arrive and Date_Depart" in this filtering we can have
I do not want "-No Value-" to appear in the pivot report.
I do not want "-No Value-" to appear in the pivot report. Can this behavior be suppressed? Please help.
Funnel Chart Percentage Decimal Point
Hi, I am trying to round up to the nearest percentage on a funnel report, but whatever I do it isnt playing ball, any ideas?
highlight current period in bar chart
I have a bar chart the shows the current value of bookings/appointments for past and future weeks along the horizontal axis. There are roughly 40 weeks shown on the chart with the current week somewhere in the middle. Is it possible to highlight or change
New Features rolled out on April 13, 2022
Enhancement in White Label Solution White Label users can now do the domain mapping and domain verification from Zoho Analytics' user interface itself. This allows them to configure the White Label Solution in a secured and user-friendly manner. Click
Calculate Average based of date filter
Hello, We want to calculate the average of rows that appear when a date filter is applied in a dashboard. Is there any way to achieve this? Thanks,
Google Ads - Zoho Analytics Integration API Update
Dear Customers, As Google suggested to upgrade the AdWords service API to the latest Ads API, on 22 April 2022, we have upgraded the APIs used in the Google Ads integration framework in Zoho Analytics. Google's Official Notice: https://ads-developers.googleblog.com/2021/04/upgrade-to-google-ads-api-from-adwords.html
How to split the y axis on a combo graph?
I have a stacked combo graph where the 2 bar graph items are sums and the line is a percentage (count % of total). The line is showing really low, because it's comparing the percentage to the count. Is this currently possible? According to the post in this topic it is: https://help.zoho.com/portal/en/community/topic/split-axis-combo-chart
Sending emails to the share group using Apply filter Criteria
I am looking forward to sending emails to multiple users using Apply corresponding share filter criteria. Whenever I add a new member or a group in the 'To' column, the following error pops up - "Apply filter Criteria is not available when email reports to Share Group.". I would like to know the options available for sending emails to multiple users using Apply corresponding share filter criteria. I have attached the screenshot of the error message for your reference. Thank you.
Multiple filters for the same data in widgets
Hi, I'd like to set up a widget that shows the values of the same data according to different filters, like this: Primary value: Created time - This month Secondary value: Created time - Custom range Is this possible?
Plugin for Analytics
Hello All, How can I create a plugin setup for Zoho analytics wherein I can push data from third party application to Zoho Analytics table? Do I have to create something on Zoho Catalyst or using Sigma or what? Please guide me here.
Zoho Charts and Trendiness
I'm pretty new to Zoho Analytics, and this is a pretty basic question. I've created some solid vertical bar charts. Everything looks the way I want it. However, I went in and decided I wanted to add a linear trend line to overlay the bar chart. It
Zip Code Location - GeoMap
See image below For Zip Code 2139 (Cambridge MA, USA) the ZOHO GeoMap defaults the location to somewhere in Australia.... this is not correct. Can you please correct this or show me how I can correct it locally? Correct Latitude and Longitude for zip
How to add analysis across n:m modules into a dashboard?
Hello, let's assume we'd like to get the total amount of all potentials, that are related to campaigns. I'd like to filter by campaign name / start & end date in a dashboard. Then, I'd like to have either a widget or something else to display the sum
Link Smart Elements (Zoho Show) to tables in Zoho Analytics
It would be GREAT if you could create a feature that can connect the Smart Elements in Zoho Show with tables that exist in Zoho Analytics so the Smart Elements can automatically update themselves in the same way that Widgets do in Zoho Analytics
New Features rolled out on Mar 11, 2022
New Business Application Connectors We are happy to announce the following new Business Application Connectors. Advanced Analytics for Google Search Console The new Advanced Analytics connector enables you to deeply analyze data from Google Search Console.
EOMONTH Function
Does Zoho not support an EOMONTH function? I keep getting an error code. Is there a workaround? SELECT "Act. Gds Mvmnt Date", "Shipping Value", "Plant", "Name of sold-to party", "Network", EOMONTH("Act. Gds Mvmnt Date",1) AS "End of Month" FROM
Gradient Coloring for Conditional Formatting
It would be a good addition if for pivot tables (and other types of data tables) you added a conditional formatting option so that you can apply gradient color formatting based on the value being high to low
last 90 days vs the 90 days before - widget
Hi, How do I add a widget that shows the sum of sales for example of the previous/last 90 days vs the 90 days before those days. So, last 90 days vs last 91-180 days? Kind Regards, Robin
Group by and SUM
Hi everyone,
I want to group all the campaigns (there are 4) and add (total) the clicks and the amount (importe). I have this but it gives me an error. SELECT Campaign, Clicks, CTR, "Importe" FROM "AdWords (Google Analytics)" JOIN Tratos WHERE Fase
What does the Modified Time in Stage History referring to and what can I do with it?
I would like to see a widget that presents the number (counter) of deals that changed to a specific stage in the last 7 days. How can I do that?
A Complete Overview of Zoho Analytics
Zoho Analytics is one of the finest self-service BI and data analytics software that allows you to analyze data, create amazing data visualizations, and discover hidden insights within minutes. It provides cutting edge analytical solutions that are needed
Sales Month on Month & YTD Sales Excluding Current Month
I have sent this through to Zoho Support however so far they havent been able to come up with an answer. I have 2 problems to solve as follows: Sales Month on Month Calc I would like to create a widget that shows the sales for last month (e.g. Mar 22)
Sales Commission Dashboard on GP
Hi, I want to create a dashboard for hte salesperson's to know their achieved targets and commission realtime from zoho books. The scenario is that the sales person has a minimum sales Gross Profit GP target of 20,000/- After pass 20,000 and till 30,000
Integration of Status Timeline from Zoho Projects to Zoho Analytics
In Zoho Projects, we have a way to find out the status timeline of each tasks in a specific project. Currently, we don't have a way to pull that information up in bulk, like being able to consolidate the status timeline of all tasks in one report. But
Add/ split X axis
I have the following requirement Y axis - sales X axis - state Department Color- product I want to plot a graph , showing sales on y axis and splitting X axis in to two axis [ state and department ] and in color in need to differentiate
Next Page