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
Importing newly added tables
DataBridge was installed on the cloud postgres server and is syncing well on schedule. however, we added more tables on the source DB and I cannot find a way to include these to the sync. The databridge is missing from seting-> Manage databridges Data
Zoho Analytics data upload through databridge
Hi, i'm new to Zoho Analytics and evaluating the free-trial. I want to visualise data from my local Postgres database. I installed the databridge and uploaded 10 tables that i wanted to visualise. The entire data sync took a lot of time and additionally,
Spread a Number (Hours) Evenly Across multiple days (Start and End Date)
We have hundreds of active jobs at any given time, all with different budgeted hours, across dozens of processes, and all with varying process start and end dates. Below is a table with just a few lines containing our active jobs by job number. What I
Schedule Refresh Times
When setting up a new data source in Zoho Analytics we can set a "refresh frequency" but we can not schedule the time in which we run it to run. I would like to be able to schedule the specific time(s) for my data sets to refresh. For example, I have one large data set in particular that I would like to refresh at 2:00am on a daily basis when I know that there is typically no one reviewing dashboards.
Third party embedded links or javascript
Hi working with Zoho Analytics dashboards, I have linked zoho and third party data sources, however is it possible within the text fields to add javascript or embedded links from third parties when in view mode eg dashboard is live, but a live weather
Next Page