Usage statistics
eazyBI for Jira
eazyBI for Confluence
Private eazyBI
On this page:
Overview
Usage statistics is an optional eazyBI feature that can be used to analyze eazyBI usage using eazyBI. If enabled then eazyBI report execution requests and source data imports are stored in a special usage statistics eazyBI account and usage statistics reports and dashboards can be created to analyze eazyBI usage. A set of default reports and a dashboard of these reports will be created in this account. You can use these reports to see the overview of daily usage, see top executed reports and dashboards, reports with errors or slow reports.
Enable in Data Center
Usage statistics can be enabled in eazyBI additional settings by Jira system administrator.
After saving the additional settings, a special (usage statistics) eazyBI account will be created which will be available to Jira system administrators. You can grant other Jira users or user groups access to this eazyBI account.
Report execution and import data are stored in a separate eazyBI database schema – eazybi_jira_dwh_stats on MySQL, dwh_stats on PostgreSQL or MS SQL, the same eazyBI user schema on Oracle. Report execution and import data are cached and the cache is cleared every 10 minutes – so you might see up to 10 minutes old data in your reports.
eazyBI will start collecting usage statistics once eazyBI advanced settings are updated and new feature is enabled.
You can disable usage statistics by disabling usage statistics option in additional settings. When usage statistics are disabled, then you can still view the collected historical usage statistics. If you do not need the history, then the (usage statistics) account can be deleted by the owner of this account.
By default, 1-year history of usage statistics data is stored. Older usage statistics entries are deleted during the eazyBI startup. You can increase or decrease how long history is stored by specifying the period (for example, 3 months or 2 years) in advanced settings:
[usage_statistics] keep_for = "3 months"
Enable in Cloud
eazyBI collects and stores usage statistics for report executions and imports in Cloud by default in the background for monitoring and support purposes. Jira system administrator can enable the usage statistics in eazyBI general settings to get access to site-specific statistics on reports executions and imports.
After saving eazyBI general settings a new special (usage statistics) eazyBI account will be created which will be available to Jira system administrators. You can grant access to other Jira users or user groups to this eazyBI account. eazyBI will share the already stored usages statistics data of report executions and import to the site usage statistics account.
You can start analyzing the eazybi usage in site with 1 year history of data in a few minutes after enabling the usage statistics option for cloud sites. Report execution and import data are cached and the cache is cleared every 10 minutes – so you might see up to 10 minutes old data in your reports.
You can disable usage statistics by disabling usage statistics option in general settings. When usage statistics are disabled, the usage statistics account will be removed from the site. You can restore the account with a default setup at any time.
Enable in Private eazyBI
Since Private eazyBI version 8.0, you should enable usage statistics in the Settings / Additional page as described above.
The following instructions are for the earlier Private eazyBI versions 7.x.
Data model
Here is a list of measures and dimensions that are available in usage statistics reports.
Measures
Accounts created NEW | Count of eazyBI accounts created by users. If a deleted account is restored from the Audit log, it is also counted as created. The Time dimension groups data by the date the account was created. Measure Accounts created is available on Cloud. |
|---|---|
Accounts updated NEW | Count of eazyBI account updates. The Time dimension groups data by the date the account was edited and updated. Measure Accounts updated is available on Cloud. |
Accounts deleted NEW | Count of deleted eazyBI accounts. The Time dimension groups data by the date the account was deleted. Measure Accounts deleted is available on Cloud. |
Reports created NEW | Count of created reports by users. If a deleted report is restored from the Audit log, it is also counted as created. The Time dimension groups data by the date the report was deleted. Measure Reports created is available on Cloud. |
Reports updated NEW | Count of report updates. The Time dimension groups data by the date the report was edited and updated. Measure Reports updated is available on Cloud. |
Reports deleted NEW | Count of deleted reports. The Time dimension groups data by the date the report was deleted. Measure Reports deleted is available on Cloud. |
Dashboards created NEW | Count of created eazyBI dashboards by users. If a deleted dashboard is restored from the Audit log, it is also counted as created. The Time dimension groups data by the date the dashboard was created. Measure Dashboards created is available on Cloud. |
Dashboards updated NEW | Count of eazyBI dashboard updates. The Time dimension groups data by the date the dashboard was edited and updated. Measure Dashboards updated is available on Cloud. |
Dashboards deleted NEW | Count of deleted eazyBI dashboards. The Time dimension groups data by the date the dashboard was deleted Measure Dashboards deleted is available on Cloud. |
Sources created NEW | Count of added data sources by users. If a deleted source is restored from the Audit log, it is also counted as created. The Time dimension groups data by the date when the source was added. Measure Sources created is available on Cloud. |
Sources updated NEW | Count of data source updates. The Time dimension groups data by by the date the source was edited and updated. Measure Sources updated is available on Cloud. |
Sources deleted NEW | Count of deleted data sources. The Time dimension groups data by the date the source was deleted. Measure Sources deleted is available on Cloud. |
Report Executions | A total number of first-time report executions when the report is opened (repeated executions are not counted when users change page selection or do drill actions). |
Report Execution Duration | Total first-time report execution time in seconds. Use the calculated measure of Average Execution Duration to get the average. |
Report Execution Errors | A total count of errors during the first-time report executions. Use the Report Execution Errors % calculated measure to see it as a percentage of total executions. |
Active Users | Unique count of users who used reports according to the selection of other dimensions. |
Active Accounts | Unique count of eazyBI accounts from which reports were used. |
Active Reports | Unique count of reports that were used. |
Active Dashboards | Unique count of dashboards which reports were used. |
Import Count | Count of source data import runs. |
Import Duration | Duration of imports. Use the calculated measure of the Average Import Duration to get the average. |
Import Errors | A total count of errors during the first-time import run. Use the Import Errors % calculated measure to see it as a percentage of total imports. |
Import Canceled | Count of manually canceled imports. |
Step Import Count | Count of steps executed during import. |
Step Import Duration | Duration of import of each step. Use the Average Step Import Duration calculated measure to get the average. |
Units Imported | Count of Source units imported with each import. Use the Average Step Import Duration calculated measure to get the average. |
Units Import Duration | Duration of import of each Source unit. Use the Units Imported Per Second calculated measure to get an average of how many units are imported per second. |
Dimensions
Account | eazyBI account – name and ID. Click on the dimension member and select Go to source to navigate to the Analyze tab of this account. |
|---|---|
Account Status NEW | Current account status - active or deleted. Dimension "Account Status" is available on Cloud. |
Time | Date of activity logged in usage statistics. |
Hour | Hour of the day of the activity logged in usage statistics. Hour is based on the Jira server time zone. |
Week Day | The day of the week of the activity logged in usage statistics. |
| Dimensions for report execution analysis: | |
User | User – display name and email. |
Report | Reports grouped by Account, Cube, and Folder levels – name and ID. Click on the dimension member and select Go to source to open the report. |
Report Status NEW | Current report status - active or deleted. Dimension "Report Status" is available on Cloud. |
Dashboard | Dashboards grouped by Account level – name and ID. Click on the dimension member and select Go to source to open the dashboard. |
Cube Type | Based on the data source – Jira or Custom. |
Report Type | Table or a specific chart type. |
Report Location | Where a report was located – Analyze tab, Dashboard, Gadget Dashboard or Gadget Report. |
| Dimensions for source data import analysis: | |
Import type | Full or Incremental import of source data. Incremental import could include Full data import of some import steps. |
Source | Individual source application or source file from which the import was done. On the Cloud, the Source dimension has an additional hierarchy By source type and host to group data sources first by type, host, and then individual data sources. Click on the dimension member and select Go to source to open the Source Data tab for the corresponding account. |
Source type | Source type, such as Jira, SQL, REST API, etc. Some source types could be expanded to Source Steps representing a step of an import (for example, Project import, Issue import steps in Jira import). |
Source Unit | Countable source units in import. For example, Issues, Projects, Objects, Rows, etc. |
Properties
you can select the most used properties from the Measures section.
Account siteAccount status NEWAccount imported issues count NEWAccount imported pages count NEWAccount imported objects count NEWAccount imported items count NEW | They are used together with the Account dimension. The selected Account has several attributes: Atlassian site name, status, and imported object count (depending on the data source). New properties are available on the Cloud. |
|---|---|
User site | They are used together with the User dimension. Atlassian site name for the selected User. |
Report siteReport accountReport site or accountReport cubeReport cube typeReport type NEWReport status NEW | Used together with the Report dimension. The selected Report has several attributes: Atlassian site, eazyBI account name, cube name and type, and report type, which you can pick from the Predefined measure section. New properties are available on the Cloud. However, there are several more properties for Report dimension which could be accessed through calculated measures using the function get():
For example, the expression to see report's last update date is this: --set measure formatting to Date / Time
[Report].CurrentHierarchyMember.Get('Updated at')
And expression to see the user name who made the last updated: [User].[User].GetMemberNameByKey(
[Report].CurrentHierarchyMember.Get('Updated by')
)
|
Dashboard siteDashboard accountDashboard site or account | They are used together with the Dashboard dimension. Atlassian site and eazyBI account name for selected Dashboard. |
Source siteSource accountSource site or account | They are used together with the Source dimension. Atlassian site and eazyBI account name for selected data Source. |