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!
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:
[Measures].[Issue created date],
[Measures].[Issue due date],
), [Measures].[Issues created]
The report could look similar to the one below:
Roberts // eazyBI support
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"
Connect with like-minded Atlassian users at free events near you!Find an event
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no Community Events near you at the moment.Host an event
You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events