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