I am trying to find Maximun count for each bin range, but bin range can move depending on data. Trying to find three bins and minumum three count in each bin. For example, for this sample ID fee 2 330 4 330 15 330 17 330 1 350 5 350 18 370 8 390 12 390 19 390 20 430 3 450 13 480 7 500 6 530 10 530 11 530 9 540 14 550 16 550 these are three different iterations and i want the best optimal solution, something like iteration 2. Bins count % Iteration 1 1 330-390 10 50.00% 2 391-530 7 35.00% 3 531-550 3 15.00% Iteration 2 Bins count % 1 330-450 12 60.00% 2 451-530 5 25.00% 3 531-550 3 15.00% Iteration 3 Bins count % 1 330-350 6 30.00% 2 351-530 11 55.00% 3 531-550 3 15.00% Can we do this in auto process? if so what would be the best approach.
... View more