conversion rate

[chan103148]

good day,

need help

I need to compute for conversion rate by dividing Traffic count from Transaction count,

problem is there are dates that have no foot traffic count, that causes abnormality in my data.

I want to include only Transaction count with corresponding Traffic count greater than zero on a daily basis.

current script:

(Count({$<[Date.autoCalendar.Year]= {"2020"}>} distinct [Transaction Number]))

/

(Sum({$<[Date.autoCalendar.Year]={"2020"},[Traffic In]={">0"}>}[Traffic In]))

in the graph above, the computed Conversion rate is 22% which should be 4% only

advance thankyou,

Christian

[sagarjagga]

You can use a measure like-

(Count({$<[Date.autoCalendar.Year]= {"2020"},[Transaction Number]={"=count(disinct [Traffic In])>0"}>} distinct [Transaction Number]))

Can you please share your expected output and sample data in a table form. 

[chan103148]

didn't work

Date	Traffic In	Transaction Number	Conversion
2/17/2020	108	4	4%
2/18/2020	0	7	-
2/19/2020	0	5	-
2/20/2020	220	10	5%
2/21/2020	0	17	-
2/22/2020	0	16	-
2/23/2020	0	13	-
current computation	328	72	22%
desired computation	328	14	4%

compute conversion only those dates with both traffic and transaction count.

disregard the date without traffic count.