Standarddeviation of distinct values?
Hey there,
I want to get the average days between orders of a customer.
stddev(days_between("Due_Date"))
works just fine. However, some customers have multiple orders on the same day. Is it possible to only include the distinct values in the calculation?
stddev(distinct days_between("Due_Date"))
doesn't work in Zoho.
Thanks in advance!