Count number of transitions to “Analysis” status during all weeks after the current one

Questions & Answers
1

Hello,

I use a calculated member to count and to display “how many times during selected Time dimension period issue has been transitioned to the status that is selected in Transition Status dimension”
([Measures].[Transitions from status], [Transition Status].[Analysis])

How can I count the same during an other time dimension period? I need to count that from next time ( [Time].CurrentMember.NextMember) and now().

The final usage is to have a report with:
Rows: Issue and Time (all members at level Week)
Columns: 2 measures:

  • Number of transitions to “Analysis” status during the week
  • Number of transitions to “Analysis” status during all weeks after the current one

Thanks in advance !
Chat’

2

Hi @chatDef,

You might want to define another calculated measure to count transitions after the selected period till now. For the calculations, use aggregate function Sum() and define the interval for periods that follow the current period. The formula for calculated measure might look like this:

Sum(
  --set of weeks from the next member till the week of the current date
  { [Time].CurrentHierarchyMember.NextMember:
    [Time].CurrentHierarchy.Level.CurrentDateMember },
  [Measures].[Transitions to status]
)

Best,
Zane / support@eazyBI.com

3

Hi @zane.baranovska,

Thanks for your feedback.
I finally was able to test your solution: it is doing the job.

Best
Chat’