Here is my a sample data. I have two columns as you can see. I need to calculate no of patients gone through only one test and so on. For example patient having id 57182 gone through only one test. 57183 gone through 2 and 13066 gone through 9.
So I need to draw a report which displays % of patients vs count of patients against no of tests (1 test, 2 tests and so on.)