Structure ALM: How to parse out field values and create a new field ?

[Rita Arellano]

Hello All, 

I want to extract field values and create a new column with only some, not all, of those values. Currently, I can retrieve the necessary values from the teams and apply them at the epic level, but I'm getting all values when I only need one value per column. 

Below query gives me all the team's values (LOEs) under a column. I only want one value per team under the new column. 

How can I extract the values and isolate one for each relevant team?

[Stepan Kholodov _Tempo_]

Hello @Rita Arellano 

If you only want to extract a value from one Story that has a certain parameter in it(like Summary in your example), you can do it with a formula like this:

stories.filter($.summary = "Team A").loe

I hope this helps. If you have more questions about Structure, please reach out to us directly at our support portal.

Best regards,
Stepan
Tempo (the Structure app vendor)

[Rita Arellano]

Hi @Stepan Kholodov _Tempo_ 

Thanks for reaching out. I have tried your suggestion, however, its not giving me any results. I would like to accomplish the below results, the highlighted area is what I would like to do to all the teams. I would like to get the LOEs from going vertically to going horizontally.  

Essentially each team will have their LOE under their team name going horizontally.