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 .
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
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
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
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
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
Next Page