nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

EazyBI: Measure to count issues that are created and due/expiring in the same month.

Marc Lim

Hi, I'm new to mdx language and eazybi in general. I would like to filter my issues across a time period of 12 months. The issues displayed per month should only be those that are created in that month and due for expiry in the same month. E. G for the month of Feb I would want to see all issues created this month, which have a due date in the month of Feb.

Would appreciate some help on this as I'm not sure where to start. Thanks in advance for advices/pointers!

Accepted answers

Roberts Čāčus - eazyBI

Hi @Marc Lim ,

To create the report you are looking for, try to put the Time dimension on rows with "Month" level selected. To get the count of issues, try to create a new calculated member in the Measures dimensions, please have a look a the formula below:

Sum(
  Filter(
    Descendants([Issue].CurrentMember,[Issue].[Issue]),
    DateInPeriod(
      [Measures].[Issue created date],
      [Time].CurrentHierarchyMember
    )
    AND
    DateInPeriod(
      [Measures].[Issue due date],
      [Time].CurrentHierarchyMember
    )
  ), [Measures].[Issues created]
)

The report could look similar to the one below:

Screen Shot 2019-09-11 at 16.03.58.png

Kind regards

Roberts // eazyBI support

All comments

Sekhar Chandra_xjd9n5

Hi Marc

You can use JQL query for what type of issues you want to get into a list. Write a JQL in Issue Navigator window, search bar .

I provide a sample example query for your reference. I hope this would help you.

Please replace the dates as you require.

"created >= 2019-07-01 AND created <= 2019-07-31 AND due >= 2019-7-1 AND due <= 2019-7-31 order by created DESC"

Chandra

Roberts Čāčus - eazyBI

Hi @Marc Lim ,

Sum(
  Filter(
    Descendants([Issue].CurrentMember,[Issue].[Issue]),
    DateInPeriod(
      [Measures].[Issue created date],
      [Time].CurrentHierarchyMember
    )
    AND
    DateInPeriod(
      [Measures].[Issue due date],
      [Time].CurrentHierarchyMember
    )
  ), [Measures].[Issues created]
)

The report could look similar to the one below:

Screen Shot 2019-09-11 at 16.03.58.png

Kind regards

Roberts // eazyBI support

Marc Lim

Thank you kindly for the reply. The answer worked.

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira

eazybi