Thanks a lot Gerda for your insights. The trick with issues worked for me
Sadly, I work within a very restrictive environment so my options are limited. an Addon might take months to approve.
One last advise, please. In order to extract just the values after | in this multi-line field, I was thinking of using some sort of a substring function with indexof.
something similar to substring ([Issue Business Justification], Indexof('Priority | ') + 11 , Index of(‘Project |’)
I know it might not be clean, but is that attainable?
CASE WHEN
NOT IsEmpty([Measures].[Issue Business Justification])
THEN
Replace(
ExtractString(
[Measures].[Issue Business Justification],
'(Priority|\\n) (.*)',
2),
"| ",
"")
END
Hi @guy.winterbotham ,
I wanted to let you know that we have released eazyBI version 7.1. recently. In this version, we included the feature to allow importing the Jira “Description” field using the New calculated fields option. In the eazyBI account, it is possible to use those settings to define and import the description field. The JavaScript code is: return issue.fields.description
I am currently importing the description field into my eazybi project. I am trying to see if I can use the description field as a psudo project status report. I have added some of the jira ‘insert elements’ to the field but they are not rendering in my eazybi report. Is there some way to get these inserted elements to display correctly? Thanks, Thayne.
Only HTML and Markdown are supported for text formatting; see calculated member formatting description. eazyBI does not recognize JIRA Rich text formatting and returns the plain text as entered when you edit the field.
We have a feature request related to this in our backlog, and I will upvote the feature with your request, but I cannot give any estimates on this development.
