Hi, I made a simple report to better understand Time Filter with Sprint, but i don’t understand, it seems Time FIlter doesn’t apply (see screenshot). I put on the Report only Dimension Sprint, Time on Page and Sprint End Date.
How is made the context for Sprint?
Hi @Marco,
Thanks for posting your question!
The problem arises because there’s no measure included to give the report context and connect the properties to the dimensions selected in the Page filters.
I understand it can be confusing since properties (like “Sprint End Date”) are listed under “Measures” in eazyBI, but think of it this way: a property provides descriptive information (like issue status or end date), whereas a measure provides a numerical value (like the number of issues created or the number of issues with due date).
Page filters work by applying conditions to measures. To fix your report, I suggest selecting a measure, e.g., “Sprint Issues completed,” left-clicking on it, and applying “filter rows” > 0. This will ensure you only get “Sprint end date” results where the measure is returned.
Alternatively, you can create a new calculated measure (instruction here: Calculated measures and members) using the following code & choosing Formatting → Numeric → Integer:
CASE
WHEN
DateInPeriod(
[Measures].[Sprint end date],
[Time].CurrentHierarchyMember
)
THEN
1
END
Once you select this new calculated measure in your report, you will also need to left-click on the name of it and apply “filter rows” > 0.
Please note that the “Sprint end date” reflects the planned end date of the sprint. Choose the “Sprint actual end date” property to see the date and time when the sprint was completed. You can read more about Sprint scope measures here: Jira Software custom fields
To put it simply, the measure acts as a link between dimensions and properties. A property is connected to a measure, and the measure, in turn, is connected to both the dimension and the property. If you try to filter properties using just dimensions, it won’t work because the necessary context (what you’re trying to count or measure) is missing.
Best,
Marita // support@eazybi.com
Hi @Marita_Burgio many thanks,
yes your answer is useful, I will try with the calculated Measure.
Is there any way to understand if a “word” under Measure menu is a Measure or a Property?
Marco
