How to add custom measure for count of rows?

[tsusa]

Including screenshots of the report I’m trying to modify. Wondering if it is possible to create a custom measure that would display a new column that returns the row count of 22 (as shown in screenshots)

Thanks in advance

[VasileS]

Hello @tsusa,
Use the predefined measures like “issues created”, etc.

I could not tell from your snips, but if the 22 tasks are just a subset of the tasks in the selected period (e.g. Jan 2024) you may want do a calculated (custom) measure - check [Measures].[Open issues]:

V.

[tsusa]

Hi @VasileS. Thanks for the quick reply.

The issue with using Issues Resolved is that it gives me a value of 28, where the row count of my custom measure is 22. My guess is that the custom measure only includes resolved tickets that have visited statuses between In Progress and Closed. Here is that calculated measure

NonZero(SUM(Filter(
  Descendants([Issue].CurrentHierarchyMember,[Issue].[Issue]),
  (
    [Measures].[Transitions to status],
    [Transition Status].[Closed]
  )>0),
  Datediffdays(
    (
      [Measures].[Transition to status first date],
      [Transition Status].[In Progress],
      [Time].CurrentHierarchy.DefaultMember
    ),
    (
      [Measures].[Transition to status last date],
      [Transition Status].[Closed]
    )
  )
))

[VasileS]

I think I get your problem!
You need to COUNT the issues that matches your criteria ( transitioned from “in progress” to “closed”) within the current period.

NonZero(COUNT(Filter(   -- COUNT instead of SUM
  Descendants([Issue].CurrentHierarchyMember,[Issue].[Issue]),
  (
--   FILTER CONDITION: DateDiffDays(in progress->Closed) > 0
  Datediffdays(
    (
      [Measures].[Transition to status first date],
      [Transition Status].[In Progress],
      [Time].CurrentHierarchy.DefaultMember
    ),
    (
      [Measures].[Transition to status last date],
      [Transition Status].[Closed]
    )
  )
  )>0)
))

Hope it helps!
VasileS

[tsusa]

@VasileS That worked!!! Thank you!!

[VasileS]

Great!
Please mark this as solved, it may help other colleagues in the future!
V.

[martins.vanags]

Hey y’all

You could try this simpler formula, which should return the count of issues that made specific transition
It must calculate results much faster.

  (
    [Measures].[Transitions to status issues count],
    [Transition Status].[Closed]
  )

Martins / eazyBI support

[tsusa]

Good to know @martins.vanags . However, I think we are looking for count of issue that have started in In Progress Status AND reached Closed status

[martins.vanags]

@tsusa

In that case, you need to stick with the previous calculation formula.

Martins / eazyBI