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
Apply Filter to multiple tabs in a Dashboard
Like the subject says, I have a Dashboard with 6 tabs across the top first tab is an overview Subsequent tabs are different views of the same data, to show computers that are out of compliance ie. needs operating system upgrade, not enough RAM etc. All
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
URL data type - Link name & link address
Hi, I have a url data type filed called "link" in a table. I currently store the url address in this field. e.g. http://www.google.com I would like to show a link name instead, e.g. "Google" - Which points to http://www.google.com Is it possible to do
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
Solution of the Week : Consolidated Balance Sheet for Multiple Organizations with different base currencies
In the previous solution, we discussed in detail about creating a Multiple Organizations Setup with the same base currency. In this solution, we will be addressing the process of creating consolidated financial reports, such as a Balance sheet, for multiple
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
How do you append all CSV files in folder using data bridge - i.e. like excels get data from folder function?
Currently we use Excel for our dashboards with power query and power pivot. The power query dataset is set to grab all csv files in a particular folder and append them together. (as we have a folder that automatically has a new sales file added to it
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" ?
MongoDB Integration Data Sync
I am currently using the MongoDB integration for Zoho Analytics. The only issue I'm having is that fields that are arrays do not sync in Zoho. It would be great to have an option for each table to unwind arrays if needed so that data could sync as well.
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
Why do I need to check for null fields when excluding fields with certain content?
If I get all records and use WHERE "Lead Source" != 'Webinar' my report removes all records where Lead Source is Webinar or is null. It removes null fields. If I want to just get all records where Lead Source is not Webinar, I need to use this WHERE ("Lead
Merge Pivot Table Columns to count as one column
I am new to using Zoho Analytics and I am trying to run some simple pivot tables. Basically I need to know how I can merge columns together so I can count them as one. We use Deal stages to track a record progress. Some deal stages need to be rolled up
Combining two reports
I am a Microsoft Access Developer new to Zoho Analytics. I ran into an issue where filter two sets of dates cancel out one of the other. For example, I have client Start Date column and a client discharge date column. When I filter the start date and
Zoho Survey Table: "Respondents", Column: "Survey Modified Time"
Hello there, I wonder what the time is in the Respondents.Survey Modified Time column. This cannot be the data from the survey, as the two data are not the same: However, it cannot be the time at which the user last edited the survey, it generally cannot
Zoho Survey Table: "Surveys", Column: "Type"
Hello there, when creating a query in Zoho Analytics, I noticed the "Type" column in the "Surveys" table (table was automatically created by the sync between Analytics and Survey). It only ever says survey... I wonder what this information is even used
Chart background color
How can I change the background color of a chart? Probably a silly question but I have tried several things and can't seem to figure it out. Our app has a grey background color throughout and the charts have a plain white background and it sticks out.
Same Year filter for two date fields
I have a report that includes a FosterIntake Date and a FosterDischarge Date. I want users to view the number of youth that entered the program this year (2024) - Year of FosterIntake, and the number of youth that were discharged from the program this
Inverse Scoring Results
I have a set of 6 text choices and they were ranked by users from 1-6, 1 being the Highest and 6 the lowest. I am trying to calculate the inverse scores and display them in a chart for all the respondents in the survey to show which answer had the highest
Importing Google Sheet - date format problems
I have a Google Sheet with a "Date" column and its format is set to yyyy-MM-dd. When I create a table in Zoho Analytics and import this sheet, the preview screen shows the Date column format as "dd MMM yyyy HH:mm:ss" (e.g., 28 Sep 2023 00:00:00). When
Changing Ownership of Zoho Analytics
How do I change the owner of Zoho Analytics
[Webinar Announcement] Transforming raw data into actionable insights using data visualization
Are you looking to maximize the impact of your data insights through effective data visualization practices? Look no further than our upcoming webinar on the best practices for visualizing data with a modern BI platform. In this webinar, we'll cover how
Next Page