But I have a problem, I have 2 projects: in first I have issues called employees and one issue per one user with user field ‘Employee’ and string field ‘Team’
In Second project I have issues for assignee and also field ‘Team’ is used. When You assign issue on me - script will take ‘team’ field from my employee issue.
Assignees starts to duplicate in teams (Because it looks through all issues)
I can check “Hide empty” but in that case I won’t be able to see members of team until they start work or other activity. But I want to see “0” instead like this.
Make sure that “Nonempty” cross join is enabled for your report rows.
If that didn’t help, please share more details about the the formula you use for the user-defined measure in your report.
I didn’t mean to select “Hide empty” from toolbars but “Nonempty” cross join (and leave hide empty turned off) to show only assignees that belong to report context.
It Does not work
I want to see empty dates, I want to see empty teams. If I will check
I want to see members of this teams with no issues. I need to show users that belongs to teams only
This is what I have now
You are right, this didn’t help.
A different approach is needed in your case.
Try creating one more calculated measure that would add the connection for the issue with team name and Assignee except Time dimension.
Then disable “Nonempy” crossjoin but use the filter in your report rows New measure > 0.
Once filter is enabled, it is safe to remove this column from the report (filter should remain).
That should show only those correct assignees for each team.