All eazyBI for Jira eazyBI for Confluence Private eazyBI

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 access to other Jira users or user groups 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

the system administrator can enable the usage statistics from the eazybi.toml configuration file by adding these two lines:

[usage_statistics]
enable = true

After updating the eazybi.toml file and restarting Private eazyBI instance a new special (usage statistics) eazyBI account will be created which will be available to eazyBI administrators. 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 by removing lines above from the eazyBI.toml file and restaring Private eazyBI instance again. 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.

Data model

Here is a list of measures and dimensions that are available in usage statistics reports.

Measures

Report ExecutionsA 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 DurationTotal first-time report execution time in seconds. Use the Average Execution Duration calculated measure to get the average.
Report Execution ErrorsA total count of errors during the first-time report executions. Use the Report Execution Errors % calculated measure to see it as a percentage from total executions.
Active UsersUnique count of users who used reports according to the selection of other dimensions.
Active AccountsUnique count of eazyBI accounts from which reports were used.
Active ReportsUnique count of reports which 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 Average Import Duration calculated measure 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.

TimeDate of activity logged in usage statistics.
HourHour of the day of the activity logged in usage statistics. Hour is based on the Jira server time zone.
Week DayThe day of the week of the activity logged in usage statistics.
Dimensions for report executions analysis:
UserUser – display name and email.
Report

Reports grouped by Account, Cube, Folder levels – name and ID.

Click on the dimension member and select Go to source to open the report.

Dashboard

Dashboards grouped by Account level – name and ID.

Click on the dimension member and select Go to source to open the dashboard.

Cube TypeBased on the data source – Jira or Custom.
Report TypeTable or a specific chart type.
Report LocationWhere 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.

Click on the dimension member and select Go to source to open the Source Data tab for the corresponding account.

Source type

Source type, for example, 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.