How to import a custom field as measure in eazybi?
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
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.comBest wishes,
Elita from support@eazybi.com
I have tried this before and I have tried again now, it doesn't appear the checkbox for measure. Any reason why?
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,
It looks like you're new here. Sign in or register to get started.
