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
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.
Display an image in Zoho reports report
I have a table report in which i'd like to display an image made up of data from another column, something like: <img src="records.photo"> However, when i do that, nothing happens. How do i pull it off?
Import from a stored procedure
Is there a way to import a tables from a database that is a stored procedure? If so, please provide details or link to steps. I have tried to import from a stored procedure and have been unable to Thanks
Would like to change the String Datatype to Date Datatype extracted from absWeek(),Week()...etc
Hi Zoho, As I need the sum of sales per week which has to be automatted every year weekly,I have extracted the Created data on absWeek() ,As the data is changed to string. I would like to change String format absWeek() data to Date format,So that I can
In analytics there is a history of change of stage in releases
I need to know the date on which a release is changed stage, in the release table are the creation, last update and Released on dates. But I need to know when I change to On Going, I understand that it can be taken from the last update field but once
Aggregate Formula - Time
I have a CRM table which has phone call start and end time. I have created a Query table that also includes a Call Duration column (using Time_Diff). I am creating a summary report on Analytics and want to show the sum of the duration of inbound/outbound
not able to access zoho analytics
Since 3 days, we are not able to synchronize data (zoho books) and we are not able to access zoho analytics .
Tip of the Week - Customized User Filters for Views in Dashboard
Did you know that you can associate/disassociate user filters with the reports in your dashboard? Zoho Analytics allows you to include/exclude user filters for the views in the dashboard. Say, you have multiple reports in your dashboard and you do not
Query multiple keywords
I am trying to create a query off a table to generate data based on multiple conditions. Below is the query that works, based on one condition (WHERE "ActivityText" = 'Non Productive Time - General Admin') SELECT "EmployeeID", "FirstNameLastName", "FormattedDate",
[Webinar] Analytics does not age well: Why fast implementations deliver more benefits
Hi there, Based on more than 20 years’ experience with software selection in analytics and BI, BARC shows why it's so important to implement analytics and BI quickly. Recommendations for how to achieve successful projects and gain the most benefits from
New Features rolled out on Oct 18, 2021
Enhancement in Importing Zoho Analytics Workspace From now on, when you are importing data from another Zoho Analytics Workspace, the data types of the columns will be copied as is from the source table. For example, when you import currency data, it
widget setting to a cutoff date
I need to configure a widgets so that it compares information to the cut of a date, for example the sale of this month accumulated to today 10/12/2021 vs. the accumulated sale of the previous month accumulated as of 09/12/2021? In this image the comparison
How to split the list of strings seprated with ; in a column
Good Morning, I have a column with client id and a column with list of strings which i have to bring down each string in the list into column. ID list 1. WOMAN,MAN,KID 2. WOMAN,KID 3. MAN,KID I would like
Premium User - Unable to use Advanced Slideshow
I am a premium user, and am trying to use the "Advanced Slideshow" option in Zoho Analytics. Unfortunately I am getting a prompt saying I need to uprgrade my plan to premium... except my plan already is premium. How can you fix this? Thanks
Tip of the Week : Show the Conversion Rate
Do you want to know the overall conversion rate of your sales funnel? This can easily be done in Zoho Reports with a few clicks. The funnel chart in general, will show the progressive conversion rate of each stage, using the Show Convertion Rate option in Charts Settings. Zoho Reports enables you to calculate the overall conversion rate by comparing the first stage and the last stage in the funnel. The below gif shows how to add the conversion rate to your funnel chart.
SQL Pivot Table
Hi, So I am new to SQL and have been actively learning it whilst we have some time on our hands to improve our reporting. I need to take data and present it as per a pivoted table the standard pivot function presents the data like this; What I am trying
Chart/widget logged in user
Hello, Is it possible to make a generic dashboard where all the info/data on widgets and charts changes automatically based on the user that logs in ? In other words a filter that shows the data from the logged in user. We don't want logged in users to
Zoho Analytics Free Lessons for Beginners
Hello friends Let me share my first Zoho Analytics course for Beginners via a youtube playlist. 14 free lessons for the first touch with the Zoho Analytics BI tool. https://www.youtube.com/playlist?list=PLnusL2XA4g1HmSGVZB51TyuiGZL8EhnCr Announce: The
Databridge Error / Please Help
I get a pop up error message that says "Login Failed" (image attached) when attempting to execute a query in the databridge. However, this cannot be true because I can see all the tables available to me, via the login. I have attached an image. Please
Serarated userfilters in dashboard
Hello, I know it's possible to create a user filter on a Chart A or on a separate Pivot Table B But when I make a dashboard with Chart A and Pivot table B, those 2 user filters are on tap of the Dashboard and are applicable for both Chart A and Pivot
Next Page