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
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?
[Webinar] Growing an Agile Project Portfolio with Advanced Analytics
Hi there, Agile project management has paved the way for businesses to adapt to changing requirements. As organizations scale, rising interdependencies and complexities in projects can slow down growth. With advanced analytics, businesses can improve
OAuth 2.0 API Requests
Hi team I'm having an issue while trying to pull data from Survey Monkey Apply, through their OAuth2.0 API I have generated the OAuth2 credentials through Survey Monkey Apply which creates: Client ID: xxx Client Secret: xxx Refresh Token: xxx Access
New Features rolled out on Oct 18, 2021
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 could be be identified as Number or Positive Number
Zoho CRM connection is down with Zoho Analytics
I didn't see any announcement of this issue so thought I'd share that the Zoho Analytics to Zoho CRM data source is down. This can lead to queries, reports, etc. being deleted.
[Webinar] Intro to Advanced Analytics for Zoho Books
Hi there, In this session, participants will receive a walkthrough of the best practices for using Zoho Analytics as an advanced analytics platform for Zoho Books. Join Brett and Tyler from Zenatta Consulting, and the Zoho Team for a top-level guide to
Ask the Experts #18: 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 #18 on 07 October 2021 between 05:30 AM - 10:30 AM PDT. If you've had any questions about the Zoho Analytics features or prefer to learn more, join the discussion
Zoho Analytics on-premise connect to DataPrep
Hi, I installed the On Premise version of Zoho Analytics, when i try to connect Analytics with the Data Prep gave me the error in the attached file, checking in the web console and in the server logs i saw that's a 500 internal server error, obviously
How to get the <OwnerEmail> using the API endpoints?
Hello! I'm trying to write some API integrations, but the endpoint I need to use requires the passing of the owner email, and I was wondering if it was possible to read this value by using a different endpoint, because the way our interface is designed,
from_unixtime() error
Merge or Remove Duplicate Y-Axis Labels on Chart
If I create a chart with several different things being tracked on the Y-Axis, Zoho Analytics will put Y-Axis labels for every individual thing I'm tracking on the Chart, even if I set them up to use the exact same Name and Range. This makes the chart
Aggregate formula based on grand total
Hi Is it possible to create an aggregate formula that uses the grand total from a column. I know that you can get this number in a pivot table (% of total) but that number cannot be used as basis for an aggregate formula. Se screenshot. I've got an grand total i Col1 (60000). Based on that I calculate a Weight. I use this Weight to calculate the Col3 values. I know that I can achieve something like this using a Query Table, but it would still not function properly if I wanted to introduce user filters
Reports on yesterday's numbers
Hi! I'm building a dashboard for a client, previous day's data is loaded once a day, during the night. Now, this means they never have today's data. I need to do a comparisons between cumulated previous month and current month but when I do that it takes
Need help getting my data out of Analytics into Mailchimp
OK so I have spent many many hours trying to crack this and just can't seem to resolve it - anyone able to offer me a solution? Will reward you with loving thoughts and, if you're close enough, beer. I make various sales on my website using a third party
Zoho Show - Amazon App
There is a problem with the Zoho App in the Amazon store I am using a firestick for display. My slideshow only is filled with embedded graphs. For some reason, after signing; when I display the slideshow the embedded graphs do not load, and instead I
i need help
I need to calculate the time zone converter from UTC to LOS Angelas time when the time zones change i know i need to use the following but I have no idea how to implement it into my query can you help. IF( CONVERT_TZ("timestamp_column", '+00:00', '-06:00')
Associated Blueprint Names of Zoho Projects Tasks
Hi, We developed some Zoho Projects reports in Analytics. We want to add the Associated Blueprint names of the tasks as a report column. We couldn't find this information in Tasks table. How can we read this information? Thanks.
Cannot receive email from Zoho Analytics
I'm new to zoho so I would appreciate your help. I'm will use zoho analytics to create report and dashboards. I was trying to add new user as viewer but the problem is that I cannot add any new user if his/her email in ending with Gmail or private
Sync failure with Zoho Desk
I've noticed today that my Zoho Desk integration with Zoho Analytics is in failure, and when it fails when I try to manually sync. I've tried also to Edit the Setup with my admin account, but the following error message appears. My admin account is an
Method to merge Workspaces?
Is there a method to merge two workspaces? Or perhaps to copy a workspace into another workspace? I have two workspaces with somewhat similar data, and now I would like to build querys/reports using the query tables and data sources from both workspaces
Report to see the sales cycle as a timeline
Hello, I am quite new to Zoho, we have a subscription, and I am curious if it is possible in Analytics to create a report in which I can see the time for each department or user between the moment the lead was created and the moment the lead was converted
Present Deal Stage Duration report as table, but retain the actual stage order, not alphabetic.
Is there a way to change the default "Stage Duration" report to present as a table, but use the correct underlying Stage order?
Client birthday report
I list my client's birthdays in the database and want to send them a birthday card on the appropriate date. In creating a report and haven't been able to find a way to filter the birthdates down to month only and over a span of years to that I get all clients whose birthday is in January, for example. Any solution? Thank you. Randy
Custom Date Range in Dashboard Widgets
When creating a widget, I can "group by" week, month, year, etc., but I can't figure out how to group by "the last X days". This can be done with a chart and pivot table. I can even set the timeline filter with a customer date range. Here is my use case
Linking to a tab
Greetings, I hope find all good and safe! I have a dashboard with a few tabs. I would like to make a tab called 'Home' and set links to other tabs. How can I do this?
How to add queries as Child Nodes in Model Diagram?
I have a lot of Queries related among them, but when I try to see the Model Diagram or the Dependency Details of a Query, none of its Child Queries is displayed. As an example the images below show the Dependency Details and Model Diagram of a Query I
Data Comparison in Widget
Hi Team, I would like to display data with the comparison of the previous date range according to a user-selected. Examples: Week - 36 (user selected) vs Week - 35 (auto detected) 6th September - 12th September (user selected) vs 30th
Using user filter with tabular view
hi, I would like to know if it is possible to add a filter specifically for the table view , I mean not in the users filter field but next to the search bar? thanks .
How to use absweek and absmonth to get previous week/month
I've got some case statements in my analytics query that I want to return something different based on a date being last week or last month. I can do this week or this month using absweek() and absmonth(). if i do these -1 though it just removes a day
Custom Predefined Date Range Filter?
I need to hardcode pre-defined date ranges in a dashboard. I want my user to be able to select "Year 1" or "Year 2". However, Year 1 is not a January - December calendar year, it begins on March 16. I must be missing something, because I do not see
Wrong ticket owner name imported form Desk to Analytics
I've just noticed that if a ticket used to have an agent as its owner, but now it's unassigned, as shown in that image below of a ticket with this description. But when the data is imported to Zoho Analytics, the ticket owner remains the last one before
how many maximum we can create data source in zoho analytics
How many data we can add "data source" (google sheet) in zoho analytics, example : i want create every outlet and division have own spreadsheet , so every spreadsheet must have 1 data source setting in zoho analytics
[Webinar] How a Modern BI & Analytics platform is the key to insights-driven business
Hi there, To become market leaders, organizations need to make sense of their data. An insights-driven business model helps companies make better decisions underpinned by data. In this webinar Senior Evangelist Chandrashekar LSP and a guest speaker, Forrester
Formula of Aggregated values from Different Tables
Hi, Lets say i have these 2 tables, Revenue and Expenses. I have created an aggregated formula to sum the Total Revenue which is attached to table Revenue, and Total Expenses which is attached to table Expenses Now i want to create a KPI Widget on my
Is there a way to access the ticket page from Zoho Analytics?
My Zoho Desk and Zoho Analytics are integrated, so I can analyse all my tickets data with the Zoho Analytics, but one feature I miss is a way to link the ticket data, as its ID or Subject, for example, with the ticket page inside Zoho Desk. This would
Next Page