Cannot Find "Edit Design" button in Zoho analytics table
Hi All, I am not able to find "Edit Design" button in Zoho analytics table which were integrated with books and auto-join feature was used to connect them. I am able to lookup on query tables or tables generated without auto join feature. Any Idea on
Compare YTD Sales vs Last Year's Sales in the same period
Hi, Is there a way to compare this year's sales with the same period of last year? So we are in June as I write this. I want to be able to compare sales from Jan-June 2022 to Jan-June 2021 and so on.
More Color Palletes
One of the things that I find to be the most time consuming, is coming up with a color palette. I know that Zoho offers several different types and formats for color palettes, but it would be nice if that preset library was greatly expanded. It would
Query Assistance
I am trying to do the following within a query but am getting a bit stuck, can you help me please? I want to round these 2 datapoints below to the nearest 15 minute interval from Leads (ZOHO CRM) and Deals (ZOHO CRM) Leads.”Created Time” Deals.”Created
The lookup column dropdown menu is a major pain point
This is in the screen called 'Change to Lookup Column'. To get to this screen, go to any table, right-click on a column, click on 'Change to Lookup Column'. There is a dropdown menu under the header 'Column to Lookup'. See screenshot below. Try doing
Zoho Analytics is rated as an overall leader in Dresner's latest survey
Dresner Advisory Services is an independent industry resource which provides an alternative perspective on information management, business intelligence, analytics, performance management and related markets through the objective, non-sponsored and crowd-sourced
Number of lines in quota
Hi, I'm using Zoho analytics cloud version and I would like to know How do the number of lines used are counted, does the number include the number of lines of query tables as well or it includes only the number of lines that are imported from a source
Stacked bar chart - display the % value of the bar segment as a percentage of the bar total.
Hi, I'm trying to figure out if it is possible to create a stacked bar chart where we can display the % value of the bar segment as a percentage of the bar total. Please refer to the attached image "ZA_Stacked_bar" of what i mean. I would like this information
[Action Required] - Bing Ads Integration in Zoho Analytics
Dear Customers, As Microsoft updating the OAuth scope (authentication), all users who are signed-in through a third-party application that uses the Bing Ads API will require multi-factor authentication in their Bing Ads account. Microsoft Announcement:
zoho analytics to do 3D bar map like Excel 3D maps graphs
Hello, It would be nice to have Zoho analytics do a 3D bar map like Excel 3D maps graphs see images:
Change widget label depending on filter value
Hello, Is it possible to change widget label depending on the selected filter value? Example use case: if the user selects a country in the filter, the text after the widget value shows the currency of that country. Please see attached screenshot. Thanks
Hours Between
Hi, I am trying to get hours_between on this query but its coming up as an unsupported function? SELECT dl."Lead Source" AS "Lead Source", dl."Lead Created Time" AS "Lead Created Time", days_between(dl."Lead Created Time", dl."First Activity Occurred")
Export report to PDF keeping the user filters
Hi I am having some issues exporting reports to PDF and filters, If I select show user filter criteria, I get everything coming back instead of the filtered report I expected, am I doing something wrong
ZOHO Analytics page not running after clean install
Hi. I have downloaded ZOHO Analytics and installed on Windows machine. Everything looks ok but https://localhost:8443 is not working. Service is running Firewall disabled - still nothing. In wrapper.log the last line is this: INFO | jvm 1 | 2022/05/20
How to get Unique Count
Hi Team, I have a table that shows users. The users have one row each for what language they can speak. In each row, they also have the country they are in. Example: Name - Language - Country Steve French Germany Steve Italian Germany Steve Spanish Germany
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.
Next Page