225904_en-US

liliconcom

Combining Label by Row with an IF statement for bar charts in graph builder

Label by rows for bar charts in graph builder shows the label for every row. I'd like to reduce the labels by using an if statement. In this case label by row is only applied if an argument from an other Column is true, for example  => if (:Column == "A", ).

Re: Combining Label by Row with an IF statement for bar charts in graph builder

Thanks ms. Your suggestion works great.

Re: Combining Label by Row with an IF statement for bar charts in graph builder

Seems not to be a built-in option in Graph Builder but it's possible to use a label column with a conditional formula.

 For example:

dt = Open("$SAMPLE_DATA/Big Class.jmp");


New Column("Girls", Character, Formula(If(:sex == "F", :name)));

:name << Label(0);
:Girls << Label(1);

dt << Graph Builder(
    Size(570, 511),
    Variables(X(:age)),
    Elements(Bar(X, Legend(3), Label("Label by Row")))
);