eazyBI. new measure [Transition Status].[StatusName] * [Measures].[Open issues]

[Alexander Bondarev]

Hello!

I need some help.

I'm having trouble writing a formula to calculate the product of two values: Open issues and Average Dev_Time (old).

I want to create a formula in the "OpenIssues * Dev_Time" column that multiplies the "latest/current count of open issues" [Transition Status].[Dev_Time (old)] by the average time spent on work [Measures].[Open issues].

Can you assist me with this?

[elita_kalane]

Hello @Alexander Bondarev 

Thank you for posting the question!

I suggest defining a new calculated measure (https://docs.eazybi.com/eazybi/analyze-and-visualize/calculated-measures-and-members/calculated-measures) 

with the formula below and checking if it returns the expected results:

CASE
  WHEN DateInPeriod(
         Now(),
         [Time].CurrentHierarchyMember
       )
  THEN
    ([Time].[Month].CurrentDateMember, [Measures].[Open issues])
    * ([Measures].[Average days in transition status],
       [Transition Status].[Dev_Time (old)],
       [Time].[$total_aggregate])
END

Best wishes,

Elita from support@eazybi.com