Hello all,
I created a chart wherein I tried to show the % of Customers vs # of Orders.
I have requirements to show the median Sum of sales for all customers that fall on or below a bin value for eg. (as shown in the screenshot) for customers that have made 4 orders or less(195 customers) compute the median Sum of sales at the individual customer level.
Is there any way we can compute this?
TIA.
4 answers
Hello @John Doe ,
This calculation should work.
{ FIXED [# Orders (bin)]:
median({ FIXED [Customer Name], [Order ID]:
sum(if { FIXED [Customer Name]: countd([Order ID])} <= 4 then [Sales] END)})}
Hope this helps! See attached.
Robert Breen
@Robert Breen
