Count Bugs based on Epic's Due date

Questions & Answers
, ,
1

Hi Team,

I’m some issues for my below use case
I need count bugs by Epics

I have epics with Due Date and bugs under them.
currently I have created issues By Epic and Bug as filter and issues created measure is working complete fine

but I would like to limit Epics whose due date is current month. I couldn’t create Calculated member as it requires Time dimension and eazybi is not allowing the same

Kindly help on the same

thanks in advance,
Simon

2

Hi @Leo,

A straightforward way to display the Epic due date at all levels below it is the following calculated measure:

Ancestor([Issue.Epic].CurrentMember,[Issue.Epic].[Epic]).Get('Due date')

With the Time dimension in report pages, you can define the following calculated measure to allow filtering by Epic due date:

CASE WHEN
  DateInPeriod(
    Ancestor([Issue.Epic].CurrentMember,[Issue.Epic].[Epic]).Get('Due date'),
    [Time].CurrentHierarchyMember
  )
THEN 1
END

You can then filter the report rows by this calculated measure - Create reports.

To view the number of Bugs unrelated to the selected Time dimension period, I recommend the following calculated measure:

([Measures].[Issues created],
[Issue Type].[Bug],
[Time].CurrentHierarchy.DefaultMember)

You can filter the report rows by this calculated measure as well. The report could look similar to the one below:

SCR-20240426-npxc
SCR-20240426-npxc1656×1276 314 KB

Best,
Roberts // support@eazybi.com