in the report below:
I noticed the issue count duplicates issues. The reason of that, I use a field to select specific project categories only (i.e. CATEG=“A,B”) to filter values (using aggregate), so if I filter “A” and “B”, the ticket is counted twice, even I use “aggregate”.
Hi @jarno.rossi,
In these cases, it is recommended to use measures that show a distinct count of issues. You can find them in Measures in the “Distinct issues count” section.
Unfortunately, the measure “Issues with due date” doesn’t have this distinct measure by default. As a workaround, you can try to add it via the eazyBI advanced settings - https://docs.eazybi.com/eazybijira/data-import/custom-fields/advanced-settings-for-custom-fields. Please have a look at the parameters below:
#dstinct count example for calculated date field
[jira.customfield_ddate_count]
name = "Issues with due date count"
data_type = "integer"
measure = true
sql_expression = "CASE WHEN {{issue_with_due_date}} IS NOT NULL THEN {{issue_id}} END"
measures_table_name = "jira_issues_measures"
aggregator = "distinct-count"
After updating the eazyBI advanced settings, head to the eazyBI import settings “Custom fields” tab and select the custom field “Issues with due date count” for import as a measure. The tickets will be counted once with this measure. Please have a look at a picture of a sample report below:
Best,
Roberts // eazyBI support
I’m so grateful. It works!!
Thanks Roberts
