1 Reply Latest reply on Jun 25, 2018 1:10 PM by Jim Dehner

# Reference Lines

How do I add a reference line that would show multiple values based on the month? I tried the below calculated field but I can't seem to get that to work/display how I want it. So basically Jan-May the target will be 180, then Jun-Aug it will be 240, then Sept-Dec its back down to 180.

IF MONTH([Order Date]) = 1 THEN "180"

ELSEIF MONTH([Order Date]) = 2 THEN "180"

ELSEIF MONTH([Order Date]) = 3 THEN "180"

ELSEIF MONTH([Order Date]) = 4 THEN "180"

ELSEIF MONTH([Order Date]) = 5 THEN "180"

ELSEIF MONTH([Order Date]) = 6 THEN "240"

ELSEIF MONTH([Order Date]) = 7 THEN "240"

ELSEIF MONTH([Order Date]) = 8 THEN "240"

ELSEIF MONTH([Order Date]) = 9 THEN "180"

ELSEIF MONTH([Order Date]) = 10 THEN "180"

ELSEIF MONTH([Order Date]) = 11 THEN "180"

ELSEIF MONTH([Order Date]) = 12 THEN "180"

END

• ###### 1. Re: Reference Lines

is this what you wanted

the formula is

just plot the min on dual axis and sync

Jim

If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution.  Thank you.