Confluence measures and dimensions

On this page:


Measures

Confluence data cube contains the following measures:

Pages created

Total number of created pages for selected dimension members. On the Time dimension data are grouped by page creation dates.

Page versions created

Number of created page versions in a selected time period. On the Time dimension data are grouped by page version dates.

Pages updatedUnique number of updated pages in a selected time period (page is considered as updated when a new page version is created).
Page likes

Number of page likes. Page likes are grouped by page creation date when the Time dimension is used.

Page views

Total number of page views in a selected time period.

Page views are imported only when the Process events import option is selected. And eazyBI collects data starting from the moment when eazyBI account is set up, and Space is selected for data import. Page views are updated every hour on Confluence Cloud and every 10 minutes on Confluence Server.

Page views counter will be cleared if you "Empty" the cube

Pages viewedUnique number of viewed pages in a selected time period (calculated as a unique page count from the total Page views).

Users viewed

Unique number of users that have viewed pages in a selected time period and according to other selected dimension members (calculated as a unique user count from the total Page views). All anonymous users are counted as one user.

Spaces viewedUnique number of spaces that have viewed pages in a selected time period and according to other selected dimension members (calculated as a unique spaces count from the total Page views).
Searches

Total number of searches in a selected time period. Searches are imported if the Import search queries option is selected. Searches can be analyzed only by Time and Search Query dimensions. As searches are performed in all spaces then it is not possible to analyze them by spaces. Due to privacy concerns users (who performed the search) are not stored.

Searches are updated every hour on Confluence Cloud and every 10 minutes on Confluence Server.

Average number of results

Average number of returned results for search queries. Imported together with the Searches measure. Twenty results per search is the maximal value as eazyBI retrieves results count for the first portion.

NEW Page attachments

The total number of attachments. On the Time dimension data are grouped by the creation date of attachment current version.

NEW Page attachments size

Size of created attachments, the value is taken from the attachment latest version. On the Time dimension data are grouped by the creation date of attachment current version.

NEW Tasks created

Count of created tasks for selected dimension members. On the Time dimension data are grouped by task creation date.

NEW Tasks due

Due tasks that have not been completed. On the Time dimension data are grouped by task due dates; if a task does not have a due date then it will be counted only in All Times member.


NEW Tasks completed

Tasks that are marked completed. On the Time dimension data are grouped by task completion date.

NEW Tasks with due date

All tasks (both due and completed) which have a due date specified. On the Time dimension data are grouped by task due date.

eazyBI collects data on page views (who, when, which pages) and searches starting from the moment when eazyBI account is set up, and Space is selected for data import. At the beginning Page views, Pages viewed, Users viewed, Spaces viewed, Searches and Average number of results measures are empty as eazBI hasn't collected history of data yet.

Data on attachments and tasks are available starting from eazyBI for Confluence Server version 6.0 and eazyBI for Confluence Cloud.


Calculated measures

The following standard calculated measures are available:

NEW Open tasks

Calculates a number of uncompleted tasks at the end of the corresponding Time dimension period (as Tasks created minus Tasks completed since the beginning of the time until the end of the selected time period).


Properties

Properties are calculated measures retrieving specific information for each particular dimension member. Some of properties are also available as dimensions (Page type, Space).

To get a property value displayed in the report, you should use dimension members of the corresponding dimension in the report rows, for example, Page dimension detailed Page level members. 

Property values are displayed empty for higher-level members or if other dimensions are selected in rows.

Property names usually start with the name of the corresponding dimension.

Page properties

Page created date

Page updated date

Page type

Page space

Page space key

Page space status

If the Page dimension is placed on rows and expanded to detailed pages and these measures are placed on columns then detailed property value for a page is shown.
Space properties

Space created date

Space status

Space categories

If the Space dimension is placed on rows and expanded to detailed spaces and these measures are placed on columns then detailed property value for space is shown.

NEW Attachment properties

Attachment created date

Attachment media type

Attachment author

Attachment comment

Attachment version number

Attachment page

Attachment space

Attachment space key

If the Attachment dimension is placed on rows and expanded to detailed attachments and these measures are placed on columns then detailed property value for an attachment is shown. All information is shown about the attachment current version.

NEW Task properties

Task created date

Task updated date

Task completed date

Task due date

Task status

Task assignee

Task page

Task space

Task space key

If the Task dimension is placed on rows and expanded to detailed tasks and these measures are placed on columns then detailed property value for a task is shown.


Dimensions

Measures and calculated measures can be analyzed by the following dimensions.

Space

Space of the page. Also, the Status hierarchy can be used with Current and Archived status level members.

There is an option to create custom hierarchies with the Add custom hierarchy. It is possible to create a hierarchy based on custom Space properties imported with additional data import.

Page TypePage type – either Page or Blog post.
PageList of all individual pages organized in a hierarchy by Space. This dimension has a secondary hierarchy Top Page that adds the additional Top Page hierarchy level.
LabelLabel of the page.
Author

User who created the page.

There is an option to create custom hierarchies with the Add custom hierarchy. It is possible to create a hierarchy based on custom User properties imported with additional data import.

Viewer

User who viewed the page (used for the Page views measure). All anonymous viewers are represented as the (anonymous) dimension member.

There is an option to create custom hierarchies with the Add custom hierarchy. It is possible to create a hierarchy based on custom User properties imported with additional data import.

TimeStandard time dimension with Year / Quarter / Month / Day hierarchy and Year / Week / Day hierarchy.
HourHour of the day when a page was created, updated, or viewed. Calculated based on the specified Time dimension time zone in the import options.
Week DayDay of the week when a page was created, updated, or viewed.
Search QuerySearch query that was used for a search (used for the Searches measure). If a user quickly performs many search queries then a query after a 5 seconds pause is stored. All search queries are stored in lowercase.

NEW Space Category

List of all categories for imported spaces.

NEW Attachments

List of all individual attachments organized in a hierarchy, first grouped by Space and then by Page. It can be used together with the Author dimension to identify who has created the attachment. 

NEW Task

List of all individual tasks organized in a hierarchy, first grouped by Space and then by Page.

NEW Task Status

Current task status - Completed or Uncompleted.

NEW Task Assignee

Currently assigned user for a task. If a task has several user mentions, then the task is assigned to the first-mentioned user.

There is an option to create custom hierarchies with the Add custom hierarchy. It is possible to create a hierarchy based on custom User properties imported with additional data import.


Calculated members in Time dimension

When you create a new eazyBI account and import data there will be some predefined calculated members created in the Time dimension. These members would be automatically available in Cloud and since server version 5.1

These calculated Time membres can help you with dynamic calculations, for example, to calculate the number of pages created in the previous month.

Current monthIt finds and returns the member of the Time dimension at the Month level that is the month when the report is being executed. This member is created in a default Time dimension hierarchy and might not work with other hierarchies in Time dimension
Previous monthIt finds and returns the member of the Time dimension at the Month level that is one month prior to the month when the report is being executed. This member is created in a default Time dimension hierarchy and might not work with other hierarchies in Time dimension
Last 12 monthsIt aggregates members from Time dimension at the Month level based between 12 months ago and today (dynamically). This member is created in a default Time dimension hierarchy and might not work with other hierarchies in Time dimension
Last 30 daysIt aggregates members from Time dimension at the Day level based between 30 days ago and today (dynamically). This member is created in a default Time dimension hierarchy and might not work with other hierarchies in Time dimension
Last 4 weeksIt aggregates members from Time dimension at the Week level based between 4 weeks ago and the current week (dynamically). This member is created in a weekly hierarchy for the Time dimension and might work only in this particular hierarchy.

eazyBI allows opening and viewing formulas for these calculated members but it would not let you change them. Feel free to copy formulas and adjust them to create your own custom periods for report filtering and calculations.