How to import a custom field as measure in eazybi?

[Yousuf Al Rawahi]

How to import a custom field as measure in eazybi?

[elita_kalane]

Hi @Yousuf Al Rawahi 

Thanks for posting your question!

The ability to import a custom field as a measure depends on the type of your Custom field. You can read more here about what custom field types are supported to be imported as a measure - Standard Custom field types 

If the field cannot be imported as a measure, but you need to make some calculations with the field, you can also describe your use case and I can help you to come up with the formula you need. If you don't feel comfortable sharing it here, you can reach out to us directly at support@eazybi.com

Best wishes,

Elita from support@eazybi.com

[Andrei Eleodor Sirbu]

Hello Yousif, welcome to the community

To import a custom field as a measure in EazyBi you need to : 

1. click on the settings icon (the cog) in the upper right corner of the app

2. Go to "Advanced Settings" tab

3. Insert the following lines 

#The name of your custom field here
[jira.customfield_XXXXX]  
measure = true

With XXXXX values being the id of your custom field 

Save the changes then go to the same screen shown on your screenshot and tick the "import as measure" and do a data import.

Kind regards

Andrei Eleodor Sirbu

[Yousuf Al Rawahi]

I have tried this before and I have tried again now, it doesn't appear the checkbox for measure. Any reason why?

[elita_kalane]

Hi @Yousuf Al Rawahi 

I posted an answer above as well - for some field types it not possible to import the field as a measure, for example a - a text field. Only numerical values can be imported as a measure. Please share your use case regarding what you would like to achieve with your report and we can help you come up with either an MDX or custom JavaScript code. 

If your field is a text/string type but you only have numeric values in the text field, you can read more about a solution how to import the field as a measure here (it would require changing the field to numeric) - https://community.eazybi.com/t/is-it-possible-to-convert-a-jira-custom-field-type-string-to-integer-to-become-a-measure/8003

Best wishes,

Elita from support@eazybi.com