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.)
PatientID | TestLISCode |
13066 | 242 |
13066 | 251 |
13066 | 256 |
13066 | 438 |
13066 | 440 |
13066 | 808 |
13066 | 2368 |
13066 | 2478 |
13066 | 2492 |
101321 | 218 |
101321 | 1250 |
100949 | 84 |
100949 | 175 |
100949 | 204 |
100949 | 241 |
100949 | 242 |
100949 | 2478 |
22998 | 126 |
22998 | 175 |
22998 | 204 |
22998 | 217 |
22998 | 241 |
22998 | 242 |
22998 | 251 |
57189 | 17 |
57189 | 58 |
57189 | 83 |
57189 | 84 |
57182 | 85 |
57183 | 88 |
57183 | 89 |
Ashish, welcome to the forums! You seem to be looking for:
{FIXED [Patient ID] : COUNT(Patient ID)}
Does that work for your situation? If not post a sample packaged workbook and tell us what version of Tableau (9.0? 8.3?) you are using.
Cheers,
--Shawn