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

0 votes
Accepted answer

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
Published Nov 29, 2018 in Marketplace Apps

How to set up an incident workflow from the VP of Engineering at Sentry

Hey Atlassian community, I help lead engineering at Sentry, an open-source error-tracking and monitoring tool that integrates with Jira. We started using Jira Software Cloud internally last year, a...

1,438 views 0 8
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