Hi, i want to calculate the average frequently rate = total of purchases over a period/ total of customers during that same period but it said error
Hmm,
This works for me.
What is your sum_app_quantity field as well? Also, is your transcation_order_id an aggregation?