How to aggregate child from same/different parents

Questions & Answers
1

Greetings,
in my organization we use a field to classify the type of problem.
This field is configured in two languages (ITA and ENG) and depending on the project the labels are in different languages.
When I import into EazyBI and try to group by classification, I naturally have the following situation:

  • For parents with the same label in Italian and English (e.g. “APP”) I have two children lines for the same case series (one in Italian and one in English).
  • For parents with different labels in Italian and English (e.g. “Administrative Management” (ENG) / “Gestione Amministrativa” (ITA)) I have two different parents and the children each under their own parent.

What I would like to do is aggregate all the children and parents under one voice in English.

So I need to know how I can:
aggregate two children under the same parent and display a row with the sum of the two values.
aggregate children from two different parents and display them as a single row under one parent.

Thanks in advance

image
image825×533 45.5 KB

2

I managed to rename the parents to have a single label in English for each category.
But now I can’t change the child values, the same path doesn’t seem to work

image

3

I solved

if (issue.fields.customfield_19500!==null)
if (issue.fields.customfield_19500.child!==null && issue.fields.customfield_19500.child!==undefined)
if (issue.fields.customfield_19500.child.value=="ITA") issue.fields.customfield_19500.child.value="ENG"
else if ......
else return null
else return null
else return null