Rpd modeling

ForSly

Summary

Rpd modeling

Content

I am trying to get a latest score for candidates that have retaken a class exam. a candidate can take same exam several times. My requirement is to always return the last exam score they took. I have tried to use the LAST function on the rpd but when i use it,i get blank rows. Is there a simpler way of capturing the latest candidate exam score? on the rpd or even analysis?

Christian Berg

LAST is the solution. If you get wrong result back the problem is in your model and/or data.

Christian Berg

So you are looking for a "simpler" way which is contrary to how analytical tools work? Because LAST is simply how it works. Literally. And mathematically.

Christian Berg

https://stackoverflow.com/questions/49369817/how-to-pick-up-a-the-newest-record-from-a-list-of-values-in-a-column

Is this your question from Stackoverflow?

ForSly

Not looking for a simplar way, just looking for a solution.

ForSly

yes, thats my question,

ForSly

I found a workaround  for this issue, i had to create a logic in the warehouse to pick up the latest score and that seems to have worked. Thanks for your help.