Rank to High Medium Low

[Anonymous]

Hi, refer to the attachment, My data on "doability' are 1,2,3,4 and 5 which means the level of difficulty. I want to show on scatter plot showing 1 as Low, 2 as Medium, 3 as High , 4 as Critical and 5 as SUper critical. How can do i it?

[jonathandienst]

You could load the 'doability' field as a dual value. In your load script:

LOAD

  ...

  Pick(doability, dual('Low', 1),  dual('Medium', 2), dual('High', 3), dual('Critical', 4), dual('Super critical', 5)) as doability,

  ...

Now doability will show the names. Sort the chart numerically to get the doability in the correct order.

[Anonymous]

Hi, I try use te code but nothings changed