FirstSortedValue()

[cfountain72]

Good evening,

Seems like a simple request, but I can't get the syntax to work. I just want the most recent Value for MeasureType = 'Rate Hospital 9 or 10', but I get 0 or Nan errors using this...

=firstsortedvalue({<MeasureType = 'Rate Hospital 9 or 10'>}Value, MeasureDate)

In this example, I expect to return 84. What am I missing?

Thanks in advance,

Chris

[cfountain72 · Accepted solution]

My bad...it was the expression syntax, not the firstsortedvalue(), that gave me the problem. Should say =firstsortedvalue({<MeasureType = {'Rate Hospital 9 or 10'}>}Value, -MeasureDate)

[sunny_talwar]

Is this resolved now?

[cfountain72]

Hi Sunny,
Yes, this has been resolved. Do you know if you can sort on multiple columns, and then get the first sorted value as well? (That was what I was initially trying to do, but had to alter the load script to get what I wanted.)
Thanks,
Chris

[sunny_talwar]

Sort of multiple columns? Can you elaborate on this with an example?