in above measure I am calling another measure to filter issues after certain date
then I have another measure in report to show issues moved to sizing after date defined in date limit measure as below:
now I want a report where I can use time dimenstion for the issues when ticket moved to UAT, as in above report I am already using time dimenstion with status moved to sizing then I don’t know how to use this time filter for status moved to UAT along with report to still filter issues moved to Sizing after a certain date.
Could you please help me on this? @zane.baranovska@gerda.grantina
The time dimension filter would generally impact the timeframe for transitions within the measure “Date limit BQ”
You might reset the Time dimension context for the measure, by adding the reference to the Time dimension .defaultMember within the expression.
The updated expression for the “Date limit BQ” might be as follows.
Datecompare(
([Measures].[Transition to status first date],
--resetting the Time context
[Time].CurrentHierarchy.DefaultMember),
"Jan 10 2024"
)
However, this construction does not explicitly state what status transition should be taken into account. Therefore the issue creation date is taken as the first transition to any status unless you have added the Transition status to the page Filter.
I suggest adding the explicitly named status within this measure to clearly define the considered status transition.
Datecompare(
([Measures].[Transition to status first date],
--resetting the Time context
[Time].CurrentHierarchy.DefaultMember,
--explicitly named transition status
[Transition Status].[Sizing]),
"Jan 10 2024"
)
Now, you can use the Time and Status filters without affecting the “BQ filtering measure”.