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?
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
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
View Mode does not apply SQL "ORDER BY", how to sort by multiple fields?
When running a query directly from the edit view it works fine, but in "View Mode" it doesn't work. What can one do to see results sorted by multiple criteria?
Aggregate Sum in Qry
Hi I have a table (1) with numerical values in it I can sum these values to get the correct answer but when I join that table up with other tables that have more rows than Table (1) the sum function will return the sum of all the rows in the query given
dynamic threshold for a report
Is it possible to add a "dynamic threshold" to a report? Or is there some other way to add this via the summary functions? Use case: I have a bar graph of sales $ by order date. I'd like to add a line that shows the average sales for the period shown. The "threshold" function creates the look that I want, but it seems to only accept a hard-coded value vs. a formula. I do not want to use a moving average, I want a horizontal line that runs the full length of the graph. It needs to update automatically,
Timestamp for Dashboard
I'd like to insert a timestamp onto a dashboard, and have the timestamp be for when the table(s) were last updated used in the reports. Any way this is possible?
PDF Export for Dashboard
How about having a PDF Export for Dashboard instead of HTML because sometimes not all of the images show
Get a list of Date in Zoho Analytics Database Query
Hi, is there an option for me to populate a date in the query? For example, 2009-01-01 2009-01-02 2009-01-03 2009-01-04 2009-01-05 2009-01-06 2009-01-07 2009-01-08 2009-01-09 2009-01-10 2009-01-11 2009-01-12 2009-01-13 is what I am looking for the column populate. I am looking forward to have this. I will also LEFT JOIN the other table 'Date' into this populated date.
Exporting a report to a specific format (following company brand guidelines)
Hi, I would like to start a discussion on the different ways to format a Zoho Analytics Reports in order to follow company brand guidelines. I would like to know if any of you had some suggestions on how I could make the format of my reports more seamless
Plain text to date data type
How would I be able to set a plain text field that contains month and year("June, 2021") as a date? I am currently trying to change it in a query table by clicking the change data type button but its not allowing me it says "it is not compatible". Is
Zoho Analytics Mass Add Field
Hi, is it possible to add the same field to several reports at once in Zoho Analytics? It will take a long time to do each one individually. Thanks.
Ask the Experts #19: Five hours live Q&A session with Zoho Analytics product experts
Hello all, We are excited to host the next online community event in 2021 - Ask the Experts #19 on 25 November 2021 between 05:00 AM - 10:00 AM PT. If you've had any questions about the Zoho Analytics features or prefer to learn more, join the discussion
Changing format from imported Zoho Projects tables
Hi, I am using Zoho Projects with Zoho Analytics. I use several tables from Projects were fields are formatted in .# (decimal) as Projects does not allow you to select other type. Is it possible to format this field differently in Analytics ? like .#
Not able to change the data type
Hi Team, I am trying to change the data type of Avg. Time on Page but I got an error message as below. Please advise me how I can change to the Time format for Avg. Time on Page.
Adding 2 columns with '+' treats numbers as strings (not fixed with cast)
Why does the '+' sign converts numbers into strings? How to fix it? Note: cast( as int) + cast( as int) does not work ("Parsing of Query failed, please check the syntax"). The following SQL should sum up two numbers, like: 0 + 10000 Expected result: 10000
Formula avg for specific month/ avg of total
I'm hoping to make a formula where the average of sales for specific months is divided by the average of overall sales. This is what I have so far: avg_if("TEST FORECAST SALES"."Month 2" = "TEST FORECAST SALES"."Month 2","TEST FORECAST SALES"."Total")/ignore_filters(avg("TEST
Break Glass Admin Suggestion
There are several issues we have ran into, involving not being able to use "Premium" features, which we have paid for, unless we are logged into the account as the owner. A minor example of this, is our ability to link zoho analytics organization to zoho
Formula to sum sales for last YTD
Hi there, I'm looking for help with an aggregate formula to sum sales for last YTD. I'm trying to create a report that will show the Months sales for 2019 and the TOTAL YTD for 2019 compared to Month sales in 2020 and the TOTAL YTD for 2020. Any help would be appreciated.
Create a dashboard with a formula in Analytic
Hi everyone, I need to know the average date of purchase per a product per a customer. Here is how I count it. For example: Customer A bought product B in Jan. I count it "1" Customer A bought product B in Feb. I count it "1" Customer A bought "0" in
Lookup two reports / Duplicating Data in table
I have two Labor reports I am trying to reconcile. One report is a payroll report with employee ID's, Date's worked, and Hours. The other report is a time ticket report to track labor activities, which also has employee ID's Hours worked, and the date.
Unable to Renew
Pay now option is missing after adding all the necessary details.
Next Page