Import Select List (cascading) custom field is shown as integers instead of string values

I’d like to import a customfield called “Team” which is defined as a "Select List (cascading) in Jira.
It has 2 levels: Team and Sub-team

I am using the following settings in " Advanced settings":

Team field with history

data_type = “string”
dimension = true
separate_table = true
changes = true

When showing a report it is displaying the first column as integers (“6”), the second is shown as string value (“AC”).

What’s the reason the first level is not shown as string?



As we already discussed in the email thread you opened with the eazyBI support team this looks like a specific case where the “Team” field was not correctly imported as a dimension (dimension members show key instead name which is not expected behavior with a cascading field in eazyBI)
Try fixing this problem by importing data (temporarily) without the “Team” field and then import the “Team” field again once the first import is completed.
That would reset the dimension members in the account.

Martins / eazyBI

1 Like