8 Replies Latest reply on May 1, 2014 12:47 PM by Aaron Clancy

    Hello people, I'm trying to isolate distinct IDs in one time period and compare them to distinct IDs from a different time period.

    Hans Benson

      I'm using healthcare data, so I can't share anything but screen shots.

      I am trying to compare unique patient IDs (MRNs below) from year X to unique IDs from year X-1 and isolate the ones from year X that DID NOT appear in year X-1.

      Ideally I will also be able to create a parameter so I can input a year and have the count refresh.

      Your help is greatly appreciated!

      Capture.JPG