I try to obtein the number of issues when the value “fecha de entrega” is minor that de date´s row.
I created a new measure like this, but doesn´t work.
Not IsEmpty([Measures].[Issue Fecha de entrega]) --custom field imported as property and filter
[Measures].[Issue Fecha de entrega] <= [Time].DefaultMember --numeric measure for filter
Which is the error?
Using MDX calculation, for operation with date, you may want to use specific functions; mathematical equivalences works with numbers only. For comparing dates, use function DateCompare() as described in documentation: https://docs.eazybi.com/eazybi/analyze-and-visualize/calculated-measures-and-members/mdx-function-reference/datecompare
Additionally, while [Measures].[Issue Fecha de entrega] most likely returns a date (if it is a property from date custom field), [Time].DefaultMember is a member, not date.
To get a date from a Time dimension member, you would use, for instance, function .StartDate (to get the first date from this time member), but it won’t work with [Time].DefaultMember. I am not sure what date you wanted to compare with Fecha de entrega date. Probably, [Time].CurrentHierarchyMember.StartDate (the start date of the selected time member)?
[Measures].[Issue Fecha de entrega],
would mean that issue Fecha de entrega is before or equal with the start date of the selected time period.
Ilze / firstname.lastname@example.org
I have a this measure:
– filter issues having a particular transition during an active sprint
[Measures].[Issues history] > 0
CoalesceEmpty(DateCompare([Measures].[=> Ready To Deploy Date],[Measures].[Sprint start date]),0) >= 0
DateWithoutTime(([Measures].[Transition to status first date],[Transition Status].[Refined Backlog],[Sprint].CurrentHierarchy.DefaultMember)),
DateWithoutTime([Measures].[Sprint start date])) <> 0
The measure => Ready To Deploy Date = ([Measures].[Transition to status last date],
[Transition Status].[Refined Backlog],
It should be granted 12 issues but it throws me 0
It is supposed to bring me the issue type stories that were “carried over” from the previous sprint
My statuses are backlog, Refined Backlog, In Progress, Ready to Deploy, Deploy, Done
And I want to take the measure of the sprint from refined backlog to Ready to Deploy