It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

eazyBI percentage of pie chart in a table

Nuria Llobera Vila Dec 27, 2017

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
Answer accepted
Mārtiņš Vanags Dec 28, 2017

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

Nuria Llobera Vila Dec 28, 2017

thanks! that worked!

Suggest an answer

Log in or Sign up to answer
This widget could not be displayed.
This widget could not be displayed.
Community showcase
Published in Marketplace Apps & Integrations

Join our webinar: “Asset Management: The Role of Context in ITSM” with Atlassian & Riada

  Hi Atlassian Community! This is Teresa from the Jira Service Desk team. On June 19th, I’ll be hosting a webinar “Asset Management: The Role of Context in ITSM” with Atlassian Partne...

111 views 0 2
Read article

Community Events

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

Find an event

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

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you