Cumulative of ticket grouped by every status update date

Questions & Answers
1

I use this measure to calculate the cumulative of ticket grouped by status update date .
But it shows only the last status update date. My objective is to get the number of ticket grouped by every status update date of a ticket
Sum(
{[Time].CurrentHierarchy.Level.Members.Item(0):
[Time].CurrentHierarchyMember},
NonZero(Count(
Filter(
Descendants([Issue].CurrentMember, [Issue].[Issue]),
DateInPeriod(
[Measures].[Issue status updated date],
[Time].CurrentHierarchyMember)
AND
([Measures].[Only Bugs Verified],
[Time].CurrentHierarchy.DefaultMember) > 0
)))
)

And my [Measures].[Only Bugs Verified] is :
(
[Severity].[Critical + Major],
[Issue Type].[Bug],
[Status].[Verified]
)

help

2

Hi,

You may want to use the default distinct measure “Transitions to status issues count” - the issue would be counted to a Time dimension member whenever the issue entered in another status (in other words, it changed the status).

Best,
Ilze , support@eazybi.com