ATM Test execution burn-down chart

[diarra2339]

Hi,
I am trying to get a report showing the test execution burn-down chart, but the calculated members I come up with do not work. I want to display the actual burn down and the ideal burn down on the same report.

Thanks!

[roberts.cacus]

Hi @diarra2339 ,

You can have a look at some burn-down reports in our Demo account, for example, the “Issue burn-down in Epic” - Issues - Jira Demo - eazyBI.

You can then replace the Epic Link dimension in pages with TM4J Test cycle. Then adapt the calculated measures to filter the time in the Test cycle with the planned start and end dates. See an example below:

Case when
  DateBetween(
    [Time].CurrentHierarchyMember.StartDate,
    [Measures].[TM4J Test Cycle planned start date],
    -- latest date - prediction date or release date
    [Measures].[TM4J Test Cycle planned end date]
    )
  or
  DateInPeriod(
    [Measures].[TM4J Test Cycle planned start date],
    [Time].CurrentHierarchyMember
    )
 Then
 1
 End

And filter the report by this measure. To get the total number of tests in the cycle, you can define a calculted measure with the formula below:

Test cases in Cycle

([Measures].[TM4J Test Cases with Test Cycles],
[Time].CurrentHierarchy.DefaultMember)

Then you can define a calculated measure that gets the number of executed test cases with “Passed” status cumulatively:

Passed test cases cumulatively

CoalesceEmpty(
  -- executed test cases passed
  ([Measures].[TM4J Test Cases executed],
  [TM4J Test Result Status].[Pass]),
  -- if empty in curent period display previous period value
  (Tail(Filter(
    PreviousPeriods([Time].CurrentHierarchyMember),
    ([Measures].[TM4J Test Cases executed],
    [TM4J Test Result Status].[Pass]) > 0
  ),1).Item(0),
  ([Measures].[TM4J Test Cases executed],
  [TM4J Test Result Status].[Pass]))
)

To get the number of issues to yet pass, you can use the formula below:

[Measures].[Test cases in Cycle]
-
[Measures].[Passed test cases cumulatively]

Now use the standard calculation “Linear trend” to calculate the actual burn down. Read more about standard calculations here - Create reports - eazyBI for Jira.

Use the formula below to calculate the ideal burn-down:

CASE WHEN
  NOT isEmpty([Measures].[TM4J Test Cycle planned start date])
  Then
  Case 
  When
  -- start with total tests
    DateInPeriod([Measures].[TM4J Test Cycle planned start date],
    [Time].CurrentHierarchyMember)
   OR
-- apply for planed period
    DateBetween(
      [Time].CurrentHierarchyMember.StartDate,
      [Measures].[TM4J Test Cycle planned start date],
      [Measures].[TM4J Test Cycle planned end date]
    )
  Then
  -- total test to burn
   [Measures].[Test cases in Cycle]
    /
    -- total days in cycle
    DateDiffDays(
      [Measures].[TM4J Test Cycle planned start date],
      [Measures].[TM4J Test Cycle planned end date]
    )
    *
    -- days till the end of cycle
    DateDiffDays(
      [Time].CurrentHierarchyMember.StartDate,
      [Measures].[TM4J Test Cycle planned end date])
  End
END

The report then could look similar to the one below:

Best,
Roberts // support@eazybi.com