[JIRA 6/ eazy BI]

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!

1 answer

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 

Hi Lauma, it's a bit tedious to systematically have to hard-code the "filter" because all the features ("Pages" for example) are not working as expected. Is there an easy way to just calculate a ratio in column C based on column A/ column B? Thanks again for your help Lauma :)

Hi Jerome, It is not always necessary to hardcode filters; in this case I imagined it would give better look for the report. Do you have other issue types or just these two? Also is Days spent a calculated measure? Would it be possible to send the report definition (https://docs.eazybi.com/display/EAZYBI/Create+reports#Createreports-Exportandimportreportdefinitions) for me to support@eazybi.com? From definition I could see how report is now defined and suggest other changes. Could you please give me some more specific example of when the Page filters do not work as expected as well so I could assist to resolve this. Kind regards, Lauma

Hi Lauma, Sorry for this late answer. In this case I've filtered issue type (two calculated members) to have only two. Days spent is also a calculated member. I've sent you the report definition. Something that would really be nice is to a have a ratio calculated from A/B whatever is A and B. That way I would be able to compare bugs/total time, project/total time, bugs/projects and so on.

Hi Jerome, Thanks for the details! I just sent you a reply in email about possible changes in your report. Kind regards, Lauma

Hi Lauma, Thanks for your feedback. It's certainly improving my report but it does no entirely solve the issue. I will manage to do it "hardcoded' way!

Suggest an answer

Log in or Sign up to answer
How to earn badges on the Atlassian Community

How to earn badges on the Atlassian Community

Badges are a great way to show off community activity, whether you’re a newbie or a Champion.

Learn more
Community showcase
Published Monday in Jira Software

How large do you think Jira Software can grow?

Hi Atlassian Community! My name is Shana, and I’m on the Jira Software team. One of the many reasons this Community exists is to connect you to others on similar product journeys or with comparabl...

727 views 6 13
Read article

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you