Discrepancy Between Drill‑Through Issue Count and Expected Results

Questions & Answers
, ,
1

Hello! eazyBI community everyone,

I am encountering an issue with a bar‑chart report and would appreciate any guidance you can provide.

Bar-Chart report

Page Filters: Time
Rows: Project, Group
Columns: Measures

In the Measures dimension I defined the following calculated measure:

CoalesceEmpty(
  Avg(
    Filter(
      Descendants([Issue].CurrentMember, [Issue].[Issue]),
      -- Filter by time when the value for any issue
      DateInPeriod(
        -- use the Issue created date property here
        [Measures].[Issue 접수일],
        [Time].CurrentHierarchyMember
      )
      AND
      [Measures].[Issue type] = "VOC"
      AND
      [Measures].[Issue status] = "완료"
      AND
      (
        [Issue].CurrentHierarchyMember.Get("VOC Level") = "LV1"
        OR [Issue].CurrentHierarchyMember.Get("VOC Level") = "LV2"
        OR [Issue].CurrentHierarchyMember.Get("VOC Level") = "LV3"
        OR [Issue].CurrentHierarchyMember.Get("VOC Level") = "LV4"
      )
      -- [VOC Level].[L1~L4] > 0
    ),
    CASE WHEN
      [Measures].[] > 0
    THEN
      DateDiffWorkdays(
        -- use the Issue 접수일 property here
        [Measures].[Issue Start Date],
        [Measures].[Issue End Date],
        '67'
      )
    END
  ),0
)

When I use Drill‑through on the bar ‘GroupA’, the total number of issues returned is 56, which is far lower than the expected count. All of those issues have a value greater than 0 (i.e., ≥ 1).

Temporary Table Report

Page Filters: Project, Time
Rows: Issue
Columns: Measures

I created a separate calculated measure to verify the count:

CASE WHEN
  DateInPeriod(
    -- use the Issue created date property here
    [Measures].[Issue 접수일],
    [Time].CurrentHierarchyMember
  )
  AND [Measures].[Issue type] = "VOC"
  AND [Measures].[Issue status] = "완료"
  AND (
        [Issue].CurrentHierarchyMember.Get("VOC Level") = "LV1"
     OR [Issue].CurrentHierarchyMember.Get("VOC Level") = "LV2"
     OR [Issue].CurrentHierarchyMember.Get("VOC Level") = "LV3"
     OR [Issue].CurrentHierarchyMember.Get("VOC Level") = "LV4"
      )
  AND [Measures].[issue 설비군] = "GroupA"
THEN
  DateDiffWorkdays(
    -- use the Issue 접수일 property here
    [Measures].[Issue Start Date],
    [Measures].[Issue End Date],
    '67'
  )
END

In this table I can see 130 issues (the same number I obtain from a direct JIRA query). Some rows display a value of 0, but the overall count matches JIRA.

I attempted to wrap the DateDiffWorkdays call with CoalesceEmpty and also experimented with adding a tiny offset (e.g., 0.000001) to force non‑zero results, but the count still drops dramatically (60 instead of 130).

I would like to know how to make the drill‑through on the bar‑chart report display 130 issues instead of 56.
Thank you very much for your help.

Best regards,
NextLife

2

Hi, Something seems off.

What you thinkg this part does in your final calculation?
This should be the key part to the problem you described

Try this instead (if that is date field and imported as measure and dproperty)

CASE WHEN
[Measures].[Issues with 접수일]>0

The following feedback might also change what you see on drill through issue screen

“Some rows display a value of 0, but the overall count matches JIRA.”

If the calculated value is 0, then these tickets won’t be shown in the results, as “drill through issue” feature has automatic “Nonzero” filter for results on screen.

Martins / eazyBI support

1 Like