Hours spent percentage by project in one report

Questions & Answers
,
1

Hello
can you please help me out.

I want to create a report that will show percentage of hours spent on production and non-production and calculate percentage per project.

I managed to create such report for 1 project, but if I add 2 or more projects it calculates percents from overall sum for all projects.

How can I make it to calculate production and non-production share from 100%/ for each project?
I tried to add screenshots but it’s not allowed since I’m a new user.

2

Hi @Murad1,
Welcome to the eazyBI Community :wave:

Can you share how you identify the production and non-production? Is there some custom field value on the issue? If so, try this calculated measure in the “Measure” dimension to identify the production value percentage.
Change “CUSTOMFIELD NAME” to the field name you have in your eazyBI:

CASE WHEN 
  ([Measures].[Hours spent],
  [CUSTOMFIELD NAME].CurrentHierarchy.DefaultMember)>0
THEN
  CoalesceEmpty(
    ([Measures].[Hours spent],
    [CUSTOMFIELD NAME].[Production]),
    0)/
    ([Measures].[Hours spent],
    [CUSTOMFIELD NAME].CurrentHierarchy.DefaultMember)
END

Don’t forget to change the measure formatting to percentage: Calculated measures

best,
Gerda // support@eazybi.com