You can easily track the outages by analyzing the key metrics such as downtime count, duration of outage, frequency, and more across locations. This helps in identifying the root cause of downtimes and make appropriate steps to maximize website/application/server performance.
Zoho Analytics is a self-service BI and data analytics software that lets you analyze your data, create stunning data visualizations, and discover hidden insights in minutes.
It offers the following important capabilities:
Advanced Analytics for Site24x7 allows you to analyze your end-user experience with powerful analytics. This helps you in improving your service/platform availability with meaningful insights on outages, alarms, monitors, and infrastructure.
You can easily track the outages by analyzing the key metrics such as downtime count, duration of outage, frequency, and more across locations. This helps in identifying the root cause of downtimes and make appropriate steps to maximize website/application/server performance.
Advanced Analytics for Site24x7 brings in all the capabilities of Zoho Analytics described below.
Users with paid accounts of both Zoho Analytics (at least the Basic plan) and Site24x7 or Zoho CRM Plus users can avail this connector.
Site24x7 Advanced Analytics is bundled free for all the paid users of Zoho Analytics. The Zoho Analytics paid plans start at $25 per month. Click to learn more about Zoho Analytics pricing .
Yes, we do provide a 15-day free trial for this connector from the date of set up.
Anyone to whom you privately share your Workspace, tables (data), reports and dashboards, created in Zoho Analytics, for collaboration is considered a 'User' in Zoho Analytics. A user is identified by his/her unique email address, with which their Zoho Analytics account was registered.
Suppose you subscribe to the Zoho Analytics Standard plan, you can privately share the data/reports in your account and collaborate with 4 other persons. Now your Zoho Analytics account is said to have 5 users (including yourself).
In Zoho Analytics, a row or record is defined in the same context as in a database (or spreadsheet). In simple terms, a table consists of rows (records) and columns (fields). Each row in a table represents a set of related data and has the same structure. For example, in a table that represents "Alarms", each row would represent a single record. The number of rows calculated for pricing is the sum of all rows/records stored across all your Workspace tables in your Zoho Analytics account.
The Account Administrator and the Organization Administrators can set up the Advanced Analytics connector. Click here to learn about
Managing Users
.
The credentials of the Administrator who set up the connector, will be used for establishing any connections with source application by other administrators.
Initial data import will take from a few minutes to a couple of hours depending on the volume of data in your Site24x7 account. You will receive an email notification once the import is complete. If you access the Workspace before the initial fetch is complete, it will not display any data (empty tables i.e., tables with zero rows).
You can synchronize the following data from Site24x7 into Zoho Analytics.
If you are a Basic plan user, you can synchronize your data once every day.
You can choose to synchronize data at one of the intervals mentioned below.
Yes, you can edit the Site24x7 connector synchronization setting if you are the administrator of the Site24x7 Advanced Analytics. To do so,
Yes, you can view the data synced history. Follow the below steps to view the data synced history.
Open the corresponding Smartsheet Analytics Workspace in Zoho Analytics.
Yes, you can synchronize your Site24x7 data instantly when needed.
To synchronize your data instantly:
Yes, you can set up the Site24x7 Advanced Analytics in any of the existing Workspace or in any of the Advanced Analytics Workspace to analyze data together. You can do this by creating a new table by importing data.
No, you cannot add/modify data in the Site24x7 data tables. Data from Site24x7 application will automatically get synced into Zoho Analytics in the different tables. You cannot edit any of this data or add new data records from within Zoho Analytics.
However, you can add new tables and add/import data into that, to create reports combining it with the data from Site24x7.
No, you cannot add new columns. But, you can add Custom and Aggregate Formulas (i.e., calculated fields) to these tables to help you create powerful reports. Refer to Adding Formulas to know more about this.
Yes, you can add new data tables. Click
New > New Table
to add a new table in the existing Site24x7 Advanced Analytics Workspace.
With this feature, you can import data from other sources or add them manually into your Workspace to analyze and create reports combining this with your Site24x7 data.
Refer:
You can re-authenticate the setup by following the below steps.
You can remove the connector from the Data Source page.
Zoho Analytics will synchronize the data specified in this question into the Site24X7 Advanced Analytics workspace. You can create reports using this data.
Yes, you can create reports using the columns from different tables. All the modules (tables) from Site24x7 will be linked by default. You can create reports by simply dragging and dropping the required columns into the reports designer.
Zoho Analytics supports a wide variety of reports.
Formulas, as the name indicates, are calculations that help you derive key business metrics that can be used for reporting and analysis. Zoho Analytics provides a powerful formula engine to create any type of calculations required, to enable creating the required reports. Refer to Adding Formulas in Zoho Analytics to know more.
The default formulas added by Zoho Analytics are listed below. You can view these formulas by opening the corresponding table and selecting Add > Edit Formulas from the toolbar.
The following are the default formulas in the Alarms table.
| Formula Name | Formula Type | Formula | Description |
| Duration in Seconds | Formula Column | dateandtimediff(second,"Alarms"."Start Time","Alarms"."End Time") | This formula calculates the duration of alarm in seconds. |
| Duration in Minutes | Formula Column | "Duration in Seconds"/60 | This formula calculates the duration of alarm in minutes. |
| Duration in Hours | Formula Column | "Duration in Minutes"/60 | This formula calculates the duration of alarm in hours. |
| Outage in Seconds | Aggregate | sumif("Alarms"."Status" = 'DOWN',"Alarms"."Duration in Seconds",0) | This formula calculates the outage in seconds. |
| Outage in Minutes | Aggregate | sumif("Alarms"."Status" = 'DOWN',"Alarms"."Duration in Minutes",0) | This formula calculates the outage in minutes. |
| Outage in Hours | Aggregate | sumif("Alarms"."Status" = 'DOWN',"Alarms"."Duration in Hours",0) | This formula calculates the outage in hours. |
The following are the default formulas in the Child Entity Performance table.
|
Formula Name
|
Formula Type
|
Formula
|
Description
|
| Performance | Custom | "Sum"/"Count" | This formula calculates the performance of the Child Entity. |
The following are the default formulas in the Infrastructure Performance table.
|
Formula Name
|
Formula Type
|
Formula
|
Description
|
| Performance | Custom | "Sum"/"Count" |
This formula calculates the performance of Infrastructure.
|
The following are the default formulas in the Internet Services Performance table.
|
Formula Name
|
Formula Type
|
Formula
|
Description
|
| Performance | Custom | "Sum"/"Count" |
This formula calculates the performance of Internet Services.
|
To know how to create your own formulas, refer to the Adding Formulas in Zoho Analytics help page.
Yes, you can combine data from your other sources with your Site24x7 data for analysis.
To do this, you need to add/import a new data table into the Site24x7 Advanced Analytics Workspace as explained in the
previous question
and then define a look-up to join it with the table from Site24x7.
To define a lookup relationship between two tables, it is essential that the tables have at least one column which is common between them. Follow the below steps to look up a column from Site24x7 along with the data from any other source.
Yes, you can join data from multiple tables to create the reports. Refer to Joining Tables in Zoho Analytics for detailed help on this.
Zoho Analytics allows you to drive the data required by writing standard SQL SELECT Queries. This feature is called Query Tables. With Query Tables, you can also combine data from different tables and create reports from the same. Click here to know how to create Query Tables in Zoho Analytics.
You can integrate and perform cross-functional analytics with most business applications that Zoho Analytics integrates with.
To import data from business apps,
A lookup relationship will not be created automatically between the Site24x7 modules and the modules of the application that you are trying to import. You will have to manually link the tables using a lookup relationship.
To manually create a lookup relationship, refer this help link - Click here
You can easily share the reports that you create with the other users in your organization. Refer to Sharing and Collaboration help page for more details on this.
Once you privately share a report to your colleagues they will be able to access the reports as you do. Refer here to know how to access the reports.
Zoho Analytics offers three user roles - Account Administrator, Workspace Administrator, and User. Click to know more about the Zoho Analytics Organization Model and User Roles .
This is the expected behavior. Only when the users to whom the reports are being shared is set as a Workspace Administrator, they will be able to edit the reports. If a normal user wants to edit the report, he/she will have to save the report with a new name using the Save As option toolbar. The User can edit this report. To know more about user roles click here .
Yes, you can. Refer to the topic Apply filter criteria.
Yes, you can export the report/dashboard in various file formats such as CSV, EXCEL, PDF, HTML, and Image. Click to know more.
To print the report/dashboard, you first need to export it. You can export the report in various file formats such as CSV, EXCEL, PDF, HTML, and Image. Click to know more.
If you are the Administrator of the Zoho Analytics or a 'Workspace Administrator', you can schedule reports and dashboards to be emailed automatically. Refer to the email schedule section in this help documentation .
Yes, Zoho Analytics supports various rebranding options such as Portal rebranding/white labeling and Logo Rebranding .
We offer 24x5 technical support (Monday to Friday). In case if you need our assistance kindly do mail us your questions to support@zohoanalytics.com .
You can also reach out to us on our toll-free numbers.
United States:
+1 (888) 900 9646
United Kingdom:
+44 (20) 35647890
Australia:
+61-2-80662898
India:
+91-44-6965 6060
Yes, certainly. Register for a demo in this page .