Zoho Project Milestone Baseline Start Date
In zoho project, i have milestone "baseline start date". in zoho analytics, I have milestone table but i am unable to find the milestone baseline start, slippage and end variation columns. any idea where I can find them??? please see the attachment for
Radar / Web chart
Hi, I am having troubles configuring a Web chart (also called spider web or radar chart). I need to create one of these charts to plot the value of 10 different variables. I really don't have an X axis because all the variables are in the Y axis. Could any one please give me some tips on how to arrange the data? Thank you
Aggregate User Filters on Dashboard?
I have created a sales dashboard where one of the user filters allows you to sort by each member of the sales team. There is a specific smaller "Inside Sales Team" within our overall sales team that I would like to easily filter down to. Is there a
Count at given moment in time
In Zoho Analytics, I want a pie chart to show how many people of each gender were employed on a particular user defined date (User Filter - Single Date Selector). I have the following fields within my employee records: Employee Number Start Date Leaving
How to set business hours
Hi, I want to know how can I add business hours and how to calculate the first and average reply time based on our business hours. So far I couldn't find this setting. I saw that I can filter based on the business hours but where can I set them?
Data snapshot every 2 weeks in Zoho Analytics?
I know you can take data snapshots in Analytics once every day, week, and month. However, I am wondering if there is a way to set up data snapshots to happen automatically only every other week?
What timezone is the timestamp in?
I'm in Pacific daylight time. When I display the chart that shows Instagram reach by weekday and hour, the hour results with high numbers are different than the high-result hours shown by other analytics providers we've tested. This leads me to wonder
How to filter (dashboard timeline filter) using both Leads and Contacts module in Pivot View (Zoho Analytics)
Hi, Currently I want to show the conversion of leads to contacts for a period of time (by lead source). So I do a count on Created Time of Leads and also count on Created Time of Contacts. For my dashboard I use timeline filter to switch the period I
Databridge on multiple machines
Hello We have set a databridge up on a machine where our database will sit but I cannot see this when I log in (it was set up by a different user). Should I be able to see this? I am setup as an Organization Admin. Also, if I also connect to the machine
Unknown text for null in Widget
Dear Community, I have a question for Widgets. When I have the technical null (no data) there is the text Unknown placed in my Widgets. For Grafiks there is a posibility to rename this value, but I did not find a posiblity to do this for Widgets. Th
Territory related reporting
Hi, We use Territory Management extensively in Zoho CRM and our reporting is done based on each territory but unable to find the option to create reports in Zoho Analytics based on the territories. Can someone help if I'm missing something.
Display sheet sorted by category with titles
Hi, What I want sounds simple but I can't work it out. All of the computers in my database have a status of either '0' or '1' Zero = computer is current One= computer has been archived I want a simple spreadsheet / report that will list ALL computers,
Tip of the Week - Applying Themes for Dashboards
Zoho Analytics allows you to apply themes to improve the appearance of your dashboards. You can customize the themes of your dashboard and personalize them to suit your needs. Conceptualize your dashboards in Zoho Analytics with six preset light and dark themes, or unleash your creativity with your own custom design. To apply themes to your dashboard, From your dashboard's toolbar, click the Themes button at the top-right corner. The Dashboard Themes dialog will open. Choose the desired theme from
"Pivot Table" Conditional Formatting
Team, I there a way to use conditional formatting a "Pivot Table" report? Thanks, Arron Blue Pumpkin Hosting | Solutions Made Simple
How to auto-remove columns that no longer exists on data source?
Hi! I have a table like this on BigQuery: id | name | description | unit_price | quantity I imported it on Zoho and created a calculated column. Now I have this: id | name | description | unit_price | quantity | total_price Then, I rename some fields
Analytics adding currency fields and totalling as plain text
I have four fields that I'm adding together. The fields being totalled all have a data type of currency. When added together, although the number returned is correct, it's a plain text field which I'm unable to change. How do I change this to return
Chaging legend item name
Hi, I was wondering if it is possible to change only the name of the legend items without adding any tables or columns. So you do not change any data nor add any data, only changing the visual part of the legend item. Thank you in advance.
Query Table
Hello All, I have connected my local database to Zoho Analytics successfully but now i want to query table but i can't seem to find the option for that. Please find the attachment.
Date Range - Default Start Date
I have a report with a User filter for a date range. Is it possible to implement default dates, which the users can subsequently change? Ideally, when loading the report, the default date range should be From: {Today} To: {Today + 84 days} But, the users should always be able to then change the date range as they see fit.
Building a chart from call log data
I have a table full of call logs and I need to build a graph that groups the logs entries that occur between each hour of the day and then count that number. The question I'm trying to answer is the average number of calls per hour for a given time
Export to Excel loses Formatting
Hello I have been trying to export and share a report I have created via email as an excel attachment however this loses it's conditional formatting applied within the report. I have tried both xls and xlsx and selected the option to export "Current
Query Table Option
Hi guys, I need to create a Query Table in my workspace and the Query Table option when I cliked + Create. Regards
New Features rolled out on Dec 21, 2021
Multi Language Support for Zia Ask Zia now supports English and Spanish languages. By default, the language specified in your Zoho Account will be selected as the language for Zia. You can choose to change this when needed. Click here to learn more. Custom
Grouping Data for a chart
I have real estate data I'm working with and want to show how many agents sell 1 house a year, how many sell 2 homes per year, etc. I'm trying to make a chart and not sure how to define the X and Y axis. Each row in my table is 1 real estate transaction
Persistent Problem
Hello, you told me to tell you if the problem persist, we need to erase data from ours tests in the analytics It persist, we have erased the surveys response from the survey and the data still exists in the Analytics Tables from the Survey integration.
Prepare Data - Remove non-numeric characters
I am trying to modify an existing scheduled import, using the "prepare data" option. How can I remove non-numeric characters from a specific column on the scheduled imports? Thank you
Scheduled emails with html inline table do not take into account color of conditional format
Hi, I've a scheduled email of a html inline table which contains conditional format. But when the recipients of the scheduled mail receive the email they do not see the coloring: Please support. Thanks!
dynamic threshold value based on required average for a target
Hi, I am looking at adding a dynamic threshold for an entire table on a chart report. For example our target is £30,000 the required average total sales is £1000 per day, however this isnt always the case for obvious reasons such as the weekend, weaker
how to restore a mistakenly deleted data source?
A data source that has a connection to the CRM has been deleted by mistake, how can this connection be re-established?
Last Synced indicator
Is it possible to have a last synced widget/system data field, which would include: date of last sync, status of last sync, # of rows synced This way I can show this info to my users so they know how 'old' the data is?
Sync Failed
We have had the last few syncs fail for one of our scheduled imports. We ran an internal query on our server and it returned 900,000+ records in under 16 seconds, so we do not THINK that the issue is on our end. We also have not made any changes to the
Add Columns to Table using Query
Normally to add columns using SQL I would use the Alter Table statement. However, it looks like ZOHO only allows Select functions. I have a row of Estimator Names, and a corresponding row of Job Amounts and a row of Job ID's. What I would like to do is
Analytics Down but Status Says All is Fine
It's been over 30 minutes that Analytics has been down and all we're getting is: Yet the Status page shows: Bad enough that Analytics is down (please fix!) but worse that the status page doesn't show accurate current information.
Zoho Hipaa compliant?
Is Zoho reports or creator Hipaa compliant?
Map chart on Dashboard - can I disable tooltip?
When adding a world map chart to a dashboard, I would like to disable the tooltip with details. Is there a way to do that?
Zia Insights
My Client is having an issue using Zia Insights on her dashboard Her dashboard is accessible to her as a Published URL with the following settings selected (images below) When she selects the ask zia option in the top right portion of her graph, she repeatedly
Tip of the Week: Show Total Value and Data Label in Ring Chart
A Ring/Doughnut chart is a circular chart, akin to a pie chart. This chart is especially useful in finding the contribution of parts to a whole set, contribution of each element that adds up to the whole composition. Some examples of Ring/Doughnut chart may include sales across regions, marketing spend in various channels, rainfall distribution etc., In Zoho Analytics, you have an option to Show Total Value and Show Data Label in a Ring/Doughnut chart. By default, the total value will be displayed
Update on the recent Apache Log4j2 vulnerabilities - Impact on Zoho Analytics On Premise Deployments
Dear Users, Three high severity vulnerabilities (CVE- 2021-44228, CVE-2021-45105 and CVE-2021-45046), impacting multiple versions of Apache Log4j utility, was disclosed publicly on December 9, 2021. We have found no evidence of any successful exploitation
SQLQuery incorrect output
hi, I ran the sql query below on zoho analytics and the result differs from what I got when i ran the same query on MSSQL Management studio. SELECT e.ClaimId, d.Diagnosis, SUM(e.InitialAmount) total_salary FROM ClaimDrug e INNER
Call modeling API
I am developing a wordpress plugin that will create a new workspace in Zoho Analytics through the Modeling API. So I am using PHP. I have the refresh token, client_id and client_secret, but i always have a fatal error in the client librairy. Here's my
Next Page