Filter query for specific issues

Filter query to filter only issues with sprint value(sprint is not empty) and status=“completed”

I have written one, but it is not correct.
Filter(
Descendants([Issue].CurrentMember, [Issue].[Issue]),
[Measures].[Issue Sprint] <>"" and
[Measures].[Issue status] =“Completed”
)

Please help by nudging in right direction.

Hi Ajain,

Could you give some more details about the context of the report?

  • Are you creating this in Issues dimension to group the issues matching the filter? In this case, Aggregate(…) function would be necessary around the returned set to group the issues.
  • Or you can Count(…) the issues matching filter if you create a new Measure.
  • Or is the Filter returning an incorrect value in some context? Usually, also some Measure would be used (not only Sprint and Status, which are properties) for the filter to work in all report context.

Lauma / support@eazybi.com

Is there a easy like writing a JQL(Jira Query Language) to quickly filter only those issues which I know I need.

My requirement is to get only those issues which are part of any sprint and in complete state.

There should simpler way for writing filters in eazybi.

Hi Ajain, Sorry for the late reply!

eazyBI is re-organizing JIRA data (for reporting needs), so it will not be possible to use JQL. In eazyBI, there are many ways of data filtering (using Page dimensions, filtering by name or value when you click on table headers or using MDX formulas), and I agree that it can take some effort to find the one that fits best for each report.

In the case you described, I imagine the best would be to add Status dimension to pages and select ‘Completed’. In such way, you will only show the issues in the Completed state.
Further, if you have issues on rows, you can add ‘Issue Sprint’ property and filter issues that do not match ‘(no sprint)’. See the screenshot

Note that the ‘Issue Sprint’ column can be removed after adding a filter, the filter remains.

Lauma / support@eazybi.com

What if you have a value that don’t show any values? I tried with NULL, Null, EMPTY, leave it blank. Any suggestions?

Hi @Daniel_Luevano!
To get all empty values, you can use the following regular expression: not matches .
This means that cell value does not match any symbol or is blank.

Lauma / support@eazybi.com

1 Like

Hi Lauma,
How can I filter out all issues created before a specific date? It is possible to do this by limiting the data that are imported, but I would need it only in one report.
Can I only report on all issues with a specific status? Without adding it as a member. I don’t want to show it on the report.
best regards,
Henk

Hi @Henk!

If you are using Issues on rows, you can use the Issue properties on columns and by clicking on column name add the filters; see more about dynamic date filtering in the documentation (https://docs.eazybi.com/display/EAZYBI/Date+filters):

Lauma / support@eazybi.com

Hi Lauma,
OK, filtering on create date is clear now. Thank you.
But I’m having trouble to filter on the status. For our integration projects, I want to calculate the average time for a complete integration for those integrations that went into production that month. I don’t want to count the days we had to wait for client tests. So, I want a report with the sum of the average days in certain statuses for issues that reach a certain status that month.
I created a report with the “transition status” measure in columns for which I select only the appropriate statuses that I want to count for the total integration time. When I select the “average days in status” measure, I get the all the averages for all the statuses. I then select the “total for columns” option, which gives the sum of all the averages. Great.
Now I need to filter the issues that have reached certain statuses that month.
I don’t think I can use the status measure because I need the historical status, I assume.
Should I create an new calculated measure and use a case expression?
I would appreciate an example.
Thank you,
Henk

I ment “conditional statement”.

Hi @Henk!

I would suggest you filter all issues that have transitioned to the statuses in the period of time and then add the days in status for the status group you are interested in. A similar example is here Lead + cycle time to replace JIRA Control Chart.

Let me know if that helped or if you have further questions regarding this!
Lauma / support@eazybi.com

Hi Lauma,
I’m sorry for the late reply. No I did not solved it until now.
I’ve studied some MDX (-: and I’ve made some progress. I was afraid, that my use case wasn’t clear, so to be clear I’ve opened a new topic.


Regards,
Henk

1 Like