Welcome to the Jazz Community Forum
Report Builder custom expression using LQE Examples

Hello,
I'm struggling to create what would be very simple in code with SPARQL (I imagine) and this custom expression editor.
What I want to do is translate a status attribute on child tasks into a percentage complete value, so I have a Status attribute with values of say, Open =0%, In Work= 20%, In Review=80% and Closed = 100%
So I can grab the status
$Task:Status$
Then I want to translate that to the percentage equivalent and average it, the logic is something like the following
$statusVal=0
if($Task:Status$="Open") $statusVal = 0
elseif($Task:Status$="In Work")$statusVal = 20
elseif($Task:Status$="In Work")$statusVal = 80
elseif($Task:Status$="In Work")$statusVal = 100
AVG($statusVal)
Anyone have any clue how to do this in SPARQL?
I have had a look at the specification, but don't really want to read a massive document
This is to give metrics on projects where personnel don't fill in how much time they spend on a task, it will gives a rough progress estimate
Thanks for any help
Richard