Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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]).
ah indeed. Thanks 🙂
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]).
ah indeed. Thanks 🙂