Histogram: User Filter for Time Period of Bars
Hi there! I am creating reports for my company. These reports include bar charts and histograms displaying insights such as revenue over time, profit over time, etcetera. I am looking for a way for the user to select whether the chart must display --
Formula and blank fields bug?
I have a table with 3 columns. Sometimes 1 of the 3 columns can be blank. The third column is a formula column where I basically do "Sales - Costs" to get "Profit". But if the Sales or Costs column is blank on a ny row the Profit column stays blank. Where it should be: Sales | Costs | Profit ---------------------------- 100 | 50 | 50 100 | 0 | 100 Any solution to this behaviour?
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
Zoho Analytics Error
Hi Team, I have been facing this issue with my dashboard. Kindly provide me a solution for this.
Timeline Date Mapping
Hi, I see someone logged a similar query 3 years ago regarding the same topic: https://help.zoho.com/portal/en/community/topic/widget-that-is-not-dependant-upon-the-timeline-filter Has there been any progress regarding the development? When I set the
New visualisations
Hi Do you have any plans to launch Sankey charts or Chord charts as part of analytics visualizations? Joe
Dashboard filtering with selected pivot row
Hi All, i have a dashboard with a pivot table with 3 level. I have sum of all data columns also on the dashboard. However, i would like to make this column sums dynamic: By default thy should show the whole data column sum, but if i select a category
How to create text widget?
How to create a widget in text format? example, I have user notes and I wanted to show them on the dashboard
Date format
Hello, I'm importing a CSV, and all works fine except that i cannot get the datetime format right! My datetime field values look like the following: 2012-03-28T00:00:00Z and 2012-03-28T16:11:36Z Could anyone advise what date format template I might be able to use to import that as a date field? I've tried yyyy-MM-ddThh:mm:ssZ and similar, and the preview looks good but on selecting "ok" i get the error "Invalid date format string found.". Any help would be appreciated. Thanks.
"Weird" date format: how to handle it?
I get data from a JSON feed that has a date format that I can't make it work with Zoho Analytics. 2018-11-28T14:34:07-02:00 I tried the format: yyyy-MM-ddTHH:mm:ssZ and it won't accept because of that "T". If I do not put the "T" it gives an error. yyyy-MM-dd
How can I delete my last data import on Zoho Analytics?
I recently uploaded the same excel file twice and need to delete the duplicate data. Is there an easy way to delete my last import?
How to get the business days between today and target date
I have a table [Calendar], with columns Calendar Date and Business Day (1 represents a working day, 0 represents a holiday). Now, I have another table [aaa_file] with the column Target Date. How can I calculate the number of working days from today to
Duplicates
Is there a way to highlight duplicates in a report duplicates? e.g., using conditional formatting. We do not do manual import. We auto-import data from Zoho Desk Thanks Rudy
Widget with text value
Hi! I have a list of names and I want a widget that will show me the name I filter with. Like logo, since the dashboard is dynamic, I want that each time I change the filter, the widget will show the relevant name. Is that possible?
Question about Data Retention in Zoho Analytics after Importing
Hello everyone, I'm currently working with Zoho Analytics and encountered a query that I hope this community can help me with. When importing data into Zoho Analytics, there's an option for "Cleanup" which allows selection of the data's age. I have two
Zoho Much Slower Than Usual
Hi Zoho Team Over the last 3-4 weeks I have noticed a major slowdown with Zoho's speed using dashboards, and also when trying to import data and edit graphs. Is this a problem other accounts are experiencing, or am I having a unique problem? I have performed
Zoom in on Maps
Hi Appreciate that the Maps are still on beta testing We're based in the UK and we have added the latitude and longitude to a trial report. We get the data we would expect back but the Zoom feature does not allow us to zoom far enough in to make use of
Slideshow from Zoho Analytics no longer displaying on TV screens
Hello. I hope you can help. We use the Analytics module to general company dashboards that are displayed on smart Tv's throughout the company. We have found recently, that they are no longer displaying when the browser on the TV goes to the URL of the
New Features rolled out on April, 2024
Sunburst Chart We're thrilled to announce that Zoho Analytics now supports the Sunburst Chart. Explore the power of hierarchical data with our sleek and intuitive Sunburst Chart and uncover trends with precision. This dynamic chart visualization transforms
business_hours() with holiday list
Hello there, I would like to calculate the time between two dates, taking into account working hours, public holidays and weekends. There is the function business_hours() in Analytics, but there is no option to pass a list of holidays. Does anyone have
Chart showing the running total per Geography per month
I want to create a chart in Zoho Analytics that displays the running total of the growth of the leads per month in 2024, grouped by Geography. However, I only seem to be getting the number of leads per geography that were added per month, not the total
Removing null values
Hi I'm making a running total in pivot view usign zoho analytics with time as a field variable. The problem is, the time coloumn has multiple null values which I want to filter out. However, I can not filter Null values or unknown values from a coloumn
How to deal with accented characters
I am trying to import data into Zoho Analytics. Some of the words are in French using accented characters, such as Montréal, but when I import them, they import as Montr�al. Does anyone know what I need to do to import the data and support the accented
Execute Query working / View Mode shows different value
Hello, We have a snapshot setup and I'm trying to return the next to last snapshot id where the data column is set to 'good' The Table: Snapshot Id Data 3 Good 2 Bad 1 Good So 3 is the newest snapshot, and I'm trying to find 1 When I run the following
Running total calculated in user filter
Hi I have a problem in zoho analytics with the running total. I want to have a running total each month of the users data. However, I want to be able to only show parts of the running total and still get the correct values. When applying a time user filter
"Temporary Error" in Zoho CRM Data Source sync
I edited my setup for the Zoho CRM to Zoho Analytics Data Source Import configuration to add some new fields. After I saved the changes, I clicked the (Sync Now) link. After a few minutes I got a Sync failure error. The only reason given is "A temporary
Merging Tickets in Desk => Bad Data in Analytics
Curious to know if anybody has experienced this issue when dealing with Desk to Analytics integration: 1. You have two duplicate tickets in Desk so you decide to merge them (in Desk). 2. The ticket that was deleted during the merge is obviously no longer
Synchronization between Zoho Analytics and Zoho Desk not working anymore
Since last Friday, our synchronization between Zoho Analytics and Zoho Desk keeps on failing.. How can I solve this problem?
Connecting Zoho Creator with Zoho Analytics
Hi Team, I am unable to import the data and forms I created in Zoho Creator to Zoho Analytics. However, another organization admin can import the data and forms they created but also cannot import mine. When I try to import from the Zoho Creator datasource,
What does it mean the letter X in Zoho Analytics
I am translating a document about the use of dashboards in Zoho Analytics , and I found these sentences : Tap any where to select corresponding X entries Tap on X-axis label to select all entries for the X Swipe down to filter all data points for any
Creating a bar chart to compare positives for 2 different yes/no fields
Here's the goal: We have multiple fields that are simple Yes/No in our Deals. I want to produce a bar chart with the number of YES for 2 of those fields. As 2 bars. i.e. X=21 Y=7 Something simple like that I currently do them from a pivot table in Excel
Analytics Down?
Is anyone else having problems with accessing analytics.zoho.com website?
Email schedule on specific date
Hi How can I schedule an email report to be sent out at a specific date and time? I don't want to send using the intervals being offered (daily/weekly etc) but rather only once on a future date. Thanks
Derived table in zoho analytics
Hi Is it possible to make a derived table also known as a subquery in the from clause. Because I keep getting an error?
Day 10 of Sync failure between desk & analytics...
I'm going on day 10 of "temporary" sync failures between zoho desk & zoho analytics. I have deleted the integration (which deletes the table and makes all the reports and dashboards useless) and re-added it. Both times it works for the first sync then
Customer connect: How Market Dojo drives business growth with 360° insights
According to McKinsey, businesses integrating diverse data sources make decisions five times more faster than competitors. In our upcoming webinar, we're excited to converse with Market Dojo, a UK-based SaaS company built for procurement professionals,
Request for Assistance in Importing Full Data from Xero to Zoho Analytics
Hello Team, I hope this message finds you well. I am writing to seek assistance with an issue I am encountering while trying to import data from Xero into Zoho Analytics. Specifically, I need to import data spanning the last 5 to 10 years. However, Zoho
Date Last Modified
How does one set up a field to automatically record the time and date that its row was last modified?
How can I use DATEDIFF in ZohoAnalytics for query?
Hey, Which function do I need to use that Zoho SQL will understand? I have used DATEDIFF and I can see that Zoho can't understand it, then I tried this date_diff(), and also no changes. Best regards, Vladimir
Monthly Average in a Summary Report (exlcude weeks with zero count)
Hi, I am trying to figure out how to get a monthly average on my attendance of unique ids (pco_id) that have checked in. If you look at May, it says there are 2 weeks in May and our average is 30, but we did not meet one of the weeks, and the 30 is not
Next Page