How to calculate count of issues in current customfield history step

Questions & Answers
, ,
1

Hi, dear community, could you please help me with calculating customfiled history.

I,m want to see 2 columns:

  1. How many issues was in current customfield value on end of period
  2. How many issues was in current customfield value on end of period and was in this value stay more than 48 hours

For first measure I,m create that calculation:
([Measures].[Issues history], [Transition field].[Шаг], [Шаг].[03.00 BSC ПРОВЕРИТЬ И ПРОВЕСТИ ДАННЫЕ В СИСТЕМЕ])

Can you please help me with second?

Thx!

2

Hi @tumcat

Please try this code for your calculated measure in 2nd requirement:

NonZero(
Count(
Filter(
Descendants([Issue].CurrentHierarchyMember,[Issue].[Issue]),
--difference between last transition to last timestamp and currentmember.nextstartdate timestamp is more than 48h
Datediffhours(
  Timestamptodate(
    (
      [Measures].[Transition to last timestamp],
      [Transition Field].[Шаг],
      [Шаг].[03.00 BSC ПРОВЕРИТЬ И ПРОВЕСТИ ДАННЫЕ В СИСТЕМЕ],
      [Time].CurrentHierarchy.DefaultMember
    )
  ),
  [Time].CurrentHierarchyMember.NextStartDate
)>48
AND
  (
    [Шаг].[03.00 BSC ПРОВЕРИТЬ И ПРОВЕСТИ ДАННЫЕ В СИСТЕМЕ],
    [Measures].[Issues history],
    [Transition field].[Шаг]
  )>0

)
)
)

But make sure that “Nonempty” crossjoin is enabled to make this calculation efficient.
https://docs.eazybi.com/eazybijira/analyze-and-visualize/create-reports#Createreports-Pagedimensions

It should count issues only if they stayed in the specific custom field value for more than 48h.

Martins / eazyBI support