How to Extract Sprint Name from Jira Custom Field in BoldBI
When working with Jira as a data source in BoldBI, you may encounter issues with the “Sprint” field (customfield_10100) being imported as a long string containing multiple data points. This article will guide you on how to extract the “Sprint Name” from this field using an expression in BoldBI.
Extracting Sprint Name using Expression
To extract the “Sprint Name” from the imported Sprint field, you can use the following expression:
SPLIT_PART(SPLIT_PART([Sprint], 'name=', 2), ',', 1)
Here, [Sprint] is the field name.
This expression works by first splitting the imported Sprint field using the ‘name=’ delimiter, and then selecting the second part of the split result. Next, it splits the result again using the ‘,’ delimiter and selects the first part of the split result, which is the “Sprint Name”.
Example
For example, if the imported “Sprint” field contains the following data:
[ "com.atlassian.greenhopper.service.sprint.Sprint@16cf5002[id=248,rapidViewId=11,state=CLOSED,name=2022 PI.3 Tasmania Sprint 1,startDate=2022-02-21T11:43:00.000-07:00,endDate=2022-03-04T07:59:00.000-07:00,completeDate=2022-03-04T12:39:08.626-07:00,activatedDate=2022-02-22T11:42:08.088-07:00,sequence=248,goal=Our focus is to add required functionality for conversation follow and multi tenant which will increase parity between our EWS and graph implementations.\n\nWe believe it provides seamless transition for our customers from EWS to graph.\n\nThis will be confirmed when we can demo conversation follow and multi tenant using graph.\n\nOur focus is to be able to determine all risks/gaps with migrating, specifically how to handle the folderID and ItemID changes\n\nWe believe that it ensures we can continue to use this functionality after the migration\n\nThis will be confirmed when we have identified the gaps on making the migration work,autoStartStop=false]"]
Using the expression mentioned above, the extracted “Sprint Name” will be:
2022 PI.3 Tasmania Sprint 1
Now you can use this expression in BoldBI to extract the “Sprint Name” from the imported “Sprint” field and display it in your dashboard.
References
