Oracle Analytics Cloud and Server
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?
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.