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?
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
Combine 4 SQL sub-query into Single query (ZOHO Analytics)
ZOHO Analytics is a database which supports SQL syntax of MySQL, SQL server, Oracle, PostgreSQL, etc... I'm using syntax of MySQL. I am able to construct the whole SQL, it consists of 4 levels of sub-query, but here's the problem. ZOHO Analytics only
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
Report of the Week - Comparative Analysis with Top N Items
Previously, we saw how to create a report for Top N Items in Each Category . Now let's see how to do comparative analysis along with top values with the following reports as examples. Comparing Current and Previous Month Customers' Invoices - This report
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
Next Page