Chart Expression (Return TestID Where TestDate is Max TestDate)

Thu, 17 Nov 2011 18:18:37 GMT

Data (in a Table Box) looks like this:

I'm trying to create a Straight Table that looks like this:

PersonID	TestFlag	MOST RECENT TestID	MOST RECENT TestDate
1234	1	87BBA227-2036-482B	10/17/2011

In other words, please give me the most recent TestID and TestDate where the TestFlag = 1 (by PersonID).

Currently, I have the Dimension as PersonID, and my Expression looks like this:

MaxString(

{$<

TestDate = {"=$(Max(TestDate))"},

TestFlag = {1}

TestID)

But this is not returning anything...

Please help.

Re: Chart Expression (Return TestID Where TestDate is Max TestDate)

johnw — Thu, 17 Nov 2011 19:05:41 GMT

most recent test ID = firstsortedvalue({<TestFlag*={'1'}>} TestID,-TestDate)

most recent test date = max({<TestFlag*={'1'}>} TestDate)

Thu, 17 Nov 2011 20:07:37 GMT

Wow! Thx so much, John! Seems to be working now