21 Nov 2021
I'm wondering why the calculation for purchase frequency is: SUM([Number of orders])/COUNTD([Order ID]).
Shouldn't it be something like COUNTD([Order ID])/COUNTD([Consumer ID])?