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

Question

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?

Rita Arellano · Answer

Hi @Stepan

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.

Stepan Kholodov · Answer

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)