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

Alexander Bondarev
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
October 25, 2023

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].

 

Снимок экрана 2023-10-25 в 13.45.34.png

Can you assist me with this?

1 answer

0 votes
elita.kalane
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
October 26, 2023

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

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events