Convert string into number for customized field

[ADAMKEY]

Hi Experts,
I am new with EazyBI and trying to do a scatter plot using below table. but impact and probability are not a number. How to convert it into 4 and 3?

Thanks!

[VasileS]

Hello @ADAMKEY ,

Check this (create a new measure):

CASE [Measures].[Issue Security Risk Impact].Value
WHEN "4-Very High" THEN 4
WHEN "3-High" THEN 3
-- .....
END

• or (hopefully you do not have values like ‘10-catastrophical’ . The example below will return also 1)

Left(  -- <String>, <Integer>
  [Measures].[Issue Security Risk Impact].Value,
  1  
)

Hope it helps!

Kind regards,
Vasile S.

[ilze.leite]

HI @ADAMKEY

Both solutions shared by @VasileS are great, use which one suits you the best. Thank you Vasile for being a great community member!
The only thing with the syntax - you do not need to use function Value in them, as it returns a numeric value, while you need to process strings in both calculations:

CASE [Measures].[Issue Security Risk Impact]
WHEN "4-Very High" THEN 4
WHEN "3-High" THEN 3
-- .....
END

and

Left(  -- <String>, <Integer>
  [Measures].[Issue Security Risk Impact],
  1  
)

Best,
Ilze , support@eazybi.com

[ADAMKEY]

Thank you llze, I will try this solution as well!!

[ADAMKEY]

Thanks VasileS, It works!!

[erezma]

any idea why i am getting this error:

[wojo3]

I get the same error.