Trying to Access all Zoho analytics data?
Hello, I am using post man at the moment to test the API connection to Zoho Anaylitics. When it comes to the URL and parameters, I think I am missing something or adding the wrong information in a step. This is currently what I am trying: GET: https://accounts.zoho.com/oauth/v2/auth?
Import Pandas data frame into an existing table in ZOHO analytics
I need to import pandas dataframe into zoho analytics table which is already existing in ZOHO analytics. How should I do that?
[Upcoming Webinar] Refined data and faster insights with data preparation
Data preparation forms the bedrock upon which insightful analyses and informed decision-making stand, directly impacting business revenue. However, preparing data is often perceived to be a complex and time-consuming task that often demands IT intervention.
We are coming to your city! Zoho Analytics Community Meetup
Hello, business leaders and data enthusiasts! We are delighted to announce that registrations are now open for the ZUG meetups, and we can't wait for you to be a part of them. Our in-house analytics experts are geared up to lead discussions on constructing
Average agent time reply - Zoho Desk
Hello, We are building a report where we would like to see the average time that an agent takes to reply to their customers. In Analytics we were using the measure "tiempo total de respuesta en horario laboral", but it does not show the correct values
Can we consolidate data from multiple Zoho Books organizations having different home currency in Zoho Analytics?
Hello, Can we connect Zoho Books account having multi organizations with Zoho Analytics to consolidate data from all organizations? Each Books organization has it's own home currency like INR, USD, GBP etc. How to consolidated Sales figure and show amount
Custom Formula - Zoho Analytics
Hi, I want to see profit% for each customer. However the aggregate formula on the tool is not the most accurate as it ignores purchase discounts all together and gives the % on Sale Price and not Purchase Price. I tried adding custom formula but could
Date from a date field to today
Here is my query, but it's not calculating correctly. I'm trying to determine how many weekdays have occurred between "23-24 Start Date" and today, but I'm getting a number that's much too high. SELECT "Q_DataWalls_Time-Off_23-24"."Name", DATEDIFF(WEEKDAY,
Data imported through URL data sources will show HTML codes instead of special characters.
We have a data source configured to import information from a URL. Some of the data contains apostrophes that will not be displayed as the actual characters but as HTML code. Example: let's go will be displayed as let's go Is there an option in the
Need Query to Output as Date
Hi, I'm new to Zoho/queries.....In my formula below, I need "23-24 Start Date" to output in a date format, but when i try to change the data type after I execute my query, it says it's not compatible. How do I fix that? SELECT "Staff Demographic Data
Analytics - String to Duration
Hey friends! Our calls module is logging the call duration automatically and it's coming into Zoho Analytics as a string. When I try to change the data type from the parent data set, I'm unable to as it's a system table. I'm trying to get around this
First reply time in hours - Zoho Desk
Hi, We are trying to build a report to see the time it takes to reply to our customers when they create a ticket. We are using the "First Reply time in hours", but checking with the tickets does not seem to show the right value for some tickets. How can
Trial: Project Status Overview Report Not Showing All Projects
We use Zoho Projects to track our teams IT projects. I'm currently evaluating Analytics to get better reporting capabilities of our projects. Unfortunately, when I run the "Project Status Overview" report, only 2 projects of the 8 projects currently open
Zoho report aggregate function issue
Hi, I wanted to write a formula connecting 2 tables. But currently im facing this error Alert Message Sorry, you cannot create a formula column involving columns from multiple tables. This is my formula. Can you help me with a workaround. Infact, i have
Is there a way to remove the border color of widgets on a dashboard?
I have a dashboard with a multicolor theme. There are four pivots with detailed information, and Zoho auto-assigns a fill color to each of the headers. I added a widget that has summary information for each of the four pivots and made the fill color match
Compare differences between data in different groups (year, year/month)
Hi, I need to compare data in a pivot table. I found articles related to the % of, however it seems that this only allows comparison with values within the same group. Let's say I have my data segmented by Year, then Year & Month. If I want to compare
Completion age Tier Range - Zoho desk
Hello, we have built a graph about the resolved tickets by time and we would like to modify the range in the lagend, lo make different buckets but we are unable to find how. Thanks!
Mapping Date Columns in Filters
Hi Team, I created a chart where I am tracking USD in proposals per month by their sent date, won date, and projected close date. Those dates are all fields in the proposal record. On the x axis I am using sent date. On the y axis I have a sum_if formula
Creating a staked bar chart in Zoho Analytics where the x axis is the date of two different fields
Hi, i would like to create a staked bar chart in Zoho Analytics where the x axis is the date of two different dependent date ranges. The first date range is the date when a stage one payment is received in the CRM. The second date range is the date when
I need help with a column
I need to help me to make a formula for a column, it is to determine that when the data is greater within a specific column, is a type of retention, if it is less, is another type of retention, and if it is much less, is another type of retention, I get
How to put a dashboard offline?
Hi, I have a dashboard which is shared to several people within the organisation. I need to make some significant changes to the dashboard. What is the easiest way to make the dashboard offline during development of new features and put them live again
How to compare data from last 7 days to previous period?
I would like to create Widget that shows data - counts the number of specific contacts that changed their Stage to a Win Stage in the last 7 days. After that, and at the same widget, I would like to see same data from the previous period. Can I do that?
Pivot chart - Formula (customisable) rows
Currently, the Pivot chart has a "grand total" bottom row that adds the values in the chart. However, I need this row to perform a different calculation. Specifically, I'm building a multi-dimensional income statement which need to subtract expenses from
Editing data sources as workspace admin?
Hi there, is there any way to allow workspace admins to edit data sources? I am a primary user of the account (across two workspaces), but not the account admin, so whenever I need to change import settings for data sources, I need to contact the account admin first and wait until they make the changes I asked for. This is very frustrating and time consuming. Please advise! Thanks, Gericke
Exporting Analytics Dashboards as PDF Reports
I am trying export PDF reports from analytics reports/dashboards that are aesthetically pleasing enough to send to clients. The native export has been a clunky process for me and the formatting has been inconsistent. Is there a 3rd party app that I can
What kind of SQL uses Analytics?
Hello, I find confusing how the SQL queries work in Zoho Analytics. Coming from other platforms, these queries have sometimes different results with the same query. Does Zoho Analytics use personalize SQL? Also, some queries fail without any kind of information,
Add column with logic function
Hello, Please, i need help for the following function in Analytics I have a column TIME with difrent numbers from 0 to 23. I have other 2 colums DAY and NIGHT with random numbers I nead an other column with following conditions. If the value in the TIME
Change database settings
Hello, I recently created a new database and created some queries. However when I'm trying to change one of the queries, I get the following error message: Performed changes in the query is not allowed due to following reason(s): Column 'totaltransactions'
How to retain Currency formatting in the concatenated the column
Hi Support Team, I would like to keep the Thousand Separator for the " Refund Amt" column. This " Refund Amt" column has been concatenated with the "Bill no" Column. The Table is generated via SQL Query. SELECT DISTINCT (VC."Vendor Credit Number") as
Starting y axis at 0 on line graph
Hi, Is it possible to change the default start point of a y axis on a line graph to 0 and not the minimum detected value? I can see that you can manually define the start and end of the range but this means that if I manually define the start as 0 then I also have to continually update the upper range limit when the data is refreshed. Cheers, James
Formula Column 'aaa' cannot be removed.
how do i remove a Formula Column? this product is frustrating... Table report
Spark Line in Zoho Analytics
Dear Team, I just noticed the Spark Line option within Zoho Analytics. However at Face Value I can not see what criteria are being used to group the data. Apart from the graphical representation I also did not find anything on this in the settings page.
Conditional display and formatting of dashboard elements
It would be great if we could set conditions for whether or not to display dashboard elements and KPIs. For instance, in the settings for a given element, there could be an item that says "if the value/count/average/max/etc. of this columnNameData is
Analytics Table Data
I would like to include a field in my analytics tables to include the name associated with the ID. For instance, in the potentials/deals table to include the contact name associated with the contact ID. Can someone advise how to accomplish this?
Zoho Books to Zoho Analytics sync fails consistently every other time
Different values between Google Ads and data in Zoho Analytics
Hi. We've actived the Google Ads integration to Zoho Analytics. However, we see that there are different values in Zoho Analytics if we compare the same data to Google Ads. How is this possible? Is it possible that values are rounded off after they are
Zoho Analytics sync period on "standard" plan
The pricing page of Analytics claims that the data sync interval is hourly without pinpointing specific applications. The shortest interval on the Data Setup page for data sync settings is "3 hours". Is the info on the pricing page incorrect or are there some other settings for the data sync setup which will allow us to set it to "1 hour" ?
What's New in Zoho Analytics - March 2024
Hello Users, We are back with the latest update and enhancements in Zoho Analytics to improve your experience. Read on to learn more about what's new in Zoho Analytics. New Database Connectivity We've added two new database connectivity options: HFSQL
Change language dynamically
Hi, Is it possible to change the language in Zoho analytics without changing the user? Maybe there is a parameter in the url to be able to do it? thank you
How to work on separate files created on different dates
I have different set of tables updated on different dates Table 1 - Location 1, Work Done %, Date A - Location 2, Work Done %, Date A - Location 3, Work Done %, Date A - Location 4, Work Done %, Date A Table 2 - Location 1, Work Done %, Date B - Location
Next Page