eazyBI percentage of pie chart in a table

Hi,

I use the pie chart to show how much time has been spent in each epic. For that I can show the hours spent, but I am interested in showing the percentatge of hour spent for each epic. I can get this using the pie chart, but I would like to have the percentage in a table form. How can I do it?

Thank you

1 answer

1 accepted

Hi Nuria,

 

In this case, you could create a new calculated member in "Measures" dimension with (% formatting) using the following code:

 

[Measures].[Hours spent]
/
(
[Measures].[Hours spent],
[Issue].CurrentHierarchy.Defaultmember
)

 

It should calculate the percentage of all epics if appropriate percentage formatting is used (see attachments).

 

integer percentage.png

 

Epics with percentage.png

Note that this approach requires importing "Epic Link" via eazyBI import settings

 

 

Best regards,

Martins / eazyBI support

thanks! that worked!

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 May 30, 2018 in Marketplace Apps

Three tips for boosting your board's efficiency with Story Maps

Trello is one of the most effective tools for driving your sprints. It's customizable for every Agile team and product owners and Scrum masters (SM) love it. However, Agile teams often struggle with:...

830 views 2 9
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