2 Replies Latest reply on Sep 24, 2018 11:24 PM by Mahfooj Khan

# How to present below level on chart for Product Availabiltiy

I have a situation where I have an measure named as ILSS we get ILSS using formula.

So we have ILSS calculated field. Keeping this calculated field in mind. For each product I want to keep them in Different levels such as L0,L1,L2,L3,L4.

IF ILSS is less then 20% then L0

elseif ILSS 20% to 40% then L1

ILSS 40% to 60% then L2

ILSS 60% to 100% Then L3

ILSS >100% then L4

these level I want to show on graph with Legion

What should I use for these level Should I create parameter or create additional calculated field for each level to show it on graph.

can someone suggest me the logic.

• ###### 1. Re: How to present below level on chart for Product Availabiltiy

IF ILSS< 0.2 then L0

elseif ILSS >=0.2 and ILSS<0.4 then L1

elseif ILSS >=0.4and ILSS< 0.6 then L2

elseif ILSS >=0.6 and ILSS< 1 Then L3

Else  L4

END

• ###### 2. Re: How to present below level on chart for Product Availabiltiy

Hi,

Find my approach,

IF [ILSS]< 0.2 THEN "L0"

ELSEIF [ILSS]<0.4 THEN "L1"

ELSEIF [ILSS]< 0.6 THEN "L2"

ELSEIF [ILSS]< 1 THEN "L3"

ELSEIF [ILSS]>= 1 THEN "L4"

ELSE NULL

END

Mahfooj