3 Replies Latest reply on Nov 6, 2018 5:03 AM by Yuriy Fal

How to define a baseline by selecting dimension values

Dear All,

I’m new to Tableau and I’m facing with the following problem.

I would like to Tableau the results of a factorial experiment. Suppose, for instance, that I have three design variables (A, B and C) and two possible levels for each variable, e.g.: a1/a2, b1/b2 and c1/c2; also, let O be the output variable (outcome of the experiment). So my data will look as follows (in csv format):

A,B,C,O

a1,b1,c1,o1

a1,b1,c2,o2

a1,b2,c1,o3

a1,b2,c2,o4

a2,b1,c1,o5

a2,b1,c2,o6

a2,b2,c1,o7

a2,b2,c2,o8

So far so good, but now what I would like to do is to define a baseline result -- for instance the outcome obtained when factor A = a1. This I would use to compare the other results to the baseline. In practice I’d like my new data to look as follows:

A,B,C,O,BL

a1,b1,c1,o1,o1

a1,b1,c2,o2,o2

a1,b2,c1,o3,o3

a1,b2,c2,o4,o4

a2,b1,c1,o5,o1

a2,b1,c2,o6,o2

a2,b2,c1,o7,o3

a2,b2,c2,o8,o4

where BL is the ‘baseline’ column.

Is there a way to do this in Tableau without having to compute the BL column externally?

• 1. Re: How to define a baseline by selecting dimension values

Hi Francesco,

You may want to use a FIXED LOD expression for that:

{FIXED [B],[C] : MIN( IF [A] = 'a1' THEN [O] END ) }

Yours,

Yuri

1 of 1 people found this helpful
• 2. Re: How to define a baseline by selecting dimension values

Hi Yuri,

Thank you very much - it's exactly what I needed!

Best,

Francesco

• 3. Re: How to define a baseline by selecting dimension values

Francesco, you're welcome.