Oracle Analytics Cloud and Server

Rpd modeling
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?
Answers
-
LAST is the solution. If you get wrong result back the problem is in your model and/or data.
-
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.
-
Is this your question from Stackoverflow?
-
Not looking for a simplar way, just looking for a solution.
-
yes, thats my question,
-
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.