cont distinct calculation error

[nihar1411]

i have a column in my data , is order on time and it has 2 values YES and NO . i need to calculate the % of orders on time per week. i use the formula 

(count(distinct {< [is order on time?] ={"Yes"}>} [order number]))
/
count(distinct [order number]).

In the filter pane i have the filter of is order on time. if i filter on YES, the above formula shows me 100% however if i filer NO, the above formula shows values above 100% which it should actually show as Zero. Any help please on fixing?

[lironbaram · Accepted solution]

hi 

because you use set analysis , in your first expression :

(count(distinct {< [is order on time?] ={"Yes"}>} [order number]))

selections you make in the field  [is order on time?] , doesn't effect this expression and the result is always as if you selected Yes

change the expressions to this 

(count(distinct if([is order on time?] ='Yes', [order number])))

/

count(distinct [order number]).

[nihar1411 · Accepted solution]

ah indeed. Thanks 🙂

[lironbaram]

Spoiler

hi 

if possible , please mark the answer as correct , so it'll be clear this thread is close