How to filter the specific products in "Products Affected"

Questions & Answers
2

Hi,
Thanks for reaching out!

In your scenario, I recommend importing your multi-list custom field as csv_dimension . This dimension will allow you to filter your issues by specific multi-value custom field combinations (including filtering on issues that have only one value).

Here are the steps to take:

  1. In eazyBI Jira import options for Custom fields, find needed field, choose Edit and then “Add additional advanced settings”. I show “Fruits” in my example, for you it would be “Products Affected”.

image.png
image.png1200×932 59.3 KB

  1. Add a parameter csv_dimension = true to enable the creation of new “multi-list custom field name CSV” dimension where values are comma separated. Increase Limit if you expect values to be longer.

image.png
image.png1056×806 40.9 KB

  1. Import data in eazyBI. You will see a new dimension ending with CSV in available custom fields dimensions.

  2. Add the new dimension “multi-list custom field name CSV” on report rows to see data and to pages to filter by it.

image.png
image.png1366×1076 103 KB

  1. If you usually need only specific values, you can create bookmarks in this CSV dimension:

image.png
image.png1276×1076 94.5 KB

Also, you can learn more about custom field settings here → Advanced settings for custom fields.

Best,
Ilze

1 Like