Turn a Dimension into a Measure

[TDolson52]

I’m new to easyBI and MDX and I’m stumped. In Jira I have a Select List (single choice) field, “Support Score”, alphanumeric by definition. The list consists of values 0, 3, 6, and 9. When imported into easyBI Support Score is recognized as a Dimension. Neophyte that I am it seems that
[Measures].[Support] = [Issue].CurrentMember.GetNumber(‘Support Score’) should return the alpha 0, 3, 6, and 9 values as numeric.
What am I missing? Help?

[gerda.grantina]

eazyBI offers default import options based on a detected custom field type. You could override the custom field definition with JavaScript code.
Here is one example on how to retrieve data from Single select customfield:

I want to enable import as measure for a custom filed in eazyBI

Hi @Rajesh, Welcome to the eazyBI community! In this case, when your field is Single Select List you need to use the JavaScript custom field to import it as a measure. It is because of the way how the field contains its values and it needs the additional calculation to retrieve this data. Here is a code for it (replace NNNNN with your customfield ID): # Select List as measure [jira.customfield_NNNNN] data_type = "integer" measure = true javascript_code = ''' // create new function whi…

A new setup requires new data structures in a database. You would like to delete old ones and then create new data entries. Please run an import twice after those changes:

1. Open import options for edit and deselect the custom field from import settings (any selection), save settings and run an import. This import should delete any data structures for this custom field.
2. Open import options for edit once more and select the custom field back for import. Save settings and run an import. This import should create new data structures for your custom field.

Also, see eayzBI documentation here: JavaScript calculated custom fields

best,
Gerda // support@eazyBI.com