1 Reply Latest reply on May 1, 2015 5:03 AM by Shawn Wallwork

    I want to get count based on no of counts

    ashish gupta

      Hello,

       

      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.)

       

       

      PatientIDTestLISCode
      13066242
      13066251
      13066256
      13066438
      13066440
      13066808
      130662368
      130662478
      130662492
      101321218
      1013211250
      10094984
      100949175
      100949204
      100949241
      100949242
      1009492478
      22998126
      22998175
      22998204
      22998217
      22998241
      22998242
      22998251
      5718917
      5718958
      5718983
      5718984
      5718285
      5718388
      5718389