eazyBI percentage of pie chart in a table

[Nuria Llobera]

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

[Martins Vanags · Accepted solution]

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).

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

Best regards,

Martins / eazyBI support

[Nuria Llobera]

thanks! that worked!