Count Matching Strings & Calculating "Per Unit" in Totals from a Custom Dimension

Questions & Answers
1

Hello -

I’m trying to solve two problems, one period and the other more effectively.

#1. I’m trying to extract the number of times a string such as “MEO-” appears in a list of linked issues. I created this custom dimension and no matter what I try I am unable to just do a simple "Count number of MATCHES of the word “MEO-”. I’ve gotten around it by doing a length count and a replace to do a diff on, but that just seems incredibly sloppy. (Though it was recommended by someone to “count the commas” to determine number of linked issues, which is what got me there)

Custom Dimension for Linked Issues:

[jira.customfield_linked_issues]
name = "Linked Issues"
outward_link = ["relates to"]
dimension = true
split_by = ","

#2 From that dataset, I’m trying to figure out how many of those have failed against the number of created issues. A metric of average number of linked issues, per issue.

I’m able to get the total of the #1 issue by adding --annotations.total=sum to the calculated measure, (otherwise it displays 0 when it should display, say, 68).

I cannot however get the total field to do the math to calculate the average. It either displays the sum (due to --annotations.total=sum), or 0. I tried --annotations.total=average/avg, but that did not work.

I’m seeing some stuff related to $total-aggregate, but nothing that’s making a lot of sense.

image

Oh and last thing… even though the dataset of the dimension is broken by commas, “split_by = “,”” doesnt seem to be doing anything? The cell still says, ISSUE-1, ISSUE-2, ISSUE-3, MEO-2, ISSUE-5… etc. What does the split do exactly? Multiple values doesn’t seem to do much either

2

Bumping this… really not understanding why this doesn’t work.

3

Hi @reeble,

you might want to update the advanced settings for issue links according to the instruction in the documentation. You should ue parameter multiple_values = true and remove parameter split_by = ",". Please follow the instructions and examples on importing issue links: Import issue links.

Note that you should perform double data import for “Issue Links” field after the changes to ensure correct outcome.

  1. In the import option, deselect the custom field “Issue Links” from data import and import data. This action will clear the previous data and data structures.
  2. Wait for data import to complete.
  3. In the import option, select the custom field “Issue Links” for data import and import data for the second time.

When the links ar correctly imported, there are several options for counting linked issues. Please see those Community posts on several approaches with claclautiona or JavaScript calcauted measures:

Best,
Zane / support@eazyBI.com