Hi Everyone,
I have a scenario where we are using some epics to track compliance intent, we have one feature created where many teams are linking their work to. The problem is that we need to know which are the teams that have yet created their stories so it can be easier to follow up.
My current approach is using a Label per team in an epic level, convert it to a string, and later, compare it to a string that pulls all the teams that have created stories underneath that epic.
I can successfully compare them and get a Yes/No answer if the string matches, however, what I’m missing is displaying who are the ones that are missing. I was able to go through this community and re-use some code to my needs but I was not able to find this same scenario, so any help will be really appreciated!
Converting epic labels into one string:
Generate(
– iterates through all labels which are assigned to issues
Filter(
[Label].[Label].Members,
[Measures].[Issues created] > 0
AND
[Label].CurrentMember.Name <> “(none)”
),
[Label].CurrentMember.Name,
', ’
)
Getting the Team field from all child stories
Generate(
Filter(
Descendants([Team(TIR Official)].CurrentMember, [Reporter].[user]),
(
[Measures].[Issues created],
[Time].CurrentHierarchyMember.DefaultMember
)>0
AND
[Team(TIR Official)].CurrentMember.Name <> “(none)”),
[Team(TIR Official)].CurrentMember.Name,’, ’
)
Comparing Strings together to a YES/No Match
CASE
WHEN
[Measures].[Affected Teams (Labels)] MATCHES [Measures].[Teams with stories]
THEN
“No”
ELSE
“Yes”
END
Identifying missing teams
??? (this is where I need help )