All eazyBI for Jira eazyBI for Confluence Private eazyBI

Monday.com
eazyBI.com

Monday.com is a Work Operating System (Work OS) that powers teams to run projects and workflows with confidence. It’s a simple, but intuitive, Work OS for teams to shape workflows, adjust to shifting needs, create transparency, connect collaboratively, and stop doing manual grunt work. 

eazyBI extends the Monday reporting suite with an advanced, easy-to-use, and flexible visualization, analysis, and reporting. You can create an eazyBI account and perform your first import in minutes. Regular daily updates import data automatically, so your charts will always have the latest data. We have several predefined sample reports and charts, and a dashboard to get you started. You can easily create custom reports, charts, and dashboards for your specific needs.

eazyBI imports and allows data analysis for Item, Creator (Users), Logged by, Status, Workspace, Board, and Group

On this page:


Dimensions

eazyBI imports this default set of dimensions:

Workspace
Workspaces provide your account with a hierarchy of organization to help you better manage multiple departments, teams, and projects in one unified place.
Board

A board is a place to organize everything you need to do - a project, a to-do list, CRM, a schedule. 

Group
A group is a color-coded section on your board that contains your items (rows) and helps to categorize and organize them in any way that you wish. When creating a board, you then need to create your groups. A group can represent anything from a week, a month, a specific step of a project, a client, or whatever you want!
Item
An item is an individual row (or line item) in a group. Your monday.com boards are made up of groups of items. The content of an item is totally up to you and will depend on what the board's plan is β€” they can represent anything from a list of projects to weekly tasks, clients, locations, or anything else depending on your workflow!.
StatusStatus Column is a key factor in helping you plan, organize, and track all of your team's work according to status labels. Easily see if a task is yet to be completed, in progress, done, or any other status that you wish!
CreatorUsers who registered the item.
Logged byUsers who logged a time entry for the item.
Transition Status

All statuses that appear in the status history log (the same statuses as in the Status dimension).

Transition

All individual transitions with names in the format β€œFrom status => To status”.

Transition Author

The user who performed the transition.

Item measures and properties

Set of measures that are imported based on Item data and work primarily with Item dimensions and common dimensions, like Workspace, Group, Board, Status.  

Numerical Measures

Items created

Measure counts items on a timeline based on Item creation date

Items doneMeasure counts assets on a timeline based on the last date when the item was completed (marked as done)
Items last updatedMeasure counts items that match selected dimension members. If the Time dimension is used then items last updated counts items by the last update date and shows the total in the corresponding period.
Hours spent

Total of registered worklog hours on item matching the selected dimension members.  On the Time dimension grouped by the start date specified in the worklog. The Logged by dimension can be used to see hours spent by individual users.

You can Drill through worklogs to get a list of all worklog entries constituting particular Hours spent total value, with additional information - date of the worklog, item, user name, as well as logged hours for this entry. The list could be exported to a file.

Transitions to status

How many times during selected Time dimension period item has been transitioned to the status that is selected in Transition Status dimension (or only transitions that are selected in Transition dimension). Also, first item status will be counted in this measure on item creation date.

If you would like to see a distinct (unique) count of items for these transitions then use Transitions to status items count measure from the Distinct items count measure group.

Transitions from status

How many times during selected Time dimension period item has been transitioned from the status that is selected in Transition Status dimension to different status (or only transitions that are selected in Transition dimension).

If you would like to see a distinct (unique) count of items for these transitions then use Transitions from status items count measure from the Distinct items count measure group.

Days in transition status

Use this measure for individual items to show how many days item has stayed in status from Transition status dimension. It is calculated when an item is transitioned from this status (when the Transitions from status measure is recorded) and will be shown on Time dimension on the date when the transition from this status happened.

Use Average days in transition status calculated measure when you are analyzing totals of many items.

Weekdays in transition statusSimilar to Days in transition status but only workdays are calculated according to Time dimension options.
Open itemsCalculates a number of uncompleted items at the end of the corresponding Time dimension period (as Items created minus Items done since the beginning of the time until the end of the selected time period).
Average done daysCalculates average done days of done items (that are counted in Items done) and are grouped by item done date on Time dimension.
Hidden Total done days Measure, which returns a pre-calculated number of days from created to done dates, is used in the Average done days formula.
Average done weekdaysSimilar to Average done days but only workdays are calculated according to Time dimension options.

Items created count

Items done count


In Distinct items count measure group distinct (unique) count of items is calculated. These measures can show a different result than previously described Items created,  and done measures in a case when some multi-value dimension with a multiple-member selection is put on pages (e.g. Board or workspace or multi-value columns). E.g. if several values are used on one column and one item belongs to two of selected values then Items created value will be 2 but Items created count value will be 1 for this item.
Items with hours spentDistinct count of items that have any hours logged in the selected Time period.
Transitions to status items count

How many (unique) items have transitioned to selected status in Transition Status dimension (or only transitions that are selected in Transition dimension) during the period chosen in Time dimension.

The measure is located in Distinct items count measure group.

Transitions from status items count

How many (unique) items have transitioned from selected status in Transition Status dimension (or only transitions that are selected in Transition dimension) during the period chosen in Time dimension.

The measure is located in Distinct items count measure group.

Items history

How many items at the end of selected Time dimension period are

  • in status that is selected in Transition Status dimension (calculated as Transitions to status minus Transitions from status from the beginning of time until the end of the selected Time period);
  • or with a columns dimension member (for which Import changes are selected) at the end of the selected Time period.
Average days in transition statusAverage days that item stayed in status that is selected in Transition status dimension. It is calculated when an item is transitioned from this status (when the Transitions from status measure is recorded) and will be shown on Time dimension on the date when the transition from this status happened.
Average workdays in transition statusSimilar to Average days in transition status but only workdays are calculated according to Time dimension options.
Transition to status first dateShows the date and time when the first transition to the corresponding Transition Status (or the selected Transition) was performed.
Transition to status last dateShows the date and time when the last transition to the corresponding Transition Status (or the selected Transition) was performed.
Transition from status first dateShows the date and time when the first transition from the corresponding Transition Status (or the selected Transition) was performed.
Transition from status last dateShows the date and time when the last transition from the corresponding Transition Status (or the selected Transition) was performed.

Property measures

Property measures should be used only with the corresponding dimension members. For example property "Item done date" would return the date when the item was sent to status "Done" only when the "Item" dimension is expanded at the item-level.

Item created date

Item updated date

Item status updated date

Item done date

Item creator

Item status

If the Item dimension is placed on rows and expanded to detailed items and these measures are placed on columns then details about issue creation, updated date, status last updated date, done date, as well as creator and status are displayed.

Columns data import

You can select additional columns for import. Columns with checkbox, dropdown type, user list, location can be imported as additional dimensions. Numeric, and date columns can be imported as additional measures. All columns can be imported as properties for related dimensions. They will be grouped in sections ending with properties (*Item properties). 

Numeric columns can be imported as measures and property. The measure will have a name-ending Custom number sum. It will be represented on a timeline mapped with the item creation date.

Date columns can be imported as a measure and will create a measure ending with a custom date. It counts entities with value in this date on the timeline mapped by the date value. For example, the column start date imported for Item will be imported by name Items with start date. It also will have property located in Item Properties with the name Item Start Date.

Checkbox, dropdown type, user list and few other columns can be imported as dimensions. Use them in reports for filters or to split data with measures. For example, if you have a drop-down selection column Class for Items then you can import it as a dimension. You will be able to create reports by Class dimension as well as you will have Item property Item Class.

Use columns in the report to split data by any measure. For example, Use dimension Time on Rows, dimension Item model on columns, and measure Items done on columns. This report will count items by done date on a timeline.

If you need additional help with column import then please contact eazyBI support and describe your needs.


Additional import options

eazyBI by default will import data on daily basis since taking into account the last successful import run. 

eazyBI will import data based on the specified timezone. For reporting on workdays/weekends set the correct non-working days. For weekly reporting set the first day of the week. 

eazyBI will import a set of sample reports by default. The option can be disabled and the default set of reports will be deleted.