Hi.
I want to make the time axis on the left, between the release dates of “A Fix Version” and “B Fix Version”.
Total
B0
B1
F2
G3
H4
Issues
Issues
Issues
Issues
Issues
Issues
Sep-20
All Project
Design
0
0
0
0
0
0
Oct-20
All Project
Design
0
0
0
0
0
0
Nov-20
All Project
Design
0
0
0
0
0
0
Dec-20
All Project
Design
0
0
0
0
0
0
Jan-21
All Project
Design
0
0
0
0
0
0
Feb-21
All Project
Design
0
0
0
0
0
0
Mar-21
All Project
Design
0
0
0
0
0
0
Apr-21
All Project
Design
0
0
0
0
0
0
May-21
All Project
Design
31
0
0
0
0
0
Jun-21
All Project
Design
389
38
27
122
0
3
Jul-21
All Project
Design
781
38
30
156
0
335
Aug-21
All Project
Design
781
38
30
156
0
335
So I create filter in “Time” dimension like this.
Aggregate(
[Time].[Month].DateMembersBetween(
[Fix Version.By name].[A].Get(“Release date”),
[Fix Version.By name].[B].Get(“Release date”)
)
)
But I don’t see any date.
Can you help me?
You are on the right track with the idea, but, instead of calculated Time member, you may want to create a measure (in Measures) that marks with 1 each time member that is between two dates (in your case, release dates for two versions). Then you would select the TIme dimension in rows and filter rows by that measure.
If you use Jira Software reports in eazyBI, the solution is similar to sprint reports, where the measure “Time within sprint” is used to filter sprint time.
The formula would be the following (use correct fix versions!):
CASE WHEN
DateBetween([Time].CurrentHierarchyMember.StartDate,
[Fix Version].[DEMO 001].[Unreleased].[Version A].GetDate('Release date'),
[Fix Version].[DEMO 001].[Unreleased].[Version B].GetDate('Release date'))
THEN 1
END
Use this measure in columns and Time dimension in rows (weeks, months, days, as you need). Then filter rows by the measure >0 , after that you may remove the column, the filter condition will remain:
Thank you!
But I want get “Release date” of A Version whether Unreleased or Released.
“[Fix Version].[DEMO 001].[Unreleased].[Version A].GetDate(‘Release date’)” is only success if Version A is unreleased.