4 Replies Latest reply on Jan 20, 2019 5:32 AM by Gabe DeWitt

# How can i calculate converion ratio?

Hello All,

I'm newbie to tableau, I wanted to get conversion ratio of  won leads.

No.
status
stage
1closedwon
2closedproposal
3openwon
4closedlost

i want to get conversion ratio = (no. of won)/ (no. of closed)

i.e conversion ratio = 2/3

conversion ratio = 0.66

• ###### 1. Re: How can i calculate converion ratio?

The following calculated field should give you what you need.

SUM(IIF([Stage]="won",1,0))/SUM(IIF([Status]="closed",1,0))

1 of 1 people found this helpful
• ###### 2. Re: How can i calculate converion ratio?

Hi Dev,

One way to do it is use if statements to determine the counts of "won" and "closed", and create a calculated field for conversion ratio.

if closed

if [Status] = "closed"
then 1
END

if won

if [Stage] = "won"
then 1
END

conversion ratio

sum([if won])/sum([if closed])

• ###### 3. Re: How can i calculate converion ratio?

{COUNT(IF Stage="Won" Then Stage End)}/{COUNT(IF Status="Closed" Then Status End)}

• ###### 4. Re: How can i calculate converion ratio?

Hi Dev,

It looks like you have 3 solutions that all solve your question... Probably should mark one of them as the solution, and that your question is answered.