Conversion Rate as a Metric

tableaucommunity@tableau.com — Fri, 01 Aug 2014 13:54:52 GMT

Hey All,

Kind of new to Tableau so sorry for the newbie question : )

B and A being two different URLs, I'm trying to define a Conversion Rate From A to B as a Metric through the calculated field feature.

I managed to calculate this Conversion Rate already through the "Table Calculation" feature, but I would like to have this Metric in my "Measures" tab to be able to use it in a more flexible way.

My data set looks like this:

Date	Marketing Type	Device type	Funnel step	Number of Visits
01-Jul-14	xxx	ppp	aaa	1150
01-Jul-14	yyy	mmm	bbb	120
01-Jul-14	zzz	nnn	ccc	16

My approach was to first define Conversions as Metrics, through the "Calculated Field" feature, following this formula:

Conversions to aaa = IF [Funnel step] = "aaa" THEN [Number of Visits] END

Conversions to bbb= IF [Funnel step] = "bbb" THEN [Number of Visits] END

Which plainly worked.

Then I tried something like:

Conversion Rate From aaa to bbb = Conversions to bbb / Conversions to aaa

Which does not work at all - always NULL, as I guess, ([Funnel step] = "aaa" and [Funnel step] = "bbb") is never TRUE....

I guess I need to use some aggregation function here, but I don't know how to.

Any idea someone ?

Many thanks

Sabrina

Content in Tableau Community Forums

Conversion Rate as a Metric