I am trying to create a report where I want to display in a dimension the first value of the customfield and not the current value of customfield in the issue.
one solution would be defining the import for your Jira custom field changes.
See how to import changes for single-select custom fields.
[jira.customfield_NNNNN] data_type = "string" dimension = true changes = true separate_table = true
You should use your single-select Jira custom field ID instead of NNNNN
And then you could import that first value in another (separate) dimension.
Try something like this (where you must use your custom field ID instead of NNNNN two places in the code and also adjust the custom dimension name for the import on line2)
But this would work only for single-select Jira custom fields and the original custom field must be also selected and imported as the dimension with changes.
Martins / eazyBI support