[JIRA 6/ eazy BI]

Jerome Renaud

Hi all,

I'm still struggling to add a single ratio column.

What I want to achieve is something like that

Developer (logged by) |  time spent in bugfix | time spent in projets | ratio bug fix/projets

I've tried to do it defining a new calculated measure called "ratio" and defined as described in my previous question (https://answers.atlassian.com/questions/9389329)

So my row data is "Logged by", first column measures with two calculated fields ("time spent","ratio"), second and last column is "Issue Type" (with two calculated fields aggregating issue types called 'bugs' and 'project).

The issue is that then I have the ratio column twice like that

Days spent        | ratio

bugs | project   | bugs | project

Of course "sub-column" ratio/bugs and ratio/project are the same.

How can I fix that ?

Thanks for your help!

Lauma Cīrule

Hi Jerome!

From you description I understand that you are also using Issue Type dimension on columns. This creates separate column for Days spent for each issue type and then does the ratio calculation for each Issue type as well. 

In this case it would be easier not to use the Issue Type on columns, but use the previously defined calculated members with overriding default Issue Type and saying for which type we want to see days spent with tuples as described earlier. Then each of Days spent measures can used in the new formula for ratio.

Let me know if you have additional questions!
Lauma