Hiding row in pivot table
In a pivot report it is possible to show/hide coloumns, but if i want to hide a specific row I can not get it to work without doing it mannually. I have 6 data rows showed each month. By removing the same check each month, I can in the end remove the
Working with Monthly averages
Hi everyone! I am trying to work out an issue...our church has a week of Monday through Sunday. I am trying to do averages on our months (which is dicated by Sundays) For example, the first Sunday in February is 2/4, so I want Monday - Sunday to be a
Creating a Report using a multi-line text
How do I create a report to determine to distinct count from two columns: (i) a unique ID column and (ii) multi-text column (with a ; delimiter) For example User ID Colour Preferences 1001 Blue; Black 1002 Black; Red I want to create a chart that counts
How to make LAG function work?
The Add Formula column modal shows that Lag, Lead, etc. window functions are available. When I try to add the formula as lag( MAX("Date"), 1), it gives this error: Please use aggregate formula option to create aggregate formula. But the function description
Chart showing Age in Months for each month
Hello. I have a Client record with a field for Date of Most Recent Enquiry (RecentDate). I want to track the number of clients with RecentDate between 12-24 months each month. So I can see, for example, in May 24 we had 1000 Clients aged 12-24 months,
Frequent Zoho Analytics Sync Failures
Analytics sync is continuing to frequently fail - every 2 or 3 days we'll have a sync failure with unhelpful messages like this: When you try a manual sync on the failed table it typically says "sync already in process" even though it's clearly errored
warehouse level inventory valuation
Currently i have multiple warehouses in an organisation. When i select inventory valuation, i can view organisation level valuation. But i would like to filter it down to warehouse level inventory valuation. I was informed that i can create custom reports
Google Calendar Integration
Is it possible to Integrate the Google Calendar data with Zoho Analytics? If yes Kindly Provide the Solution.
[Upcoming Webinar] Fostering a data-first culture with enterprise analytics
Businesses today are fully aware of the importance of being data-driven, and there are countless companies catering to their needs. Technology and software vendors, specialized management firms, and more enable businesses to set up and maintain their
Zoho Analytics - Line chart Axis
How can I hide the button displayed near the axis in the snapshot below? I do not want the axis to be visible to everyone.
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
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
Next Page
