Create one excel sheet and develop this as view in tableau.
do some calculations, better attach some sample workbook.
Before that I wanted to know if we can achieve this in tableau.
1) How can we redistribute the properties between officers based on the no of complains?
2) How will we calculate the average distance between the start place and the remaining suburb?
A common example would be dividing regions between sales managers so each manager gets an equal type of customer ( small business, enterprise and gov) and they all have to travel approximately the same distance.