Trying to filter reports based on the application and releases that have a prod date within fiscal year 2021 and 2022. When I used the Time dimension it affected the open and closed dates (see below). But I need to filter off the release prod dates in reference to the fiscal years.
I then attempted to manually enter the release prod dates since they are not stored in any JIRA fields and then filter off those dates. This gave me the correct applications and releases that had prod dates for each fiscal year but now I’m stuck. I need the report to show this but not the PROD Date column. Is there a way I can link these prod dates to the specific application and releases and then filter off of that? Or is there any other method I can do?
Hi @Alyssa_A,
With the Time dimension in the report, each measure returns results respective of their relation to it. For example, the measure “Issues created” will return the number of issues created in the respective period. Likewise, “Issues resolved”, the number of issues with a resolution date within the Time dimension period. For more details, please visit the eazyBI documentation page - Jira Core measures and dimensions.
Suppose you want the Time dimension to affect only the Fix Version dimension, and not the measures. In that case, reset the context set by the Time dimension for these measures by defining a new calculated measure. See an example below for “Issues created”:
([Measures].[Issues created],
[Time].CurrentHierarchy.DefaultMember
To see the Fix Versions set to release in the period selected in the Time dimension, define a new calculated measure with the formula below:
IIf(
DateInPeriod(
[Fix Version].CurrentHierarchyMember.Get('Release date'),
[Time].CurrentHierarchyMember
),1,0
)
Then you can filter the report rows to display only relevant releases. Please see an example of the report below:
You can see another approach to this on our demo account - Version releases - Issues - Jira Demo - eazyBI. Please see its description for more details.
Best,
Roberts // support@eazybi.com
