Assign a numerical value to a status

Questions & Answers
1

Hello !
I would like to assign each status a value, for example: “Done” = 100, “Funnel” = 20, “To Do” = 10…

This represents the percentage of progress of a subject in order to see where it is.
The goal is to take an average of the Status (converted into number) of the sub-tasks and stories attached to the feature in order to deduce a percentage of progress.

I would like to know if this is possible in EazyBI, and if so, how to do this?
I’m new to EazyBI, thanks for your help!

PS : I already tried to base it on an existing topic, but that doesn’t correspond to what I want. I also tried to map the fields via Excel which I then uploaded to EazyBI but I couldn’t do it either.

2

Hi @Marius_LAU,

Welcome to the eazyBI community!
​
​You might multiply the number of issues with the relevant status by the value of the status and sum them up. Then you might divide the total value by the number of issues in scope.
​The expression might be as follows.
​

CASE WHEN
--there are any issues in scope
 [Measures].[Issues created]>0
THEN
 (
  ([Measures].[Issues created],
   [Status].[To Do]) 
  --multiplied by value
   *10
   +
  ([Measures].[Issues created],
   [Status].[In Progress])
  --multiplied by value
   *30
   +
  ([Measures].[Issues created],
   [Status].[Review])
  --multiplied by value
   *60
  +
  ([Measures].[Issues created],
   [Status].[Done])
  --multiplied by value
   *100
 )
 /
--divided by the total number
 [Measures].[Issues created]
END

​Regards,
​Oskars / support@eazyBI.com