EazyBI - Filtering

[Todd Palermo]

Hello, I am new to Jira and EazyBI and I am having trouble getting the graphs that I am interested in. In Jira I can filter exactly what I want but I am having a hard time graphically showing the data. My JQL looks like: status in ("In Progress", "Not Ranked") AND "Problem Rank" = Medium AND "Rank Date" <= -30d AND "Temp C/M Date" is EMPTY, Where Problem Rank is a select list and the dates are of course date pickers. Is there a way to have EazyBI work with saved filters or use this kind filtering? I want a bar graph showing issue count per month. Thanks!

[Janis Plume _eazyBI_]

Hi Todd,

I would start thinking of the implementation of such report from the end of your case description since the need to report by months is a game changer.

The Issues history measure is usually needed if the report needs Time dimension (per month). This measure gives the historical counts of issues at the end of the selected period in the Time dimension. The Issues history measure combined with the Transition status dimension shows the count of the issues per status. You can select to show only the statuses "In Progress" and "Not Ranked" to show in the report and switch the report to the bar chart view (please, find here a similar example: https://eazybi.com/accounts/1000/cubes/Issues/reports/50046-history-of-unresolved-issue-statuses.

You can import the "Problem Rank" custom field as a separate dimension (https://docs.eazybi.com/display/EAZYBIJIRA/Custom+Fields). Then if you add the "Problem Rank" dimension to the report pages, you can filter the issue counts by Problem rank.

Finally, the need to filter historical data of issues by the custom date fields is what makes the solution more difficult and might be a reason for the performance issues. A custom measure should be created with the calculation like this:

nonzero(count(
 Filter(Descendants([Issue].CurrentMember,[Issue].[Issue]),
 isempty([Issue].CurrenthierarchyMember.get('Temp C/M Date'))
 and
 Datediffdays(
 [Issue].CurrentHierarchyMember.get('Rank Date'),
 Now()
 ) > 30
 and
 [Measures].[Issues history]>0
 )
))

For this calculation to work, you need to import both custom date fields as properties. My example report looks like this (not to use your statuses and add the Problem rank dimension to the report pages):

Kindly,

Janis, eazyBI support