zoho Analytics
How do I hide the sidebar for a particular page?
From the selected page, click Page Options. Click Hide sidebar on this page.
What is the difference between Zoho Analytics and Zoho Creator?
The key difference between Zoho Analytics and Zoho Creator is in-depth reporting and analytics vs online custom database application creation. Zoho Analytics enables you to easily create powerful and sophisticated reports with your data by creating ...
Is there an integration between Zoho Analytics and Zoho Creator?
Yes, indeed. Zoho Analytics makes it easy to create reports on the data your application generates in Zoho Creator. Refer to this link to know more about Zoho Analytics integration with Zoho Creator. Zoho Analytics will continue to be offered as a ...
Any other integration plans of Zoho Analytics into other Zoho Services?
We are planning to provide integrations with all our Zoho business services.
What are the Zoho Services Zoho Analytics is integrated with?
Currently, Zoho Analytics is integrated with Zoho CRM, Zoho Recruit, Zoho Projects, Zoho BugTracker, Zoho Survey, Zoho Desk, Zoho Campaigns, Zoho Finance and Zoho Creator. We also offer integration with Manageengine ServiceDesk Plus and Manageengine ...
How to Merge User Filters in Dashboard?
Zoho Analytics allows you to merge user filters. Refer the below animation to know how.
How to create a Full Dial KPI?
Refer the following presentation to know how to create a full dial KPI.
Can I create reports in a table similar to the reports in another table?
Yes, you can if the columns in these tables are identical. i.e., Table 1 and Table 2 share same column design and structure. And a set of Reports were created over Table1. Now you can duplicate these reports over Table 2. The following steps to ...
My date columns are imported as a string column. How do I resolve this?
Do ensure that the column type is set as DATE, DATETIME or equivalent types in the source table. In case your column type is set as string or similar types, then your data column may get imported as a string column. In this case you can convert it ...
I want to sync data more frequently than 3 hours. How can I do this?
Yes, you can. It is possible to sync your data more frequently than 3 hours. Do write your exact requirement to us at support@zohoanalytics.com. We'll get back to you on this.
Can I change the cloud data source of my Workspace?
Yes, you can change the cloud database from which you are importing data into your workspace. Follow the steps below to change the data source of your reporting database. From Workspace Explorer, click Data Sources. In the Data Sources section, ...
I get this error - 'Sorry, problem in connecting to your database server.' How do I overcome this?
This error occurs in the following scenario: Incorrect connection settings are specified - Ensure that the correct Endpoint, Port and user credentials are specified. Your cloud database service does not recognise Zoho Reports as an authenticated ...
My scheduled import from a cloud drive has failed continuously. Why?
Scheduled import from a cloud drive may fail due to one of the following reasons. File has been deleted - Ensure that the source does exist in your cloud drive. You have signed in as different user - You cannot map two account from the same cloud ...
How to upload/push data from in-house and hosted applications into Zoho Analytics?
Refer to the solution page "How to upload/push data from in-house applications" for details.
How to upload/push/import data periodically into Zoho Analytics?
You can periodically upload/push/import of data into Zoho Analytics through any of the following supported means: Setup periodic import of data from Web URL based CSV data. Read for more details. Use CSV Upload tool and setup periodic schedules. Use ...
I get this error - 'Sorry, Zoho Analytics was unable to import this file' while importing Excel files. How do I overcome this?
This error occurs in the following scenario: Invalid Excel file has been selected for import. Any conditional format is specified with infinite range. For Eg: A:A Any pivot view is created in the Excel workbook. Invalid Lookup or any reference error ...
Any restriction on the size of data that could be imported?
Zoho Analytics has the following restrictions on the size of data import. You can upload a maximum of 1,000,000 rows and the file size should not exceed 100 MB. However, you can upload huge CSV files using the Databridge. Zoho Databridge is a ...
How to upload large data into Zoho Analytics?
If you have a large amount of data (greater than 100 MB or 1000,000 rows) to be uploaded into Zoho Analytics, loading them using the Web Graphical Interface of Zoho Analytics, might not be the best way. As the upload happens over the Internet, slow ...
What are the file formats from which you can import data?
You can import tabular data from the following file formats: Excel Spreadsheets (.xls) CSV (Comma Separated Values) TSV (Tab Separated Values) Any tabular data in text file format HTML files MS Access (.mdb) files Odata Web URLs which generates data ...
Some of the records are not imported into Zoho Analytics table. Why?
Zoho Analytics will auto identify the data type of the column based on the first fifty records. In case there are any incompatible records ., import errors will be generated. Zoho Analytics will handle the error conditions as you have set in On ...
CaCan I schedule my import in every N minutes?n I schedule my import in every N minutes?
Yes, it is possible to enable scheduling EveryN minutes. Do write your exact requirement to us at support@zohoanalytics.com. We'll get back to you on this.
Will columns added to my source table automatically added in Zoho Analytics when the scheduler runs?
Yes, new columns added in your source table can automatically get added into the Zoho Analytics table to which data is being added. To do this, you need to select the Import any new columns added subsequently in the Data URL option in the scheduler.
Can I set up an import scheduler with a dynamic web URL?
Scheduling import of data from a dynamic URL is currently not supported. This could be achieved by the following workaround. Write a script (or an application) that will hit the dynamically constructed URL to retrieve the data from the web at regular ...
Can I import date from two or more locations?
Currently, Zoho Analytics does not support scheduling more than one import into the same table. However, you can combine the data from both tables for reporting by following the below workaround. Import data from each of the sources into separate ...
What are all the import options available in Zoho Analytics?
The following import options are available in Zoho Analytics: Import from Files - Zoho Analytics allows you to import data stored in tabular file formats like CSV, XLS (Excel), JSON, OData, and HTML files in your system. Import from Feeds - Zoho ...
Does Zoho Analytics support SQL (Structured Query Language) Querying?
Yes, Zoho Analytics supports full-fledged SQL based querying of your database. It understands SQL SELECT Queries written in any of the well-known database dialects including Oracle, Microsoft SQL Server, IBM DB2, Sybase, MySQL, PostgreSQL, Informix ...
What are the SQL Dialects supported by Zoho Analytics?
Zoho Analytics supports SQL written in a wide variety of popular database dialects. It currently supports Oracle, SQL Server, IBM DB2, Sybase, MySQL, PostgreSQL, Informix and ANSI SQL database dialects.
Does Zoho Analytics support Relational modeling?
Yes, Zoho Analytics supports relational modeling of your database. There are some limitations currently, which would be addressed incrementally to provide a powerful relational modeling capability in Zoho Analytics. The following are the important ...
How to Add Aggregate Formula Directly from Reports
The following are the steps to add an aggregate column directly from reports pag Open the reports tab in edit mode. Click Add Aggregate Formula link. The Add Aggregate Formula dialog box will open. Specify the formula name. Choose the data type. ...
How to optimize Workspace for better performance.
The following are few methods to Optimize the Workspace. When adding lookup column, ensure that the reference column in the parent table contains unique data. When you set Import Type to UPDATE ADD for uploading data into an existing table, you ...
Do you offer bulk pricing packages (with users and rows)?
Yes, we do. Please write to sales@zohocorp.com with your exact requirements & we'll get back to you with a price quote.
Where can I get more details about Zoho Analytics pricing?
You can find more details about the various pricing plans at https://www.zoho.com/analytics/pricing.html and FAQ related to Zoho Analytics pricing is available at this link.
How much does Zoho Analytics cost?
The pricing for Zoho Analytics starts at $25/month (supports 2 users, 500,000 rows & unlimited Workspace in the account). There are various plans ranging till $495 per month (50 users, 50 million rows & unlimited reporting databases). Zoho Analytics ...
How to change the primary Email ID of Zoho account?
To edit your email address, follow the steps given below: Log on to your Zoho account at https://accounts.zoho.com/ and click on the My Profile Info tab > Email Address. Click the Edit option to the right. Enter your new email address and password in ...
What type of reports could be created in Zoho Analytics?
Zoho Analytics supports a wide variety of report creation options, which includes: Charts : Allows you to create 25+ chart types. Pivot Tables: Allows you to create a powerful view with data summarized in a grid both in horizontal and vertical ...
What are the browsers supported by Zoho Analytics?
Zoho Analytics supports the following browsers: Google Chrome - Latest 3 versions Firefox - Latest 3 versions Safari - Latest 3 versions Internet Explorer - version 9 and above Microsoft Edge - Latest version The above browsers have been tested in ...
What is the best viewed screen resolution for Zoho Analytics?
Zoho Analytics is best viewed in 1280 * 720 screen resolution and above.
Can Zoho Analytics be accessed from handheld devices?
Can Zoho Analytics be accessed from handheld devices?
Can I change the data source of a table in my Workspace?
Yes, you can change the data source table to import into a Zoho Analytics table. Follow the steps below to change the data source of your table. Open the table for which you want to change the data source. Click Import > Import into this Table. The ...
Who should use Zoho Analytics?
Follow this link for a detailed discussion on https://www.zoho.com/analytics/who-should-use-zoho-analytics.html
Next page