Reference Line

[bobbydave]

I am trying to create a reference line showing a stacked bar chart with expressions 'Cycle Hit' and 'Cycle Miss'

I want to differentiate between them with a reference line.

Analyst would be my dimension.

So I am saying in my Target reference expression

if( Analyst = 'A', 1,

     if( Analyst = 'B', 1,

          if( Analyst = 'C', 1,

              if(Analyst = 'D', 1,

                    if(Analyst = 'E', 4,

                         if( Analyst = 'F', 4 )))))))

So what will happen is the Analysts will all have the reference link showing as 1 but will spike to 4 on E and F

Any ideas as my IF Target statement doesnt work

[stigchel · Accepted solution]

A reference line (in presentation tab) is not evaluated by the chart's dimensions. You can use a combo chart where you add this expression with line representation in the expression tab

[stigchel]

Has this helped, or do you have any further questions?

[bobbydave]

Combo chart was the way to go.

Thanks