Hello Community! Hope you are all doing well.
I need to know how much time I am spending with different clients.
Client is a custom field that I only fill in the Epic level, so I’m not being able to summarize those values in the task level since the Client custom field is not filled in the Task or sub-task level.
That Client custom field is already available in the EazyBI and working fine.
Any thoughts?
Thanks!
Welcome to community, @LucasPellizon
In this case, you could use Javascript in advanced settings to import the inherited custom field - copy field “Client” values from Epic to Children.
https://docs.eazybi.com/eazybi/data-import/data-from-jira/jira-custom-fields/javascript-calculated-custom-fields#JavaScriptcalculatedcustomfields-Inheritedfielddimension
Just be careful with the Javascript functions, as some custom field types require .value to return the right. You can validate the script (before using it in advanced settings) for one issue key
See similar discussion here: Filtering on Program Increment at Epic Link level - #2 by zane.baranovska
Then you could use the new “Epic Client” field in your reports with measure “Hours spent” and all hours would be grouped by the client of the epic.
But this approach would work only with single-select Jira custom fields (one value per field)
Martins / eazyBI support
Thanks, Martins! Works like a charm 
The problem I’m facing now is that for some issue types that are not related to Epic (like a bug), this custom field(client) is returning (null) instead of the current value.
Is there someway to keep the filled value instead of overwriting it with the Epic value?
Tks!
Why don’t you instead try creating new calculated measure - to add the results from issues without Epic Client
[Measures].[Issues created]
+
(
[Measures].[Issues created],
[Client].[Client].Getmemberbykey(
[Epic Client].Currentmember.key
),
[Epic Client].[(none)]
)
Martins / eazyBI