API EXPORT JSON Formatting
I have successfully setup a API call to export data from an Analytics report table. I am using JSON format for the export. But the JSON formatting is not as expected. I would like to see the column names included as true JSON key / value pairing format, and not have the column names shown above as in the column_order field. Current output { "response": { "uri":"\/api\/dfgdsfjdfsdfjgdf", "action":"EXPORT", "result": { "column_order":["Market_Day","Stalls"], "rows":[New Features rolled out on May 8, 2019
Dashboard Layouting made easy Dashboard layout has been enhanced with the following flexible layout options: Drag and drop multiple components together to reorganize the dashboard Resize multiple components together Copy-paste desired component's dimension to other components Apply proportionate width to selected components in a row Click to resize component and fill available space in the layout Allow Export for Reports in Dashboard A new option to enable or disable export options for the embeddedPercentages in table with Top N are limited
We've created a Top 10 table using the Top N filter feature, but since our top 10 shows the percentage that each of the records represent, we found out that Zoho actually ignores everything else, which means a record that would normally represent 30% of the total values, is shown as representing 45%, as it only considers the 10 filtered records. Is there a way to fix that?Having an issue with a Nested "IF" Condition statement
I am uzing Zoho Analytics: This statement does works: If(condition"Rep ID"='Rep 1', "Gross Margin"*.5,If(condition"Rep ID"='Rep 2', "Gross Margin"*.50,If(condition"Rep ID"='Rep 3', "Gross Margin"*.05,if(condition"REP ID"='Rep 4',"Gross Margin"*.05,if(condition"REP ID"='Rep 5',"Gross Margin"*.2,"Gross Margin"*.4))))) This statement doesn’t work: If(condition"Rep ID"='Rep 1', "Gross Margin"*.5,If(condition"Rep ID"='Rep 2', "Gross Margin"*.50,If(condition"Rep ID"='Rep 3', "Gross Margin"*.05,if(condition"REPAdd columns in user table - ZOHO Analytics
Hello! Is possible to add information extra of ZOHO CRM in my users table of ZOHO Analytics (when I make sync)? How I can do it? Thanks guys.Converting a Date from imported data which is in Plain Text to a date field to use with "include Timeline Filter" in dashboard
HI All I have data that in being imported from an external application and all the dates are being imported as strings. I need a way to change or create a new colum based on the date passed in so that it can be used in a dashboard using the control "include Timeline Filter" I have tried to change the data type to date but it errors on import and removes all the dates This is the date from the import The error i get on import is ThanksIs there a way to pass a parameter in the URL generated for the viewers?
Considering we generate the URL for a particular dashboard, is there a way to get a parameter through the URL and use it to filter what the viewer sees?Create Aggregate Formula to Determine True Win Rate %
Good Morning, We are using Zoho connected to Salesforce. I am trying to create an aggregate formula similar to the "Win Rate %" formula that comes with the package and is used on salesperson performance reports. The current formula only addresses closed lost vs closed won. I need a formula that considers every lead a salesperson visits, using all of the stages in an opportunity. Excuse my ignorance, I do not write code... The formula I need would use the stage field in Salesforce Opportunity Objectmultiple customers on Business Intelligence Analytics (on premise)
Hello, We have a Business Intelligence Server on Amazon (EC2) hosting database of more than 100 customer. Each customer has a separate database because it has millions of records and in addition to being large databases would like to allow each customer to have access privilege to customize their own dashboards. In this context, I would like to use Zoho Analytics on premise installed on that single server on Amazon (EC2) and create a workspace for each customer. I will configure the profile of eachFacebook ads Integration bug when using account in MXN currency
Hello Guys I've been trying to retrieve data from Facebook ads and campaigns, however, when I open the Accounts table created by zoho, I see the columns "Amount spent" and "Balance" quantities are wrong. They display $37,947.00 and $15,407.00 this is wrong, since when I see this in facebook, Amount spent is $379.47 and $154.07 its like is not reading the decimals or some weird conversion is happening. Hope you can help me with this. Thanks!Create Dashbord with Tabs
Are we able to create Dashboard with Tabs? either on the horizontal top part or the vertical on the left side? Any examples? thanks.We require an aggregated formula which uses the Desk ticket modification time based on a text field
We want to create a monthly average time report calculated by the difference of the ticket creation time and the modification time from Desk which is based on a specific text type field called "quotation no". Is it possible to create an aggregated formula which can use the ticket modification time based on the content of a text field?Geo Maps
I think it would be a great addition on the back end of Geo Maps if you can add "Display Specific Continent" right under the "Display Specific Country Map" This way we can have 3 levels of seeing data 1. World 2. Continent 3. CountryNew Features rolled out on April 26, 2019
Geo Maps Visualization Enhancements Zoho Analytics Geo Map Visualization has been enhanced with the following features. New Map Themes Map themes has been enhanced with Satellite map theme and a custom theme. With Satellite map theme you can now plot a geo map chart over Satellite map. The custom theme allows you to design a theme with your own colors and apply the same on a map chart. The map themes now support an option to invert the land and water color using the Invert Color toggle button.Why is my filter not working in my CRM report?
Hello! I have created a lead report and want to filter out leads from shows. We have designated these in a field titled 'Lead Quality' then denoted as '5 - Show List'. I have this filter set as 'Lead Quality isn't 5 - Show List' but they are still showing on my report. Any idea why? I also have a filter of 'Lead Status isn't Disqualified' and the pattern set as OR. I have also tried AND, but that doesn't work either. Thanks for the help.Selected Desk Ticket Field is not being synchronized
I've created a few reports to see the weekly ticket status on all departments in our Desk data. One of the departments was missing a field called "Serial Numbers" and I have added it into the synchronization setup just now but after forcing the synchronization I can't find it on the "Show/Hide Column" of the report settings. Please check this problem. Our workspace is already shared with your Analytics support team. Be aware that there is already a field named as "Serial Number" in singular formLine chart with a start time and end time
Hi There, I am trying to create a line chart similar to the attached photo that has the count of staff on per hour of the day. Our dataset is of a shift start date/time and end date/time. Is this possibleCross CRM Deal information and Zoho Desk Ticket information
Hi, I would like to cross CRM Deal information and Zoho Desk Ticket information to identify tickets on our import account with high amount deals. Can we do that in CRM reports, Desk reports or Zoho Analytics? Thanks, LeonardNew Features rolled out on April 3, 2019
View Report in Zo ho Sheet Now you can view the Zoho Analytics view in Zoho Sheet. The data in each of the view will be displayed in Zoho Sheet retaining the same structure. In case of Chart, only the underlying data will be displayed and it will not be displayed as a chart visualization. The following view types can be viewed in Zoho Sheet. Table Chart Pivot Table Summary View Tabular View Query Table For more details refer here. Organize Views in Navigation Panel Now you can choose toIf statement with Date
Hi, in Zoho Reports I added a formula column with this If statement: If("Fecha">='19/10/2018', 100, 10) The field Fecha is a date field. What I want to do is that all records that have a date that is equal or greater than 19/10/2018 should have in that column a value of 100, the ones that are less than that date should have a value of 10. My problem is that all records appear with a 100 value in them, instead of the corresponding ones. My DB have records since 16/10/2017 up to date.KPI widget - set filter, but have Maximum Range ignore it?
I'm trying to create a KPI widget using bullet or dial chart. The data table that I have has a column with date and time, and I would like the Value on the chart to be count of entries with date/time being within a certain range (which I can easily set with a filter), however, for Maximum Range, I'd like to use the total number of entries in the table (but the filter is preventing me from getting that metric). Is there a way around that?Tip of the Week - Read by Color intensity
Zoho Analytics allows you to categorize the data by color intensity. This will be pretty useful for visualizing data based on factors like volume of occurence or create a performance scale (bad to good) etc. To read the data by color intensity, you need to add an aggregate numerical column to the Color shelf, and set the legend to continuous band as shown in the below animation. This option is available in Bar, Bubble, Packed Bubble and Heat Map charts. However, it is best visualized in Heat MapPulling data from two Zoho Books modules
Hi, I am trying to figure out how to pull data from the Invoices and Expenses modules from Zoho Books to make a Income vs Expense table. I have tried multiple versions of joining tables, but there is no column in the two modules that is named the same. I think the logic here would be to join the tables on the date, but the date columns are named differently. Any ideas on how to do this?Will Zoho Subscription be integrated into Zoho Analytics soon?
Will it be possible to import Zoho Subscription Data into Zoho Analytics?Average line on Bar graph/view
Hi, I have a view that is a bar graph which represents a count by month. I was wondering if I can also show an average line (like a target line) across the graph. It would have to recalculate based upon the user filters selected. Thanks SteveDefault value for Timeline Filter
Hi, Does anyone know if I can set a default value for a Timeline Filter? Thanks SteveMoving a Summarize Column to the middle of a Summary View Report
How can I move a Summarize Column in a Summary View to the second column in the report?When was the 100K records per employee cap implemented for Zoho One subscriptions.
When I signed up for Zoho One, the limit for Analytics was 5.2 million records with NO "per employee" restriction. Today, I see there is a 100k record per employee limit. I'm a Zoho One single-seat license holder (a Solopreneur) and feel like the ground keeps shifting beneath my feat. When using Zoho Forms, records are stored in Analytics. My license allows for either 20,000 or 200,000 form submissions per month. Unsure because the number has a typo in your plan details page (see attached.) AssumingTicket Backlog Trends graph is being refreshed when backlog tickets get closed
We have created a ticket backlogs (Data is being transferred from Desk) trend graph which is based on Ticket Creation date and the actual values of the Unresolved Tickets count. This graph does refresh itself when we close those backlog tickets later on. For example its January column displays 5 total tickets at the moment but when we close one of those tickets then it does refresh itself down to 4. We want the monthly columns to always display the count of tickets which weren't closed at the endDeleted emails from trash
Few emails has been accidentally removed from one of our client sales@freezee.us Missing emails from 15-01-2019 to 01-04-2019 please retrieve the emails soon .Emails has been deleted 01-04-2019. .New Features rolled out on Mar 20, 2019
Security Control Options Zoho Analytics provides a set of security options that enable you to control and manage access to your account. This includes setting up IP restriction as well as controlling the various sharing & collaboration options being made available. Allows you to restrict accessing views in your organization account only from the allowed IP ranges. Allows you to restrict sharing of data/views in Zoho Analytics only to users from the trusted domains. Allows you to restrict the generationInvited user for a standard plan can't access our workspace
This user has accidentally created a free account on Analytics instead of joining our workspace and unfortunately they can't access the workspace at the moment. How can we delete their free account from the system or at least let them join to our workspace?Moving Count of previous 12 months
I am trying to create a graph that counts the number of entries in 2 tables per month as a moving count of the previous 12 months. Based on this count, I am calculating the average by dividing the count of one table by the other (by adding a formula). The data I have is for 10 years, but I would like to see only the last 12 months in my graph. I am attaching 2 graphs. One is with Null values selected. This shows the correct data for the previous 12 months, but has 13-24 months also shown as a nullZOHO Forms to input data into the Tables
I would like to know if it is possible to integrate ZOHO Forms with ZOHO Analytics. This way I an create a form for end users to enter data into the tables. This would need to have drop downs and selections to make it easy and prevent data errors during data entry. Best regards, SonyNew Features rolled out on Mar 27, 2019
New Chart Type - Bubble Pie A new chart type called Bubble Pie Chart is now added. This is a combination of pie and bubble charts. The data column dropped in the Size determines the size of the bubble. Other aggregation will be plotted as a proportional division of the bubble. This will be useful in displaying multiple pie charts to compare the proportion of data across a series. For more details refer here . Combination Chart - More Chart Types Supported Now Combination Chart supports moreError to share Workspace in Zoho Analytics
We are getting this error: "Alert Message" "One or more specified users do not exist in the Zoho One organization. add users and try again" But the user exists in Zoho One. Any help would really appreciated, it's really urgent. Thanks,Heatmap in Zoho Reports Dashboard
Hi, Is it possible to create a heatmap chart, such as the attached, for viewing in Reports Dashboard, or is it possible to import one from excel, or integrate a plugin from google maybe? I've attached an image of the type of heatmap I would like to use. Thanks, LeonCannot add another dashboard
I have a db which currently has 2 dashboards. I am attempting to add a third, however when I drag a report to the "right hand side" it doesn't drop into place. I seem to be able to add widgets and text but no reports. Possibly related is that when I try to add another report to one of the existing dashboards the same thing happens. Thanks.Aggregation based on user filters
I have seen this in other analytics packages, but when a user enters a different time period in a filter, the ability to change the time period that the data is aggregated by is also provided (for example, you can change from monthly to a quarterly data aggregation when you extend the period from 6mths to 24mths)dashboard update automatically after 5 minutes
Hi, Hello, I set up a dashboard to let on a LED TV 40 "presenting graphs (full screen chrome navigate, key F11), how to do that it is updating the dashboard from time to time (5 in 5 minutes)? Rgs, Fabio.Next Page
Access your files securely from anywhere
New to Zoho LandingPage?
Zoho LandingPage Resources
New to Zoho Survey?
New to Zoho Marketing Plus?
Everything you need to run your marketing
New to Zoho Marketing Plus?
Everything you need to run your marketing
New to Zoho CRM Plus?
Deliver unforgettable customer experiences
New to Zoho CRM Plus?
Deliver unforgettable customer experiences
New to Bigin?
Announcements
[Product Update] Locations module migration in Zoho Books integration with Zoho Analytics
Dear Customers, As Zoho Books are starting to support an advance version of the Branches/Warehouses module called the Locations module, users who choose to migrate to the Locations module in Zoho Books will also be migrated in Zoho Analytics-Zoho BooksImportant Update: Mandatory Email Domain Verification for Zoho Analytics Users
To enhance the security and reliability of email notifications, we are implementing an important update. Starting February 1, 2025, verifying your email domain will be mandatory to continue sending email notifications via Zoho Analytics. Failure to verifyWhat's New in Zoho Analytics - December 2024
Hello Users! We’re excited to bring you a roundup of the latest features and improvements in Zoho Analytics. These updates are designed to elevate your data analytics experience, making it more powerful, interactive, and seamless. Let’s dive in! Expanded[Product update] Instagram Profile Integration with Zoho Analytics
Dear Customers, We want to inform you about an update affecting the Instagram Profile integration with Zoho Analytics. Meta will deprecate certain metrics from January 8, 2025 as per their announcement in this document. To ensure uninterrupted syncs inZoho Analytics in 2024: A look back
Happy new year to everyone in the Zoho Analytics community! As we welcome 2025, here's a look back of important happenings in 2024.
Most Discussed Topics
User Filter for Dynamic Date Dimensions in Zoho Analytics
One challenge I frequently encounter is the need to create multiple versions of the same report—one for yearly data, another for quarterly data, another for monthly, and so on. While this works, it leads to unnecessary duplication, making maintenanceCase and Left Join Problem
I am attempting to find the cost per lead, however they are on different tables. I am using the Case and Left Join Functions to do so. The following Queries are working correctly. These are below: SELECT "Campaign", COUNT("Id") AS 'total_leads' FROM "Deals"Sending two different reports through one e-mail schedule
Hi. I have two different reports which I want to send to someone. However, I don't want two separate emails, but only one. Is this possible?Create Dashboard with information pulled from multiple modules?
I am looking to create an overview dashboard for each account we have within the CRM. This will need to include information from Books, Bookings, Analytics (want to see the graphs). I am new to using Zoho but am trying to help streamline our processesAnalytics report issue
Hey, does anyone know why suddenly our Analytics report goes blank whenever we add a field from the contacts module? It shows when adding fields from all other modules. Thanks.
Zoho Developer Community
Zoho DataPrep Resources
Zoho Subscriptions Resources
Zoho CRM コンテンツ
-
オンラインヘルプ
-
Webセミナー
-
機能活用動画
-
よくある質問
-
Ebook
-
-
Zoho Campaigns
- Zoho サービスのWebセミナー
その他のサービス コンテンツ
ご検討中の方
Zoho Sprints Resources
New to Zoho TeamInbox?
Zoho TeamInbox Resources
Zoho Books Resources
Zoho Projects Resources
Qntrl Resources
Zoho CRM Plus Resources
Migrate to Show’s New Community
A place to share, discuss and stay updated about everything relating to Zoho Show presentations.
Get Started. Write Away!
Writer is a powerful online word processor, designed for collaborative work.
Design. Discuss. Deliver.
Zoho Show Resources
Zoho Creator Resources
Nederlandse Hulpbronnen
Zoho Inventory Resources
Zoho CRM Resources
Sticky Posts
Zoho Analytics in 2024: A look back
Happy new year to everyone in the Zoho Analytics community! As we welcome 2025, here's a look back of important happenings in 2024.Announcing Zoho Analytics 6.0 Beta!
We are delighted to open up the next major version, Zoho Analytics 6.0 Beta! The new version comes packed with a wide range of functionalities for all persona, namely business users, data analysts, data engineers, and data scientists. Zoho Analytics teamWhat's New in Zoho Analytics - August 2024
Hello Users! We are back with the latest updates and enhancements made to Zoho Analytics. Keep reading to learn more about them. Connect to the data hosted in the cloud without allow-listing the IP addresses Utilize Zoho Databridge to connect to the dataWe 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 constructingZoho Analytics: 2021 Look Back
As we start a new year in 2022, here's some of our top moments from 2021. Zoho Analytics in 2021
Top Contributors
Naresh Kumar K K R
Anitha Rajesh Kumar
Ganesh Radhakrishnan
Charanya R
Daren