Calculating few statuses by formula

Questions & Answers
,
1

Hi!
Help me please to build the calculated value
I have the statuses Completed and Closed (besides them - 10 more statuses)
I need to output the value by the formula:
Resault = Completed / (Completed + Closed)
How and where can I do such a calculation?
If I display the Dimension Transition Status in the pages and select the Closed and Completed statuses there, then I see these 2 statuses in the table, but how to make the calculation?

2

Hi @Mitirrol

You may want to create a calculated measure (in Measures) where you calculate the ratio: Calculated measures - eazyBI for Jira.

To create that, you need to choose a measure what you would want to use as a base for the calculation because statuses by themselves do not contain any quantitative information; only measures do, and you must combine them.
For instance, if you want to calculate the ratio based on the count of issues that currently are in those statuses, then use “Issues created” and the Status dimension members. The formula for the measure would be the following then:

CASE WHEN
 (([Measures].[Issues created],
[Status].[Completed]) + 
([Measures].[Issues created],
[Status].[Closed]))>0
THEN
([Measures].[Issues created],
[Status].[Completed])
/
(([Measures].[Issues created],
[Status].[Completed]) + 
([Measures].[Issues created],
[Status].[Closed]))
END

(CASE WHEN construction is needed to avoid dividing by zero)

You may want to watch a video on the principles of how to combine dimensions and measures to create calculations: * MDX ABC: Let’s start at the very beginning

Best,
Ilze, support@eazybi.com