3 Replies Latest reply on Aug 1, 2017 8:16 AM by Ben Neville

    Trying to obtain an overall aggregate score in comparing first/last observations for client data arranged in rows

    Jason Alexandre



      I've been racking my brain on this problem all day and have the distinct feeling that I'm overthinking it.  My data is arranged in rows by client and I would like to see if there has been an improvement in the ratio of Developmental Age to Chronological Age in comparing the first evaluation (Dev Snapshot ID) to the last evaluation.  I developed some simple LOD and filter criteria in order to look at group changes from first to last evaluation while weeding out the middle observations (Worksheet titled: Change in Developmental Age Scores - First/Last); however, I would also like to see the %age of children who improve from first to last observation, regardless of whether they Meet or Exceed their Developmental Age over time.


      I initially developed a calculated field to recode the data (BetterSameWorse) when I realized that the organization of the data by row would make this impossible.  My first thought was to see if there was a way to convert the row data to column data, but I couldn't figure that out (fail), then I played with a few different LOD expressions (fail) and now I'm wondering if there is just a way to subtract the last Dev Age/Chron Age score from the first where a '0' result would be no change, a positive would be a positive and change and a negative result would constitute a negative change, and then just recode and aggregate the results accordingly.


      Thoughts, help, guidance would be greatly appreciated. 


      Packaged workbook is attached.


      Thank you!