Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All
I am trying to count Distinct ORDNUM if NewOrderDate = NewdispatchDate, I am trying this in KPI and I want to select NewOrderDate from the Filter.
=IF (
[NewOrderDate] = [NewDispatchDate] , Count ( DISTINCT ( ORDNUM ) )
)
TIA!!!
Hi,
This is always giving Count by month level. I have three filters - NewOrderDate, Week(NewOrderDate), Month(NewOrderDate). When I select NewOrderDate I want a count for that day but instead, it is coming for the whole month.
Thanks