When I want to use them as dimensions to filter in the eazyBI reports, only the 4 of list type appear. The two of string type don’t even let me import them as dimensions so I can’t use them for filtering.
I have never successfully used a multi-select field as a dimension in a report. Is it possible your issues dont have 2 selections of that field? That always gives me an error. I have many string type custom fields that I use as dimensions in reports. Here is what one of my custom definitions looks like
data_type = “string”
dimension = true
separate_table = true
changes = true
Make sure your advanced settings has the dimension = true .
eazyBI tries to detect import options for custom fields based on the custom field data type. We import select list (single select) and select list (multiple select), labels, and several more as dimensions by default.
Text single line and Text multi-line values can be imported as properties only. We might not detect the data type of some add-ons and offer to import some as properties only as well.
If eazyBI can’t detect a field type properly or you would like to change the import options for the field, you would like to use eazyBI advanced settings for custom fields.
This definition example should enable custom field import as a dimension. It should be of data type string, integer, or decimal and import option dimension = true explicitly specified for them:
The definition above might change the data type of the field. Data type and import option changes for the custom field might need data structure changes in eazyBI. You would like to run two full imports to get this working:
Please deselect the custom field from import options (any selection), save import options, and run an import. This import should delete any data structures for this custom field.
Please select the custom field back for import. Save import options and run an import. This import should create new data structures for your custom field.
Thank you very much for your reply. I think I’m closer to solve it but I still need help.
I don’t know if I’m doing something wrong.
I followed your steps and filled in the advanced settings (although I don’t know if you wanted me to create two new measures or modify the ones already created: SWF PROJECT CLARITY and SWF PETICION GADGET).
Or … ¿Would there be a way (some command) to indicate in advanced settings to modify the old SWF PROJECT CLARITY and SWF PETICION GADGET to be able to use them as dimensions?
Or is it only possible to create two new custom fields SWF PROJECT CLARITY and SWF PETICION GADGET and specify that they are strings and can be used as dimensions. If this is the only way, would you know how to make them appear in JIRA?
I know how to create fields in JIRA and synchronize them with eazyBY but not the other way around.
eazyBI allows importing number and string fields as dimensions.
You can add the dimension = true option for this field to eazyBI advanced settings. Here is a similar community post where dimension = true option was used for Story Points. The post includes an additional option to import the field as an interval dimension. However, it is optional.