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