Create a tuple including Summary with specific texts

Questions & Answers
, , ,
1

Hi all:

I need to create a tuple using some dimensions and including the Issue Summary, with specific texts present in the issues. For instance:

Tuple 1

([Measures].[Issues Created], 
[(CS) Affected Product].[Prod XYX], 
 [(CS) Affected Service].[Interface A-B], 
 [(CS) Error].[Resend bookings from A to B],
 [Issues Summary].["text in Summary"],
 [Reporter].[John Doe])

Tuple 2

([Measures].[Issues Created], 
[(CS) Affected Product].[Prod XYX], 
 [(CS) Affected Service].[Interface A-B], 
 [(CS) Error].[Resend bookings from A to B],
[Issues Summary].["Another text in Summary"],
 [Reporter].[John Doe])

Ideas?

2

Hi @walterdp,

The idea of using tuples to get specific issues is correct. Howevere, Summary is not available as a dimension and, therefore, can not be used in the tuple.

To make this work, you should create a new JavaScript calculated field (this is done in import options) that groups issues by keywords in their summary. Then import this new calculated field in eazyBI as dimension.
Here are more details on JavaScript calcauted fields and how to make them: Account specific calculated fields

JavaScript calcauted field to group by Summary
JavaScript calcauted field to group by Summary1424Ă—1400 113 KB

In your case, the JavaScript part for the calculated field might look like the one below. The code example assumes that each issue will have only one of the listed phrases:

//check if the summary has any description
if (issue.fields.summary) {

  //check for individual key phrases in lowercase
  if (issue.fields.summary.toLowerCase().includes("text in Summary")) {
    //you can enter whatever text you would like to see in report for grouping
    return "Group 1";
  };
  if (issue.fields.summary.toLowerCase().includes("another text in Summary")) {
    //you can enter whatever text you would like to see in the report for grouping
    return "Group 2";
  } 

}

Please see this Community post on a similar use case:

Best,
Zane / support@eazyBI.com

1 Like