Obtain a sum of items based on labels that are delimited in a single column

[whagg55056]

Hello, 

I am working with a report from JIRA and I am trying to create basic visuals where I provide the sum of storypoints resolved by month and split the chart based on if the resolved item contains "techdebt" in the label. I can split the Labels column by the delimiter and create either new columns or new rows but neither work well. When splitting into new rows, you can't sum the values as you will double count items. If I split into columns, the labels are not in order so I can't use them in the legend. Any other thoughts? 

Key	Summary	Story Points	Labels
ABC-1	Feature 1	5	team1;techdebt
ABC-2	Feature 2	3	techdebt
ABC-3	Feature 3	8	newfeature;team1

[ImkeF · Accepted solution]

Hi @whagg55056 ,

how about just adding a column that checks if the labels contain "techdebt"?

Text.Contains([Labels], "techdebt")