Import 'Traffic light' custom fields in EazyBI

[Kris Dewachter]

Hi,

In our Jira, we use a marketplace app "JIRA Traffic-Light CustomField", which allows you to create custom fields of type "Traffic Light".

However, when creating a Jira data import in EazyBI, these field do not appear in the list of custom fields, and can not be imported.

Is there a way to get these fields into EazyBI ?

Best regards,

Kris

[elita_kalane · Accepted solution]

Hi  @Kris Dewachter 
Thanks for raising this question!
eazyBI has no integration with the traffic light app from Jira.

But you should be able to define these fields using Javascript in advanced settings (https://docs.eazybi.com/eazybi/data-import/data-from-jira/jira-custom-fields/advanced-settings-for-custom-fields) and then import them in eazyBI.
Then you could create calculated measures with markdown/icons to reach a similar look for the report.
See some markdown possibilities in the last version of eazyBI:
https://community.eazybi.com/t/measure-formatting-markdown-and-custom/5157/10

The JavaScript for advanced settings might look like this where NNNNN is the ID of your traffic light custom field ID

[jira.customfield_NNNNN]
data_type = "string"
dimension = true
javascript_code = '''
if (issue.fields.customfield_NNNNN) {
issue.fields.customfield_NNNNN = 
issue.fields.customfield_NNNNN.value;
}
'''

Best regards,

Elita from support@eazybi.com

[Kris Dewachter]

Hi Elita,

Thank you. This works perfectly.

Best regards,

Kris