Hello QVers, at the moment I'm going round in circles finding a solution. For better visualisation for what I want see attached qvw file [QV9].
There are CASEs belonging to one - sometimes identical - DRG, these have several PERFormances with a - sometimes identical - individual Date (DATEPERF) inbetween each CASE / DRG.
Like a business process I want to see the distribution of PERFs for identical DRGs originating from one or more CASEs. I want to know how often one PERF is first, second aso in sequence inbetween a DRG.
My considerations are: First step: the individual DATEPERF should be grouped from min to max inbetween each DRG per CASE; - How to do that when the source is not grouped? Second step: the lowest DATEPERF should get order number #1, second lowest #2 and so on till highest to obtain a consecutive ordering [as RESULT=field created manually] independent from individual DATEPERF; - How to do?
Presuming QVers are sharing my considerations to do this or another way so let me know your ideas and I would appreciate your proposals. Thank You in advance.
