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

Accepted Answer
0 votes

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
Community showcase
Posted Oct 11, 2018 in Marketplace Apps

You + one app + a desert island...

Hi all! My name is Miles and I work on the Marketplace team. We’re looking for better ways to recommend and suggest apps that are truly crowd favorites, so of course we wanted to poll the Community. ...

3,197 views 6 6
Join discussion

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