In the global store datasource, I made an left join between orders and returns tables. I need to findout the top 10 customers with highest percentage of returns... How do I do that?
3 answers
you have to create 3 calculated fields...
- first count the Order ID's (how many times did someone make an order)
- then count Return ID's (how many times did someone return an item)
- then create a ratio of returns to orders Count(returns) / Count(Order)
- then create a ranking function using Index ()
here is a screenshot. hope that makes sense
