Different data in comparison to Jira

Questions & Answers
, ,
1

Hi everyone

Iam importing Jira data to eazybi but when I compare the information, they came different.

An exemple:
Jira, 30 items

image
image1793×719 152 KB

Eazy, 29 items

image
image942×778 65.3 KB

I’ve analised the unic item that is not appearing and the informations like “resolved”, “actual end”, are filled correctly.

2

Hi @Thaina_Penha_Baima_V,

When comparing the data in Jira and eazyBI, you should apply the same filtering criteria in both.

  • In Jira, you’re using a JQL filter to count work items by specific fields, including dates
  • In eazyBI, you’re using a specific measure (like “Issues resolved”, “Issues created”, “Issues with due date”) in combination with dimensions.

Make sure both are counting the same thing with the same criteria. Here is a training video explaining the main concepts for translating JQL filters in Jira to eazyBI reports: Videos: create reports and charts

In your specific report,

  1. Import the custom field “Actual end” as a measure and as a property (Jira custom fields).
    This enables analysis by Actual end date.

  2. On report columns, select measure “Issues with actual end” to show which issues have this date field filled. The measure is the key element that brings all report data together and matches the filter criteria.

  3. Add the “Time” dimension on report pages to filter report by “Actual end” period. Please see the documentation on how Time dimension works and allows you to filter data by specific date fields: Time dimension
    Select “2025 June” in the “Time” dimension to see “Issues with actual end” date falling in June 2025.

  4. Add the rest of the dimensions from JQL filter, “Project”, “Issue Type”, and “Assignee”, on report pages for filtering data.

Best,
Zane / support@eazyBI.com